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.
Learning 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.
Major Topics
• 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.
