Learn Financial Modelling - Step by Step - Session 4 | 3 Statement Financial Modelling

In this session of FULL COURSE on FINANCIAL MODELLING in EXCEL; we have covered everything you need to know in FINANCIAL MODELLING as BEGINNER. It covers plotting 3 statements in financial modelling. I will guide you on how to prepare 3 statement model in excel step by step.
Like our previous session in FULL COURSE on FINANCIAL MODELLING for BEGINNERS, it also breakdown everything in STEP BY STEP manner using LIVE PROJECT or EXERCISE file so you can PRACTICE it while watching this session (link below).
FINANCIAL MODELLING in EXCEL is a crucial SKILL one must learn in order to make a CAREER in INVESTMENT BANKING, EQUITY RESEARCH, VALUATION, and other CORE FINANCE ROLES.
By the end of this course, you will have a STRONG FOUNDATION in FINANCIAL MODELLING and be able to confidently CREATE FINANCIAL MODELS IN EXCEL to support decision-making in your professional life.
Start your journey towards becoming a FINANCIAL MODELLING EXPERT now!
You can connect with Parth Sir on Linkedin -
📥 DOWNLOAD the EXERCISE FILES - drive.google.com/drive/folder...
📛 If you want to join our next LIVE masterclass on Zoom = Join our Whatsapp Channel (TVS Mentoring) - whatsapp.com/channel/0029VaLf...
📌SUBSCRIBE NEWSLETTER - cutt.ly/gw2ozQbj
--------------------------
👉JOIN:
🔥REGISTRATION LINKEDIN COHORT : cutt.ly/ieeOXuwl
🔥REGISTRATION EQUITY RESEARCH COHORT Latest Batch: cutt.ly/4wSDnDLA
📛 Please refer to this video for all the Details of the Cohort:
• Equity Research cohort... !
✅ For queries, please reach to us on our Instagram handle: / thevaluationschool or DM us on WhatsApp - [phone]
👉Register here for our latest Advanced Valuations and Financial Modelling Cohort
🔥 AVFM LIVE - cutt.ly/rwXYEN2A
🔥 AVFM RECORDED - cutt.ly/VwXYW7Xp
--------------------------
✅ You can Connect with Parth Sir on Linkedin - linkedin.openinapp.co/097ag
✅Follow The Valuation School page on Linkedin - / thevaluationschool
✅Join our Instagram handle - / thevaluationschool

[@IAKCO]

I have gone through the whole video, rather I am seeing this course from its first session. I am an experienced Chartered Accountant from Pakistan . The method followed in this course up till now and the way Mr. Parth takes through every step is impressive. Great course for someone who is new to financial modelling. Most importantly he is following the international norms of modelling like hard code color and first column width adjustment. From that I knew the person knows the stuff. His communication skills are also good and he knows how to keep the audience engaged in a course which could quite often get boring. Overall one of the best courses on financial modelling.

[@castudy5925]

is there any website like screener operating in pakistan from where we can collect data of companies?

[@muhammadhammad7088]

@@castudy5925 AOA! Did you find any pakistan or global companies?

[@yasarbhatti]

​@@castudy5925dps.psx

[@yasarbhatti]

​@@castudy5925dps psx

[@waleedmadni4239]

​@@castudy5925 sarmaaya

[@ayushchaudhary5649]

Been working on excel for 4 years and yet learning new stuff here. And till it's just the basics. Heavens bhai heavens amazing

[@shashankkumar9153]

the saviour is back with a bang, waited for the whole week

[@tanmoyuzir5858]

This is one of the best financial modelling classes I have ever attended! Thank you so much sir for teaching us the nitty gritties of financial modelling. I was intending to learn financial modelling for sometime now but was not able to find the perfect class. Now this is like a boon to me. Thank you so much sir once again!

[@Jassisingh1991]

I did Financial Modelling from Some other Institute But the way you teach and explain complicated topics in such simple manner helps us in learning a lot. Thanks For such amazing videos . God Bless You.

[@user-qy2ro5ws4r]

Sir, I had no knowledge of Financial Modeling at all. I had heard about it and I was so excited about how to create models and I searched about it on KZbin, and I found your classes. Thank you so much. Your teaching is the best, especially for a basic learner like me. Thank you so much, sir.

[@riddhichaturvedi4921]

Sir you are a God's angel .... earlier i was thinking how will i do financial modelling and i don't want to give my aim of investment banking but it was really god's blessing that i came through video... sir pls continue this series like this .... my huge request and thanks a ton sir😊

[@muralidandu8993]

I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..

[@akshay6280]

