How does Financial Analysis Work?
Very simply, just introduce the data from a series of Profit & Loss Statements and Balance Sheets, or even Trial Balances, and get the complete ratio analysis, Cash Flow Statement and Performance Charts. That's it!
If you include forecasted data, you also get the company valuation and Sensitivity Analysis.
Do I have to be an accountant to use this spreadsheet?
No, all you have to know is to fill in the input data and be able to interpret the results. We have a lot of valuable articles in our blog to help you with accounting and finance, should you have any difficulties. You may also contact me, in case of trouble.
Will Financial Analysis run on a Mac?
No, unless you use some sort of virtualisation, that is, you force the Mac to run on Windows, like a PC.
Will I be able to edit the formulas?
Yes, you may see and edit the formulas.
What kind of assumptions do I have to make to perform a company valuation?
You have enter the forecasted P&L and Balance Sheet Data for the period of your choice. You also need to enter the cost of borrowing, the cost of equity and the tax rate.
What if I want to add more periods for historical/forecasted?
Just add columns and drag the formulas to the left or right as needed.
How is residual value calculated?
Residual value is a perpetuity that depends on the last forecasted cash flow plus an estimated annual growth rate. The spreadsheet will do the calculation for you as long as you enter the estimated growth rate.
Does Financial Analysis calculate the WACC?
Sure, using the inputs for cost of equity and cost of borrowing and the capital structure, the spreadsheet will automatically calculate the weighted average cost of capital (wacc).
How do I buy it?
Just click here to download the application immediately.