Corporate and project finance modeling : theory and practice /

A clear and comprehensive guide to financial modeling and valuation with extensive case studies and practice exercises Corporate and Project Finance Modeling takes a clear, coherent approach to a complex and technical topic. Written by a globally-recognized financial and economic consultant, this bo...

Full description

Bibliographic Details
Main Author: Bodmer, E. (Edward)
Format: eBook
Language:English
Published: Hoboken, New Jersey : Wiley, [2014]
Subjects:
Online Access:Connect to the full text of this electronic book
Table of Contents:
  • Intro; Title Page; Copyright; Preface; Acknowledgments; Part I: Financial Modeling Structure and Design; Chapter 1: Financial Modeling and Valuation Nightmares; Chapter 2: Becoming a Black Belt Modeler; Chapter 3: General Model Objectives of Structuring Transactions, Risk Analysis, and Valuation; Chapter 4: The Structure of Alternative Financial Models; Structure of a Corporate Model: Incorporating Historyand Deriving Forecasts from Historical Analysis; Use of the INDEX Function in Corporate Models; Easing the Pain of Acquiring PDF Data.
  • Structure of a Project Finance Model That Accounts for Different Risks in Different Phases over the Life of a ProjectReconciliation of Internal Rate of Return in Project Finance with Return on Investment in Corporate Finance; Structure of an Acquisition Model: Alternative Transaction Prices and Financing Terms; Structure of an Integrated Merger Model: Forecasting Earnings per Share; Chapter 5: Avoiding Bad Programming Practices and Creating Effective Auditing Processes; How to Make Financial Models More Efficient and Accurate; Chapter 6: Developing and Efficiently Organizing Assumptions.
  • Assumptions in Demand-Driven Models versus Supply-Driven Models: The Danger of Overcapacity in an IndustryCreating a Flexible Input Structure for Model Assumptions; Alternative Input Structures for Project Finance and Corporate Finance Models; Setting Up Inputs with Code Numbers and the INDEX Function; Chapter 7: Structuring Time Lines; Timing in Corporate Finance Models: Distinguishing the Historical Period, Explicit Period, and Terminal Period; Development to Decommissioning: Phases in the Life of a Project Finance Model.
  • Timing in Acquisition Models: Separating the Transaction Period, the Holding Period, and the Exit PeriodStructuring a Time Line to Measure History, Explicit Periods, and Terminal Periods in Corporate Models and Risk Phases in Project Finance Models; Computing Start of Period and End of Period Dates; TRUE and FALSE Switches in Modeling Time Periods; Computing the Age of a Project in Years on a Monthly, Quarterly, or Semiannual Basis; The Magic of a HISTORIC Switch in a Corporate Model; Transferring Data from a Corporate Model to an Acquisition Model Using MATCH and INDEX Functions.
  • Chapter 8: Projecting Revenues, Expenses, and Capital Expenditures to Derive Pretax Cash FlowTransparent Calculations of Pretax Cash Flow; Inflation and Growth Rates in Calculations of Pretax Cash Flow; Valuation Analysis from Prefinancing, Pretax Cash Flow; Chapter 9: Moving from Pretax Cash Flow to After-Tax Free Cash Flow; Working Capital Analysis; Problems in Computing Depreciation Expense in Corporate Models Involving Asset Retirements; Portfolios of Assets with a Vintage Process; Accounting for Asset Retirements in Corporate Models.