Building a Financial Model - VIRTUAL CLASS

Desktop keyboard


Learning Objectives

Topics Include

  • Model design
  • Logic
  • Construction
  • Financial concepts and accounting treatment

Learning Outcomes

  • Design and layout a financial model clearly and logically
  • Develop useful inputs and assumptions schedules
  • Use switches to create effective scenarios and value drivers
  • Forecast and build-up a company's revenues and expenses
  • Design and incorporate a company's income statement, balance sheet and cash flow statement
  • Construct all necessary schedules, including:
    • Depreciation/CAPEX Schedule
    • Working Capital Schedule
    • Income Tax Schedule
    • Debt and Interest Schedule
    • Shareholders' Equity Schedule
  • Use Lookup functions within the model to effectively extract information
  • Properly incorporate Senior Term Debt with an amortizing repayment schedule
  • Create a robust Bank Operating Line (Revolving Credit Facility)
  • Design and incorporate a cash sweep for a company's Revolver
  • Balance the company's balance sheet
  • Rid a model of undesirable error messages