In this playlist, you will learn about how to build a financial model in Microsoft Excel
Aulas do Curso
(15 vídeos)
0 de 15 aulas concluídas
0%
Progresso salvo somente neste navegador.
0
1.0 Introduction
Welcome to the free financial modeling course for absolute beginners. In this course, I will take you through six steps …
1
2.0 Income Statement - Historical Analysis
In this course, you will learn how to analyze the income statement historical data for XYZ and apply the financial model…
2
3.0 Income Statement - Forecasts
In this course, you will learn how to forecast the income statement.
Want to take your career in finance to the next le…
3
4.0 Cash Flow Statement - Historic
In this course, you will learn how to read the cash flow statement and compute totals.
The cash flow statement measures…
4
5.0 Cash Flow Statement - Projection
In this course, you will learn how to project the cash flow statement. You will learn how to project CAPEX, Changes in w…
5
6.0 Depreciation Schedule
In this course, you will learn how to depreciate PP&E and CAPEX using the straight-line method of depreciation.
Depreci…
6
7.0 Working Capital Schedule - Historic
In this course, you will learn how to project working capital items as well as calculate the changes in working capital.…
7
8.0 Working Capital Schedule - Projection
In this course, you will learn how to project working capital items as well as calculate the changes in working capital.…
8
9.0 Linking WC to CF
In this course, you will learn how to link changes in working capital items to the cash flow statement.
When linking cu…
9
10.0 Balance Sheet - Historic
In this course, you will learn how to project the balance sheet using the cash flow statement. The logic is to capture t…
10
11.0 Balance Sheet - Projection
In this course, you will learn how to project the balance sheet using the cash flow statement. The logic is to capture t…
11
12.0 Debt Schedule
In this course, you will learn how to build a debt schedule and calculate interest expense, and interest income.
Firms …
12
13.0 Linking Debt Schedule
In this course, you will learn how to link the debt schedule to the income statement, cashflow statement and balance she…
13
14 Grouping Items
In this video, you will learn how to organize and group items for presentation purposes.
Want to take your career in fi…
14
How to Do Scenario Analysis: A Comprehensive Tutorial!
In this comprehensive tutorial, you will learn everything you need to know about scenario analysis, a powerful tool for …
