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

[@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

[@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. Whereas, in Schedule III or any other standard format of a profit and loss account or a cost sheet, we take change in inventory as "Opening - Closing" which automatically gives a negative figure if there is closing stock at the period end that is more than opening, and ultimately reduces the cost of production to achieve COGS.

[@lakshyasingh099]

I have a doubt: when calculating cash flow after extracting data from the screener, the net cash flow value doesn't match the net cash value on the data sheet. Why is that?"

[@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.

[@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!

[@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.

[@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

[@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

[@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?

[@muralidandu8993]

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

[@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?

[@mathew11930]

@@prabhkiratsingh4055 annual report bhai

[@akshay6280]

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

[@rahulramchandani6585]

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

[@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 😁.

[@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

[@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🙏

[@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😊

[@BhaskarMondal-g7e]

Hello Sir I am overhelwed the way you teaches us the concept of financial Modelling and its properties . Right now i m in the middle of my career and switching my career from hedge Fund analyst to private equity operation . One last thing i want to say " sir apko dekhne se super 30 me aanad kumar ji ki yaad aati hai jaise aanad kumar baccho ko free ke IIT ki education dete hai wasie apne ye pura Financial Moddeling jo kuch Xyz institutes bhari bhari paisa lekar padahte hai woh apne free ki hai . Hats off to you 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.

[@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!

[@SahilSharma-gw3lu]

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

[@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!

[@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🙏🙏🙏🙏🙇🙇🙇🙇😁😁😁

[@udaymanna6275]

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

[@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...

[@udaytandel465]

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

[@prabhatverma2542]

at last it was magic that humne bs ek company ki financial statements bnai aur baaki sbki apne aap ussi format m aagyi woahhhhhhhh

[@namankaushik1008]

Thank youuu sir, it's really great, when I first started this video of making financial statement, it really took me 3 days to make whole full fledge statement of tata motors, but for making excel of ITC it took only 30 minuets, and I am so exiticed and happy now. Thank you sir.

[@RiyaRoy-hw6fv]

Hey Could you help me i have some doubts

[@namankaushik1008]

@@RiyaRoy-hw6fv Sure, I will try my best.

[@LekishaKatyal]

@@namankaushik1008Sir, why are the figures different in both models, I noticed that in my model, EBT was matching with the screener but PAT wasn't until I realised that the tax rate was taken in round figures without decimals in consideration, so is it fine to hardcode just the tax rates numbers in order to match both?

[@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...

[@nikhilns7425]

Hello sir, I am Nikhil CA Final student Had confusion whether to make career in finance or tax but believe me your videos has influenced me to concentrate on finance. A big thanks for your free initiative It is very helpful ❤❤❤. Once again Thank you so much.

[@aashishsharma6706]

Me too

[@vaibhavbaj-yj4lz]

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

[@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.

[@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.

[@sachinprajapati6069]

Thanks sir such a great series

[@jaikumarpritmani6596]

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

[@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

[@kapildayma6361]

Twist at the end was amazing

[@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

[@Asfan_Arab]

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

[@Kukkibuzz]

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

[@ashishthomas5276]

Hi Sir, the Operating profit and Net cash flow seen on screener and from our calculation is different. Could someone elaborate on this?

[@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.

[@idhruv_07]

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

[@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?

[@FahadWasim-gn9rk]

Sir, is this course relevant for people outside India? I'd really appreciate if you could answer that. Thank you for the incredible value you're giving for free! It's unbelievable for this day and age.

[@nitikaverma1810]

jaw dropping techniques.. thank you so much sir

[@ishankhare2672]

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

[@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.

[@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.

[@adityamamodia4151]

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

[@PoojaPal-lr1rm]

What type of settings have you done, because when I copy and paste the data from screener into Excel, it never gets loaded in the same format pr in such an organised format.

[@user-sw3dq7jp1q]

Cntrl+Alt+V karke phir Text pe click kiya karo

[@parasdanure6091]

Good Evening Sir, usually it is a general practice in the industry to extract data from the actual annual report reported by the company. Using third party applications is mostly avoided. So what is it that we should follow? Also the template works well for Income and Balance sheet because screener has its own template where the line items for all the companies are same. However, in reality the line items may differ drastically. So what should we do in such cases? Should we follow the 1st method, i.e conversion of actual annual report to excel and then do the formatting or go with the automation method? Kindly guide for the same. Thanks in advance.

[@ParthMore276]

Hi, as mentioned at 07:04 in the video - kzbin.info/www/bejne/Y4esooawequpoK8 - You will have Plug-in / software to pull out actual data from authentic source.

[@bhavyagarg1264]

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

[@govindgoel2442]

Love this video, I have almost literally spent my 1 year to find good channel where I can do financial modeling and bought udemy course, pirated course, Quora, Artical and finally find your channel that's the reason to thanks again and again. ~Have a question~ I have mostly listen while reading article and investment banker your cash flow statement made from IS and BS so it is okay to hardcore the numbers?

[@moneebbaqi4928]

Hi Govind 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.

[@user-vz3bs9fu6p]

mind blown when we finish the model and upload it on screener

[@chetanpatel3466]

Hey, could you please explain me why the amount of Net Profit we have calculated is different from the one given in the data sheet ?

[@vishal12681]

Great work flow and excellent excercise. However after performing the steps, the excel sheet downloaded has complete mismatch from the figures given in screener. For eg. Tata Motors Net Profit for 2014 is 14050cr as per screener but the excel sheet shows 14261cr. For the year 2022 the net loss as per the excel sheet is 13658.8cr while screener shows a loss of 11309cr. It is the case with every figure and with every company that I've tried to perform this excercise on.

[@threegentlemen-1795]

When we plot the cash flow statements, be it TATA MOTORS OR BE IT ITC, our individual cash flow from investing and financing activities matches with the Data Sheet. But if you check the net cash flow, be it tata motors or itc, none of them match. This is because of wrong cash flow of operating activities. It's is wrong in both Tata motors as well as ITC and does not match with data sheet. Could you please reply, and tell a formula so that CASH FLOW FROM OPERATING ACTIVITES AND NET cash flow matches with data sheet. Hoping for a reply !

[@SM_Lil_Explorer]

Why are you only liking all good comments, please address actuall queries, I also blv there is some error in that paart

[@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!

[@architpawar6745]

Best youtube learning till date

[@adorable_writes]

I choose Marketing over Finance in MBA but ab lagta hai Parth sir mujhe CA Bana k rahege I much appreciate you Parth sir really enjoy your classes 😊

[@McFactMotivation]

the way he explain that's amazing

[@RiyaRoy-hw6fv]

I didn't have EBIDTA in my excel file which i downloaded from Screener. In that case how will i calculate EBIDTA for LTM?

[@khurramshahzad-jp2wc]

Appreciated. watch all three sessions till now.

[@tanmayvarshney9200]

What a diamond he is!! I am proud of myself to find a diamond on KZbin where all are just coal.😂😂 🙏🙏 Thanks sir, koi nahin hai takker me, CA shaab hai tashan me 😅😅. Your export waali technique, amazing 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

[@rohittanti1500]

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

[@VishalPawar-ff8oi]

Sir first of all thank you for providing the valuable content, i have a doubt while calculating COGS why we have deducted Changes in inventory and added negative amount of Changes in inventory in COGS ?

[@shivanshshukla5883]

First Sir you are awesome subscribed and notification on hai sir

[@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 !!

[@amitsingh-be6me]

Gr8 Learning, thanks for this free session.

[@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.

[@manishbhadane3925]

you are doing great work , dont stop it sir i am so dumb that i pay 25000 rupees to wallstreetschool

[@mehranahmad5294]

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

[@shrutinaik4239]

Thank you so much❤

[@Embracing_Love]

31:11 Times stamp prr sir aapne depreciation Quarters wale mei se kyu liya Mar 13 ke liye means rule hai kya ki jaha smal hai wha se lena hai

[@shohailshaikh6671]

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

[@pranavsharma2719]

In my Excel why NIL amount is appearing as 0.0 and not as "-" like in this excel. Kindly help.

[@canikitak]

You are seasoned financial modeller

[@adorable_writes]

absolutely

[@mahima4840]

If PY financials are not audited yet, then should we consider that year too in actuals while preparing financial model and take the data from screener?

[@LIPIKABACHHAWAT]

what are the components we will take while analysing the financial statements of banks @parth verma

[@nidhisharma-tm6un]

Hello sir, it's a great video, I have doubts about the cash flow, can you confirm how to recheck the cash flow, their few values do not match I have checked multiple times. Recheck the formula, I tried but get the wrong value, false * HOW TO CHECK CASHFLOW- ??

[@Komalmishra-mr1ui]

I'm glad I got this channel

[@riteshmistry8095]

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

[@jeevikagoenka8247]

Question Sir when i m doing for HUL the screener has not given the data for EBITDA for quarter so for LTM what figures to put in EBIDTA ????

[@reshmajagade4325]

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

[@youtubepremium1099]

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

[@pranjaltiwary]

Bhaiya! Maza agya ye 3 videos maine total 4-5 hrs me dekhe h over period of 3-4 days. Isme excel bhi sikh rha. Thank You so much❤❤❤

[@harshitchauhan326]

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

[@commercewithmj4960]

Very well explained. Keep it up.

[@kartiksahani6109]

Hello, it is very useful information, I watched many video and it is very damn good ,in this video cash flow operating activates is incorrect, that's why total in not matches with cash flow data.

[@SN-qf9pl]

Sir you are right they are indeed wasting us

[@nikhiljuneja421]

Thank You for your efforts!

[@dhairyachauhan1234]

sir I am watching your financial modelling video this year and i had exported data from sceener to excel but i can't find "EBITDA" in Excel Spreadhseet!! Sir Can you Pls let me know what to do now??

[@VidhiPathak-sp2ze]

Excellent video!! very detailed.

[@mihirranjan3440]

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

[@capriyankajaiswal12]

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

[@krupashethh]

Hi sir, I have a question it would be great if you come across this question and help me with that. What if we want to analyse any US stocks which stock screener website we will use for US stocks?? @the valuation school

[@anish9409]

20:53 I think Changes in Inventory will be added. As Changes in Inventory = Opening Stock - Closing Stock, As per Cost Sheet, Direct Material + Direct Cost + opening Stock - Closing Stock =COGS Moreover, COGS = Opening Stock + Purchases - Closing stock = Purchases + Changes in Stock

[@srinivasaragha1854]

changes in inventory means ending inventory - beginning inventory, which would make the final profit/loss match the profit/loss in data sheet, i cross checked the changes in inventory shown in P/L and B/S, the signs match but the amount doesnt match, i guess there might be impairment or some non COGS exp change in inventory which might be shown in other income or operating expense that might somewhat explain that discrepancy,(maybe)

[@anish9409]

@@srinivasaragha1854 Ok Thanks for clearing the confusion

[@reelchannel111]

In historical financial statement of income statement sir didn't took other income why is it not included can you please help me ? Was it error ?

[@srinivasaragha1854]

@@reelchannel111 yeah, I saw that too, i think he missed that out while maintaining focus on teaching, we should add that too before EBIT, if we add that, the EBT from data sheet and our historical FS would match

[@sahilbhardwaj8727]

@@srinivasaragha1854 What about other expenses, I think he hasn't taken them into consideration as well. And, why before EBIT. Should we not add other incomes and subtract non-operating (other expenses) after EBIT?