Learn Financial Modeling in Excel - Step by Step (Colgate Case Study)

This video explains how to build a financial model from scratch using the financials of Colgate-Palmolive Company. Here, we adopt a step-by-step approach to help you comprehend financial modeling in Excel. Also, this video comes with a template to help develop a practical understanding. Before wrapping up, it shows some resources that one can utilize to jumpstart their career in financial modeling.
DOWNLOAD TEMPLATE - tinyurl.com/co...
0:01-0:00:26 Introduction
0:01:22-0:02:09 Download Colgate Financial Model Template
0:02:09-0:04:16 Step #1 Colgate’s Financial Model - Historical
0:04:16-0:08:35 Step #2 Ratio Analysis of Colgate-Palmolive
0:08:35-0:12:51 Step #3 Projecting the Income Statement
0:12:51-0:15:08 Step #4 Working Capital Forecast
0:15:08-0:16:49 Step #5 Calculating Depreciation
0:16:49-0:17:33 Step #6 Amortization Forecast
0:17:33-0:19:19 Step #7 Other Long Term Forecast
0:19:19-0:20:44 Step #8 Completing the Income Statement
0:20:44-0:21:56 Step #9 Shareholder’s Equity Forecast
0:21:56-0:22:30 Step #10 Shares Outstanding Forecast
0:22:30-0:25:24 Step #11 Completing the Cash Flow Statements
0:25:24-0:29:27 Step #12 Debt and Interest Forecast
0:29:40-0:31:36 Enhance Your Financial Modeling Knowledge
DOWNLOAD TEMPLATE - tinyurl.com/co...
Subscribe to our channel to get new updated videos. Click the button above to subscribe or click on the link below to subscribe - / @wallstreetmojo

[@Ashish-WSM]

The crash course on financial modeling, we all were looking for..👍

[@rutanbhattacharyya4127]

Loved the step-by-step approach. This is really helpful! Thank you!

[@Priyankawsm041]

I was looking for this one! Thanks for the simple explanation.

[@wallstreetmojo]

Glad it was helpful!

[@ANANTHAKN]

Nice video 👏

[@wallstreetmojo]

Appreciate your feedback, more content coming soon!

[@ro5252]

The best model you can currently build is a Liberty Media company full of debt, like Qurate Retail.. any chance you would provide us with a full modeling of such a complex company?? Thanks from the United States

[@soundaryasuresh1845]

Sir please bring a real case m&a study in excel with excel file sir and teach us step by step approach from scratch to end sir

[@pizzadude69420nomeme]

please do an Indian company next time with data taken from company report