This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Complete Financial Modeling Course
Section 1: INTRODUCTION
Lecture 1: Course Introduction (2:30)
Lecture 2: Author / Instructor Introduction (2:50)
Lecture 3: Model Walk Though (6:51)
Lecture 4: Complete Dynamic Model Impact of Inputs on the Outputs (20:53)
Section 2: TEMPLATE, BUSINESS MODEL, FINANCIAL MODEL DESIGN, NAMING & LISTING
Lecture 1: Template, Business Model, Financial Model Design (10:56)
Lecture 2: Naming and Listing
Section 3: INPUTS
Lecture 1: Dates Inputs (7:05)
Lecture 2: Escalations and Assets Inputs
Lecture 3: Remuneration, Sales, Asset Inputs
Lecture 4: Funding Mix, Payment Frequency Inputs
Lecture 5: Loans and Other Key Assumptions Inputs
Section 4: GENERAL CALCULATIONS
Lecture 1: Calcs Gen Dates & Escalations
Lecture 2: Calcs Gen Assets Bought
Lecture 3: Calcs Gen Remuneration
Lecture 4: Calcs Gen Sales Units
Lecture 5: Calcs Gen Units, Cost per Unit, Total Cost, Selling Price
Lecture 6: Calcs Gen Fresh Chips, Cooking Oil
Lecture 7: Calcs Gen Drinks
Lecture 8: Calcs Gen Other Expenses, Consumables
Lecture 9: Calcs Gen Tax Depreciation
Section 5: DEBT CALCULATIONS
Lecture 1: Debt Calcs Funding Mix, Dynamic Loans
Section 6: MONTHLY SUMMARY
Lecture 1: Monthly Summary Revenue and Costs of Sales
Lecture 2: Monthly Summary Operating Costs, Cashflow, Income Statement, Balance Sheet
Section 7: ASSETS
Lecture 1: Asset Register
Section 8: MOVEMENTS - WORKINGS
Lecture 1: Movements Working 1 to Working 10
Lecture 2: Movements Working 11 to Working 16
Section 9: INCOME STATEMENT, BALANCE SHEET, CASHFLOW STATEMENT
Lecture 1: Income Statement, Balance Sheet, Cashflow Statement
Section 10: RATIO ANALYSIS & INVESTMENT ANALYSIS
Lecture 1: Ratio Analysis and Investment Analysis
Section 11: FINAL BASE CASE PROJECT
Lecture 1: Final Base Case Project
Section 12: APPLICATION OF THE MODEL
Lecture 1: Value Added Tax
Lecture 2: Breakeven Analysis and Scenario Analysis
Lecture 1: Calcs Gen Dates & Escalations
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock