Course curriculum

  • 1

    Welcome to the Course!

    • How to use this Platform

    • Your Expectations

  • 2

    Building a detailed Guide Sheet

  • 3

    Building the Model Sheet Structure

    • Exercise Files

    • Building the Cover Sheet

    • Implementing a Column Structure for the Model

    • Implementing a Row Structure for the Model

    • Automating Sheet Structure Timing

    • Inserting Actual and Forecast Flags

    • Setting up the Sheet for Printing

    • Duplicating the Sheet Structure

    • Finalising your Model Sheet Structure

  • 4

    Extracting & Normalising Historical Financial Statements

    • Nestle Nigeria PLC 2019 Financials - Download

    • Exercise Files

    • Extracting Historical Financial Statements

    • Purpose of normalizing the financial statements

  • 5

    Restructuring the Profit or Loss Account

    • Exercise Files

    • Defining a Preferred PorL Structure

    • Creating a Template for accurate Restructuring

    • Restructuring Process for PL

    • Extracting the Depreciation and Impairment Values

    • Dealing with incomplete information

    • Normalizing the cost of sales

    • Identifying depreciation on cost of sales

    • Normalizing the SG&A

    • Normalizing Net Finance Cost

    • Extracting Current and Deferred Tax Expense

    • Reconciling the normalized PorL

  • 6

    Restructuring the Balance Sheet

    • Exercise Files

    • Purpose of normalizing the Balance Sheet

    • Plan for Restructuring non-Current Assets

    • Restructuring of Non-current Assets

    • Planning the restructuring of Trade and Other Receivables

    • Long-term receivables linked to Trade and other receivables

    • Restructuring Trade and Other Receivables

    • Treating allowances for credit losses and other payables

    • Reconciling restructured value with audit values

    • Restructuring all other Assets

    • Planning the restructuring of Liabilities

    • Restructured Trade and Other Payables

    • Building loans and borrowings

    • Extracting Loans and Borrowings information

    • Extracting Equity Values

    • Finalising the BS Restructuring Template

    • Building out the Restructured balance Sheet

    • Linking the restructured note line item to restructured balance sheet

    • Linking values to restructured line item of the balance sheet

  • 7

    Audit Checks, Navigation & Documentation

  • 8

    Building Assumptions for the Profit or Loss Account

    • Structuring General Assumptions

    • Understanding the P&L Structure

    • Revenue Assumptions

    • Cost of Sales Assumptions

    • SG&A Assumptions

    • Depreciation Assumption

    • Impairment Assumptions

    • Net Foreign Exchange Loss Assumptions

    • Understanding Tax Accounting

    • Computing Deferred Taxes

    • Current & Deferred Tax Assumptions

    • Summary of Profit or Loss Assumptions

  • 9

    Building Assumptions for the Balance Sheet

    • Template for Balance Sheet Assumptions

    • PPE Assumptions

    • Review of Drivers from Restructured Financials

    • Trade Receivables and Right of Return Assets

    • Determining the Predictive Power of Drivers

    • Adjusting Restructured Financials for better Drivers

    • Determining Current Asset Drivers

    • Computing Current Asset Drivers

    • Finalising the Assumptions for Current Assets

    • Determining Drivers for Current Liabilities

    • Computing Drivers for Current Liabilities

    • Finalising the Assumptions for Current Liabilities

    • Deriving Equity Assumptions

    • Building Assumptions for Non Current Liabilities

    • Structure of Financing Assumptions

    • Building Debt Assumptions

    • Accuracy check with the Model Audit Tool

  • 10

    Building the Scenario Sheet

    • Overview of the Scenario Sheet

    • Building a Scenario Picker Tool

    • Building the Revenue Scenarios

    • Replicating your Scenario Template

    • Automating the Live Scenario Labels in each sheet

    • Documenting the Inputs and Scenario Sheets with Outlines

    • Quiz on Building Model Drivers, Assumptions & Scenarios

  • 11

    Profit or Loss Account Computations

    • Setting up your Profit or Loss Sheet Structure

    • Revenue Computations

    • COS & SG&A Computations

    • Other Profit or Loss Computations

    • Linking Computations to the Profit or Loss Account

    • Setting up the income Tax Schedule

    • Computing Current & Deferred Tax Expenses

  • 12

    Balance Sheet Computations

    • Setting up the Structure of your Balance Sheet

    • Setting up the Audit Check for your Balance Sheet

    • Balance Sheet Computations - Types of Schedules

    • Planning the Balance Sheet Computations - Detailed Structure

    • Building the PPE Schedule

    • Building the Equity Schedules

    • Retained Earning Schedule

    • Setting up the Operating Working Capital Schedule

    • Building Linked Tables for OWC Computations

    • Computing Operating Working Capital

    • Finalise the Operating Working Capital Computations

    • Basic Debt Schedule

    • Linking Computations to the Balance Sheet

  • 13

    Building the Cashflow Statement

    • Overview of the Business & Accounting Cycle

    • Setting up the Cash Flow Statement Sheet Structure

    • Linking the Values from the Financials

    • Method 1 for determining Cash and Overdraft Values

    • Adjusting for Non-Cash Taxes

    • Balancing the Balance sheet - Stage 1

    • Setting up Dividends Payable Schedule

    • Computing the correct Dividends Payable Schedule

    • Balancing the Balance Sheet Stage 2

  • 14

    Dynamic Debt and Interest Computations

    • Building the Structure for Dynamic Debt computations

    • Dynamic Link to Debt Assumptions

    • Completing the Dynamic Debt Template

    • Creating Assumptions for New Debt

    • Automate the Debt Schedule with FLAGS

    • Compute the Dynamic Interest Rate & Interest Expense

    • Replicating the Dynamic Debt Template

    • Finalise the Summary Debt Schedule

    • Balancing the Balance Sheet Stage 3 - the 1 Check

    • Understanding the concept of the Cash Sweep

    • Building Total Interest Expense and Interest Income Calculations

    • Understanding Circular References

    • Model Infection & Solving for Circular Reference

    • Balancing the Balance Sheet Stage 4 - Circularity Switch

    • Documenting with Outlines and labels

    • Quiz on Financial Modeling Computation Mechanics

  • 15

    Incorporating a Cash Sweep

    • Understanding the concept of the Cash Sweep

    • Building the Schedules for implementing a Cash Sweep

    • Completing the Cash Sweep Schedules

    • Cash Sweep Computations

    • Plugging the Sweep into the Financial Model

    • Final Checks and Documentation

  • 16

    Updating your Model: Incorporating new Audited Financial Statements

    • Review Model Audit Checks and Controls

    • Download the Latest Audited Financials and update Model Timings

    • Review the Structure of the Latest Audited Accounts

    • Implement any Structural changes from the Audited Accounts

    • Update the Model Historicals with the latest Audited Financial Numbers

    • Planning the Updates to the Profit or Loss Accounts

    • Updating Depreciation Values

    • Updating Impairment Values

    • Updating Other Profit or Loss Line Items

    • Complete the reconciliation of the Updated Profit or Loss Account

    • Updating Non-Current Assets

    • Updating Current Assets

    • Updating Current Liabilities

    • Updating Equity

    • Updating Long-Term Liabilities

    • Updating Loans and Borrowings

    • Carry out a Detailed Audit Checks

    • The One Check - the Ultimate Balance Sheet Recon Check

    • Correcting the Logic Error in Impairment

    • Correcting the Logic Error in Lease Liabilities

    • Sense Checking and Beauty Saving your Model

  • 17

    Course Completion and Certification

    • Capstone Project

    • Evaluation & Digital Certificate

    • How to Attach your Certificates to your LinkedIn Profile

