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

Overview

CFI’s - FP&A Modeling Pt.5 - Debt and Capex Analysis - course will help you filter through any past challenges you may have had to learn best-in-class approaches to monitor the company’s capital expenditure. This course will also include detailed instructions about how to install a revolving line of credit and set it up as the lender of last resort in the model.

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.