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