merger merger

Welcome to your new course portal!

On October 15th, hotcourses.com moved to findcourses.co.uk - which means you can now find all your favourite courses right here. Don't worry - you can still do all the things that you could do before.

All you need to do is search.

Show findcourses.co.uk as: Mobile

Financial Modeling - Cash Sweep and Troubleshooting (1 day)

AMT Training
Course summary
1 day
650 GBP
Full time
Online courses
Next available date: Online delivery option may be available - Please contact provider - Online courses
Professional Training

Course description

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.

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.

Suitability - Who should attend?

  • 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

Outcome / Qualification etc.

Cash Sweep 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

Troubleshooting 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

About provider

AMT Training - Financial Modeling Courses

For over 20 years we have been equipping analysts and associates with core skills for banking and finance. Our clients include the top ten investment banks and some of the biggest private equity firms in the world. With offices in...


Read more and show all courses with this provider

Request info

Fill out your details to find out more about Financial Modeling - Cash Sweep and Troubleshooting (1 day).

  Contact the provider

  Get more information

  Register your interest

Contact info

AMT Training

5th floor Whitechapel Building 10 Whitechapel High Street
E1 8QS London

 Show phone number
www.amttraining.com

Reviews

Average rating 4.8

Based on 24 reviews.

Lizzie
They was a very kind trainer who was very patient with me and always went the extra mile to help and clear my doubts. Definitely we had many interesting conversations on business, finance and markets which helped clarify my misunderstandings as well. Thank you and hope to see them again!
Eloise
I think the training session is quite beneficial. I like financial modeling session most.
Blake
They were very nice and eay to communicate, we all enjoy their training sessions.
Request Information

Find out more about this Financial Modeling - Cash Sweep and Troubleshooting (1 day) course - simply fill out your details:

Reviews
Course rating
(4.8)
Based on 24 reviews.
Not sure where to start?