Basic Conventions: 1. Reduce Column Width of Column A to 1.15 and leave it blank. 2. Write the currency at top before anything else. 3. Plot years through formulas. 4. Distinguishing between Actual & Estimate figure years. Select the cell with Actual Year. Ctrl+1 (Format Cells window) Number Custom Choose “0” Type: 0“A” (Sample will show “2020A” - For Actual). Write “F/E” for Forecasted/Estimated. 5. Make the heading background dark and use White as font colour. 6. Freeze the heading. 7. Use Paste Special for Copy - Paste. Ctrl + Alt + V for Paste Special. 8. Consistency is must. Numbers at 1 decimal. Percentages at 2 decimals. Comma at the distance of 3. How to do that? a. Ctrl+1 (Format Cells window) Number Custom Choose 5th option from top (#,##0;-#,##0) Type: #,##0.0;(#,##0.0) 9. Hard-coded numbers’ font colour should be blue. Font Colour More Colours 2nd row and 3rd from last colour (blue). For ease, use F4 (Fn+F4) after selecting hard-coded numbers to copy the format. (Works only if you have not used some other formatting) 10. Use formula wherever possible. 11. The “Particulars” column should be left-aligned. And others should be right-aligned. 12. Use Alt+H+0 for increasing decimals. 13. Use Ctrl+Alt+V (Paste Special) for copying the formats. 14. Use Shift+Alt+Right Arrow for grouping. Use Shift+Alt+Left Arrow for ungrouping. 15. Bold the top and bottom line. Add borders to Immediate attention rows/columns like Gross Profit, EBITDA, EBIT etc. 16. Checking/Auditing the model: a. Ctrl+G Special (OR Alt+S) Select Constants It will show all the hard-coded entries. b. Ctrl+G Special (OR Alt+S) Select Formulas It will show all the formulas. 17. Shift+ Space Bar Row Selection Ctrl + Space Bar Column Selection 18. Try not to hardcode data into formulas as well. Go To wouldn’t be able to catch it as well.
#Dynamic Headings: ="Heading"&" - "&Cell of hardcoded company name #Conditional Format: (Alt+H+L)then highlight cell rules #Functions: Time periods : 1.Function for finding end of month -Monthly Data =EOMONTH(start date,select cell of hardcoded zero) press F4 for fixing start date 2.Function for finding end of year-Annual Data =DATE(YEAR(start date)+select hardcoded zero,12,31) press F4 for fixing start date 3.Function for finding Gap betwen Start date and end date in terms of years (note: end date can be Monthly or Yearly data) =YEARFRAC(start date,end date) press F4 to fix start date #Formulas of Averages: Average =AVERAGE(select all cost of a column) Weighted AVG =SUMPRODUCT(select all weights,select all cost in a column) press F4 to fix Weights Median =MEDIAN(select all cost in a column) Minimum =MIN(select cost column) Maximum =MAX(selct cost column) Small =SMALL(select cost column,select hardcoded no.3) press F4 to fix Hardcoded no.3 Large =LARGE(select cost column,Select harcoded no.3) press F4 to fix Hardcoded no.3 #IF Statement: =(logical test,value if true,value if false) Use of Margin Space - put # along the Headings for Easy Navigation
I want to hug you buddy. There are very few people in this world who can teach students the way you teach. You're not forcing anything, nor selling anything, you are soo good at it that learners will appreciate your work in coming years. I hope your channel grows exponential. Thank you once again.
Sir a true teacher and a true Heart ❤️ ❤ I have no words to express but I feel from the last 20 days ki like yes I can do the best financial model and which is always in my hands and you always mentioned that your model should be in your control that's I feel today
He knows he doesn't need to "Sell" his course, cuz its already the best and that we would support him!! This is my third session with you, I'm already so overwhelmed by how amazing excel is, excited to learn much more about it. Thank you!!
These videos will make history may be these are on slower side in terms of views and traction but mark my words people who are genuinely interested will visit again and again just to learn and clear their concept, please keep up the good work as these videos will act as a pioneer in the field of financial modeling and valuation God bless you brother
Timestamps 00:01 - Learn Excel functions to simplify financial models 02:05 - Importance of maintaining consistency and simplifying complex financial models 06:24 - Selecting and managing names for conventions in Excel for financial modeling. 10:16 - Simplify financial modeling by breaking down calculations 15:17 - Understanding the impact of issuing debentures on coupon rate based on debt equity ratio. 18:46 - Using VLOOKUP function in Excel for data lookup 24:33 - Understanding the necessary sales growth to achieve a specific profit target. 26:40 - Understanding the impact of changing margins on sales and profit analysis 31:56 - Formatting and color-coding can help improve visibility and understanding of financial models. 34:14 - Analyzing impact of sales growth on gross margin through scenario analysis 42:10 - Explaining financial modeling concepts in Excel. 44:50 - Understanding Data Validation in Excel 51:44 - Protecting Excel sheets for data security 54:00 - Importance of data security and formula protection
This video covers advanced excel topics such as; Name Manager from series 5:20 Data Table and Scenario Analysis 39:00 Circle Invalid data in data validation at 49:35 Protect sheet and calculated cells 53:00
i love it when you invoke the IF and VLOOKUP formulae. It actually helps understand the formula better. In college, I had literally rote learnt adding 2 to the column index input. It worked because of the model but the logic was flawed. Thank you so much!
Thank you for this session sir. This session not only opened the doors to learning Financial Modelling for me but also gave me a new perspective on using Excel. This session has made me realise how much my excel skills were lacking.
Hey just a excel tip @ 20:43 instead of using vlookup , excel has a function specifically designed for these type of problems , the function is lookup , =lookup( Lookup value , lookupvector, result vector) Lookup value is the value u want to look for , in this it is 25% , lookvector is nothing but from where u want to lookit up from that is the De ratio table , and the result vector is wt u want as a result , in this case it is the coupon rate table Tq so much sir for these amazing lectures really soooo helpful
Best thing about sir; firstly he will be telling that; I am not going to make you understood the basic stuff then also describes each and every stuff from the very basics. thanks a lot sir.
Awesome and simplified. I have done a course on Financial Analyst, but I rarely remember anything from that. And these videos will stay for lifetime in my head. Very nicely explained with simplified examples. Thank you so much Sir for these videos. Turned on All the Notifications from the channel, only and only this channel.
I could not perform the data table & Scenario Analysis exercise using Alt, A, W, and T. The amounts were not coming the way they are coming in the video. I tried doing this exercise 5 times but still was not able to perform it. then I got the answer. Just letting my fellow viewers know that we have turned the settings to "Automatic except for data tables" in Formula settings, hence we have to press the F9 key for calculating the table. Hope this helps!! Sir, you are doing a great job 😍
I just want to really thank you from the bottom of my heart^^You giving so much value for free...But I think you're doing it for free because it gives you, emotionally a feeling that money cannot buy.Bless your heart.
Sir, You're truly great. I have been seeing your videos since past 3 days and there's not a single thing which have gone above my head reason? you simplify everything and breakdown to understand it in easier way. I will call you god of Valuations. :)
Amazing videos... Thank you for your efforts.. also request everyone to share these videos to your connections... really disheartening to see that the number of comments and likes are very much low for such an amazing content.. where stupid ticktock or Insta people get famous doing nothing good for the society.. this channel deserves much appreciation that its getting now
Amazing 🤩🤩🤩🤩🤩 This is not only Financial model but FM + Excel training, so much of efforts to teach us the very useful excel functionalities.. A very big Thank You ❤
Thank you, sir, for the incredible sessions! 🙌 I want to express my heartfelt appreciation for the exceptional teaching style you bring to every session. Your expertise and passion shine through, making the learning experience truly enjoyable. Despite already being familiar with the subject matter, I find myself captivated by your approach and gaining valuable insights with each session. Your dedication to teaching and your ability to deliver information smoothly have undoubtedly elevated my understanding of the topic. Learning from you has been a remarkable journey, and I am grateful for the knowledge you have shared. I am honored to have your support and guidance throughout this learning process. Your encouragement and expertise have made a significant impact on my educational journey, and I can't thank you enough for that. Once again, thank you so much for your unwavering support and for making each session an enriching experience. Your commitment to excellence is truly inspiring, and I look forward to continuing this remarkable learning journey with you.
Trust me I have learnt all this functions but never thought that these functions will be used in this way and to be honest these functions used by you is more easy to learn.Thank you sir for this one.
Shortcut for borders- Instead of using ctrl+1, we can use the following as well- a. alt h b r/l- right/ left border b. alt h b p/o- top and bottom border alt h b will activate the border shortcut, and there are other border formulas (eg. oustide borders, bottom double, thick outside borders etc.) as well which we can use
Thanks Sir Parth, Day 2: Session 3 done; Today session was quite advance level but you explained really well but need to revise it tomorrow before moving it to Session 4. Stay Blessed. :)
Great sir, this is pure gold..wanted to learn financial modelling since a long time...but unable to do so...but this time no excuses. Thank you so much for your effort.
If anyone has problem related to data table calculation where all values are coming as 9570, you need to press F9 after the data table output. This happens because in workbook calculation setting we set as "Automatic except for data tables", so we need to manually calculate it by pressing F9.
excuse me, but can you guys help regarding first exercise? (Defining Names) On how to calculate the Cost of Goods sold, and Gross Profit, also about the instructions that say we need to highlight cells K23:L25, and name them? I know that we have to define names, but mereko smjh nhi a rha kaise karu. Please help.🙏
Thanks Sir Boss Guru Maharaaaaaaaaj, GOD Bless you, really enjoying the lectures. Recently started following your channel and these video are full of knowledge and clarity. I hope to continue watching these videos completely.
Thank you sir for providing the financial modeling playlist for free.. In this tutorial you taught very well. & it is my request that please make playlist on Fixed Income Securities certification exam preparation for NISM.. Thank you once again for excellent teaching :)
Very well explained all the formulas with at most simplicity. Sir blessed you as a mentor / teacher which teach students with full of passion and enthusiasm!!
Very insightful and detailed to the basic fundamentals before moving ahead to the ultimate aspects of the topic speaks of your experience in the field. Genuine appreciation towards teaching with a noble intention of free but quality learning. Loved your explanation member. Highly recommended.
Soch raha video editing hi seekh leta hu, kam se kam kisi kaam hi aa jaunga 🙄🙄🙄 Just feeling very great full, You are teaching really good stuff, Big Fan
I have been confused as to how to lear financial modelling, bought expensive course however couldn't complete it. Didn't like the way of teaching. This one is free and fun. Hope to complete this one.
Time stamp 4:59 While calculating WACC , you have used C12 instead of C13 for multiplying value of debt to total capital Although the WACC is correct because both equity value and debt value is same 👍 You are doing a pretty good job, i am learning a lot from your videos Thanks for the help ❤️
Very few can match the level of your teaching Your integrity in your work is already seen Wud be leaving our contacts Any time you have a right to ask Guru Dakshina ~ Hak se maang lijiye sir . May god bless you with good health rest you will achieve your goal for sure
Hi sir I completed my MBA in Finance but didn't get any job, so I started learning data analysis based on market demand. But after seeing you I started learning FM through your videos. But I have fear about my future due to changing goals. Please suggest to me whether I have made the right decision or not please.
Hi Brother, I can't understand how to calculate the next year sales, cost of sales and gross profit as well? Neither I could understand what the instructions meant by highlighting cells from K23:L25. Please help out🙏
Sir I watched 3 videos - practiced a lot - confident enough. Even a 5 year old kid also can follow the steps - very detailed yet so simple. Sir, I am a student of Mathematics - had no financial background. My intention was to learn economics,& finance in order to invest in stocks. Then I realised that big investors also do financial modelling to get a better gestimation of companies' future. I started watching videos, reading Investopedia and all of a sudden I got YOU. ( I had problem with Excel as well 😊) You changed my thinking. In 3rd video I didn't really understand COST OF CAPITAL, ERP, DEDT FUNDING etc. Sir, can I learn those ? Please, reply me sir and will it be possible for you make a series of for us who are literally, illiterate in finance? I am a teacher in Mathematics - but, now I want to be like you ( just a dresm sir - I know the complexity). Please do something so thqt guys like me also can be a part of your financial TH-cam journey. I love you sir
If you want to learn analysing, you need basic understanding of financial statements and then try to learn financial management and other advanced stuff later
struggling with the language ,wish it was delivered fully in english....good course like this should have been in a common language for international students too..anyways thanks soo much sir
Basic Conventions:
1. Reduce Column Width of Column A to 1.15 and leave it blank.
2. Write the currency at top before anything else.
3. Plot years through formulas.
4. Distinguishing between Actual & Estimate figure years. Select the cell with Actual Year. Ctrl+1 (Format Cells window) Number Custom Choose “0” Type: 0“A”
(Sample will show “2020A” - For Actual). Write “F/E” for Forecasted/Estimated.
5. Make the heading background dark and use White as font colour.
6. Freeze the heading.
7. Use Paste Special for Copy - Paste. Ctrl + Alt + V for Paste Special.
8. Consistency is must. Numbers at 1 decimal. Percentages at 2 decimals. Comma at the distance of 3. How to do that?
a. Ctrl+1 (Format Cells window) Number Custom Choose 5th option from top (#,##0;-#,##0) Type: #,##0.0;(#,##0.0)
9. Hard-coded numbers’ font colour should be blue. Font Colour More Colours 2nd row and 3rd from last colour (blue). For ease, use F4 (Fn+F4) after selecting hard-coded numbers to copy the format. (Works only if you have not used some other formatting)
10. Use formula wherever possible.
11. The “Particulars” column should be left-aligned. And others should be right-aligned.
12. Use Alt+H+0 for increasing decimals.
13. Use Ctrl+Alt+V (Paste Special) for copying the formats.
14. Use Shift+Alt+Right Arrow for grouping. Use Shift+Alt+Left Arrow for ungrouping.
15. Bold the top and bottom line. Add borders to Immediate attention rows/columns like Gross Profit, EBITDA, EBIT etc.
16. Checking/Auditing the model:
a. Ctrl+G Special (OR Alt+S) Select Constants It will show all the hard-coded entries.
b. Ctrl+G Special (OR Alt+S) Select Formulas It will show all the formulas.
17. Shift+ Space Bar Row Selection
Ctrl + Space Bar Column Selection
18. Try not to hardcode data into formulas as well. Go To wouldn’t be able to catch it as well.
Thank you buddy😊
thank you very much this is really helpful
#Dynamic Headings:
="Heading"&" - "&Cell of hardcoded company name
#Conditional Format:
(Alt+H+L)then highlight cell rules
#Functions:
Time periods :
1.Function for finding end of month -Monthly Data =EOMONTH(start date,select cell of hardcoded zero) press F4 for fixing start date
2.Function for finding end of year-Annual Data =DATE(YEAR(start date)+select hardcoded zero,12,31) press F4 for fixing start date
3.Function for finding Gap betwen Start date and end date in terms of years (note: end date can be Monthly or Yearly data)
=YEARFRAC(start date,end date) press F4 to fix start date
#Formulas of Averages:
Average =AVERAGE(select all cost of a column)
Weighted AVG =SUMPRODUCT(select all weights,select all cost in a column) press F4 to fix Weights
Median =MEDIAN(select all cost in a column)
Minimum =MIN(select cost column)
Maximum =MAX(selct cost column)
Small =SMALL(select cost column,select hardcoded no.3) press F4 to fix Hardcoded no.3
Large =LARGE(select cost column,Select harcoded no.3) press F4 to fix Hardcoded no.3
#IF Statement:
=(logical test,value if true,value if false)
Use of Margin Space - put # along the Headings for Easy Navigation
while starting protect cells how did sir showed all the formule in the cell using goto like he said??
LEGEND
I want to hug you buddy. There are very few people in this world who can teach students the way you teach. You're not forcing anything, nor selling anything, you are soo good at it that learners will appreciate your work in coming years. I hope your channel grows exponential. Thank you once again.
Thanku so much sr from bottom of hard
Sir a true teacher and a true Heart ❤️ ❤ I have no words to express but I feel from the last 20 days ki like yes I can do the best financial model and which is always in my hands and you always mentioned that your model should be in your control that's I feel today
He knows he doesn't need to "Sell" his course, cuz its already the best and that we would support him!! This is my third session with you, I'm already so overwhelmed by how amazing excel is, excited to learn much more about it. Thank you!!
These videos will make history may be these are on slower side in terms of views and traction but mark my words people who are genuinely interested will visit again and again just to learn and clear their concept, please keep up the good work as these videos will act as a pioneer in the field of financial modeling and valuation
God bless you brother
Timestamps
00:01 - Learn Excel functions to simplify financial models
02:05 - Importance of maintaining consistency and simplifying complex financial models
06:24 - Selecting and managing names for conventions in Excel for financial modeling.
10:16 - Simplify financial modeling by breaking down calculations
15:17 - Understanding the impact of issuing debentures on coupon rate based on debt equity ratio.
18:46 - Using VLOOKUP function in Excel for data lookup
24:33 - Understanding the necessary sales growth to achieve a specific profit target.
26:40 - Understanding the impact of changing margins on sales and profit analysis
31:56 - Formatting and color-coding can help improve visibility and understanding of financial models.
34:14 - Analyzing impact of sales growth on gross margin through scenario analysis
42:10 - Explaining financial modeling concepts in Excel.
44:50 - Understanding Data Validation in Excel
51:44 - Protecting Excel sheets for data security
54:00 - Importance of data security and formula protection
This video covers advanced excel topics such as;
Name Manager from series 5:20
Data Table and Scenario Analysis 39:00
Circle Invalid data in data validation at 49:35
Protect sheet and calculated cells 53:00
The Protect Sheet explanation was really important. Most of the FM workshops don't teach this. Honestly this is explicit content. Thank you so much.
i love it when you invoke the IF and VLOOKUP formulae. It actually helps understand the formula better. In college, I had literally rote learnt adding 2 to the column index input. It worked because of the model but the logic was flawed. Thank you so much!
Thank you for this session sir.
This session not only opened the doors to learning Financial Modelling for me but also gave me a new perspective on using Excel. This session has made me realise how much my excel skills were lacking.
Hey just a excel tip @ 20:43 instead of using vlookup , excel has a function specifically designed for these type of problems , the function is lookup , =lookup( Lookup value , lookupvector, result vector) Lookup value is the value u want to look for , in this it is 25% , lookvector is nothing but from where u want to lookit up from that is the De ratio table , and the result vector is wt u want as a result , in this case it is the coupon rate table
Tq so much sir for these amazing lectures really soooo helpful
Best thing about sir; firstly he will be telling that; I am not going to make you understood the basic stuff then also describes each and every stuff from the very basics. thanks a lot sir.
Awesome and simplified. I have done a course on Financial Analyst, but I rarely remember anything from that. And these videos will stay for lifetime in my head. Very nicely explained with simplified examples. Thank you so much Sir for these videos. Turned on All the Notifications from the channel, only and only this channel.
I am ACCA qualified and 10 years of experience but in your modelling series I am learning lot of new things thank you.
I could not perform the data table & Scenario Analysis exercise using Alt, A, W, and T. The amounts were not coming the way they are coming in the video. I tried doing this exercise 5 times but still was not able to perform it. then I got the answer. Just letting my fellow viewers know that we have turned the settings to "Automatic except for data tables" in Formula settings, hence we have to press the F9 key for calculating the table. Hope this helps!!
Sir, you are doing a great job 😍
how do we need to use f9
same thing is happening with me
@@ektabhatt13watch the first video and change your settings, then you don't need to use F9
Thank you so so much Manav! Really helped
This helped. Even I was stuck here
Thanks a lot.
I just want to really thank you from the bottom of my heart^^You giving so much value for free...But I think you're doing it for free because it gives you, emotionally a feeling that money cannot buy.Bless your heart.
Sir, You're truly great. I have been seeing your videos since past 3 days and there's not a single thing which have gone above my head reason? you simplify everything and breakdown to understand it in easier way. I will call you god of Valuations. :)
Can’t thank you enough for all your videos. You are a gem of a teacher. Blessed to have found you.
I was thinking I m pro in excel but after watching the last 2 videos I realized that how rookie I am thank you very much sir.
Beyond patience content, buddy is in the zone where this seems an art to him but for others it is like a hardwork.
these lessons are gems. No one talks finance simpler than you
Can’t thank you enough for all your videos. You are a gem of a teacher. Blessed to have found you here in the right juncture of my life.
Amazing videos... Thank you for your efforts.. also request everyone to share these videos to your connections... really disheartening to see that the number of comments and likes are very much low for such an amazing content.. where stupid ticktock or Insta people get famous doing nothing good for the society.. this channel deserves much appreciation that its getting now
Amazing 🤩🤩🤩🤩🤩
This is not only Financial model but FM + Excel training, so much of efforts to teach us the very useful excel functionalities..
A very big Thank You ❤
Thank you, sir, for the incredible sessions! 🙌
I want to express my heartfelt appreciation for the exceptional teaching style you bring to every session. Your expertise and passion shine through, making the learning experience truly enjoyable. Despite already being familiar with the subject matter, I find myself captivated by your approach and gaining valuable insights with each session.
Your dedication to teaching and your ability to deliver information smoothly have undoubtedly elevated my understanding of the topic. Learning from you has been a remarkable journey, and I am grateful for the knowledge you have shared.
I am honored to have your support and guidance throughout this learning process. Your encouragement and expertise have made a significant impact on my educational journey, and I can't thank you enough for that.
Once again, thank you so much for your unwavering support and for making each session an enriching experience. Your commitment to excellence is truly inspiring, and I look forward to continuing this remarkable learning journey with you.
So, much grateful and thankful to you Parth sir, can't even express how much valuable and quality content you are catering to students god bless you 👏
Pehle video like kar deta hu, kyuki pata hai video toh achha hi hona hai, 2nd lecture me 6 ghante lagaya par pura samajh ke liye, really found a gem
Love the way he uses sarcasm...Teacher ho to aese ho...Finance ka rencho...👏
Fantastic work.... for borders .. like for all border Alt, h, b, A for bottom Alt,h,b o for top Alt,h,b,p and so on
using youtube since 10 years, but commenting for second time. THE BEST❤
Trust me I have learnt all this functions but never thought that these functions will be used in this way and to be honest these functions used by you is more easy to learn.Thank you sir for this one.
Glad it was helpful!
Whattttt is thisssss? I mean , you are really creating wonders. Thankyou so much for this playlist.
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.
55 mins of complete knowledge 🔥
Shortcut for borders-
Instead of using ctrl+1, we can use the following as well-
a. alt h b r/l- right/ left border
b. alt h b p/o- top and bottom border
alt h b will activate the border shortcut, and there are other border formulas (eg. oustide borders, bottom double, thick outside borders etc.) as well which we can use
SIR AAP KITNA ACHHE SE SAMJAATE HO LITTERALY....!!!!😇💛💫
Thanks Sir Parth, Day 2: Session 3 done; Today session was quite advance level but you explained really well but need to revise it tomorrow before moving it to Session 4. Stay Blessed. :)
Sir , your next sandip masheswasri... u r doing it this without any selling purpose ... man god blessed u
Great sir, this is pure gold..wanted to learn financial modelling since a long time...but unable to do so...but this time no excuses.
Thank you so much for your effort.
All the best
I m feeling that I'm learning.. This cource in heaven .. Thankyou so much sir.. For making our life even more easier..
sir you spend all night to teach us and we will also spend all night to learn it.
🎉 parth sir bahut achi class thi... I got everything ... thank you sir for this 😊😊😊😊God always bless you 🙏🙏🙏🙏
If anyone has problem related to data table calculation where all values are coming as 9570, you need to press F9 after the data table output. This happens because in workbook calculation setting we set as "Automatic except for data tables", so we need to manually calculate it by pressing F9.
Nahi hora vhai merato 2010 mein vhi chalayatha laga isme nahi huwato 2016 me dekha phir vhi nahi huwa 😭😭sab try karliya help me
@@DOBUDOBU-wi1bx next year sales and cost of sales ko calculate karte time do not use name manager.
thankyou so much 🤗
excuse me, but can you guys help regarding first exercise? (Defining Names) On how to calculate the Cost of Goods sold, and Gross Profit, also about the instructions that say we need to highlight cells K23:L25, and name them? I know that we have to define names, but mereko smjh nhi a rha kaise karu.
Please help.🙏
A goldmine for finance enthusiasts
Best content available for financial modelling! I am glad I found this.
Thanks Sir Boss Guru Maharaaaaaaaaj, GOD Bless you, really enjoying the lectures. Recently started following your channel and these video are full of knowledge and clarity. I hope to continue watching these videos completely.
Thank you sir for providing the financial modeling playlist for free.. In this tutorial you taught very well. & it is my request that please make playlist on Fixed Income Securities certification exam preparation for NISM.. Thank you once again for excellent teaching :)
Very well explained all the formulas with at most simplicity. Sir blessed you as a mentor / teacher which teach students with full of passion and enthusiasm!!
17:09
Hey " if " function Best!!!! thank you sir
Thank you so much sir🥺
We need teachers like you.
Very insightful and detailed to the basic fundamentals before moving ahead to the ultimate aspects of the topic speaks of your experience in the field. Genuine appreciation towards teaching with a noble intention of free but quality learning. Loved your explanation member. Highly recommended.
Thank you so much for such valuable session 👏👍
Best session out of the world 🎉🎉❤❤
Soch raha video editing hi seekh leta hu, kam se kam kisi kaam hi aa jaunga 🙄🙄🙄
Just feeling very great full, You are teaching really good stuff, Big Fan
Lovely session ❤
I have been confused as to how to lear financial modelling, bought expensive course however couldn't complete it. Didn't like the way of teaching. This one is free and fun. Hope to complete this one.
you're a blessing for so many ambitious students
God bless you Sir 🙏
Speechless..Hats off to you sir...😇
Completed all the exercises!!
great great great 👍👍👍
Boss u are taking an excellent initiative, I mean even those who give some knowledge don't share such deep things which u have shared in this video.
Time stamp 4:59
While calculating WACC , you have used C12 instead of C13 for multiplying value of debt to total capital
Although the WACC is correct because both equity value and debt value is same 👍
You are doing a pretty good job, i am learning a lot from your videos
Thanks for the help ❤️
Really helpful sessions Sir. You are an inspiration for me really !
Great excel function video for modeling. Thank you!
I'm new here and I really love it the way you teach us sir you r excellent💯
Very few can match the level of your teaching
Your integrity in your work is already seen
Wud be leaving our contacts
Any time you have a right to ask Guru Dakshina ~ Hak se maang lijiye sir .
May god bless you with good health rest you will achieve your goal for sure
Great work Sir, I like your style when you said jin ko pata hy vlookup ap agy barh ja e a 18:52 🤣
Thank you very very very much sir 🙏 , excellent teacher i have ever seen
Excellent stuff. Respect from Pakistan.
Best teacher
it's just a mindbloing session
Mind blowing session
I love it - thank you so much!!. Much valuable content providing to us for free..
How to get certificate of financial modelling after watching all the videos of sir
Thanku so much bro the content you have provided is pure class
Hi sir I completed my MBA in Finance but didn't get any job, so I started learning data analysis based on market demand. But after seeing you I started learning FM through your videos. But I have fear about my future due to changing goals. Please suggest to me whether I have made the right decision or not please.
Same thought 😅
wow absolutely awesome brother
You are simply amazing.. Please make more videos on Core finance concepts and current finance topics & launch your own course !
you are remarkable thanks for sharing useful knowledge
Thank you so much sir! You have been of great help.
Thank you ❤ Parth Bhai for making this video
Best training sessions.
Thanks a lot sir . These videos are really helpful
really enjoyed this session sir !!! God bless you
Next Year Sales- 15950
Cost of Sales- 6380
Gross Profit- 9570
Hi Brother, I can't understand how to calculate the next year sales, cost of sales and gross profit as well? Neither I could understand what the instructions meant by highlighting cells from K23:L25.
Please help out🙏
Love u sir..I am an ACCA from BD
You are great sir🙏❤
thanks for this amazing video,it helps a lot...
Loved the session Sir. Thanks alot❤
Thankyou sir for all the valuable efforts of yours
Sir I watched 3 videos - practiced a lot - confident enough.
Even a 5 year old kid also can follow the steps - very detailed yet so simple.
Sir, I am a student of Mathematics - had no financial background. My intention was to learn economics,& finance in order to invest in stocks.
Then I realised that big investors also do financial modelling to get a better gestimation of companies' future.
I started watching videos, reading Investopedia and all of a sudden I got YOU. ( I had problem with Excel as well 😊)
You changed my thinking.
In 3rd video I didn't really understand COST OF CAPITAL, ERP, DEDT FUNDING etc. Sir, can I learn those ? Please, reply me sir and will it be possible for you make a series of for us who are literally, illiterate in finance?
I am a teacher in Mathematics - but, now I want to be like you ( just a dresm sir - I know the complexity).
Please do something so thqt guys like me also can be a part of your financial TH-cam journey.
I love you sir
Sir, please reply
You need to learn financial management subject, you can find it in yt (refer CA material for better understanding)
@@samarth_hs I want to learn it to analyse stocks... please guide me if you can
If you want to learn analysing, you need basic understanding of financial statements and then try to learn financial management and other advanced stuff later
Thank you so much sir😇
Sir, thank you so much for sharing this insightful video with us
thank you sir😇
Sir it's amazing lectures sir
Bt please sir basics theory, , knowledge k liye kese prepare kare please guide us....
Thank you so much sir for your efforts, much obliged!
Most welcome! Keep Learning!
Thank you so much buddy. Love from pune. ❤
Thank you so much sir God bless you 🙏
struggling with the language ,wish it was delivered fully in english....good course like this should have been in a common language for international students too..anyways thanks soo much sir
bhai thanks, naukri bacha li aapne
Hahaha, Keep learning!
38:00 minutes, is it also called sansivity analysis?