Corporate and Project Finance Modeling

Index

• Accretion and dilution
• Accumulating periodic data
  • automatically adjusting formulas
  • balance sheet accounts
  • detailed sheet
  • fiscal month switch
  • income statement items
  • quarterly counter
  • quarterly summary report
• Acquiring PDF data
• Acquisition model phases
  • acquisition period
  • alternative holding periods
  • exit period
  • optimal period
• Acquisition model structure
  • cash flow priorities
  • exit values
  • goodwill analysis
  • holding period
  • pro forma balance sheet
  • sources and uses
• Aggregate test
• ALT and F1
• Annual page
• Annuity and equal installment repayments
  • tax effects
• Arrange all option
• Array variable
• Asset retirements
  • full life cycle of plant
  • gross plant balance
  • new growth
  • percent of depreciation
  • true cash flow
• Automatic except data tables

• Back-of-the-envelope models
• Bad programming practice
  • auditing processes
  • inputs as part of a formula
• Balance sheet test
• Benchmarking and regression of multiples
  • implied cost of capital
  • regression analysis and offset function
• Bond cash account
• Break-even analysis
  • corporate finance
  • debt service coverage ratio
  • deriving the break-even point
  • forecasting commodity prices
  • Goal Seek
  • IRR on senior debt
• Bridge between equity value and enterprise value
  • analogy to invested capital segregation
  • and weighted average cost of capital
  • use of market value
• Brownian motion

• Cap exp to depreciation
  • and implied EV/EBITDA
  • net plant depreciation formula
  • nominal current currency
  • and plant age
  • stabalization
• Capital asset pricing model
  • failed