About & Tour

The best bankers training program dollar for dollar, world-wide

1. Benefits

With FinancialModelTraining's courses, you will:

Learn how to build 3-way integrated Financial Models (Profit & Loss, Cash Flow and Balance Sheet statements) that forecast for a five year period;
Learn how to derive a discounted cash flow valuation using the same techniques as Investment Bankers, Corporate Financiers, Private Equity Analysts and Financial Analysts;
Learn techniques for assessing the credit worthiness and debt capacity of a company.

You will learn skills to develop your career in:

Investment Banking and M&A
Corporate Finance
Accounting Advisory Services
Financial Analysis
Research
Private Equity & Venture Capital
Relationship Banking

FinancialModelTraining.com is also great for people wanting to learn how to develop valuations on companies for their own private use.

Boost your Finance skill set, boost your resume and boost your career -

2. Course Contents Listing

Primer	Level 1 Course	Level 2 Course
Why use the Dividend Discount Model? Forecast Dividends Per Share for the Forecast Period Determine an appropriate Discount Rate to discount the Dividends The Gordon Growth Model as the Terminal Value Determining Justified Share Price and Sensitivity Analysis Finding Assumptions Data	What is Financial Modelling? Four Sections of a Model The Layout of a Model The Assumptions of a Model The Engine of a Model The Metrics Output Goals & Requirements of this Course The aim of the Layout Date Functionality Laying Out the Operating Assumptions Laying Out the Capital Assumptions Laying Out the Profit & Loss Statement Laying Out the Balance Sheet Laying Out the Cash Flow Statement Chapter 2 QUIZ Operating vs Capital Assumptions Operating Assumptions List Sales Growth & Gross Margin Assumptions Wages & Salaries, Variable Costs & Fixed Costs Assumptions Working Capital Theory and the basic Cash Collection Cycle Working Capital Assumptions & Formulas Tax Rate Assumption Operating Expenses vs Capital Expenses CAPEX, Depreciation and Amortisation Assumptions Operating Assumptions Check Page Chapter 3 QUIZ What is Capital and Who provides it? Equity Capital Assumptions Term Debt Capital Assumptions Overdraft and Cash Assumptions Check your Capital Assumptions Here Chapter 4 QUIZ What is the Model Engine? The Check Mechanism and its Importance Summing Infrastructure in the Profit & Loss statement Summing Infrastructure in the Cash Flow statement Summing Infrastructure for the Balance Sheet Chapter 5 QUIZ The Engine, and Double Entry Accounting in a Financial Model Retained Earnings Linkage Cash & Overdraft Linkages Sales & COGS Wages & Salaries, Variable Costs & Fixed Costs Check Your Progress Here Chapter 6 Quiz Discussion Chapter 6 QUIZ Tax Theory Tax Formulas Relative & Absolute References in Excel Depreciation CAPEX & PP&E Amortisation & Intangibles Chapter 7 QUIZ Working Capital Revisited Receivables Formulas Inventory Creditors Progress Check Point Chapter 8 QUIZ The Capital Structure of the Company Interest Income & Interest Expense Term Debt Balances Equity & Dividends Check your Work Chapter 9 Quiz What are Metrics? EBIT/Interest Debt/EBITDA Debt/Capital Debt Service Coverage Cash Collection Cycle Margins DuPont Analysis Simple Debt Capacity Simple Payback Period Calculation CFADS Debt Capacity Check Progress Here Chapter 10 QUIZ Dividend Discount Model Why use the Dividend Discount Model? Forecast Dividends Per Share for the Forecast Period Determine an appropriate Discount Rate to discount the Dividends The Gordon Growth Model and the Terminal Value Determining Justified Share Price and Sensitivity Analysis	Welcome to Level 2 About the Level 2 Course Detailed Operating Assumptions Building Up Sales & COGS Forecast Sales & COGS The Working Capital Cycle Revisited Working Capital Assumptions and Formulas Employee Provisions Assumptions Employee Provisions Formulas Chapter 2 QUIZ More Complex Capital Structures The Interest Calculation Switch Interest Rates & Principal Movements Capital Assumption Calculations The Capital Schedule Cash Sweeping Functionality Part 1 Cash Sweeping Functionality Part 2 Cash Sweeping Functionality Part 3 Cash Sweeping Functionality Part 4 Linking the Capital Schedule to the Financial Statements Linking the Capital Schedule to the Financial Statements Continued Interest and Convertible Coupons Preference Share Dividends Fixed Assets and Tax Modelling Opening & Closing Fixed Asset Balances Tax Assets & Liabilities due to Depreciation Depreciation Methods Depreciation Formulas Linking Fixed Asset and Tax Items to the Financial Statements Check Progress Here Chapter 4 QUIZ Weighted Average Cost of Capital The Costs of Debt Capital Sources The Costs of Hybrid Capital The Cost of Equity Capital and WACC Optimising WACC Valuing Enterprises FCFF Calculation Discounting FCFF to get Enterprise Value Justified Share Price calculated from Enterprise Value Residual Income Concept NOPAT, WACC and the Capital Charge Calculating Residual Income The Residual Income Enterprise Valuation Calculating Justified Share Price using the Residual Income Model Comparing Free Cash Flow and Residual Income Enterprise Value Chapter 6 QUIZ Acquisition Transactions Why do Acquisition Transactions occur? Paying for an Acquisition Assumptions regarding the Acquirer Assumptions regarding the Target's Long Term Assets Operating Expense and Working Capital Synergies Acquisition Profit & Loss Formulas Acquisition Cash Flow Formulas Acquisition Balance Sheet Formulas Accretion/Dilution Analysis Private Equity Transactions and the Internal Rate of Return Chapter 9 Quiz

