Mastering Cash Flow and Valuation Modelling

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

...
See more details below
Paperback (New Edition)
$92.50
BN.com price
(Save 7%)$99.99 List Price
Other sellers (Paperback)
  • All (11) from $72.44   
  • New (10) from $72.44   
  • Used (1) from $92.49   
Sending request ...

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

Read More Show Less

Product Details

  • ISBN-13: 9780273732815
  • Publisher: FT Press
  • Publication date: 1/12/2012
  • Series: Financial Times Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 344
  • Product dimensions: 6.50 (w) x 9.40 (h) x 0.90 (d)

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

Read More Show Less

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

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star

(0)

4 Star

(0)

3 Star

(0)

2 Star

(0)

1 Star

(0)

Your Rating:

Your Name: Create a Pen Name or

Barnes & Noble.com Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & Noble.com that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & Noble.com does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at BN.com or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation

Reminder:

  • - By submitting a review, you grant to Barnes & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on BN.com. It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

 
Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)