This template helps you analyse a company’s financial statements and estimate the fair value of its shares without building formulas from scratch.
What’s inside
- Linked income statement, balance sheet and cash flow statement
- 18 financial ratios (liquidity, solvency, profitability, efficiency and valuation)
- DuPont analysis
- Free cash flow calculation
- Cost of capital (WACC), including cost of debt and cost of equity
- Stock valuation compared with the market price
What you get
- Example version: filled with sample company data so you can follow the logic.
- Blank version: ready for the company you want to analyse.
Format and access
- .xlsx files for Microsoft Excel (2016 or later recommended); they generally also open in Google Sheets.
- Digital product: download links are emailed to you and available under My Account once payment succeeds.
- Prices are in Indonesian Rupiah (IDR).
- The template is also included as companion material with the danieel.id e-book on financial statements and stock valuation.
This template is an analysis and learning tool, not a recommendation to buy or sell any particular stock.
This post is also available in:




Reviews
There are no reviews yet.