Video
Learn Financial Modeling in Excel – FREE COURSE (By Ex-JPMorgan Analyst)
📥 DOWNLOAD THE FILE TO FOLLOW ALONG: Free Financial Modeling Excel Template & Case Study: https://tinyurl.com/financial-model-excel-template
In this video, Dheeraj Vaidya, an ex-JPMorgan analyst breaks down the process of financial modeling in 9 easy steps. The video comes with a financial modeling template and case study that will allow learners to practice and build a practical understanding. At the end of the video, individuals can get to know about some of the top resources they can utilize to build an illustrious career in financial modeling.
Timestamps
0:00:01-0:01:052 Introduction
0:01:52-0:03:38 Download Case Study & Financial Modeling Template
0:03:38-0:05:09 Overview of the Steps
0:05:10-0:13:00 Step #1 Creating the Structure for Financial Model
0:13:00-0:24:08 Step #2 Analyzing Historical Financial Statements
0:24:08-0:30:54 Step #3 Projecting Revenues
0:30:54-0:45:18 Step #4 Projecting Costs
0:45:18- 0:56:49 Step #5 Projecting Depreciation
0:56:49-01:15:30 Step #6 Projecting Working Capital
1:15:30-1:30:17 Step #7 Completing the Cash Flow Statement
1:30:17-1:44:23 Step #8 Projecting Debt
1:44:23-1:52:49 Step #9 Integrating the Statements and Balancing the Balance Sheet
1:52:49-1:55:16 Jumpstart Your Career in Financial Modeling
📥 DOWNLOAD THE FILE TO FOLLOW ALONG: Free Financial Modeling Excel Template & Case Study: https://tinyurl.com/financial-model-excel-template
source