This free preview course will help you learn to build a fully integrated three statement forecast model for a corporate, learning best practice in formula construction and how to use keyboard shortcuts to eliminate use of the mouse.
This free preview course will help you learn to build a fully integrated three statement forecast model for a corporate, learning 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.
Learning Objectives
Forecast an Income Statement, Balance Sheet and Cash Flow Statement, given a set of forecast assumptions
Build all formulas 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
Topics Covered
Complete topics step by step or jump to any of the below at any time.
Best practice
Model steps
Balancing 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.
Since 1999, Training The Street (TTS) offers targeted training courses to academic, corporate, and public enrollment clients. TTS provides unparalleled training and practical skills development in accounting, corporate finance, financial modeling, and valuation topics for finance professionals.
By incorporating a mix of hands-on instruction, computer-based exercises, mini-lectures, group projects, visual presentations, and practical illustrations, we teach you real-world applications of finance theory in a way that brings finance fundamentals to life.
Our differences make up the core of our strength
At Training The Street, we are committed to providing a safe and inclusive environment and strive wholeheartedly to be free from racism and discrimination of any kind.
We are therefore committed to going above and beyond to build a more just and equitable environment where all individuals can achieve their full potential.
It is the policy of Training The Street to provide and promote equal opportunity for all people without regard to race, color, creed, national origin, gender, age, sexual orientation, religion, marital status, familial status, veteran’s status, gender identity, or the presence of any sensory, mental, or physical disability.
We are proud to acknowledge that our differences make up the core of our strength.
Hands-on practical training course to help you learn exactly what is required to do in your daily work. Up-skill your knowledge to be a Financial Analyst. Practical assignments, illustration spreadsheets, and excel shortcuts- all included and can be downloaded at your end for self-practice.
The Financial Modeling Professional Certificate teaches you how to build common to complex financial models on Excel with the information provided both on financial statements and from external sources.
This five-day advanced certificate program consists of three courses; Fundamentals of Financial Modeling, Best Practice Financial Modeling and Advanced Financial Modeling.
This course will introduce the learner to financial models by familiarizing the learner with aspects of financial models like financial forecasting, revenue projections, and expense and margin.
Build a comprehensive DCF (Discounted Cash Flow) model and master essential finance and accounting concepts. First, you'll dive into advanced Excel functions for finance like VLOOKUP and IF statements.
© 2024 coursetakers.com All Rights Reserved. Terms and Conditions of use | Privacy Policy