Financial Modeling in MS Excel - Beginners to Advance

Course Overview

Financial modelling is an essential skill for accounting and finance professionals. Employers place a high value on it and it is in high demand in the job market. Our financial modelling training takes you from the basics to the professional level.

This twenty-hour training is based on practical exercises. The course focuses 30% on honing the participants MS Excel skills and 70% on the application of MS Excel in Accounting and Finance

Financial Modelling Fundamentals
If you are new to financial modelling, they will find videos starting right from the beginning and gradually progress forward.

Discounted Cash Flow
Discounted Cash Flow (DCF) is an important area covered here. Starting from the concept of DCF we will learn its application.

Capital Budgeting
We will build projects from scratch, build up relevant cash flows and use the NPV and IRR method using scenario analysis.

Profit and Loss Case Study
In this section we will have extracted data from accounting software and we will learn how to quickly organize the data and automate our first Profit and Loss Statement.

SOFP & Cash Flow - Case Study
Continuing with the example of Profit and Loss, we will construct Statement of Financial Position and then produce a Statement of Cash Flow based on P&L and SOFP.

Business Valuation
Starting with the concepts of Business Valuation, we will value a business using different valuation techniques including FCF and FCFE and terminal value concept.

Course Curriculum

Free Preview
5 Lessons
- Introduction to Financial Modelling Training (14:17)
  Preview
- Formating Basics Using Macros (10:46)
  Preview
- Forecast Revenue and COS (32:35)
  Preview
- Cash Flow Based Enterprise Value (29:11)
  Preview
- 49. Mapping the Account Codes to the P&L Account (15:17)
  Preview
Getting to Grips With Excel
8 Lessons
- 1. Introduction to Financial Modelling Training (14:17)
  Start
- 2. Introduction to MS Excel - Menus and Ribbon (23:06)
  Start
- 3. Copy Paste, Cut Paste and Linking the Sheets (15:16)
  Start
- 4. Locking Cell References in Formulas (08:50)
  Start
- 5. Fast Scrolling with F5 Key (05:17)
  Start
- 6. Dynamic Naming (06:34)
  Start
- 7. IF and AND Function (15:49)
  Start
- 8. Lock Cell References with $ sign (05:18)
  Start
Formatting and Data Sorting in Excel
7 Lessons
- 9. Data Sorting and Sub Totals (10:27)
  Start
- 10. Formatting Basics Using Macros (10:46)
  Start
- 11. Data Filters in Tables (06:45)
  Start
- 12. Pivot Tables Basics (11:56)
  Start
- 13. Format Table Function (07:46)
  Start
- 14. DSum and DAverage (09:46)
  Start
- 15. Removing Errors (03:19)
  Start
Basic Concepts of Discounted Cash Flow - DCF
4 Lessons
- 16. Compounding and Discounting (18:31)
  Start
- 17. Discounting Cash Flow - DCF (28:51)
  Start
- 18. What is Net Present Value - NPV (07:55)
  Start
- 19. Internal Rate of Return - IRR (09:33)
  Start
Financial Model For Forecast Profit and Loss Statement
5 Lessons
- 20. Forecast Financial Statements - Introduction (09:33)
  Start
- 21. Forecast Financial Statements - Forecast Revenue and COS (32:35)
  Start
- 22. Forecast Profit and Loss - Fixed and Variable Costs (08:43)
  Start
- 23. Forecast Profit and Loss (25:53)
  Start
- 24. Completing Profit and Loss (27:24)
  Start
Financial Model For Forecast Balance Sheet
2 Lessons
- 25. Understanding the Statement of Financial Position (07:02)
  Start
- 26. Assumption for Statement of Financial Position (40:38)
  Start
Financial Model For Forecast Cash Flow
5 Lessons
- 27. Introduction to Cash Flow Statement (17:19)
  Start
- 28. Forecast Cash Flow Statement (18:53)
  Start
- 29. Completing the SOFP (16:32)
  Start
- 30. Completing the Cash Flow Forecast (15:27)
  Start
- 31. Cash Flow Based Enterprise Value (29:11)
  Start
Capital Budgeting Theory
4 Lessons
- 32. Introduction to Capital Budgeting (17:17)
  Start
- 33. Introduction to Risk (25:13)
  Start
- 34. Beta Values and CAPM (16:36)
  Start
- 35. Geared and Ungeared Betas (25:42)
  Start
Your First DCF Financial Model
11 Lessons
- 36. Introduction and Assumptions in DCF Model (27:45)
  Start
- 37. Fixed Assets and Depreciation Schedule (20:33)
  Start
- 38. Depreciation and Tax Benefits (15:05)
  Start
- 39. Calculating the Operating Cash Flow (27:37)
  Start
- 40. Common Issue in DCF Assumptions (17:44)
  Start
- 41. Introduction to WACC and Beta Value (46:48)
  Start
- 42. Calculating Project Beta, Cost of Equity and WACC (18:17)
  Start
- 43. Getting the Final DCF Model Output (23:29)
  Start
- 44. Calculating the Internal Rate of Return - IRR (13:35)
  Start
- 45. - Sensitivity Analysis of the Project (24:00)
  Start
- 46. Vlookup (14:20)
  Start
Creating a Profit and Loss from Scratch from Historical Data
4 Lessons
- 47. Analyzing the Data and Creating Unique Codes (11:09)
  Start
- 48. Using Vlookup to Extract Data (18:04)
  Start
- 49. Mapping the Account Codes to the P&L Account (15:17)
  Start
- 50. Creating the Final Profit and Loss Output Sheet (12:00)
  Start
Business Valuation Case Study
3 Lessons
- 51. Intro to Business Valuation (13:38)
  Start
- 52. Understanding a Case Study and Intro (29:28)
  Start
- 53. Business Valuation Final (33:51)
  Start

Course Pricing

Financial Modeling in MS Excel

$25 USD

Beginners to Advance
- Use code "FM30" to get 30% discount
- One Year Access to Course Content
- MS Excel Tips and Tricks
- Financial Modelling Fundamentals
- Discounted Cash Flow
- Capital Budgeting
- Profit and Loss Case Study
- SOFP & Cash Flow - Case Study
- Business Valuation Theory
- Business Valuation Case Study
- Downloadable MS Excel Files

Buy Now