Overview: 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. During the seminar, participants will build a model that includes a forecast of a company’s income statement, cash flow statement and balance sheet.

 

The course material includes model design, logic, construction, financial concepts and accounting treatment. Various intermediate Excel tools along with helpful keyboard shortcuts will also be covered throughout the day.

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

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

* Places limited, registration required before 4:00 PM, Friday, September 25.

Please note that a laptop with a full working version of Microsoft Excel is required for this seminar

 

 

JON ZELMAN Principal The Marquee Group Prior to joining The Marquee Group, Jon was an investment banking professional who advised clients on a wide range of transactions and opportunities including mergers and acquisitions, debt and equity financings, restructurings and liability management. Read more...