skip to Main Content

juin, 2018

13juin9:00 AM5:00 PMBuilding a financial modelThe Marquee Group

Détails

Building a financial model (of a company)

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.

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, 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 (or Revolving Credit Facility)
  • Design and incorporate a cash sweep for a company’s Bank Operating Line
  • Balance the company’s balance sheet

This seminar will focus on the skills required to design and create an interactive financial model of a company that adheres to the highest industry standards

  • Participants will learn to forecast a company’s income statement, cash flow statement, and balance sheet
  • Course material includes model design, logic, construction, financial concepts and accounting treatment
  • Price: $600 + tax ($525 + tax if registration is paid by Wednesday, May 30, 2018)
  • Save 20% with code: MTL20 at checkout

Heure

(Mercredi) 9:00 AM - 5:00 PM

Adresse

Concordia University downtown Campus

1455 Boulevard De Maisonneuve West

Organisateur

Back To Top
X
X