Performs Financial Analysis, calculates cash-flow, ratios and company valuation.
This Google Sheets add-on performs financial analysis using data entered into balance sheet and profit and loss statements. It will create a template for a chosen number of historical and forecast periods and it will calculate automatically:
* Cash flow statements
* 26 Financial ratios including Dupont Analysis and Altman Z-Score
* Company valuation
* 8 performance charts
Financial Analysis is a great support for performance review and decision making.
Its use is very simple: just install the add-on and click 'Financial Analysis' -> 'Create Financial Analysis' from the main menu.
A sidebar will be displayed where you may configure the name of the company and number of periods you want to use in your analysis.
In seconds, you'll have a clean template where you can simply enter the balance sheet and profit and loss data. All the analysis will be done for you automatically.
You will also be able to share your sheets with others (or keep them private for yourself), download them as Microsoft Excel, OpenDocument format, PDF, etc.