NPV (Net Present Value) - Explained in Hindi
Тәжірибелік нұсқаулар және стиль
Net Present Value or NPV concept & calculation method in Excel explained in Hindi. NPV is an important valuation metric to evaluate a project, business, franchise or an investment opportunity. Sign-up to our new app for discounts and early access: ✔ assetyogi.com/sign-up/
-----------------------------------------------------------------------------------
It is also used in Discounted Cash Flow method to value a company. It is used along with IRR (Internal Rate of Return) to evaluate an investment.
Net Present Value is based on the concept of Time Value of Money where we calculate the present value of future cash flows (future value).
Related Videos:
Internal Rate of Return (IRR) - • IRR (Internal Rate of ...
Time Value of Money - • Time Value of Money - ...
Present Value - • Present Value - Explai...
Present Value of an Annuity - • Present Value of an An...
एक्सेल में नेट प्रेजेंट वैल्यू या एनपीवी का कांसेप्ट और कैलकुलेशन मेथड इस वीडियो में हिंदी में समझिये। एनपीवी किसी प्रोजेक्ट, बुज़ीनेस, फ्रेंचाइज़ी या इन्वेस्टमेंट ओपोर्च्युनिटी की वैल्यूएशन करने के लिए एक महत्वपूर्ण वैल्यूएशन मीट्रिक है। इसे किसी कंपनी की वैल्यूएशन के लिए डिस्काउंटेड कैश फ्लो मेथड में भी उपयोग किया जाता है। किसी इन्वेस्टमेंट का वैल्यूएशन करने के लिए इसका उपयोग आईआरआर (Internal Rate of Return) के साथ किया जाता है।
नेट प्रेजेंट वैल्यू टाइम वैल्यू ऑफ़ मनी के कांसेप्ट पर आधारित है जहां हम फ्यूचर कॅश फ्लो (फ्यूचर वैल्यू) के प्रेजेंट वैल्यू की गणना करते हैं।
Share this Video:
• NPV (Net Present Value...
Subscribe To Our Channel and Get More Property and Real Estate Tips:
/ @assetyogi
If you want to become an Expert Real Estate investor, please visit our website assetyogi.com now and Subscribe to our newsletter.
In this video, we have explained:
What is net present value?
What is the purpose of net present value?
Why net present value calculation is used?
How to calculate net present value?
What is the calculation formula for net present value?
What is the method of NPV calculation?
How to evaluate a project, business, franchise or an investment opportunity with net present value method?
What is discounted cash flow method?
What is DCF and IRR (Internal Rate of Return) and how they are used?
What is terminal cash flow?
How net present value is calculated for a project, business or franchise?
How net present valuation method is used to evaluate an investment opportunity?
What is discount rate?
How to evaluate the value of a company?
What is the valuation method for projects, business, company, franchise and investment opportunity?
How to calculate net present value in a Microsoft Excel sheet or Google spreadsheet?
How to evaluate the net present value of any investment?
Make sure to Like and Share this video.
Other Great Resources
AssetYogi - assetyogi.com/
Follow Us:
Instagram - / assetyogi
Twitter - / assetyogi
Linkedin - / asset-yogi
Facebook - / assetyogi
Pinterest - / assetyogi
Google Plus - plus.google.com/+assetyogi-ay
Hope you liked this video in Hindi on “Net Present Value (NPV)”.
Пікірлер: 356
Sign-up to our new app for discounts and early access: ✔ assetyogi.com/sign-up/
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 understand concept.I don't care of mistake.. I am nothing to appreciate u so I thank u sir as usually.
Thank you sir ..i am ca student and it really helped me and i keep watching your videos of you...very useful ..
The video was too good. Appreciate your effort. Please keep up the good work.
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.
Sir very nicely introduced to NPV. Hope to learn lot from your video in future
Awsome Sir.. It was hard getting from the book. But quiet easy from your tutorial 👌👌
You have got another subscriber :).. thankyou for well explanation of topic..
Well explained sir g
Ap ka channel bht pasand hien humien buhat kuch sekhtay hien ap sien,shukarya sir
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.
Well Explained. Thank You
Concept has been very nicely explained..
Very good explanation. Thanks.
Very clear . Good learning , Even IIM prof are not able to explain like this to general background student ,
@arunkumar4u
11 ай бұрын
Professor sirf padhane ke liye hai... practical learning toh yahi se milegi
Thanks for you I am very happy because I have confusion its topic so you have discuss the continue about financial management
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 .
very nice video sir..what a way to make things understand..
Thank you kya samjaya hai aapne majaaa aagayaaa ❤❤❤❤
Really simple and clear videos
You are an absolute genius in terms of expaining. JUST WOWWW!!!!!!. Able to understand each and every concept very easily.
@AssetYogi
3 жыл бұрын
Glad to hear that :)
Sir apki vedios bhut understandable hoti h ...Plz ap pay back period ke advantages aur short coming pr vedios bna dijiye
Beautiful video. thank you
Nice ! Quality content
Very nice, appreciate the way you explain..
@AssetYogi
6 жыл бұрын
Thank you so much for appreciation.
I am Adil sheikh kashmiri from Kashmir and I appreciate your work in finance I really need it.... 💕 U bro
Thank you so much Sir.
Great explanation, great initiative. Keep it up.
@AssetYogi
6 жыл бұрын
Thank you so much 😊
Very clear concept
Very well explained in simple and lucid language...thank you soo much sir.. please never stop making such valuable videos and enlighten us all🙏🙏🤗
@AssetYogi
3 жыл бұрын
Keep learning Pratik
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..
@VampPalash
4 жыл бұрын
I was consfused in the way sir calculated it. Thank you for the correction :)
@ashishsonone5614
Жыл бұрын
@AssetYogi please mention this correction in the video or as a pinned comment - people might get confused otherwise.
@herrytech1644
Жыл бұрын
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
@vev1989
10 ай бұрын
Absolutely right brother. Sir has made the mistake
is the WACC always taken as the discount rate when calculating PV? OR is it that WACC and discount rate can be different?
Great sir it is very useful for me
Mast sarji khup sopya bhashet sangitlat
Asset yogi channel se woh सीखने को मिलता हैं जो MBA Finance me bhi सीखने को नहीं मिला. या ये कह सकते हैं ke lecturer ने explain ऐसे नहीं किया जो इस चैनल pe explain होता है.... Thanks a lot Sir....
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 :)
@marialazar5724
5 жыл бұрын
i'm confused
@jisnaponnu5499
5 жыл бұрын
U r ri8 its 6237.05
@AsadUllah-my2td
5 жыл бұрын
Sir Y0 ko add ya minus mery khyal minus karna hai
@SkyStudy72
4 жыл бұрын
Right Y0 minus hoga
@enchinamaraya
4 жыл бұрын
correct!!!
Very nicely explained ...school me koi aise parhata to kitna achha hota
Thanks, Sir!!
Thanku sir for explaining NPV in excel sheet...
@AssetYogi
5 жыл бұрын
Thank you for appreciation.
Bahut bahut thanks sir apka hinde me batane ke liye
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...
@AssetYogi
4 жыл бұрын
Thanks for appreciation Shiwangi :)
Thank you bhai..
nicely explained
Sir your teaching way is very nice please make a video on estimate project cost. Thanks
Explicitly defined. An awesome briefing.
@AssetYogi
3 жыл бұрын
Thanks 😊
@samridhijain019
3 жыл бұрын
@@AssetYogi Amazing explanation!
best video on npv, very well explained, very helpful, thanks
@AssetYogi
3 жыл бұрын
Thanks 😊
Excellent video Mukul ji 👍👍
@AssetYogi
2 жыл бұрын
Thanks Navin :)
goood work sir appriciate
Very Nicely explained... Thanks ☺️👍🏻
@AssetYogi
4 жыл бұрын
I hope this will be useful Raseek
Very nice explaination!!Helpful!
@AssetYogi
4 жыл бұрын
Keep learning :)
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
Nice topic
Thank you Sir for your valuable input.
@AssetYogi
2 жыл бұрын
Welcome Nirmala.
Stupendous, video sir.👍
@AssetYogi
4 жыл бұрын
I hope this will be useful
The future cash flows predicted are Net Profits or Operating Profits?
Superb valuable information 😍
@AssetYogi
5 жыл бұрын
Hope it helps :)
Thanks for explaining NPV & IRR. love from Pakistan
@AssetYogi
5 жыл бұрын
Glad to hear that Tahir :)
Sir, your videos are very well explained!!!
@AssetYogi
3 жыл бұрын
Keep watching
Sir i would like to know salvage value adjustment in terminal value cashflow
Thank You kind Sir
Acha samjhaya guruji...🙏
@AssetYogi
4 жыл бұрын
Dhanywaad :)
nice explaination
Superb sir.... Well done.... Good job👌👍👏
@AssetYogi
5 жыл бұрын
Thank you for appreciation 😊
VERY NICE VIDEO
Please make a Video on "Other Comprehensive Income"
Nice video sir
sir i got project work on golden quadrilateral- cost ratio benefit. can you help me ?
Sir, Excellent Lecture...
@AssetYogi
4 жыл бұрын
Thanks 😊
Wow you are great sir thank you
@AssetYogi
6 жыл бұрын
Glad to know, hope it helps. 😊
Thanks for the video. Sir it's too informative. Although their is mistake in formula used by you. But, it's ok. I understand❤
Nicely explained
@AssetYogi
6 жыл бұрын
Thank you 😊
Sir your explanation is really nice
@AssetYogi
2 жыл бұрын
Keep watching
Sir aap bhot acha smjhte h ek bar m hi smjh aajata thnq sir
@AssetYogi
4 жыл бұрын
Thanks for appreciation :)
Sir very nice information. Please make a video on dcf and wacc soon.
you are best teacher, yau have good teaching ability.
@AssetYogi
5 жыл бұрын
Thank you for appreciation 😊
@subhashisroy3069
3 жыл бұрын
Do you know how the values are red and green? I am not getting that
Sir,i like your teaching very much
@AssetYogi
5 жыл бұрын
Thank you 😊
I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in KZread ever. I never comment in KZread; but, today I could not resist myself. Thanks for this video.
@AssetYogi
4 жыл бұрын
Thanks for your support Anand :)
@subhashisroy3069
3 жыл бұрын
How the values are red and green? I am using excel 2007 but the values are black
Really explained well Thanku sir
@AssetYogi
4 жыл бұрын
Keep learning
Very nice video sir and clearly understandable.
@AssetYogi
3 жыл бұрын
Glad to hear that Rahul 🙂
Very nicely explained.
@AssetYogi
5 жыл бұрын
Thank you Ruchi 😊
nice explantion keep it up .
@AssetYogi
6 жыл бұрын
Thank you so much 😊
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).
@bishwajeetpandey1570
Жыл бұрын
Correct
Does net present value is related to mutual funds? Like uneven SIP we make and the returns calculated are similar to future value by taking in account net present value??
Sir please Explain about PAT(performance Achieve and Trade)
Thank You so much for this video
@AssetYogi
3 жыл бұрын
Keep learning 😊
Thanks sir for this wonderful video. Can u make a video on yes bank revival.
Thanks for the video Can please make a video on How make KPI in the company
Very important information
@AssetYogi
5 жыл бұрын
Thank you for appreciation.
Thanks Sir.sir please make a vedio regarding advantage and disadvantages of Pay back period ,NPV,ROI,AND IRR IN easy language
How to calculate net cash flows of a company .please make a video.Thanks
Bahut aachachha sir
@AssetYogi
3 жыл бұрын
Thanks 😊
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
@shobhitsharma2137
3 жыл бұрын
Pakistan ke bhi aise channel btao jinse hmein knowledge mile
@marialazar5724
3 жыл бұрын
@@shobhitsharma2137 I do wish to make a Channel, but have least knowledge in this regard...
Nicely explained!
@AssetYogi
3 жыл бұрын
Thanks Manisha
Thanks sir
Plz make video on terminal value
Thanks a lot.
@AssetYogi
2 жыл бұрын
Most welcome!
hello sir very good evening , what is (APR) average price realization .
Nice explanation
@AssetYogi
Жыл бұрын
Thanks Nikhil
@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 💎.
@AssetYogi
Жыл бұрын
Thanks a lot