Last updated 3/2023Course Language EnglishCourse Caption English [Auto]Course Length 10:57:55 to be exact 39475 seconds!Number of Lectures 115
This course includes:
11 hours hours of on-demand video
5 article
Full lifetime access
Access on mobile and TV
Certificate of completion
20 additional resources
Understand Financial Modeling in detail
Learn to prepare Financial Models in Excel
Before starting Financial Modeling, understand the Financial Statements in detail
Learn all the key Accounting & Finance terms for Financial Modeling
Learn Basic Finance, Time Value of Money and DCF
Learn to calculate Net Present Value - NPV
Learn to perform complete Financial Appraisal for projects
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 onPractice material and assignments Covers a fairly complex yet covers a complete business scenarioStarts from very basics, and gradually builds to cover advanced concepts Who should take this course:Finance, Accounting, and business StudentsAspiring Finance Professionals Entrepreneurs and Business Owners Investors and start-up foundersPrerequisite: 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+ studentsWho this course is for:Accounting professionals and studentsFinance professionals and studentsStartup and small business founders/ownersInvestors and Venture Capitalists
Course Content:
Sections are minimized for better readability, click the section title to view the course content
35 Lectures | 03:15:47
Introduction to Financial Statements
04:52
Profit & Loss Statement (aka Income Statement)
02:28
Revenue - Operating & Non-operating
06:31
Operating and Non-operating expenses
05:00
P&L - updated
05:35
Classifying Operating into Trading & Other
02:48
P&L - updated
02:02
Understanding Net Wealth
01:38
Balance Sheet - Introduction
04:42
Own & Owe - Professional terminology
07:05
Balance Sheet - the professional format
01:52
Understanding Equity in Detail
02:26
Types of Organization and Understanding Equity in Company
10:42
Statement of Changes in Equity
03:01
Preparing Financial Statements - Practice
13:42
Preparing Financial Statements - Additional Practice
11:18
Preparing Financial Statements
4 questions
Prepare following Financial Statements Reports for 2021:
- Profit & Loss Statement
- Balance Sheet
- Statement of Changes in Equity
Accounting break - What is Accounting?
05:45
Depreciation
02:48
Amortization
00:41
Understanding Cash Flow
05:24
Cash Flow Statement - Introduction
03:18
Calculating Cash Flows from P&L and Balance Sheet
04:24
Calculating Cash Flows - Issue of Shares
03:05
Calculating Cash Paid in Interest Payment
04:52
Calculating Cash Paid in Taxes
02:54
Calculating Cash Paid in Fixed Asset Purchases
04:42
Cash Received in Fixed Asset Sale - Gain or Loss on disposal
02:56
Cash Received from Sales
04:12
Cash Paid in Operational Expenses
05:20
Cash Paid in Trading Expenses
03:49
Operating Activities - Indirect Method
08:33
Cash Flow Statement - Complete Format
02:22
Preparing Cash Flow Statement
12:17
Preparing Cash Flow Statement - with Excel
18:43
Preparing Cash Flow Statement - 2020
14:00
Preparing Cash Flow Statement - 2021
4 questions
From the given Profit & Loss Statement, and the Balance Sheet, prepare Cash Flow Statement for FY 2021.
32 Lectures | 03:35:53
Financial Modelling - Introduction - What? Why?
07:52
Key notes: Qualitative Aspects of Financial Modeling
00:08
Introduction to the scenario and assumptions
10:15
Some Qualitative Aspects to Discuss
05:24
Qualitative Aspects - Recap
00:24
Getting started - Layout, Format, & Styling
15:58
Notes: Formatting Best Practices
00:15
Getting started with calculations - Schedules & Best Practices
Calculating Interest Income - Why we can't at the moment...
02:19
Calculating Interest Expense - Why we can't at the moment...
01:40
Calculating Inventory
03:32
Calculating Receivables
02:33
Calculating Payables
06:34
Inventory, Receivables, & Payables in Balance Sheet
01:15
Calculating Total Investment
04:56
Calculating Total Debt Financing and Interest Expense
18:42
Calculating Equity Investment required
05:19
Completing P&L and Calculating Net Profit
03:20
Calculating Dividends/Incremental Equity Input
09:05
Completing Balance Sheet
04:32
Preparing Cash Flow Statement
24:17
Incorporating Interest Income
02:52
Formatting the Three Reports
11:27
Formatting the Schedules
14:45
Tracing values backwards
05:39
3 Lectures | 24:25
Excel break - Now to make changes in Model without breaking it
06:15
Case Analysis - Understanding the scanerio
03:12
Case Analysis
14:58
7 Lectures | 30:44
Time Value of Money
05:47
$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?
Interest and Types of Interest
03:43
In this lecture, we will learn about the interest an investment earns. This lecture will become the foundation of our valuation concepts.
Interest Calculations
08:35
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
Present Value and Future Value Concept
02:54
Time to learn two of the most important terms used in finance.
Present Value to Future Value Conversion Example
03:16
Let's practice to convert Present Value to Future Value.
Discounting, FV to PV conversion
03:11
Let's practice it in the reverse order now, that is, calculation of present value from the future value.
Present Value from Future Value calculation Practice
03:18
Time to practice the FV to PV calculation.
Present Value Calculations
2 questions
8 Lectures | 58:30
Net Present Value - NPV - Introduction
03:53
Now that we now the conversion of future cash flows to present value, it's the time to learn the Net Present Value.
Net Present Value - Example
04:04
Net Present Value - let's do an example with all the calculations involved.
Net Present Value - Complete Project Appraisal
13:18
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.
NPV - Startup Appraisal
11:43
Time to give numbers to startup dreams! Let's calculate the NPV of a startup.
Assumptions in NPV calculation
02:45
NPV calculations are complex. So, we have to make some assumptions to avoid over-complication. Let's take a look at these assumptions.
Understanding NPV
04:34
So, what exactly NPV mean? Let's discuss it!
Net Present Value - Assignment
3 questions
Calculate the NPV of the project.
1. Using the discount rate 10%
2. Using the discount rate 15%
3. Using the discount rate 20%
IRR - Internal Rate of Return
07:14
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.
IRR formula and details
10:59
Let's use mathematics to learn a quicker way to calculate IRR.
If you like to get inspired by great web projects, you should check out Made with Javascript. If you have a project that you wish to share with the world, feel free to submit your project on Made with Javascript Club website.
Free Online Tools And Converters for your use
URL Encoder
Input a string of text or a URL and encode the entered string
FAQ: Udemy Free course Most frequent questions and answers
Does Udemy offer Free Udemy coupons?
Yes, Udemy is the largest online education platform, with the broadest selection of video-on-demand courses and qualified instructors available to meet your needs. At theprogrammingbuddy.club we curate the latest udemy coupons, their expiry, and the number of uses left of these udemy coupons.
How to get free Udemy courses?
There are two ways to get free Udemy courses:
Go to udemy.com and search for your desired course category. Then select free from the filter options.
You can also get paid courses for free if you have a coupon. You can head to theprogrammingbuddy.club, where you can get a daily udemy paid course for free.
How to get Udemy Certificates for free?
Udemy offers certification on completion of each course. In order to receive a certificate of completion from Udemy, you need to complete your course 100%. There is a simple hack, you can open a video and jump on the timeline to complete a lecture.
To download the certificate from Udemy, you need to head over to your account on a desktop browser. Udemy certificates can't be accessed on the mobile app.
Do Udemy courses expire?
No, once you enroll, you will have lifetime access to the course. You can complete the course on your schedule.
Why are the Udemy instructors giving away free Udemy Coupons?
Every instructor has worked for hours on each of their courses. As new courses get launched, the instructors have no way to get their course in front of an audience to get some feedback. So, instructors share free coupons for their courses to get feedback from the students. We attheprogrammingbuddy.club work with these instructors to get their courses available to our buddies.
Is Udemy safe to use?
Yes, payments on Udemy are safe. It is no different than paying for other services on an application or website and inputting your payment information before receiving your goods. Just be sure to keep your account secure, do not share your udemy accounts.
Can Udemy courses get you a job?
Earning a skill is more valuable than earning a job these days. Skills are your most valuable asset. They can help you qualify for jobs you want and get promoted to more advanced positions within your organization. Unfortunately, it is difficult for many people to balance taking courses with work and family obligations. We have had many students, who have taken just Udemy courses, started a job as well as started freelancing with the skills they have learned.