Thank you Mukul Sir for such videos. I am totally dependent on your video for my studies. Your explanation is very easy to follow and apply. It's a blessing for me to come across your videos. Thank you so much.
Asset yogi channel se woh सीखने को मिलता हैं जो MBA Finance me bhi सीखने को नहीं मिला. या ये कह सकते हैं ke lecturer ने explain ऐसे नहीं किया जो इस चैनल pe explain होता है.... Thanks a lot Sir....
Hi Mukul - Thanks for explaining NPV in a very simple and professional way . In your above example pl let me know what will happen if there is another investor after two years and puts money of rs 2 lakhs then how we can calculate NPV .
I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in RUclips ever. I never comment in RUclips; but, today I could not resist myself. Thanks for this video.
@assest yogi Thanku for such a great information....need a little bit correction in your formula...NPV 6237 is correct value..in formula u have selected wrong cells... correct formula is =NPV(0.12,D6:H6)+C6= 6237 = As we calculated manually.i have learnt after watching all your videos.once again thanku sir.u are gem 💎.
So simply explained!!. I fully understood NPV. Sir, Please Explain DCF(Discount cash flow) technique of valuation in Hindi. Kindly do the needful. Thank you sir.
Hi, the formula in excel should be "Year 0 Value (i.e. -10,00,000) + NPV(12%, Cashflow of Year1 to Year5)" which will give 6237, which was derived manually also. Both figures will match only when the investment amount in year 0 is kept out of NPV formula in excel..
I also came to comment same as i was practicing on laptop with video on. I also stumbled upon this for 2 hours than seen another video of other channel than found this video has mistake
Please talk on 'cash flow statement' elements importantance tried to find videos but none of are that good -- your hindi is too good so requesting to talk on it --
Thanks. But you have included the initial investment also into NPV formula. In fact NPV is different values discounted values. It should be -1000000+npv(roi, range).
Hi Mukul, all fine but in excel you are taking the NPV sum of all, which is not correct. You should take the NPV of Y1 to Y5 and then add to the initial outflow to get the NPV. It comes to Rs. 6,237.05. It should be = NPV(12%, Y1..Y5)+Y0. Nice explanation, however. Thanks :)
A firm needs component in an assembly operation. If it wants to do the manufacturing itself, it would need to buy a machine for Rs. 400,000 which will last for 4years with no salvage value. Manufacturing costs in each of the 4 years would be Rs. 600,000, Rs. 700,000, Rs. 800,000, and Rs. 1 million respectively. If the firm had to buy the components from a supplier, the cost would be Rs. 0.9 million, Rs. 1 million, Rs. 1.1 million and Rs. 1.4 million respectively in each of the four years. However, the machine would occupy floor space which would have been used for another machine. This latter machine would be hired at no cost to manufacture an item, the sale of which would produce net cashflows in each of the four years of Rs. 0.2 million. It is impossible to find room for both the machines and there are no other external effects. The cost of capital is 10% and the present value factor for each of the four years is 0.909, 0.826, 0.751 and 0.683 respectively. Should the firm make the components or buy from outside? What will be the solution?
Sir Facing difficulties in calculating Cash flow 2/3/4 and 5 year time line in excell. Please let me know how to calculate one inflow by using power in excell. Thanks
Sign-up to our new app for discounts and early access:
✔ assetyogi.com/sign-up/
I understand concept.I don't care of mistake.. I am nothing to appreciate u so I thank u sir as usually.
Very clear . Good learning , Even IIM prof are not able to explain like this to general background student ,
Professor sirf padhane ke liye hai... practical learning toh yahi se milegi
I am Adil sheikh kashmiri from Kashmir and I appreciate your work in finance I really need it.... 💕 U bro
You are an absolute genius in terms of expaining. JUST WOWWW!!!!!!. Able to understand each and every concept very easily.
Glad to hear that :)
Thank you Mukul Sir for such videos. I am totally dependent on your video for my studies. Your explanation is very easy to follow and apply. It's a blessing for me to come across your videos. Thank you so much.
You have so nicely explained the concept of Net Present Value ( NPV). Thank you very much.
Asset yogi channel se woh सीखने को मिलता हैं जो MBA Finance me bhi सीखने को नहीं मिला. या ये कह सकते हैं ke lecturer ने explain ऐसे नहीं किया जो इस चैनल pe explain होता है....
Thanks a lot Sir....
Hi Mukul - Thanks for explaining NPV in a very simple and professional way . In your above example pl let me know what will happen if there is another investor after two years and puts money of rs 2 lakhs then how we can calculate NPV .
way of teaching is awesome sir, ur videos is very 2 usefull for all finance aspirants.... clear my all doubts related to npv,,,
thanku so much sir...
Thanks for appreciation Shiwangi :)
Ap ka channel bht pasand hien humien buhat kuch sekhtay hien ap sien,shukarya sir
Very well explained in simple and lucid language...thank you soo much sir.. please never stop making such valuable videos
and enlighten us all🙏🙏🤗
Keep learning Pratik
Thank you sir ..i am ca student and it really helped me and i keep watching your videos of you...very useful ..
I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in RUclips ever. I never comment in RUclips; but, today I could not resist myself. Thanks for this video.
Thanks for your support Anand :)
How the values are red and green? I am using excel 2007 but the values are black
good evening sir.... this is maria from Pakistan... i appreciate your all videos.... u r doing enormously fantastic work, keep it up! God bless you
Pakistan ke bhi aise channel btao jinse hmein knowledge mile
@@shobhitsharma2137 I do wish to make a Channel, but have least knowledge in this regard...
@assest yogi Thanku for such a great information....need a little bit correction in your formula...NPV 6237 is correct value..in formula u have selected wrong cells... correct formula is =NPV(0.12,D6:H6)+C6= 6237 = As we calculated manually.i have learnt after watching all your videos.once again thanku sir.u are gem 💎.
Thanks a lot
Sir very nicely introduced to NPV. Hope to learn lot from your video in future
best video on npv, very well explained, very helpful, thanks
Thanks 😊
Sir aap bhot acha smjhte h ek bar m hi smjh aajata thnq sir
Thanks for appreciation :)
Thanx for this video sir after following only it is tough to understand but after watching this video now I am able to understand NPV.
Very nicely explained ...school me koi aise parhata to kitna achha hota
Thanks for the video. Sir it's too informative. Although their is mistake in formula used by you. But, it's ok. I understand❤
Explained really well. Thanks for sharing!
Sir apki vedios bhut understandable hoti h ...Plz ap pay back period ke advantages aur short coming pr vedios bna dijiye
Excellent video Mukul ji 👍👍
Thanks Navin :)
Thank you kya samjaya hai aapne majaaa aagayaaa ❤❤❤❤
Thanks for you I am very happy because I have confusion its topic so you have discuss the continue about financial management
The video was too good. Appreciate your effort. Please keep up the good work.
So simply explained!!. I fully understood NPV. Sir, Please Explain DCF(Discount cash flow) technique of valuation in Hindi. Kindly do the needful. Thank you sir.
Sir, your videos are very well explained!!!
Keep watching
Awsome Sir..
It was hard getting from the book. But quiet easy from your tutorial 👌👌
Thanks for explaining NPV & IRR. love from Pakistan
Glad to hear that Tahir :)
Sir your explanation is really nice
Keep watching
Beautifully explaned🎉
Hi, the formula in excel should be "Year 0 Value (i.e. -10,00,000) + NPV(12%, Cashflow of Year1 to Year5)" which will give 6237, which was derived manually also. Both figures will match only when the investment amount in year 0 is kept out of NPV formula in excel..
I was consfused in the way sir calculated it. Thank you for the correction :)
@AssetYogi please mention this correction in the video or as a pinned comment - people might get confused otherwise.
I also came to comment same as i was practicing on laptop with video on. I also stumbled upon this for 2 hours than seen another video of other channel than found this video has mistake
Absolutely right brother. Sir has made the mistake
Ur videos contents are very helpful for my credit officer exam. Thanks sir
R u a CA?
Thank you very much.
Very Nicely explained... Thanks ☺️👍🏻
I hope this will be useful Raseek
Thanks a lot by heartly ❤️❤️❤️👍👍👍🙏🙏🙏
Most welcome 😊
Concept has been very nicely explained..
Please talk on 'cash flow statement' elements importantance tried to find videos but none of are that good -- your hindi is too good so requesting to talk on it --
Thanks. But you have included the initial investment also into NPV formula. In fact NPV is different values discounted values. It should be -1000000+npv(roi, range).
Correct
Acha samjhaya guruji...🙏
Dhanywaad :)
you are best teacher, yau have good teaching ability.
Thank you for appreciation 😊
Do you know how the values are red and green? I am not getting that
Explicitly defined. An awesome briefing.
Thanks 😊
@@AssetYogi Amazing explanation!
Sir your teaching way is very nice
please make a video on estimate project cost. Thanks
very nice video sir..what a way to make things understand..
Mast sarji khup sopya bhashet sangitlat
Very nice video sir and clearly understandable.
Glad to hear that Rahul 🙂
Thank You kind Sir
Really simple and clear videos
Superb sir.... Well done.... Good job👌👍👏
Thank you for appreciation 😊
Thank you Sir for your valuable input.
Welcome Nirmala.
Very nice explaination!!Helpful!
Keep learning :)
Bahut bahut thanks sir apka hinde me batane ke liye
Sir,i like your teaching very much
Thank you 😊
Thanku sir for explaining NPV in excel sheet...
Thank you for appreciation.
Great sir it is very useful for me
Hi Mukul, all fine but in excel you are taking the NPV sum of all, which is not correct. You should take the NPV of Y1 to Y5 and then add to the initial outflow to get the NPV. It comes to Rs. 6,237.05. It should be = NPV(12%, Y1..Y5)+Y0. Nice explanation, however. Thanks :)
i'm confused
U r ri8 its 6237.05
Sir Y0 ko add ya minus mery khyal minus karna hai
Right Y0 minus hoga
correct!!!
I think like this we can calculate NPV of a stock investment through it's free cash flow/share.
Sir, Excellent Lecture...
Thanks 😊
Beautiful video. thank you
Thank you so much sir 😊😊
Most welcome Ashpreet.
You have got another subscriber :).. thankyou for well explanation of topic..
Great explanation, great initiative. Keep it up.
Thank you so much 😊
Plz make video on terminal value
Very good explanation. One question- Why are you including year Zero? Shouldn’t we start from Yr 1 onwards? NPV= (Rate, Y1:Y5)+ Y0??
0 year means at beginning of year. 1 yr means at completion of one yr from investment
Really explained well
Thanku sir
Keep learning
Thanks for the video
Can please make a video on
How make KPI in the company
Very clear concept
Very well explained
Keep watching
Sir ji, financial analyst and consultant k upar ek complete practical video banayiye. Hume bahot help hogi ek achi job k liye please
Sir, make video on property plant and equipment. Thank you.
Very informative videos! But likes by people are less.. Let's encourage people doing good work..
Please make vedio on adjust present value..!!
Very nice, appreciate the way you explain..
Thank you so much for appreciation.
Thanks sir for this wonderful video. Can u make a video on yes bank revival.
Sir please upload a video on terminal value
Nicely explained!
Thanks Manisha
Stupendous, video sir.👍
I hope this will be useful
Very good explanation. Thanks.
Superb valuable information 😍
Hope it helps :)
Thanks, Sir!!
experienced accountant if changed a company need to develop in which aspects- please make a video please
Noted your topic suggestion Ramesh
A firm needs component in an assembly operation. If it wants to do the manufacturing itself, it would need to buy a machine for Rs. 400,000 which will last for 4years with no salvage value. Manufacturing costs in each of the 4 years would be Rs. 600,000, Rs. 700,000, Rs. 800,000, and Rs. 1 million respectively. If the firm had to buy the components from a supplier, the cost would be Rs. 0.9 million, Rs. 1 million, Rs. 1.1 million and Rs. 1.4 million respectively in each of the four years. However, the machine would occupy floor space which would have been used for another machine. This latter machine would be hired at no cost to manufacture an item, the sale of which would produce net cashflows in each of the four years of Rs. 0.2 million. It is impossible to find room for both the machines and there are no other external effects. The cost of capital is 10% and the present value factor for each of the four years is 0.909, 0.826, 0.751 and 0.683 respectively.
Should the firm make the components or buy from outside?
What will be the solution?
Thank You so much for this video
Keep learning 😊
Excellent sir, but is there any formula also for NPV.
Thank u sir 😊🙏
Keep learning 😊
VERY NICE VIDEO
In your excel sheet you have shown, will it not be as - (minus) 10 lakh as net cash flow as it was the invested money.
Thanks Sir.sir please make a vedio regarding advantage and disadvantages of Pay back period ,NPV,ROI,AND IRR
IN easy language
Bahut aachachha sir
Thanks 😊
Bhut jayda Acha lga
Dhanyawad 😊
you are god sir
Thanks Nikhil 😊
Nice topic
Sir very nice information. Please make a video on dcf and wacc soon.
Great sir
I hope this will be useful :)
thanks .........it is a greatvideo
Keep supporting :)
Sir
Facing difficulties in calculating
Cash flow 2/3/4 and 5 year time line in excell.
Please let me know how to calculate one inflow by using power in excell. Thanks
nice explaination
How to calculate net cash flows of a company .please make a video.Thanks