Mastering Cash Flow and Valuation Modelling, w. CD-ROM

Acknowledgements About the author Conventions Overview Executive summary Warranty and disclaimer 1 Introduction and overview Scope of the book Model design methodology Example models Summary 2 Functions Categories Finance Mathematics Time Lookup Logic Text Other functions Summary 3 Model template Design objectives Systematic design method Case objectives Templates Input sheet Timeline Summary 4 Historic statements Accounting sheets Income Statement Balance sheet Adjustments Summary 5 Sales forecast Forecasting objectives Method Sales Common size analysis Forecast sheet Summary 6 Assets Fixed assets Excel functions Existing assets New asset depreciation Written down value Asset summary Tax depreciation Summary 7 Debt Debt schedule Required entries Interest rates Forecast income statement Forecast balance sheet Summary 8 Balance sheet Current assets Non-current assets Current liabilities Long-term liabilities and shareholders' funds Tax Balancing item Summary 9 Cash flow Outline Cash flow statement Cash for debt service Cash waterfall Chart Summary 10 Ratios Method Common size analysis Core ratios Profitability Operating efficiency Financial structure Cash flow Debt coverage Growth Market ratios Summary 11 Cost of capital Background Cost of debt Preference capital Historic cost of equity Forecast cost of equity Cost of capital Graphical representation Summary 12 Valuation Cash flows Terminal value Choice of method Initial valuation Chart Summary 13 Other approaches Method Book value Adjusted book value Market value Multiples Peer data Summary 14 Alternative methods Method Adjusted present value Economic profit Summary 15 Sensitivity Outline Returns Data matrix Scenario manager Manual scenarios Summary 16 Optimisation Outline Goal Seek Solver Coding Solver Summary 17 Reporting Reporting Executive summary Dashboard Dynamic charts Summary 18 Auditing and review Model review Self-checks Excel audits tools Consistency checks Audit sheet Summary 19 Documentation