Skip to main content

ISCPA observes summer hours, and team members may be unavailable after noon on Fridays.

FP&A Modeling Pt.5 - Debt and Capex Analysis

Available Until

Self-study

2.00 Credits

Member Price $49.00

Non-Member Price $59.00

The item(s) you are attempting to remove has already been removed from your cart.

Overview

Examine functions that help us trap and handle errors and discuss efficient methods to perform list comparisons. Continue to integrate these features as we proceed throughout the series. This is part 4 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 how corkscrews can be used to monitor capital expenditure and track property, plant & equipment (PP&E) totals in a financial model.
  • Use corkscrews to also monitor the company's cash balance and the amount of borrowing on a revolving line of credit.
  • Calculate the amount of cash that may be needed from a revolving line of credit or excess cash amounts that could be used to pay down any existing revolver balance.
  • Install model checks to determine whether or not the limit on a revolving line of credit has been exceeded.

Prerequisites

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

Objectives

  • Track monthly capital expenditure and use corkscrews to monitor balances for property, plant & equipment (PPE).
  • Explore best-in-class approaches to tracking cash balances and a revolving line of credit.
  • Establish the revolving line of credit as the lender of last resort and install an alert if its limit has been exceeded.

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.

Non-Member Price $59.00

Member Price $49.00

Add To Cart