Dates and location
Pricing
Hours
Dates and location
Pricing
Hours
Description
Being able to construct and balance a 3-Statement Modeling is a critical skill for many roles in accounting and finance. Including an income statement, cash flow statement, and balance sheet helps to assess the financial health of a business. Connecting the balance sheet correctly can also help by adding an error detection system to highlight issues with the financial model.
This course discusses model circularity in detail beginning with the advantages and disadvantages of building circular models. We review the two circular loops in the model and walk through the necessary steps to install a circularity switch. Important figures from the financial statements are summarized on an attractive model dashboard. We also review important print settings used to format the model as a polished financial presentation.
Topics Include:
- Model Theory
- Compact 3 Statement Model
- Model Design
- Model Drivers
- Operational Schedules
- Capital Structure
- Financial Statements
- Circularity
- Dashboard
- Checks
- Printing
Unlock learning anytime, anywhere with the Blackboard Learn app
Seamlessly access your on demand courses, assignments, and get PD hours on the go. Learn how to download now and elevate your education experience with the convenience of mobile learning.
Key Takeaways
Upon completing this course, you will be able to:
- Review the best way to design 3-Statement Modeling, which have been prioritized for presentation and printing.
- Use separate corkscrews to build debt and equity schedules, including detailed instructions for installing a dynamic revolving line of credit.
- Understand the correct linkages between the three financial statements and how to use the balance sheet as an error detection system for the model.
- Discuss the two circular loops in the financial model and how to connect them to a circularity switch to reset the model when needed.
- Pull important figures from the financial statements into a rich dashboard with graphs highlighting critical model insights.
- Summarize model checks on the cover page with conditional formatting to alert the user to any areas of concern in the model.
Who Will Benefit
This course is most suitable for anyone working in investment banking, equity research, and private equity. The content may also be relevant for other financial modeling roles such as corporate development.
How to Access the Course
New mobile learning! Download Blackboard Learn from your app store (iOS or Android). Learn more.
To access the course on your computer please visit our BlackBoard site, and log-in using the same login and password used for the Registration Portal.
Please allow up to 15 minutes after registration for the course to appear on your BlackBoard page.
Registration, cancellation, withdrawal and all other CPA Ontario PD policies can be found here.
Speaker(s)
Duncan McKeen is fascinated with pedagogy and loves course creation and design. He is an effective communicator with extensive experience teaching financial modeling, accounting, analysis, and valuation. Since 2014, Duncan has been focused on designing courses and teaching financial modeling to employees working in accounting, valuation, investment banking, equity research, and private equity. He also has extensive experience providing consulting services on financial modeling to large corporations and institutions. Prior to transitioning over to teaching, Duncan held senior equity research positions with top banks & brokerages using financial models to form opinions and guide institutional investors with capital allocation. Since 2015, he has also been an Adjunct Faculty member teaching financial modeling courses at the Smith School of Business at Queen’s University.