A DCF model projects a company’s future cash flows, discounts them to today’s value, and produces an estimate of what the business is intrinsically worth. It is the core analytical tool in DCF valuation, the method used by investment banks, equity research analysts, and corporate finance teams to value companies based on fundamentals rather than…
Read More
Inventory, receivables, and payables
ValueModel checks if Inventory conversion period, receivables collection period and payables deferral period forecast deviates substantially
Read More Introduction to the model
The excel file consists of 9 sheets which serve different purposes. Sheet FS: This sheet includes the financial data provided
Read More Formulas & definitions (list)
Explanation of items and the used formulas within the ValueModel. Quick jump to: P&L – Supplemental – BS: Assets – BS: Liabilities
Read More Dividend payout ratio and ROE
The ValueModel checks whether your ROE and DPR forecast deviates substantially from the past.
Read More Common valuation mistakes
Don’t lose sight of the bigger picture of the complex of Business valuation. The ValueModel is designed for the analyst to avoid mistakes.
Read More Code of ethics
The CFA Institute Code of Ethics and Standards of Professional Conduct are fundamental as the code every analyst should follow.
Read More Change in working capital
ValueModel checks if the change in working capital is in line with historical figures. If the company is spending in advance of its growth…
Read More Cash to sales
The ValueModel checks whether your cash-to-sales-ratio forecast deviates substantially from the past. Necessary for the unexpected
Read More