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