Financial Modeling in Excel: Beginner to Pro Masterclass
- Description
- Curriculum
- FAQ
- Reviews
Financial Modeling is the Art and Science of preparing future financial statements.
A Financial Model is a set of Future Financial Statements, prepared in such a scientific way that any changes made in data updates the whole model according to new information without breaking any calculation.
Do you know what is common between Finance, Accounting, Financial Statements, & Financial Modeling?
The answer is: These all are used in every single business, by almost all the senior professionals who are involved in decision making.
This course is designed to teach you everything that you need to know to sit at that decision making seat!
Plot:
Assuming no previous knowledge, this course begins from the fundamentals and first you first learn the key business reports and the terms used in these reports. Then after getting the idea about financial reports and accounting behind reports, you will prepare these reports – financial statements – from the accounting data.
Once you have the good understanding of Financial Reports, you will learn to model them into a beautifully linked and interlinked Financial Model. Using a demo start-up company information, you will prepare their complete Financial Model. Not only this model will present all values for decision making, but also it will be dynamically adjusted to reflect any business scenario.
Then you will learn the Finance and all the basic concepts needed to calculate the value of a business; like Time Value of Money, Present Value, Future Value, DCF, NPV (Net Present Value) and IRR.
What makes this course special:
-
Brief in theory, yet fully practical and hands on
-
Practice material and assignments
-
Covers a fairly complex yet covers a complete business scenario
-
Starts from very basics, and gradually builds to cover advanced concepts
Who should take this course:
-
Finance, Accounting, and business Students
-
Aspiring Finance Professionals
-
Entrepreneurs and Business Owners
-
Investors and start-up founders
Prerequisite: None, but basic knowledge of Excel will be helpful.
Money-Back Guarantee: Udemy offers 30 days money-back guarantee for this course.
Introduction to the teacher: Chartered Accountant | x PwC | Startup founder | 100,000+ students
-
1
Introduction to Financial Statements -
2
Profit & Loss Statement (aka Income Statement)
-
3
Revenue - Operating & Non-operating
-
4
Operating and Non-operating expenses
-
5
P&L - updated
-
6
Classifying Operating into Trading & Other
-
7
P&L - updated
-
8
Understanding Net Wealth
-
9
Balance Sheet - Introduction
-
10
Own & Owe - Professional terminology
-
11
Balance Sheet - the professional format
-
12
Understanding Equity in Detail
-
13
Types of Organization and Understanding Equity in Company
-
14
Statement of Changes in Equity
-
15
Preparing Financial Statements - Practice
-
16
Preparing Financial Statements - Additional Practice
-
17
Preparing Financial Statements -
18
Accounting break - What is Accounting?
-
19
Depreciation
-
20
Amortization
-
21
Understanding Cash Flow
-
22
Cash Flow Statement - Introduction
-
23
Calculating Cash Flows from P&L and Balance Sheet
-
24
Calculating Cash Flows - Issue of Shares
-
25
Calculating Cash Paid in Interest Payment
-
26
Calculating Cash Paid in Taxes
-
27
Calculating Cash Paid in Fixed Asset Purchases
-
28
Cash Received in Fixed Asset Sale - Gain or Loss on disposal
-
29
Cash Received from Sales
-
30
Cash Paid in Operational Expenses
-
31
Cash Paid in Trading Expenses
-
32
Operating Activities - Indirect Method
-
33
Cash Flow Statement - Complete Format
-
34
Preparing Cash Flow Statement
-
35
Preparing Cash Flow Statement - with Excel
-
36
Preparing Cash Flow Statement - 2020
-
37
Preparing Cash Flow Statement - 2021
-
38
Financial Modelling - Introduction - What? Why?
-
39
Key notes: Qualitative Aspects of Financial Modeling
-
40
Introduction to the scenario and assumptions
-
41
Some Qualitative Aspects to Discuss
-
42
Qualitative Aspects - Recap
-
43
Getting started - Layout, Format, & Styling
-
44
Notes: Formatting Best Practices
-
45
Getting started with calculations - Schedules & Best Practices
-
46
Notes: Best Practices
-
47
Calculating Sales Revenue
-
48
Calculating Cost of Sales
-
49
Calculating Operational Expenses
-
50
Calculating Marketing Costs
-
51
Preparing Schedules - Fixed Assets & Depreciation
-
52
Preparing Schedules - Intangible Assets & Amortization
-
53
Calculating Interest Income - Why we can't at the moment...
-
54
Calculating Interest Expense - Why we can't at the moment...
-
55
Calculating Inventory
-
56
Calculating Receivables
-
57
Calculating Payables
-
58
Inventory, Receivables, & Payables in Balance Sheet
-
59
Calculating Total Investment
-
60
Calculating Total Debt Financing and Interest Expense
-
61
Calculating Equity Investment required
-
62
Completing P&L and Calculating Net Profit
-
63
Calculating Dividends/Incremental Equity Input
-
64
Completing Balance Sheet
-
65
Preparing Cash Flow Statement
-
66
Incorporating Interest Income
-
67
Formatting the Three Reports
-
68
Formatting the Schedules
-
69
Tracing values backwards
-
73
Time Value of Money
$1 today has more value than $1 after a few days/months/years, agreed? Let's learn if that is true and if so, why?
-
74
Interest and Types of Interest
In this lecture, we will learn about the interest an investment earns. This lecture will become the foundation of our valuation concepts.
-
75
Interest Calculations
Fasten the seat belt as we are about to start the calculations of interest. These mathematical techniques that we learn here are the foundation. that we need
-
76
Present Value and Future Value Concept
Time to learn two of the most important terms used in finance.
-
77
Present Value to Future Value Conversion Example
Let's practice to convert Present Value to Future Value.
-
78
Discounting, FV to PV conversion
Let's practice it in the reverse order now, that is, calculation of present value from the future value.
-
79
Present Value from Future Value calculation Practice
Time to practice the FV to PV calculation.
-
80
Present Value Calculations
-
81
Net Present Value - NPV - Introduction
Now that we now the conversion of future cash flows to present value, it's the time to learn the Net Present Value.
-
82
Net Present Value - Example
Net Present Value - let's do an example with all the calculations involved.
-
83
Net Present Value - Complete Project Appraisal
The most sophisticated method to appraise any investment project is to calculate Net Present Value. In this chapter, we will calculate a complete project NPV.
-
84
NPV - Startup Appraisal
Time to give numbers to startup dreams! Let's calculate the NPV of a startup.
-
85
Assumptions in NPV calculation
NPV calculations are complex. So, we have to make some assumptions to avoid over-complication. Let's take a look at these assumptions.
-
86
Understanding NPV
So, what exactly NPV mean? Let's discuss it!
-
87
Net Present Value - Assignment
-
88
IRR - Internal Rate of Return
NPV is the best method to appraise a project! But what if we have to communicate our results in percentage terms? What is the percentage return the project is making? Let's learn to calculate the percentage return.
-
89
IRR formula and details
Let's use mathematics to learn a quicker way to calculate IRR.
