Home > Store > Business & Management > Finance & Investing > Personal Finance

Mastering Cash Flow and Valuation Modelling

Register your product to gain access to bonus material or receive a coupon.

Mastering Cash Flow and Valuation Modelling

eBook (Watermarked)

  • Your Price: $79.99
  • List Price: $99.99
  • Includes EPUB, MOBI, and PDF
  • About eBook Formats
  • This eBook includes the following formats, accessible from your Account page after purchase:

    ePub EPUB The open industry format known for its reflowable content and usability on supported mobile devices.

    MOBI MOBI The eBook format compatible with the Amazon Kindle and Amazon Kindle applications.

    Adobe Reader PDF The popular standard, used most often with the free Adobe® Reader® software.

    This eBook requires no passwords or activation to read. We customize your eBook by discreetly watermarking it with your name, making it uniquely yours.

Description

  • Copyright 2011
  • Edition: 1st
  • eBook (Watermarked)
  • ISBN-10: 0-13-354059-6
  • ISBN-13: 978-0-13-354059-8

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/.

Sample Content

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® Office 2010 (Office 14)

Index

Updates

Submit Errata

More Information

Unlimited one-month access with your purchase
Free Safari Membership