Virtual Session Starts

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

Register now!
  • 00 Days
  • 00 Hours
  • 00 Minutes
  • 00 Seconds

Course curriculum

    1. Is this course for me?

    2. How to use this Platform

    3. Full Course Brochure & Agenda

    4. Your Expectations

    5. Ask the Trainer

    1. Overview

    2. Download the Exercise Files

    3. Preparing the Template

    4. Real vs Nominal Terms

    5. Building an Inflation Index

    6. Introducing TVM Calculations

    7. Building a Retirement Model Template (Part 1 of 2)

    8. Building a Retirement Model Template (Part 2 of 2)

    9. Using Financial Functions in Excel for TVM Calculations

    10. Calculating Investment Value at Retirement

    1. Overview

    2. Download the Exercise Files

    3. Understanding Capex Assumptions in Models

    4. Building a Capex Schedule

    5. Building a Depreciation Schedule

    6. Using a Matrix Formula to build a Depreciation Schedule (Part 1 of 2)

    7. Using a Matrix Formula to build a Depreciation Schedule (Part 2 of 2)

    8. Preparing a Depreciation Schedule using the OFFSET Methodology

    9. Using the OFFSET Function to Calculate Depreciation (Part 1 of 3)

    10. Using the OFFSET Function to Calculate Depreciation (Part 2 of 3)

    11. Using the OFFSET Function to Calculate Depreciation (Part 3 of 3)

    1. Overview

    2. Download the Exercise Files

    3. Case Study: Overview of the Retirement Problem

    4. Answering the Retirement Problem with Scenario Analysis

    5. Goal Seek & Scenario Analysis

    6. Setting up the Scenario Manager Tool

    7. Recording Scenarios with the Scenario Manager Tool

    8. Running Reports with the Scenario Manager tool

    9. Scenario Manager Chapter Quiz

    1. Download Exercise Files

    2. Overview of Sensitivity Analysis - The Data Table Tool

    3. Building a One Input Sensitivity Table - The Setup

    4. Building a One Input Sensitivity Table - Implement

    5. Building a Two Input Sensitivity Table - Setup the Table

    6. Building a Two Input Sensitivity Table - Understanding the Logic

    7. Building a Two Input Sensitivity Table - Implementation

    8. How to make your Sensitivity Tables Dynamic

    9. Best Practice Formatting for Sensitivity Tables

    1. Defining Accounting and Finance

    2. The Business & Accounting Cycle

    3. Introducing the REAL Framework for Accounting

    4. The Structure of the Balance Sheet

    5. The 5 Box Balance Sheet Layout

    6. The Structure of the Income Statement

About this course

  • Free
  • 84 lessons
  • 3.5 hours of video content

Become a top Modeler with these courses

  • $2,000.00

    $2,000.00Advanced Financial Modeling Course

    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