05405nam 2200745 450 991014049970332120220426120108.01-118-85445-41-118-95739-31-118-85446-2(CKB)2670000000570934(EBL)1813673(SSID)ssj0001369812(PQKBManifestationID)11883161(PQKBTitleCode)TC0001369812(PQKBWorkID)11289992(PQKB)10022022(DLC) 2014017619(Au-PeEL)EBL1813673(CaPaEBR)ebr10953589(CaONFJC)MIL650911(OCoLC)879119445(CaSebORM)9781118854365(MiAaPQ)EBC1813673(PPN)241285453(EXLCZ)99267000000057093420141201h20152015 uy| 0engurcnu||||||||txtccrCorporate and project finance modeling theory and practice /Edward Bodmer1st editionHoboken, New Jersey :Wiley,[2015]©20151 online resource (627 p.)Wiley finance seriesIncludes index.1-118-85436-5 1-322-19631-1 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 ModelsStructure of a Corporate Model: Incorporating History and 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 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 ShareChapter 5: Avoiding Bad Programming Practices and Creating Effective Auditing Processes How 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 AssumptionsAlternative 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 FlowA 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 highlyWiley finance series.Project managementFinanceGestió de projectesthubFinancesthubLlibres electrònicsthubProject managementFinance.Gestió de projectesFinances658.1501/1Bodmer E(Edward),960621MiAaPQMiAaPQMiAaPQBOOK9910140499703321Corporate and project finance modeling2177727UNINA