OfficeTrainingHub

How to use this Platform

Your Expectations

Ask The Trainer

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

Overview

Right of Return Assets & Refund Liability

Accounting for Operating Leases

Accounting for Finance Leases

Overview of IFRS 15, Revenue Recognition

Revenue Recognition and Contract Assets

Calculating Historical Profit and Loss Assumptions based on Drivers

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

Building your P&L Projections for Year 1

Overview of Calculation Schedules

Methodologies for Building Schedules

Building Out your BASE Schedules

Linking Historical Balances

Building out your BCE Schedules

Building out your OWC Schedules

Finalizing your Calculations Schedules

Exercise Files , Assignments and Videos

Overview-Completing the Calculations Sheet

Building your Balance Sheet

Building your Cash Flow statement Structure

Completing your Cash Flow Statement

Balancing your Balance Sheet

Replicating your Year 1 Model for the forecast period

Model Auditing with the dbrown 1 Check

Exercise File

Overview of Debt Calculations

Using Boolean Logic for Smart Logical Formulas

Automating Debt Issue with an Issue Flag

Planning the Automation of Interest Expense

Model Build Mechanics for Interest Expense

Completing the Dynamic Debt Schedule

Replicating your Dynamic Debt Schedule

Exercise Files , Activities and Videos

Capstone Project

50 Excel Keyboard Shortcuts for Windows

50 Excel Keyboard Shortcuts for Mac

How to Create 5-Box Balance Sheet on PowerPoint

Evaluation & Digital Certificate

How to Attach your Certificates to your LinkedIn Profile