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.
I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in UA-cam ever. I never comment in UA-cam; but, today I could not resist myself. Thanks for this video.
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 .
Asset yogi channel se woh सीखने को मिलता हैं जो MBA Finance me bhi सीखने को नहीं मिला. या ये कह सकते हैं ke lecturer ने explain ऐसे नहीं किया जो इस चैनल pe explain होता है.... Thanks a lot Sir....
@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
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 :)
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).
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 --
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
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 are an absolute genius in terms of expaining. JUST WOWWW!!!!!!. Able to understand each and every concept very easily.
Glad to hear that :)
I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in UA-cam ever. I never comment in UA-cam; 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...
Ap ka channel bht pasand hien humien buhat kuch sekhtay hien ap sien,shukarya sir
I am Adil sheikh kashmiri from Kashmir and I appreciate your work in finance I really need it.... 💕 U bro
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 .
Thank you sir ..i am ca student and it really helped me and i keep watching your videos of you...very useful ..
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....
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 :)
Sir very nicely introduced to NPV. Hope to learn lot from your video in future
The video was too good. Appreciate your effort. Please keep up the good work.
best video on npv, very well explained, very helpful, thanks
Thanks 😊
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
Thanks for explaining NPV & IRR. love from Pakistan
Glad to hear that Tahir :)
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.
Thank You kind Sir
Sir aap bhot acha smjhte h ek bar m hi smjh aajata thnq sir
Thanks for appreciation :)
@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
Excellent video Mukul ji 👍👍
Thanks Navin :)
Explained really well. Thanks for sharing!
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
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
Awsome Sir..
It was hard getting from the book. But quiet easy from your tutorial 👌👌
Sir apki vedios bhut understandable hoti h ...Plz ap pay back period ke advantages aur short coming pr vedios bna dijiye
Very nicely explained ...school me koi aise parhata to kitna achha hota
Beautifully explaned🎉
Thanks for you I am very happy because I have confusion its topic so you have discuss the continue about financial management
Concept has been very nicely explained..
Explicitly defined. An awesome briefing.
Thanks 😊
@@AssetYogi Amazing explanation!
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!!!
Thanks a lot by heartly ❤️❤️❤️👍👍👍🙏🙏🙏
Most welcome 😊
Very Nicely explained... Thanks ☺️👍🏻
I hope this will be useful Raseek
Thank you kya samjaya hai aapne majaaa aagayaaa ❤❤❤❤
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
Very nice explaination!!Helpful!
Keep learning :)
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
Superb sir.... Well done.... Good job👌👍👏
Thank you for appreciation 😊
Bahut bahut thanks sir apka hinde me batane ke liye
You have got another subscriber :).. thankyou for well explanation of topic..
Great explanation, great initiative. Keep it up.
Thank you so much 😊
Sir your explanation is really nice
Keep watching
Thanks for the video. Sir it's too informative. Although their is mistake in formula used by you. But, it's ok. I understand❤
Acha samjhaya guruji...🙏
Dhanywaad :)
very nice video sir..what a way to make things understand..
Mast sarji khup sopya bhashet sangitlat
Ur videos contents are very helpful for my credit officer exam. Thanks sir
R u a CA?
Thank you very much.
Really simple and clear videos
Great sir it is very useful for me
Very nice video sir and clearly understandable.
Glad to hear that Rahul 🙂
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
Sir your teaching way is very nice
please make a video on estimate project cost. Thanks
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 --
Thank you Sir for your valuable input.
Welcome Nirmala.
Very nice, appreciate the way you explain..
Thank you so much for appreciation.
Thanku sir for explaining NPV in excel sheet...
Thank you for appreciation.
Sir,i like your teaching very much
Thank you 😊
Sir, Excellent Lecture...
Thanks 😊
Stupendous, video sir.👍
I hope this will be useful
Really explained well
Thanku sir
Keep learning
Superb valuable information 😍
Hope it helps :)
Beautiful video. thank you
Nicely explained!
Thanks Manisha
Very good explanation. Thanks.
Plz make video on terminal value
Very well explained
Keep watching
Thanks for the video
Can please make a video on
How make KPI in the company
Sir, make video on property plant and equipment. Thank you.
Please make vedio on adjust present value..!!
Very clear concept
I think like this we can calculate NPV of a stock investment through it's free cash flow/share.
Thank you so much sir 😊😊
Most welcome Ashpreet.
Thanks sir for this wonderful video. Can u make a video on yes bank revival.
Excellent sir, but is there any formula also for NPV.
Sir please upload a video on terminal value
Very informative videos! But likes by people are less.. Let's encourage people doing good work..
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.
Thank You so much for this video
Keep learning 😊
experienced accountant if changed a company need to develop in which aspects- please make a video please
Noted your topic suggestion Ramesh
Sir ji, financial analyst and consultant k upar ek complete practical video banayiye. Hume bahot help hogi ek achi job k liye please
Sir very nice information. Please make a video on dcf and wacc soon.
VERY NICE VIDEO
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
Bhut jayda Acha lga
Dhanyawad 😊
Explain what is cap rate or Appraisal rate in real estate investment terms
Well Explained. Thank You
It means IRR and discount rate is same..kindly clarify sir..
sirji good video...thanks..but isi me agar tax aata hai...uska treatment kese n kya hoga?
Thanks, Sir!!
The future cash flows predicted are Net Profits or Operating Profits?
Hello..thanks for wonderful videos..can you explain how to calculate the value of the share and find out whether it is undervalued or overvalued
Bahut aachachha sir
Thanks 😊
Sir agar interest rate 15% means 12% sa jayada hai to ya -ve Npv kyu de rha hai
Thanks Sir.sir please make a vedio regarding advantage and disadvantages of Pay back period ,NPV,ROI,AND IRR
IN easy language
Nice ! Quality content