Tech & IT
Business
Coding & Developer
Finance & Accounting
Academics
Office Applications
Art & Design
Marketing
Health & Wellness
Sounds & Music
Lifestyle
Photography
.jpg)
Free
6 days left at this price!
This plan includes
- Limited free courses access
- Play & Pause Course Videos
- Video Recorded Lectures
- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Email & Chat Support
Get Unlimited Learning Access
$29
6 days left at this price!
30-Day Money-Back Guarantee
This plan includes
- Access to 11,000+ Courses
- Ads free experience Courses
- Play & Pause Course Videos
HD Video Recorded Lectures- Learn on Mobile/PC/Tablet
- Quizzes and Real Projects
- Lifetime Course Certificate
- Instructor Direct Support
- Email & Chat Support
- Cancel Anytime
$29
$29
What you'll learn?
- Ability to make a 3 statement financial statement from scratch
- Ability to make any financial model using MS Excel
Course Overview
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.
Pre-requisites
- Microsoft Excel Installed on PC/Laptop
Target Audience
- Aspiring Investment Bankers
- Aspiring Investors
- Finance Students
- Start-up founders making business plan
Curriculum 16 Lectures 01:54:33
-
Section 1 : Introduction to the Course
-
Section 2 : Creating Input Assumptions
- 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
- 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
- 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
- Lecture 1 :
- Intro: Creating your first cash flow statement
- Lecture 2 :
- Explained: How to create your first cash flow statement?
-
Section 6 : Closing Remarks
- Lecture 1 :
- Yaay! You are a financial modeler now! Closing comments
Our learners work at
Frequently Asked Questions
-
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?
Instructor
552 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.
View More...
