Master Financial Modeling in Excel: Complete Pro Guide 2024
Focused View
26:00:58
1 -Introduction.mp4
09:58
2 -What is Financial Modeling.mp4
19:37
3 -Introduction to Excel.mp4
17:06
4 -Pre-requisites in Excel.mp4
10:43
1 -Basic Excel Formulas.mp4
23:46
1 -DataSheet 1 for Excel Functions and Formulas.xlsx
2 -Cell Referencing.mp4
22:08
3 -Basic Formatting in Excel.mp4
13:06
4 -Cell Formatting in Excel.mp4
08:12
5 -Date related formulas in excel.mp4
08:11
6 -Conditional Formatting.mp4
09:21
7 -Pivot Table.mp4
08:36
8 -Vlookup, Hlookup, Concatenate and Transpose.mp4
16:27
9 -Data Validation in Excel.mp4
07:17
10 -Protect Sheet Protect Workbook Protect Cell.mp4
08:42
1 -Datasheet 2 for advanced excel functions and formulas.xlsx
1 -Name Manager.mp4
08:07
2 -Goal Seek.mp4
04:11
3 -Scenario Manager.mp4
05:12
4 -Data Tables.mp4
06:45
1 -Datasheet 3 From Historical Plotting to Forecasting.xlsx
1 -Financial Statements.mp4
27:27
2 -Historical Data Plotting.mp4
51:11
3 -Historical Data Plotting Version 2.mp4
06:30
1 -Ratio Analysis (Introduction).mp4
07:34
2 -Liquidity Ratios.mp4
02:29
3 -Liquidity Ratios - Current Ratio.mp4
06:48
4 -Liquidity Ratios - Quick Ratio.mp4
05:03
5 -Liquidity Ratios - Cash Ratio.mp4
04:30
6 -Liquidity Ratios - Interval Measure Ratio.mp4
07:52
7 -Liquidity Ratio - Net working Capital Ratio.mp4
03:26
8 -Solved Illustrations for Liquidity Ratios.mp4
17:29
9 -Leverage Ratios - Introduction.mp4
04:32
10 -Leverage Ratio - Equity Ratio.mp4
02:57
11 -Leverage Ratio - Debt Ratio.mp4
04:22
12 -Leverage Ratio - Debt to Equity.mp4
06:37
13 -Leverage Ratio- Debt to Total Assets Ratio.mp4
02:57
14 -Leverage Ratio - Proprietary Ratio.mp4
03:09
15 -Leverage Ratio - Capital Gearing Ratio.mp4
03:37
16 -Leverage Ratios - Debt Service coverage ratio.mp4
05:32
17 -Leverage Ratios - Interest Coverage Ratios.mp4
04:01
18 -Leverage Ratios - Fixed Charges coverage ratio.mp4
04:11
19 -Leverage ratios - Dividend Coverage ratios.mp4
03:44
20 -Solved Illustration on Leverage ratios - Capital Structure Ratios.mp4
29:39
21 -Solved Illustration on Leverage ratios - Coverage Ratios.mp4
14:47
22 -Activity Ratio Introduction.mp4
02:48
23 -Activity Ratio - Total assets turnover ratio.mp4
05:23
24 -Activity Ratio - Fixed assets turnover ratio.mp4
09:17
25 -Activity Ratio - Net Assets turnover Ratio.mp4
04:50
26 -Activity Ratio - Current Assets turnover ratio.mp4
05:06
27 -Activity Ratio - Working Capital turnover ratio.mp4
06:01
28 -Activity Ratio - Inventory turnover ratio.mp4
07:18
29 -Activity Ratio - Receivables turnover ratio.mp4
07:33
30 -Activity Ratio - Payables turnover ratio.mp4
06:54
31 -Solved Illustration - Activity Ratios.mp4
31:08
32 -Profitability ratios introduction.mp4
03:53
33 -Profitability ratios - Gross profit Ratio.mp4
01:50
34 -Profitability Ratios - Net Profit Ratio.mp4
02:16
35 -Profitability Ratios - Operating Profit Ratio.mp4
03:43
36 -Profitability Ratios - Expense Ratio.mp4
03:59
37 -Profitability Ratio - Return on Investment.mp4
05:13
38 -Profitability Ratio - Return on Asset.mp4
09:09
39 -Profitability Ratio - Return on Capital Employed.mp4
04:57
40 -Profitability Ratio - Return on Equity.mp4
01:48
41 -Profitability Ratios - Dupont Analysis.mp4
14:35
42 -Profitability Ratio - EPS Ratio.mp4
01:16
43 -Profitability Ratios - DPS.mp4
01:29
44 -Profitability Ratios - Dividend Payout Ratio.mp4
02:07
45 -Profitability Ratio - Price Earning Ratio.mp4
02:27
46 -Profitability Ratio - Dividend and Earning Yield ratio.mp4
03:58
47 -Profitability Ratio - Market value by book value.mp4
02:27
48 -Q Ratio.mp4
01:53
49 -Solved Illustration - Profitability Ratios.mp4
41:15
1 -Ratio Analysis in Excel (Part 1).mp4
30:12
2 -Ratio Analysis in Excel (Part 2).mp4
21:40
3 -Ratio Analysis in Excel (Part 3).mp4
25:26
4 -Dupont Analysis in Excel (Part 1).mp4
33:54
5 -Dupont Analysis in Excel (Part 2).mp4
09:30
6 -Altmans Z Score Concept.mp4
08:43
7 -Almans Z Score Calculation in Excel.mp4
19:25
8 -Common Size Statement in Excel.mp4
18:21
1 -What is time value of Money.mp4
06:13
2 -Use of Concept - Time value of money.mp4
02:53
3 -Time Value of Money - Relationship between Inflation and Purchasing power.mp4
12:08
4 -Simple Interest and Compound Interest.mp4
17:36
5 -Present Value and Future Value.mp4
06:55
6 -Present Value and Future value (for single payments) without Formula.mp4
07:04
7 -Present Value and Future value (for single payments) with Formula.mp4
05:40
8 -What is discount factor.mp4
07:28
9 -What is annuity.mp4
03:25
10 -Present value of Annuity without Formula.mp4
09:49
11 -Present value of Annuity with Formula.mp4
14:41
12 -Present Value of Ordinary annuity using Formula.mp4
04:12
13 -Present Value of Annuity due using formula.mp4
04:00
14 -Future Value of Annuity without Formula.mp4
11:58
15 -Formula for future value of annuity.mp4
12:09
16 -Future value of annuity calculation using formula.mp4
04:14
17 -Single payment compounded annually, Semi Annually, Quarterly, Monthly and daily.mp4
04:33
18 -Annuity compounded annually, Semi Annually, Quarterly, Monthly and daily.mp4
05:39
19 -Annuity Factor.mp4
13:26
20 -Internal Rate of Return (IRR).mp4
13:39
1 -Capital Budgeting basics.mp4
06:03
2 -Purpose of Capital Budgeting.mp4
05:26
3 -Process of Capital Budgeting.mp4
05:31
4 -Types of Capital Investment decisions.mp4
03:02
5 -Replacement and Modernisation decisions.mp4
06:11
6 -Expansion decisions.mp4
03:48
7 -Diversification decisions.mp4
07:05
8 -Mutually exclusive decisions.mp4
03:29
9 -Accept or Reject decision.mp4
04:39
10 -Contingent decisions.mp4
03:57
11 -Accounting Profit and Cashflow.mp4
05:34
12 -Incremental Cashflows.mp4
04:43
13 -Depreciation and Tax Benefit.mp4
07:25
14 -Opportunity Cost.mp4
04:29
15 -Sunk Cost.mp4
06:24
16 -Working Capital Cost.mp4
02:48
17 -Allocated Overheads cost.mp4
08:28
18 -Types of Cashflows for new project.mp4
06:01
19 -Types of Cashflow for replacement project.mp4
08:54
20 -Basic Principles for calculating cashflows.mp4
04:35
21 -Block of assets and depreciation concepts.mp4
12:53
22 -Financing costs treatment.mp4
11:17
23 -Interest and Depreciation.mp4
07:32
24 -Post Tax Principle.mp4
10:24
25 -Capital Budgeting techniques.mp4
02:48
26 -Payback period introduction.mp4
06:00
27 -Payback period when cashflow is same.mp4
05:18
28 -Payback period when cashflow is not same.mp4
09:29
29 -Advantages and disadvantages of payback method.mp4
09:29
30 -Payback reciprocal.mp4
05:22
31 -Accounting Rate of return.mp4
02:59
32 -Accounting rate of return - Solved example.mp4
10:24
33 -Advantages and disadvantages of Accounting rate of return.mp4
05:33
34 -How to determine discount rate.mp4
04:49
35 -Discounted payback period.mp4
02:18
36 -Discounted payback period illustration.mp4
13:50
37 -Advantages and disadvantages of discounted payback period.mp4
05:02
38 -Profitability Index.mp4
04:14
39 -Solved illustration - Profitability index.mp4
07:57
40 -Profitability index - advantages and disadvantages.mp4
12:59
41 -Net Present value method.mp4
15:36
42 -Net Present value (Example).mp4
08:37
43 -Advantages and disadvantages of Net Present Value method.mp4
07:07
44 -Internal Rate of Return.mp4
07:35
45 -Reading Present value annuity factor table.mp4
04:29
46 -IRR using present value annuity factor table.mp4
08:58
47 -Solved illustrations on IRR (When cashflows are uniform).mp4
08:03
48 -Solved illustrations on IRR (When cashflows are not uniform).mp4
12:05
49 -8.mp4
08:39
49 -IRR and NPV (Reinvestment assumption).mp4
08:39
50 -IRR and NPV (Mutually Exclusive projects ) - Illustration 1.mp4
09:35
51 -IRR and NPV (Mutually Exclusive projects ) - Illustration 2.mp4
12:29
52 -IRR and NPV (Mutually Exclusive projects ) - Illustration 3.mp4
06:37
53 -Advantages and Limitations of IRR method.mp4
04:34
54 -Multiple IRR.mp4
10:48
55 -Modified internal rate of return.mp4
06:45
56 -Modified internal rate of return - solved illustration (How to calculate it).mp4
14:25
57 -Capital rationing - Divisible and non divisible projects.mp4
13:17
58 -Methods to analyze mutually exclusive projects.mp4
08:46
59 -Replacement chain method.mp4
08:39
60 -Equivalent annualized criterion method.mp4
09:09
1 -Basic formulas for Time Value of Money in excel.mp4
20:26
2 -Loan amortization schedule in excel.mp4
19:51
3 -Project evaluation by NPV Method in Excel.mp4
15:17
4 -Project evaluation by IRR method in excel.mp4
04:03
1 -Introduction - Revenue and expense forecasting.mp4
06:27
2 -Revenue and expense forecasting using arithmetic mean.mp4
17:24
3 -Revenue and expense forecasting using geometric mean.mp4
13:43
4 -Revenue and expense forecasting moving average.mp4
05:29
5 -Basics of Regression.mp4
04:11
6 -Revenue and expense forecasting using regression.mp4
08:11
7 -Calculating regression in excel.mp4
05:13
8 -Balance sheet Forecast basics.mp4
09:09
9 -Balance sheet Forecasting in Excel.mp4
10:18
More details
Course Overview
Master professional financial modeling from scratch in Excel, covering everything from basic functions to advanced forecasting, valuation, and capital budgeting techniques used by finance professionals.
What You'll Learn
- Build complete financial models from scratch in Excel
- Master advanced functions including VLOOKUP, pivot tables, and scenario analysis
- Apply financial concepts to real-world valuation and forecasting
Who This Is For
- Aspiring financial analysts and investment professionals
- Finance students seeking practical Excel modeling skills
- Business owners needing financial forecasting capabilities
Key Benefits
- Develop industry-standard financial modeling skills
- Learn through hands-on Excel exercises and case studies
- Gain confidence in making data-driven financial decisions
Curriculum Highlights
- Excel Financial Functions Mastery
- Financial Statement Analysis & Ratios
- Valuation & Capital Budgeting Models
Focused display
Category
- language english
- Training sessions 172
- duration 26:00:58
- Release Date 2025/04/26
