Virtual Session Starts

The next cohort of this Course will start soon. Get ready

  • 00Days
  • 00Hours
  • 00Minutes
  • 00Seconds

Course curriculum

  • 1
  • 2

    Time Value of Money Calculations

    • Overview

      FREE PREVIEW
    • Download the Exercise Files

    • Preparing the Template

    • Real vs Nominal Terms

    • Building an Inflation Index

    • Introducing TVM Calculations

      FREE PREVIEW
    • Building a Retirement Model Template (Part 1 of 2)

    • Building a Retirement Model Template (Part 2 of 2)

    • Using Financial Functions in Excel for TVM Calculations

    • Calculating Investment Value at Retirement

  • 3

    Building Capex & Depreciation Schedules

  • 4

    Using Excel's Scenario Manager Tools

    • Overview

    • Download the Exercise Files

    • Case Study: Overview of the Retirement Problem

      FREE PREVIEW
    • Answering the Retirement Problem with Scenario Analysis

    • Goal Seek & Scenario Analysis

    • Setting up the Scenario Manager Tool

    • Recording Scenarios with the Scenario Manager Tool

    • Running Reports with the Scenario Manager tool

    • Scenario Manager Chapter Quiz

  • 5

    Introduction to Sensitivity Analysis

    • Download Exercise Files

    • Overview of Sensitivity Analysis - The Data Table Tool

    • Building a One Input Sensitivity Table - The Setup

    • Building a One Input Sensitivity Table - Implement

    • Building a Two Input Sensitivity Table - Setup the Table

    • Building a Two Input Sensitivity Table - Understanding the Logic

      FREE PREVIEW
    • Building a Two Input Sensitivity Table - Implementation

    • How to make your Sensitivity Tables Dynamic

    • Best Practice Formatting for Sensitivity Tables

  • 6

    Finance Fundamentals

    • Defining Accounting and Finance

    • The Business & Accounting Cycle

    • Introducing the REAL Framework for Accounting

    • The Structure of the Balance Sheet

    • The 5 Box Balance Sheet Layout

    • The Structure of the Income Statement

  • 7

    Drivers & Assumptions

    • Exercise Files

    • Building Base Profit and loss Assumptions

    • Calculating Historical Asset Assumptions based on Drivers

    • Calculating Historical Liability Assumptions based on Drivers

    • Simple Technique for Creating Base Assumptions

    • Testing the Predictive Power of Drivers

  • 8

    Virtual Session_01

    • Introduction

    • Exercise Files , Assignments and Videos

    • Step by Step Guide to build a simple Model

    • Introducing Modeling Mechanics

    • Understanding Growth Formulas

    • Understanding Account Drivers

    • Smart Techniques and Shortcuts

    • Using Growth Formulas

    • Using Account Drivers

  • 9

    Virtual Session_02

    • Introduction

    • Exercise Files

    • Defining Accounting and Finance

    • The Business & Accounting Cycle

    • Introducing the REAL Framework for Accounting

    • The Structure of the Balance Sheet

    • The 5 Box Balance Sheet Layout

  • 10

    AFM Exam Preparation Content

  • 11

    Evaluation & Bonus Material

Become a top Modeler with these courses

  • $1,200.00

    $1,200.00Advanced Financial Modeler Virtual Training

    The definitive Financial Modeling Training. This comprehensive course will teach you all you need to be a great modeler and also ace the Level 1 Exams from the Financial Modeling Institute
    Get it now
  • $199.00

    $199.00Advanced Financial Modeler Exam - Step by Step Guide

    This is the only guide you need to ace the Advanced Financial Modeler Exams.
    Get it Now

Instructor

David Brown

FCA, Microsoft MVP

David has worked with and taught Excel and financial modelling to over 4,000 people in the last 22 years. He is the Managing Partner of dbrownconsulting where he runs the Consulting Division.He is a Fellow of the Institute of Chartered Accountant of Nigeria & a Financial Analyst with over 16 years experience working as a Business intelligence, Financial Modelling & Tax Consultant with Arthur Andersen, KPMG & dbrownconsulting.He is also an International Consultant to the World Bank on Oil Revenue Modelling and is a registered financial adviser.David attained the Master Trainer & Master Instructional Designer designation from the Association for Talent Development (ATD).He is passionate about Financial Modelling, Business Intelligence and Analytics especially with Microsoft Power BI and Excel and regularly host meetups and speaker event in Nigeria and around the world.

Your Instructors

With over 200 completed models between them

Victor Ogundele

Financial Modeler & Trainer

Victor Ogundele is a highly experienced Financial Modeling Consultant and Trainer with dbrownconsulting. He is a Certified Financial Modeler and also an Advanced Financial Modeler with the Financial Modeling Institute.

Some of our Clients