What Do Analysts at Goldman Sachs and Amazon Have in Common?
They master their craft with the full CFI curriculum. Now 45% off with code AFF45FI, through Nov 1.
Get 45% Off
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.
Who Should Take This Course?
This course is perfect for FP&A professionals at a beginner, intermediate, or even advanced level. This course is a part of a series of FP&A courses.FP&A Modeling Pt.5 - Debt and Capex Analysis Learning Objectives
- 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 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
