3-Statement Modeling

Overview

High-performing leaders and teams often feature great communicators. Ironically, we spend little of our professional time thinking and talking about what great communication looks like. Learn the secrets of high-impact communication; explore effective vs. less effective communication channels; discover the power of giving and receiving professional feedback; the benefits, and curses, of nonverbal communications; and how to make highly impactful presentations.Plus, to reinforce learning, you will actively engage in lively and informative communication-related activities. The webcast was originally broadcast on May 30, 2013. Note: There is a minimum passing rate of 70% for this course.

Highlights

• 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.

Objectives

• Determine how the balance sheet serves as an error detection system by correctly linking the income statement, cash flow statement, and balance sheet in a three-statement model.
• Identifythe two primary circular loops in a financial model and the steps required to implement a circularity switch to manage them effectively.
• Recognize how to present model results clearly by summarizing key figures on a dashboard and applying print and formatting techniques for professional output.

Preparation

Attendees should have a basic understanding of accounting fundamentals and Excel.

Notice

This is a self-study/on demand course offered by a 3rd party vendor and will NOT be accessible in the My Upcoming CPE section of the ISCPA website. Course access information will be emailed directly to you by CalCPA. The course expires one year from the purchase date. Format = Online Self-Study.