2024 Financial Modelling from Scratch Masterclass

The Ultimate Financial Modelling Course!

Created by : Rated :4.8 560 views

Last Updated: 2024-03-01 12:03:52 English Course Type: Self Learning

Ability to make a 3 statement financial statement from scratch
Ability to make any financial model using MS Excel

The course content remains relevant for the year 2024 without material changes.

Personal Message from the Instructor: "I promise you that the few hours you spend with me on this course would help you learn skills that come after months of classroom training.

Designed and delivered by an Investment Banker and Private Equity Investor who has made more than 200+ financial models, this course can teach you how to make your first financial model or brush up your knowledge if you have made financial models in the past. This course is relevant for any business executive wanting to add the skill set of financial modelling to his CV/Resume. We will create a live model during the course and the instructor will provide inputs at each step. If you are an executive trying to gain financial modelling skill or if you are a startup founder looking for guidance in making your business plan or just a student interested in adding financial skills to your resume, this course is for you!

The instructor, Piyush Arora (CFA, MBA-Finance) has been an Investment Banker, a Private Equity investor and a Venture Capitalist. He has worked on more than 200 deals worth more than USD 1 billion over the last decade.

Microsoft Excel Installed on PC/Laptop

Aspiring Investment Bankers
Aspiring Investors
Finance Students
Start-up founders making business plan

Section 1 : Introduction to the Course 1 Lectures 00:01:05
Lecture 1 :
What will students learn in this course? Preview
Section 2 : Creating Input Assumptions 6 Lectures 00:37:58
Lecture 1 :
Intro: Creating input assumptions for your first financial model
Lecture 2 :
Input assumptions of a financial model- Part 1 - Ground Rules
Lecture 3 :
Input assumptions of a financial model- Part 2 - Revenue Assumptions
Lecture 4 :
Input assumptions of a financial model- Part 3 - Direct Cost Assumptions
Lecture 5 :
Input assumptions of a financial model- Part 4- Indirect Cost Introduction
Lecture 6 :
Input assumptions of a financial model- Part 5- Indirect Cost Assumptions
Section 3 : Creating Your First Profit and Loss Statement 2 Lectures 00:18:00
Lecture 1 :
Intro: Creating the first Profit and Loss Statement (P&L)
Lecture 2 :
Explained: How to create your first Profit and Loss Statement?
Section 4 : Creating Your First Balance Sheet 4 Lectures 00:35:41
Lecture 1 :
Intro: Creating the inputs for your first Balance Sheet
Lecture 2 :
Explained: How to create inputs for your first Balance Sheet?
Lecture 3 :
Intro: Building your first Balance Sheet
Lecture 4 :
Explained: How to build your first Balance Sheet?
Section 5 : Creating Your First Cash Flow Statement 2 Lectures 00:20:41
Lecture 1 :
Intro: Creating your first cash flow statement
Lecture 2 :
Explained: How to create your first cash flow statement?
Section 6 : Closing Remarks 1 Lectures 00:01:08
Lecture 1 :
Yaay! You are a financial modeler now! Closing comments

How do i access the course after purchase?
It's simple. When you sign up, you'll immediately have unlimited viewing of thousands of expert courses, paths to guide your learning, tools to measure your skills and hands-on resources like exercise files. There’s no limit on what you can learn and you can cancel at any time.
Are these video based online self-learning courses?
Yes. All of the courses comes with online video based lectures created by certified instructors. Instructors have crafted these courses with a blend of high quality interactive videos, lectures, quizzes & real world projects to give you an indepth knowledge about the topic.
Can i play & pause the course as per my convenience?
Yes absolutely & thats one of the advantage of self-paced courses. You can anytime pause or resume the course & come back & forth from one lecture to another lecture, play the videos mulitple times & so on.
How do i contact the instructor for any doubts or questions?
Most of these courses have general questions & answers already covered within the course lectures. However, if you need any further help from the instructor, you can use the inbuilt Chat with Instructor option to send a message to an instructor & they will reply you within 24 hours. You can ask as many questions as you want.
Do i need a pc to access the course or can i do it on mobile & tablet as well?
Brilliant question? Isn't it? You can access the courses on any device like PC, Mobile, Tablet & even on a smart tv. For mobile & a tablet you can download the Learnfly android or an iOS app. If mobile app is not available in your country, you can access the course directly by visting our website, its fully mobile friendly.
Do i get any certificate for the courses?
Yes. Once you complete any course on our platform along with provided assessments by the instructor, you will be eligble to get certificate of course completion.
For how long can i access my course on the platform?
You require an active subscription to access courses on our platform. If your subscription is active, you can access any course on our platform with no restrictions.
Is there any free trial?
Currently, we do not offer any free trial.
Can i cancel anytime?
Yes, you can cancel your subscription at any time. Your subscription will auto-renew until you cancel, but why would you want to?

Piyush Arora, CFA, CAIA,

560 Course Views

1 Courses

Having built 200+ financial models for multiple companies over last many years, Piyush Arora (CFA & MBA - Finance) is the best suited instructor for a course on Financial Modelling. He has been an Investment Banker, a Private Equity investor, a Venture Capitalist and a CFO. He delivers the best insights through live examples and keeps the learning levels of students in mind while teaching.