FP&A Modeling Pt.6 - Financial Statement Aggregation

Overview

Cover fundamental functions, concepts and techniques that provide a firm foundation for our workbooks. Continue to integrate these items as we proceed throughout the series. This is part 2 of a 10-part series: Module 1: Fundamental Features Module 2: Fundamental Functions, Concepts, Techniques Module 3: Six Critical Excel Functions Module 4: Handling Errors and Comparing Lists Module 5: Date and Text Functions Module 6: Time-Saving Techniques Module 7: Introduction to PivotTables Module 8: PivotTable vs. Formula-Based Reports Module 9: PivotTable Wrap-Up and Web Data Module 10: Getting, Preparing and Summarizing Data

Highlights

• Understand the difference between current & deferred income taxes and why both are needed in FP&A models.
• Use consolidated monthly financial statements to determine the company's health in terms of profitability and cash flow
• Use Excel functions to aggregate monthly figures into quarterly and annual estimates.

Prerequisites

Although not required, it is recommended to take the sections of this eight-part series in order.

Objectives

• Track current & deferred income taxes monthly to determine profitability and cash impact of tax payments.
• Consolidate FP&A figures into financial statements to evaluate the financial health of the company.
• Aggregate monthly figures using industry best practices up into quarterly and annual estimates.

Preparation

Attendees should have a basic understanding of accounting fundamentals and financial reporting.

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.