Corporate and project finance modeling : theory and practice / Edward Bodmer.
By: Bodmer, E. (Edward).Material type: BookSeries: Wiley finance series: Publisher: Hoboken, New Jersey : Wiley, Description: 1 online resource.Content type: text Media type: computer Carrier type: online resourceISBN: 9781118854457 (epub); 1118854454 (epub); 9781118854464 (pdf); 1118854462 (pdf); 9781118957394; 1118957393.Subject(s): Valuation -- Mathematical models | Finance -- Mathematical models | Financial risk -- Mathematical models | BUSINESS & ECONOMICS -- Industrial Management | BUSINESS & ECONOMICS -- Management | BUSINESS & ECONOMICS -- Management Science | BUSINESS & ECONOMICS -- Organizational Behavior | Valuation -- Mathematical modelsGenre/Form: Electronic books. | Electronic books.Additional physical formats: Print version:: International valuation, modelling and project finance analysisDDC classification: 658.1501/1 Online resources: Wiley Online Library
Description based on print version record and CIP data provided by publisher.
Corporate and Project Finance Modeling: Theory and Practice; Contents; Preface; Acknowledgments; Part I: Financial Modeling Structure and Design: Structure and Mechanics of Developing Financial Models for Corporate Finance and Project Finance Analysis; Chapter 1: Financial Modeling and Valuation Nightmares: Problems That Financial Models Cannot Solve; 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 History and Deriving Forecasts from Historical AnalysisUse 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 Project; Reconciliation 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 ProcessesHow to Make Financial Models More Efficient and Accurate; Creating Shortcut Keys and Setting Up the Model Area So You Can Build Your Model Quickly; Color Conventions and Creating the SHIFT, CNTL, C Macro to Color Inputs; Creating an Audit Page That Tells You Where Errors Are Located; Chapter 6: Developing and Efficiently Organizing Assumptions; Assumptions in Demand-Driven Models versus Supply-Driven Models: The Danger of Overcapacity in an Industry; Creating a Flexible Input Structure for Model Assumptions
Alternative Input Structures for Project Finance and Corporate Finance ModelsSetting 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 Period
Structuring a Time Line to Measure History, Explicit Periods, and Terminal Periods in Corporate Models and Risk Phases in Project Finance ModelsComputing 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 Flow; Transparent Calculations of Pretax Cash Flow
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 book provides a thorough explanation of financial modeling and analysis while describing the practical application of newly-developed techniques. Theoretical discussion, case studies and step-by-step guides allow readers to master many difficult modeling problems and also explain how to build highly.