Sold out

OVERVIEW

This is a two-part course. The first part focuses on the fundamentals of financial modeling and the second focuses on cash sweep and building a fully integrated three statement forecast model.
 
5 hours of video content.
Estimated 10 hours to complete.

Financial Modeling - Fundamentals:

Learn to build a detailed, fully integrated three statement forecast model for a corporate. You will learn best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse. Throughout the training you will learn the tried and tested habits and techniques to minimize errors, and make models easy to interpret, adapt and audit.
 

Financial Modeling - Cash Sweep:

Learn to build a detailed, fully integrated three statement forecast model for a corporate with high leverage, as well as how to model an automated, debt pay-down such that the business will reduce its debt as fast as possible, without impacting the operational needs of the firm. You will learn best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse, whilst learning tried and tested habits and techniques to minimize errors, and make models easy to interpret, adapt and audit.

LEARNING OBJECTIVES

  • Forecast an Income Statement, Balance Sheet and Cash Flow Statement, given a set of forecast assumptions
  • Incorporate an operating cash requirement into the model and understand how this differs to the modeling of excess cash
  • Build all formulae clearly and correctly
  • Balance your balance sheet every time from your well-constructed CFS
  • Compute interest income and expense based on average balances, and carefully control the resulting intentional circularity
  • Check your complete model for errors and save it in a professional manner, ready to be shared with colleagues or clients
  • Forecast debt repayments using a ‘cash-sweep’ or ‘debt-waterfall’ such that the model will automatically adapt to any assumption changes that impact cash, and always pay down debt as quickly as feasible

TOPICS COVERED

Complete topics step by step or jump to any of the below at any time.

  • Model steps
  • Operating cash
  • Deriving the cash flow statement from scratch
  • Balancing the balance sheet
  • Cash sweep concept
  • Modeling the revolver and other debts
  • Linking debt to the balance sheet
  • Calculating interest
  • Stress testing and final checklist

PREREQUISITES

This course is open to all. To maximize the benefit of this course we recommend an understanding of financial statements and Microsoft Excel.

REVIEWS

**Training The Street acquired AMT Training in 2021. We have merged AMT's products into one store, to increase our content offering.**

Save money with this course by purchasing our bundle!

This course is available in the:
Essentials 10 Courses Bundle - Valuation, Modeling and Origination.

Save up to 57% on all courses with this bundle!
The bundle includes the following courses:

  • Financial Statement Analysis
  • Excel Best Practices for PC: Become an Excel Expert
  • Financial Modeling: Building a Complete Model in Excel
  • Corporate Valuation: How to Value Companies and Mergers
  • Merger Modeling: How to build an M&A Model in Excel
  • LBO Modeling: Building an LBO Model in Excel
  • Capital Markets and Corporate Funding
  • Debt Captial Markets
  • Equity Capital Markets
  • Applied Excel: Working with Data Sets and Scenario Analysis

Group Orders

We offer discounts for group orders on our self-study products. Group orders are an attractive option for companies or teams looking to upskill together.

Contact us at selfstudy@trainingthestreet.com to learn more about how to save money on group orders.


Browse All Course Bundles Below:

Sold out

Sold out

Sold out

Sold out

Gain your recognition with our digital certificates

Training The Street has been teaching the biggest finance firms for over 20 years. To help unlock your career potential, we offer certificates to provide the recognition you deserve.

After you finish your course, you will receive a certificate which can be easily added to your LinkedIn profile.