FP&A Modeling Pt.5 - Debt and Capex Analysis (1.5 hours) - OnDemand Webcast
Available Until
On-Demand
1.5 Credits
Member Price $49.00
Non-Member Price $74.00
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.
Notice
“Adding to Calendar” does not register you for this event. Please either register online by clicking “Add to Cart” or contacting OSCPA at 503-641-7200 / 800-255-1470, ext. 3. Thank you!
Non-Member Price $74.00
Member Price $49.00