Building Financial Models / Edition 2

Building Financial Models / Edition 2

2.8 6
by John Tjia
     
 

View All Available Formats & Editions

ISBN-10: 0071608893

ISBN-13: 9780071608893

Pub. Date: 05/27/2009

Publisher: McGraw-Hill Professional Publishing

The ability to effectively create and interpret financial models is one of the most valued skills in corporate finance--from Wall Street to Main Street. Now, the acclaimed guide to designing, building, and implementing valuation projection models is fully revised and expanded to keep finance and accounting professionals competitive in today's marketplace.

This

Overview

The ability to effectively create and interpret financial models is one of the most valued skills in corporate finance--from Wall Street to Main Street. Now, the acclaimed guide to designing, building, and implementing valuation projection models is fully revised and expanded to keep finance and accounting professionals competitive in today's marketplace.

This second edition of Building Financial Models continues the tradition of its predecessor by providing a hands-on approach to creating a core model that is supported by broad coverage of cornerstone accounting and finance principles. Additionally, this updated volume features:

  • Entirely new coverage of discounted cash flow (DCF) modeling
  • Excel formulas for making powerful calculations within the spreadsheet
  • In-depth explanations of both the principles and mechanics of projection models

Building Financial Models helps readers practice good thinking and apply sound knowledge of their tools--two key attributes to producing robust and easy-to-use models. This practical guide takes you step by step through the entire process of developing a projection model, with a full chapter dedicated to each phase. By the end, you will have a working, dynamic spreadsheet financial model for making projections for industrial and manufacturing companies.

Furthermore, this Second Edition provides the vocabulary and syntax of model building so you can tailor core models to fit any size company and allow for quick input changes to test sensitivity. The companion website www.buildingfinancialmodel.com offering example spreadsheets will give you a head start on developing your own models.

A flexible and successful financial projection model does more than just add numbers--it explains the complex relationships between those numbers and illuminates ways to use those associations to add value to an enterprise. Building Financial Models is the only book you need to create and implement a fluid financial projection model that is both state of the art and user friendly.

Product Details

ISBN-13:
9780071608893
Publisher:
McGraw-Hill Professional Publishing
Publication date:
05/27/2009
Series:
[Irwin Library of Investment and Finance]
Edition description:
List
Pages:
464
Sales rank:
575,259
Product dimensions:
6.20(w) x 9.10(h) x 1.40(d)

Table of Contents

1.A Financial Projection Model

2.Best Practices in Modeling

3.Starting Out

4.Your Model-Building Toolbox: F Keys and Ranges

5.Your Model Building Toolbox: Functions

6.The Role of Cash in Modeling

7.Balancing the Balance Sheet

8.Income Statement and Balance Sheet Accounts

9.Putting Everything Together

10.The IS and BS Output Sheets

11.The CF sheet

12.Ratios: Key Performance Indicators

13.Forecasting Guidelines

14.The Cash Sweep

15.The Cash Flow Variation for Cash Sweep

16.Recording macros

17.Discounted Cash Flow Valuation

18.On-screen controls

19.Bells and whistles

20.Writing a macro in visual basic for applications

Customer Reviews

Average Review:

Write a Review

and post it to your social network

     

Most Helpful Customer Reviews

See all customer reviews >

Building Financial Models 2.8 out of 5 based on 0 ratings. 6 reviews.
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago
Anonymous More than 1 year ago