Course Outline

Course Start

Compare Traditional to 5g Models

Intro to Dynamic Arrays

• One cell one formula

• The HASH# symbol

• Demonstration

5g Bridges the Skills Gap

Model Structure

• Cover

• Table of Contents

• InpV

• InpC

• InpT

• Time

• Depr

• Debt

• Calcs

• Statements

• Checks

Importing 5g Functions

Building worksheet Time

• Timelineλ

• Inflationλ

Building worksheet Depr

• Fixed Assets Table

• Depreciateλ

• DepreciateLabelsλ

• DepreciateSumsλ

• SumContainsλ

Building worksheet Debt

• Loans Table

• Installmentsλ

• DebtLabelsλ

• SumRCλ

Building worksheet Calcs

• Revenue: ScheduleRatesλ 

• COS: SumAλ

• CAPEX

• Working Capital

  • WC, AR:  Movementλ

  • WC, Inv

  • WC, Other: ScheduleValuesλ

  • WC, AP

  • WC

• Financing

  • Equity: Corkscrewλ 

  • Debt

  • Tax

• Retained Earnings

• Cash

Building Worksheet Statements

• Income Statement

• Cash Flow Statement

• Balance Sheet

Building Worksheet Checks