OfficeTrainingHub

How to use this Platform

Your Expectations

Preparing the Model Guide Sheet

Building Model Details Section

Listing the Model Sheet Structure

Building the Styles Section

Normal Style

Number Styles

Label Styles

Flag Styles

Implementing Styles

Listing Names Section

Building Audit Check

Building Version Control Section

Creating Outlines

Exercise Files

Building the Cover Sheet

Implementing a Column Structure for the Model

Implementing a Row Structure for the Model

Inserting Actual and Forecast Flags

Setting up the Sheet for Printing

Duplicating the Sheet Structure

Finalising your Model Sheet Structure

Nestle Nigeria PLC 2019 Financials - Download

Exercise Files

Extracting Historical Financial Statements

Purpose of normalizing the financial statements

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

Extracting Current and Deferred Tax Expense

Reconciling the normalized PorL

Exercise Files

Purpose of normalizing the Balance Sheet

Plan for Restructuring non-Current Assets

Restructuring of Non-current Assets

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 values to restructured line item of the balance sheet

Finalizing your Financial Statement Normalization

Adjusting for the unbalanced Audited balance sheet

Creating outline for good interface and navigation

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

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

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

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

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

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

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

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

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

Capstone Project

Evaluation & Digital Certificate

How to Attach your Certificates to your LinkedIn Profile