Self-Study: FP&A Modeling Pt.4 - Contractor Analysis

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.