Financial Modeling | TTS Academy eLearning course

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!

FIND OUT MORE

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

Browse All Course Bundles Below:

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.

Item added to your cart