Mastering Cash Flow and Valuation Modelling (The Mastering Series)
Home » Books » Business » Money Investment » Finance

Mastering Cash Flow and Valuation Modelling

The Mastering Series

By Alastair Day

US$109  
Free Shipping Worldwide
Ships from UK
Order now for Christmas delivery
Rating:
 
Register or sign-in to rate and get recommendations.
Format: Mixed media product, 344 pages
Published In: United Kingdom, 02 November 2011
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/.

Table of Contents

AcknowledgementsAbout the authorConventionsOverviewExecutive summaryWarranty and disclaimer 1 Introduction and overview Scope of the bookModel design methodology Example modelsSummary 2 Functions CategoriesFinanceMathematicsTimeLookupLogicTextOther functionsSummary 3 Model template Design objectivesSystematic design methodCase objectivesTemplatesInput sheetTimelineSummary 4 Historic statements Accounting sheetsIncome StatementBalance sheetAdjustmentsSummary 5 Sales forecast Forecasting objectivesMethodSalesCommon size analysisForecast sheetSummary 6 Assets Fixed assetsExcel functions Existing assetsNew asset depreciationWritten down valueAsset summaryTax depreciationSummary 7 Debt Debt scheduleRequired entriesInterest ratesForecast income statementForecast balance sheetSummary 8 Balance sheet Current assets Non-current assetsCurrent liabilities Long-term liabilities and shareholders fundsTaxBalancing itemSummary 9 Cash flow OutlineCash flow statementCash for debt serviceCash waterfallChartSummary 10 Ratios MethodCommon size analysisCore ratios ProfitabilityOperating efficiencyFinancial structureCash flowDebt coverageGrowthMarket ratiosSummary 11 Cost of capital BackgroundCost of debtPreference capitalHistoric cost of equityForecast cost of equityCost of capitalGraphical representationSummary 12 Valuation Cash flowsTerminal value Choice of methodInitial valuation ChartSummary 13 Other approaches MethodBook valueAdjusted book valueMarket valueMultiplesPeer dataSummary 14 Alternative methods MethodAdjusted present value Economic profit Summary 15 Sensitivity OutlineReturnsData matrixScenario managerManual scenariosSummary 16 Optimisation OutlineGoal SeekSolverCoding SolverSummary 17 Reporting ReportingExecutive summaryDashboardDynamic chartsSummary 18 Auditing and reviewModel reviewSelf-checksExcel audits toolsConsistency checksAudit sheetSummary 19 Documentation Documentation NavigationProtection Version checkFinal reviewSummary Appendices1 Functions list, software installation and licence2 An introduction to Microsoft (R) Office 2010 (Office 14) Index

About the Author

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.

EAN: 9780273732815
ISBN: 0273732811
Publisher: Financial Times Prentice Hall
Dimensions: 23.7 x 17.4 centimeters (0.62 kg)
Age Range: 15+ years
Tell a friend

Their Email:

Review this Product

BAD GOOD
 

Related Searches

 

This item ships from and is sold by Fishpond World Ltd.