FP&A Modeling Pt.4 - Contractor Analysis

Overview

This session continues the discussion about external data and digs into the details for retrieving data from other sources. Pull data from an Access database using Microsoft Query; learn how to retrieve data from simple text files; and prepare data for use with Excel. This session concludes by examining several data visualization tools in Excel, including PivotCharts. This is part 10 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

• 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

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.