Building a Financial Model (of a Company)

Description

Design and create a dynamic financial model of a company that adheres to the highest industry standards

This hands-on course focuses on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards. The course material includes model design, logic, construction, financial concepts and accounting treatment. During the seminar, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.



Building a Financial Model (of a Company) also serves as a preparatory course for the Advanced Financial Modeler (AFM) exam offered by the Financial Modeling Institute (FMI)

Details
Prerequisites

Participants should have a solid grasp of basic accounting fundamentals and proficiency with Excel prior to taking this course

Time

1 day

Learning Topics

Design and Structure a Financial Model

  • Design and layout a financial model clearly and logically
  • Discuss the need for a model to serve as a marketing tool
  • Create clearly defined inputs and assumptions sections
  • Connect strings of data to create assumptions and footnotes

Build Powerful Scenarios and Financial Statements

  • 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

Incorporate all Relevant Schedules

  • Construct all necessary schedules
  • 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 (or Revolving Credit Facility)
  • Design and incorporate a cash sweep for a company’s Bank Operating Line
  • Balance the company’s balance sheet
Download a one-page course summary
Download Now

Upcoming Building a Financial Model (of a Company) Events

All Events