Financial Modeling – Cash Sweep

Description

**AMT Training joined Training The Street in 2021. Our eLearning is now offered on Training The Street**

Training The Street’s online self-study courses are perfect for busy professionals who want to sharpen their financial skills and advance their careers. Our self-study courses use the same content and the same instructors to put you in control so you can learn at your own pace.

All participants who attend the public course training receive a certificate of completion.

Our expanded offering provides is now live on TTSacademy.com. Click below for more.

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.

What you will learn

• 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
• 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
• 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