1:10:34 , Jahapna Tussi Great Ho, Inti khushi mujhe aaj tk nhi hui. Thank you so much sir 🙏

[@SONUKUMAR-qv6jm]

We are very thank full to have you like my mentor I have Paid thousands of rupee to learn this but eventually wasted but get more courage to learn.

[@haritikachhatwal8275]

Excellent Lecture ,commendable efforts by you Sir . I have been looking for such a channel since last 6 years and my search ends at "The Valuation School" . Extremely grateful to you for making such interesting videos. The lectures keep you engrossed and completely absorbed in the content. Extremely valuable lecture as each and every aspect is explained in detail (even the minute details are not missed). Thank you for your efforts.

[@rahulramchandani6585]

You are just brilliant, the only purpose of him is to make us learn what a selfless man.

[@kruthikabr1548]

Sir you are a blessing to all of us who want to learn, the way you are teaching is so good. Thank you so much sir🙏

[@vaibhavbaj-yj4lz]

By far the best content and learning and that too for free.....Really amazing!!!

[@ajinkyakasabi4033]

Great session... I want to appreciate the consistency and teaching techniques. Right now The Valuation School is an undervalued stock with more significant growth potential. Keep up the excellent work. Your honesty and dedication towards the work are inspirational. Kudos...

[@spidycounts3165]

Sir, the amount of hard work and effort you are putting in is immense. I swear that whenever in the future I'll tell someone that I've learned Fin Modelling, I'll take your name. Thanks a lot, sir!

[@vinodgundwade3845]

Magic Waah... Ky baat hai sir ji.. Apne to FM sort kar di... Aise to sub log FM Sikh jayenge .. Huge ❤ for you.. sir ji...

[@Rohitkumar-jg9cl]

I was pleasantly surprised to discover the ability to obtain data from the Screener using the custom template. I'm grateful that I stuck with the tutorial until the very end and appreciate the effort put into making it available on KZbin.

[@tgvlogs2000]

hi rohit i wantetd to ask one thing, i have downloded tatamotors report but it fails to convert it into excel properly, it is not converting like it did in parth sir excel sheet, could u please help me , im stuck

[@user-df2hr2tz7r]

Changes in Receivables, Inventory, Payables in Cash Flow Statements are included individually and as Net in the line item WC changes. That's why there's the difference of 100 in Cash Flows at 1:13:48. Screener nets the changes in WC and also shows individually thus when copying the Cash flows from screener, it feels like it is a separate item but it is not. Absolutely love this series!!

[@vaiware]

Savior.Thanks!

[@TheNiveshNukkad]

Thanks dude

[@shreyasmungad]

Yo thanks man, was confused about this

[@mayanktiwari2498]

Thanks a ton man!! was wondering why the mismatch is happening!

[@manvinagpal2095]

Did you faced a problem when you tried to save your sheet on excel and it's showing some error when you tried to change the company

[@jaikumarpritmani6596]

No fees and no side talks, you are great Parth sir

[@SahilSharma-gw3lu]

Your video is best than I spent $500 from US for financial modelling. You Rocks man🎉. Respect for you!

[@SONUKUMAR-qv6jm]

Bahut hi badhiya sir me faltu me paid courase dhund raha tha guru to mujhe youtube pe hi mil gaye shehar me dhundora bagal me chora Thank you so much to have you like mentor I really want to meet you because guru ko guru dakshana jarur milni chahiye

[@ishankhare2672]

Great series sir. Thanks a lot. Such in depth teaching is the need of the hour.

[@McFactMotivation]

the way he explain that's amazing

[@udaymanna6275]

i have no words how much valuable these videos are for me. Really thnx a lot thankyou so much❤. May god bless you.🤗😇

[@manobhavkumar5272]

Sir g mzaa aara h aap sy sikhne mei . Thank God aap mil gy jldi, jyada time waste nhi hua BSS ysy hi kirpa bnaay rkhna sir g . And please continue rkhna series🙏🙏🙏🙏🙇🙇🙇🙇😁😁😁

[@idhruv_07]

Thank You Parth Sir For This Amazing Sessions and Life Long Learning 🎉🎉 Love From Gujarat ❤

[@udaytandel465]

GREAT VIDEO SIR VERY INFORMATIVE AND RIGHT TOWARDS THE TOPIC AND WITH NO TIME WASTE THANK YOU

[@amitmane681]

Awesome Lectures Sir, I am learning Financial Modelling in May 2024. Still I am able to relate all the teachings you have given in these series. Thank you!

[@harshitchauhan326]

thankyou for this series sir...the quality of these videos is just superb

[@au0037]

