Course curriculum

  • 01

    INTRODUCTION

    • Welcome to Financial Modeling course

    • GBT Solutions Broucher

    • Learning Objectives

    • Course Download
  • 02

    FINANCIAL MODELING

    • 2.0 What is Financial Modeling

    • 2.1 Financial statement overview

    • 2.2 Income statement

    • 2.4 Balance sheet

    • 2.5 Cash Flow Statement

    • 2.6 Cash Flow Statement

    • 2.7 Balance Sheet
  • 03

    FINANCIAL RATIO

    • 3.1 Financial Ratio

    • 3.2 Profitability Ratio

    • 3.3 Profitability Ratio-Vertical Analysis

    • 3.4 Efficiency Ratio - Working Capital

    • 3.5 Liquidity Ratio

    • 3.6 Assets Ratio

    • 3.8 Market Value Ratio

    • 3.9 Financial Ratio

    • Assessment 2 Template Financial Ratio

    • A- Financial Ratio- Income Statement Assessment

    • B. Financial Ratio - Balance Sheet Ratio.
  • 04

    THE THREE STATEMENT MODEL

    • 4.1 Financial Modeling Process

    • 4.2 Financial Modeling Structure
  • 05

    FORMAT FINANCIAL STATEMENT

    • 5.1 Format Income Statement

    • 5.2 Format Balance Sheet

    • 5.3 Format Cash Flow Statement

    • 5.4 Format historical financial statement
  • 06

    FORECAST AND ASSUMPTIONS METHODS

    • 6.1 Financial Forecast

    • 6.2 Financial Forecast Methods

    • 6.3 Build Assumptions

    • 6.4 Build Assumptions Forecast
  • 07

    FORECAST FINANCIAL STATEMENTS

    • 7.1 Forecast Income Statement

    • 7.2 Balance Sheet Forecast

    • 7.3 Cash Flow Statement Forecast
  • 08

    SUPPORTING SCHEDULES

    • 8.1 Change In Working Capital

    • 8.2 Fixed Assets _ Depreciation Schedulee

    • 8.3 Debt _ Interest Schedule
  • 09

    COMPLETE FORECAST AND REVIEW

    • 9.1 Complete Financial Forecast

    • 9.2 Complete the Financial Forecast

    • 9.3 Model Review and Audit

    • Assessment -1
  • 10

    FINANCIAL RATIO ANALYSIS

    • 10.1 Financial Ratio

    • 10.2 Working Capital Ratio

    • 10.3 Liquidity Ratio

    • 10.4 Leverage Ratio

    • 10.5 Market Ratio
  • 11

    CHARTS AND GRAPHS

    • 11.1 Charts-Revenue _ Margin

    • 11.2 Charts - Cash Flow _ Profitability

    • 11.3 Summary Result Analysis
  • 12

    WALMART CASE STUDY

    • Disclaimer

    • Introduction

    • Case Study Download Materials
  • 13

    FORMAT HISTORICAL FINANCIALS

    • 12.1 Copy historical Financial

    • 12.2 Format Income Statement

    • 12.3 Format Income Statement Cont.

    • 12.4 Format Income Statement Cont.

    • 12.5 Format Balance Sheet

    • 12.6 Format Balance sheet Cont.

    • 12.7 Format Cash flow statement

    • 12.8 Finalize Historical Financial Formatting
  • 14

    BUILD FINANCIAL ASSUMPTIONS

    • 13.1 Income Statement Assumptions

    • 13.3 Balance Sheet Assumptions

    • 13.4 Cash Flow Assumptions

    • 13.5 Cash Flow Assumptions

    • 13.6 Assumptions Forecast

    • 13.7 Income Statement Assumptions Forecast

    • 13.8 Balance Sheet Assumptions Forecast

    • 13.9 Cash flow assumptions Forecast
  • 15

    FINANCIAL STATEMENT FORECAST

    • 14.1 Income Statement Forecast

    • 14.2 Balance Sheet Forecast

    • 14.4 Balance Sheet -Equity Forecast

    • 14.3 Balance Sheet Check

    • 14.5 Forecast Cash Flow
  • 16

    SUPPORTING SCHEDULES

    • 15.1 Change in Working Capital

    • 15.2 Supporting schedules- Working Capital

    • 15.3 Supporting Schedules - Fixed Assets

    • 15.4 Supporting Schedules- Intangibles Assets

    • 15.5 Supporting Schedules - Short Term Debt

    • 15.6. Long Term Debt _ Lease Forecast

    • 15.7 Interest Amount
  • 17

    COMPLETE AND REVIEW MODEL

    • 16.1 Complete Income Statement

    • 16.2 Complete Balance Sheet

    • 16.3 Complete Cash Flow Forecast

    • 16.4 Review Financial Forecast
  • 18

    FINANCIAL RATIO

    • 17.1 Financial Ratio- Vertical Analysis

    • 17.2 Profitability SQ Feet

    • 17.3 Financial Ratio - Efficiency

    • 17.4 Financial Ratio- Liquidity

    • 17.5 Financial Ratio - Assets

    • 17.6 Financial Ratio - Leverage _ Market
  • 19

    GRAPHS AND CHARTS

    • 18.1 Charts- Revenue_Gross Margin

    • 18.2 Charts Cash Flow Profitability

    • 18.3 Graphs_Charts Analysis

    • Assignment
  • 20

    CONCLUSION

    • Assessment

    • Financial Modeling Certificate Survey