FP&A Modeling Pt.4 - Contractor Analysis (1 hour) - OnDemand Webcast

Overview

CFI’s - FP&A Modeling Pt.4 - Contractor Analysis - course will help you filter through any past challenges you may have had to learn best-in-class approaches to forecasting contractor costs in FP&A models. This course will also include a summary of the company’s cost of goods sold (COGS) and selling, general & administrative (SG&A) for the income statement.

Highlights

• Explore functions in Excel to accurately calculate the number of workdays per period for the financial model.
• Use functions to detect whether there has been a scheduling issue with any of the contractors listed on payroll.
• Evaluate ways to schedule payables for contractors that mimic how these costs impact the company from a cash perspective.
• Summarize accrued amounts for cost of goods sold (COGS) and selling, general & administrative (SG&A) for use on the company's income statement.

Prerequisites

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

Objectives

• Track monthly days scheduled for contractors and calculate expenses using per-day amounts.
• Calculate contractor payables to determine the impact they are having on the company's cash flow.
• Summarize totals for cost of goods sold (COGS) and selling, general & administrative (SG&A) for use on the company's income statement.

Preparation

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

Notice

“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!