Intro to the Course
  • Welcome
  • A few reminders before we begin
Jumpstart
  • How to Take this Course
  • Jumpstart Intro
  • Jumpstart - The Financial Modeling Process
  • Jumpstart - Financial Model Design
  • Jumpstart - Introduction Case Study - Part 1
  • Jumpstart - Introduction Case Study - Part 2
Important Finance & Accounting Principles
  • Finance & Accounting Principles Overview
  • Balance Sheet & Capital Structure
  • Income Statement
  • Statement of Cash Flows
  • Financial Forecasting Process
  • Time Value of Money
  • Capital Asset Pricing Model
  • Weighted Average Cost of Capital
  • Investment Return Metrics
  • SUMMARY: Finance & Accounting Priciples
  • Finance & Accounting Concepts
Important Excel Features & Techniques
  • Important Excel Features & Techniques Overview
  • Anchoring Cells
  • Data Validation
  • Conditional Functions
  • Named Ranges
  • Conditional Statements
  • Financial Functions
  • Reference and Lookup Functions
  • Dealing with Formula Errors
  • Importing External Data
  • Leveraging PivotTables & PivotCharts
  • Using Solver
  • Data Tables
  • Recording Macros
  • Workbook and Worksheet Security
  • SUMMARY: EXCEL Features & Techniques
  • Excel Features & Techniques
Building a Financial Forecast Model
  • Financial Forecasting Model Overview
  • Financial Forecasting Example Part 1
  • Financial Forecasting Example Part 2
  • Financial Forecasting Example Part 3
  • Financial Forecasting Example Part 4
  • Financial Forecasting Example Part 5
  • SUMMARY: Financial Forecasting Model
Building a Financial Reporting Model
  • Financial Reporting Model Overview
  • Financial Reporting Example Part 1
  • Financial Reporting Example Part 2
  • Financial Reporting Example Part 3
  • Financial Reporting Example Part 4
  • SUMMARY: Financial Reporting Model
Building a Financial Decision-Making Model
  • Financial Decision-Making Model Overview
  • Financial Decision-Making Example Part 1
  • Financial Decision-Making Example Part 2
  • Financial Decision-Making Example Part 3
  • Peak Capital
  • Financial Decision-Making Example Part 4
  • Financial Decision-Making Example Part 5
  • SUMMARY: Financial Decision-Making Model
Back of the Envelope
  • Building a Back of the Envelope Rental Income Property Model Part 1 of 2
  • Building a Back of the Envelope Rental Income Property Model Part 2 of 2
Congrats
  • Congrats!
New to Udemy?
  • OPTIONAL: How to use Udemy, download files, etc...