LEADER 05405nam 2200745 450 001 9910140499703321 005 20220426120108.0 010 $a1-118-85445-4 010 $a1-118-95739-3 010 $a1-118-85446-2 035 $a(CKB)2670000000570934 035 $a(EBL)1813673 035 $a(SSID)ssj0001369812 035 $a(PQKBManifestationID)11883161 035 $a(PQKBTitleCode)TC0001369812 035 $a(PQKBWorkID)11289992 035 $a(PQKB)10022022 035 $a(DLC) 2014017619 035 $a(Au-PeEL)EBL1813673 035 $a(CaPaEBR)ebr10953589 035 $a(CaONFJC)MIL650911 035 $a(OCoLC)879119445 035 $a(CaSebORM)9781118854365 035 $a(MiAaPQ)EBC1813673 035 $a(PPN)241285453 035 $a(EXLCZ)992670000000570934 100 $a20141201h20152015 uy| 0 101 0 $aeng 135 $aurcnu|||||||| 181 $ctxt 182 $cc 183 $acr 200 10$aCorporate and project finance modeling $etheory and practice /$fEdward Bodmer 205 $a1st edition 210 1$aHoboken, New Jersey :$cWiley,$d[2015] 210 4$d©2015 215 $a1 online resource (627 p.) 225 1 $aWiley finance series 300 $aIncludes index. 311 $a1-118-85436-5 311 $a1-322-19631-1 327 $aCorporate 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 327 $aStructure 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 Share 327 $aChapter 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 Assumptions 327 $aAlternative 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 Period 327 $aStructuring 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 Flow 327 $aTransparent Calculations of Pretax Cash Flow 330 $aA 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 410 0$aWiley finance series. 606 $aProject management$xFinance 606 $aGestió de projectes$2thub 606 $aFinances$2thub 608 $aLlibres electrònics$2thub 615 0$aProject management$xFinance. 615 7$aGestió de projectes 615 7$aFinances 676 $a658.1501/1 700 $aBodmer$b E$g(Edward),$0960621 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910140499703321 996 $aCorporate and project finance modeling$92177727 997 $aUNINA