Overview

Your practical step-by-step guide to planning and building cash valuation models. Through a set of comprehensive instructions and templates it provides the tools to build models that will enable you to carry out accurate and informed analysis of your company's cash liabilities, cash flow and value. If you are buying the ebook, companion files can be downloaded from the digital downloads section of http://www.financial-models.com/.

Full Product Details

Author:   Alastair Day
Publisher:   Pearson Education Limited
Imprint:   FT Publishing International
Dimensions:   Width: 17.00cm , Height: 2.00cm , Length: 23.80cm
Weight:   0.530kg
ISBN:  

9780273732815

ISBN 10:   0273732811
Pages:   344
Publication Date:   09 November 2011
Audience:   Professional and scholarly ,  Professional & Vocational
Format:   Mixed media product
Publisher's Status:   Active
Availability:   Available To Order  
We have confirmation that this item is in stock with the supplier. It will be ordered in for you and dispatched immediately.

Table of Contents

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 Documentation Navigation Protection Version check Final review Summary Appendices 1 Functions list, software installation and licence 2 An introduction to Microsoft (R) Office 2010 (Office 14) Index

Reviews

Author Information

Alastair Day has worked in the finance industry for 20 years in treasury and marketing functions. In 1990 he established Systematic Finance as a consultancy and financial lessor concentrating on the computer and communications industries. Alastair has a degree in Economics and German from London University, an MBA from the Open University Business School, and is an associate lecturer in corporate finance with the OUBS. He is the successful author of several books including Mastering financial Modelling, Mastering Risk Modelling and The Financial Director's Guide to Purchasing Leasing.

Tab Content 6

Author Website:  

Customer Reviews

Recent Reviews

No review item found!

Add your own review!

Countries Available

All regions