3. Step by step instructional material

Our financial modelling courses will give you step by step course content in a easily readable format with screenshots, diagrams and inbuilt quizzes.

The courses are designed to be navigated at your own pace and content is worded and structured in a friendly and readable format.

At the beginning of each course, you will download an Excel 'model' template which the course will teach you to populate.

Here is a look at the (completed) template from our Primer course:

The courses themselves should take between 20-40 hours to complete each, however some of our students have completed the level 1 course in under 10 hours if they have had experience working in Finance previously or have a natural strength with this sort of knowledge. The length of the courses has been designed to roughly match the length of time you would spend learning a Finance subject at University in Australia, 2 hours of lectures per week for twelve weeks equates to 24 hours, and our course should take roughly the same amount of time.

In both courses you will be taken step-by-step through the model building process with explanations of the accounting concepts and valuation techniques along the way. There is a screenshot after every step as well to help you validate that you have built your model correctly. At the end of the course you submit your model up to our website for checking, and we personally look at all model submissions and either pass you or else provide feedback for any errors made (you get two submissions included with each course purchase, and any additional submissions required cost extra). To date, every one of our students has passed on first submission - the instructions in the courses are quite clear and easy to understand. Also, you can run through the course content as many times as you want prior to submission, which is recommended if you want additional practice.

Once you have signed up we encourage you to contact us via our customer service enquiry form if you have any questions about the course content, and we generally respond to queries within 24 hours.

4. Certifications

All our courses are backed by a FinancialModelTraining.com certification.

This certification is a great resume-builder / interview talking point and it really helps our graduates stand out from the crowd.

Click on one of the above certificates to download a sample PDF certificate

5. Background

FinancialModelTraining.com was conceived when Paul Mason realised that demand for the face-to-face financial modelling courses he taught at ANZ were becoming too popular for him to meet demand, and he needed to develop an online offering.

Teaming with Jason Kotchoff (Silicon Valley Entrepreneur), they resolved to develop best of breed internet based financial modelling courses with a highly intuitive interface and engaging content.

In developing the FinancialModelTraining.com courses, Paul has utilised the skills and experience gained from working in Equity Analysis, Distressed Debt and Relationship Banking at multiple Australian banks.

Together Paul and Jason have developed the courses to bring you a user-friendly and comprehensive set of training that is second to none.

Financial Model Training