Last mein kya mast jaadu dekhne ko mila sir😯. Thank you so much for this precious content on FM. 1.5 month se koi accha course khoj rahe the but koi mila nahi and finally 2 days ago ap mil gaye...loved your content sir😍..keep it up

[@govindgoel2442]

Home work done. Maina Tata Steel ka model bnaya..File bhi uplode ho gayi. Thanks mja a rha hain. Ager Research Report banana bhi skha doon chandi chandi ho jayegi 😁.

[@udayteja6595]

Thanks for the informative video. Note: Screener considers change in inventory as "Closing - Opening", that is why we are reducing the same from cost of production, to achieve COGS.

[@radhika19089]

Day 4 of me learning financial modelling from you. Have no doubts so far, everything is made crystal clear from you! Thank you for the efforts sir.

[@gamingduniya3909]

Can u explain me why he had taken interest and depression quarterly. When we have yearly data.

[@adityamamodia4151]

we have only taken qtry for LTM part and these also not alone we club last 4 qtrs ... please go through full video u will get it @@gamingduniya3909

[@sujaldoshi18a41]

Why change in inventory is reduced while calculating COGS?

[@AdityaRajput-oh3sj]

Thank you so much for sharing your knowledge with us it really means alot 🙏❤️

[@youtubepremium1099]

just wow with so much simplicity sir !!! amazing session

[@mihirranjan3440]

Done with the 4th session .It was great as usual!

[@Kukkibuzz]

You are a blessing to those of us who aspire to learn, Sir your method of teaching is excellent🤩

[@khurramshahzad-jp2wc]

Appreciated. watch all three sessions till now.

[@adityamamodia4151]

excellent excellent , thanks for these deep lernning videos, mazza aagya ...aj kuch laga utube koi kaam ka h 😍😍😍😍

[@architpawar6745]

Best youtube learning till date

[@badrishpai9141]

Thank you Parth Verma Sir for this valuable course. Looking forward for more videos like this. Please keep bringing up value adding courses like this.

[@Komalmishra-mr1ui]

I'm glad I got this channel

[@riteshmistry8095]

Thank you so much Parth sir, I fall in love with financial modelling 😅

[@purusottamsahu2073]

Superb explanation sir, You made our life even more easier. ❤

[@nitikaverma1810]

jaw dropping techniques.. thank you so much sir

[@mehranahmad5294]

It's a great session Sir. I have learned a lot from this session.

[@shohailshaikh6671]

Amazing module... Looking forward to learn more financial model .

[@bhavyagarg1264]

Thank you sir! Your videos are really amazing😍😍😍

[@rohittanti1500]

thanks a lot Parth sir for you valuable and practical learning.

[@capriyankajaiswal12]

thanks parth… started from your first lecture and excited for upcoming lectures as well

[@ayushjain2871]

Really great sir, the efforts you have made to teach us. I just wanted to say that the eps growth formula you have used is simple and when there is 2 consecutive negative eps, it is showing positive growth. Therefore I used a super complicated formula 😅 using nested if function.

[@nikhiljuneja421]

Thank You for your efforts!

[@ashishrajput1125]

Awesome Video, Really helping a Lot, Thanks a TON !!!!, For the Last part (ITC Cash Flow) we can also Paste the ITC data on the side and Run a V Lookup in our Template, that way only Relevant cells will get filled.

[@VidhiPathak-sp2ze]

Excellent video!! very detailed.

[@reshmajagade4325]

Thank you sir....I am enjoying the learning.

[@vimalamoli8742]

Amazing modules, thanks sir 🎉

[@akashdeepdhiman6775]

Great content and learnings...thank u sir 😊

[@karanjain1937]

Thank you so much for making such informative and in-depth content. I am really enjoying learning from these videos! Question - is there a platform like Screener for U.S. markets? What would be the best way to download data in excel for public companies in the U.S.?

[@akash.karmakar]

Revolutionary Course

[@Asfan_Arab]

"Thak Thak Thak Thak"👌 Thank you sir, One of the best & also it is never boring sir.

[@kapildayma6361]

Twist at the end was amazing

[@meltinmathew2]

Very informative video. Loved it!!!

[@amitsingh-be6me]

Gr8 Learning, thanks for this free session.

[@sachinprajapati6069]

Thanks sir such a great series

[@vedikakhamayacha7659]

Just now completed with session 4. And I must say that the quality of lectures and teaching is too high to appreciate. I am glad that I found this brilliant lectures to learn and sharp my financial modelling skills. Waiting for upcoming lectures😀😀

[@moneebbaqi4928]

Hi Vedika sorry to bother you, but I am unable to convert the data from pdf to excel it is being distorted although I've tried other tools in addition to I love PDF. could you please facilitate me in this matter. I'll really appreciate it.