Other courses for you

  • $199.00

    $199.00Advanced Financial Modeler Exam - Step by Step Guide

    Buy Now
  • $297.00

    $297.00The Definitive AFM Exam Prep Course + Mock Exams + Video Resources

    Buy Now
  • $199.00

    $199.00Microsoft Excel Fundamentals for Analysts

    Buy Now

What People Have to Say...

20,000+ people are learning on our platform

“Attempting to tackle the AFM Exam is a bit daunting, which is why this course really shines brightly. Unlike many of the other excellent modeling courses out there, this course specifically focuses on the AFM exam and is a great combination of reviewing modeling skills and fine-tuning your exam preparation. This course is like the capstone to your AFM Exam preparation pyramid. There's nothing quite like it out there yet. It reviews the hard skills, sharpens the soft skills such as template preparation, gives exam tips to save time, advises on how to approach the exam, and brings all the needed skills together in an excellently paced course. Highly recommended. ”

Rasheed Davis

“Excel Essentials for Reporting is a wonderful course. It unearths the secrets on which Excel is built and presents it in a very simple manner. I found a solution to a problem I have grappled with for a long time in this course. DBrown training did a great job that deserve to be commended. Thank you for this course and may your reward be great in your chosen enterprise of expanding the frontiers of knowledge in the IT industry. Regards. Engr. Okumo Ipigansi”

Ipigansi Okumo

“Your course on Report Automation in Modern Excel is indeed an eye opener as to the many possibilities in Microsoft Excel. The training is superb and very informative with great content. I enjoyed every minute of the videos and it has provided me with a greater level of understanding, additional skills and knowledge, to aid my numerous tasks in the office. Report Automation in Modern Excel is suitable for all who analyze data. The course delivery is excellent. DBrown Consulting, please keep it up.”

Otti Grant Onyeukwu

“Clearly, the use of lookup functions in Excel cannot be overemphasized. Mr. David in less than an hour 30 mins will take you to a realm of possibilities (previously thought of as impossibilities or not thought of at all) through this training. The delivery of the videos was succinct and concise; be prepared to get much value from this training.”

Akinwunmi Bello

“I was really impressed with the simplicity of the lessons and the ease of learning. Looking forward to taking more courses.”

Tomilola Sadare

“I particularly love the flow of teaching, its unconstrained. Also, the fact that you are spurred to practise on your own, and tweak as you are taught - not been spoonfed. I am always waiting for the release of the next class. Thank you David.”

Adebayo Aderohunmu

Building an Audit Check for the Balance Sheet

Watch this sample video to see how to incorporate an audit check tool as part of the Model Guide sheet for a Corporate Financial Model. 

Some of our Clients


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.