Financial Modeling - Cash Sweep and Troubleshooting

Description

AMT Training has a new home!

In 2021, AMT Training joined Training The Street

The new global standard in financial modeling and valuation training
We have expanded our product offering by combining our content libraries with Training The Street. You can find your training solutions for corporate, Public Courses, and self-study all in one place.

Who should attend the course?

• New hires who have joined the firm late and missed the in-house program
• Individuals looking to fill a knowledge gap
• Experienced bankers looking to refresh their technical skills
• Teams employed in financial strategy roles from non-banking corporations
• Graduates preparing to interview for a role in the finance sector
• Students at business school and looking for a career in finance

What you will learn

Financial Modeling - Cash Sweep

In this session, we build a three statement operating model for a real company, which incorporates a detailed revenue forecast based on price and volume drivers. We set up a hierarchy of a series of debt items and we learn how to model the sequential debt paydown using a ‘cash sweep’ approach. Best practice modeling techniques are emphasized throughout.

Learning outcomes:

• Building a detailed debt schedule
• The waterfall of debt repayments
• Building a simple cash sweep
• Modeling revolver
• Modeling a price/volume revenue forecast

Financial Modeling - Troubleshooting

This session covers a range of error-checking techniques to find and correct the most common errors found in financial models. We use a series of financial models to allow participants to practice error-checking.

Learning outcomes:

• Stabilizing a model
• Making a model map
• Sanity checking a model
• Fixing a non-balancing balance sheet
• Troubleshooting techniques for cash flow statements
• Checking the model’s matrix
• Finding unidentified hard numbers
• Using Excel’s ‘Jump tool’ to trace through formulas with ease
• Using Excel to show the formulas underlying output
• Using Excel’s auditing tool to trace formulas