[@melwyndcosta4966]

Sir ur just awesome..great..teaching 😀

[@shwetajain7119]

Thank you sir for this series 🤗

[@Rehesamay]

i just watched your few videos and i can see your growth in near future but i have an observation that people change their motivation after being famous, they start focusing more on paid videos. i can understand that everyone is working for money but i can assure you that those who don't distract by money, eventually gets more money than they thought of.

[@thevaluationschool]

I know Samay, I will be cautious of this fact. Thanks!

[@allabouthuskies.9213]

Thank you sir for this awesome course

[@maheshshettigar5205]

Important Note to Everyone: Total of Cash flow from Operating activity and its bifurcation doesn't add up most of the time in screener, make sure you tally the same referring to the AR of target company and match the Net cash flow. And Thank You for this wonderful session. Ping this Comment if possible.

[@adinisar2079]

Other EXPENSES negative kese ho sakte hai.. in this sheet other expenses are negative...

[@prabhkiratsingh4055]

bro what is AR and i have also some other doubt in cash flow statement also

[@adinisar2079]

@@prabhkiratsingh4055 annual report

[@sujaldoshi18a41]

Why change in inventory is reduced while calculating COGS?

[@jaioberoi2729]

Thank you so much!

[@sakshikirar8409]

sir u r great ❤😊 thanku for that series it was too helpful for us

[@Komalmishra-mr1ui]

This video is really helpful ...

[@ritikaaggarwal6075]

Your videos are superb. I have been following you on linkedin even before looking to these videos. The way you said" arey yeh kyaa ho gya" hahahah perfect sir !!

[@commercewithmj4960]

Very well explained. Keep it up.

[@poonamkaushik4866]

Thanks sir for the videos

[@dipanshijain424]

i had a query while working on cashflow data for different firms, is it easier to tally the values of the report with our existing model or make a new model just for cashflow data ?

[@ashishrana6]

Thankyou for the video.

[@loopes2026]

Thank you sir it is very helpful

[@sonamprasad1473]

Best course on financial modelling....thank you so much sir for such a Valuable content

[@ashishmehta3415]

Why change in inventory is reduced while calculating COGS?

[@abhishektyagi4955]

Thank you so much for your efforts sir.. it is very helpful 👍

[@thevaluationschool]

You are most welcome

[@dhwanishah4179]

Screenr data does not include EBITDA - for quarterly how should we consider the amount for EBITDA?

[@ashishkumar-me1uc]

Any update on this? @thevaluationschool @dhwanishah4179

[@aish000]

Did you find a solution?

[@MohakSinghal-rw9gb]

Just add interest, tax, depreciation to net profit, you will get EBITDA

[@ajinkyaphirke7675]

Thanks man!! ​@@MohakSinghal-rw9gb

[@vanshikapatidar4509]

Hello Sir, First of all a big thank you Sir, literally you have delivered an amazing content which I was looking all round . And I want to ask question that can we extract excel files of different companies from other screening website too and then do we have options on other website too to upload our financial analysis excel.

[@camanishagarwal]

Very useful thanks a lot 😊

[@lalitmohansharma468]

Dear Sir, PDF file not converting as you are showing in Video all data divided in different sheet. How to convert pdf data in Excel in correct form.

[@user-yz1fh5ec8t]

Hello Sir, It's a great source for finance enthusiastic fellows! I had a doubt that some calculations for cash flow statements are incorrect on screener for ITC. Can you please suggest what can be done in such scenario?

[@shakirchoolakal5436]

Fantastic lecture

[@r4deon602]

Stay Blessed brother!

[@shivanshshukla5883]

First Sir you are awesome subscribed and notification on hai sir

[@Vinayworks666]

Thankyou for the session sir

[@mandarnaswale9853]

Thank you so much sir, ❤🙏

[@user-rh3xv8zk8r]

Learnt a lot from your video. Please correct WC changes, to tally the Net cash flow. Last I liked the upload part. Thanks once again.

[@prathameshrane7607]

Mind-blowing

[@ayushawasthi4744]

Thank you sir.

[@ishikagupta3745]

Sir I followed the excess exact steps and also made suitable changes according to the items missing/added, my CFO and Net CF just do not seem to match as shown in screener

[@harshabali2750]

Thank you so much for these methods sir. I had earlier joined some classes and they literally asked us to hard punch all the numbers from income stat and balance sheet. And it was so confusing for me as we hav e to change the tab again and again.

[@sohailmirza6195]

Sir you are Gem💎

[@llinone8366]

Thanku so much sir 🙏

[@architvijay1482]

Thankyou so much sir