Personal Finance Calculators for Mac Excel 2011

Here is a list of personal finance calculators and tools available for Mac Excel 2011.  The stock analyzer is now available in Mac.

Converting the Windows Excel tools to be Mac compatible is an ongoing effort and I shall update this page from time to time.

I request the support of the Mac Excel community to help improve these sheets and point out errors if any. This is a work in progress. I will be updating this page from time to time with Mac Excel versions.

1 Download: Automated Stock analyser with data  This is a free stock analysis spreadsheet that can automatically process balance sheet data from This is the 12th edition of the freefincal automated stock analyzer. Fill details can be found here: Automated Stock Analysis with data Thanks to Butan Mohapatra for suggesting I do this.

2 Download: Money Control Mutual Fund Portfolio Comparison Tool for Mac

The sheet extracts three mutual fund portfolios from money control and compares stock holdings to determine the extent of portfolio overlap among your mutual fund holdings.  The tool can help you build a well-diversified equity portfolio. More details and the Windows Excel version can be found at Moneycontrol edition: Equity Mutual Fund Portfolio Comparison Tool (Feb 2016)


3 Download: Step-by-Step Goal-Based Investing Calculator to begin and track long-term goal based investing.  Most goal planning calculators tell you how much you should invest.  This sheets asks you, how much you can invest and goes about calculating the portfolio return. With that you can calculate the asset allocation required (equity to fixed income ratio). More details can be found here: A Step-By-Step Guide to Long Term Goal-Based InvestingThe above file will work ‘as is’ in Window Excel as well with macros enabled.


Integrated Financial Planning Template will work ‘as is’ except for the macro which is required for printing the plan.

Financial Goal Planner with Flexible Asset Allocation will work ‘as is’ including the macro.


Create a "from start to finish" financial plan with this free robo advisory software template

Free Apps for your Android Phone

Install Financial Freedom App! (Google Play Store)
Install Freefincal Retirement Planner App! (Google Play Store)
Find out if you have enough to say "FU" to your employer (Google Play Store)

About Freefincal

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

One thought on “Personal Finance Calculators for Mac Excel 2011

  1. Hi – I have used your excel v10 and found it very useful – however I do not find this and others to be working on Libreoffice an open source program that in many ways is like excel. It might need some customisation i think – and open source is getting very popular.

Do let us know what you think about the article