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)”.

[@AssetYogi]

Sign-up to our new app for discounts and early access:
✔ assetyogi.com/sign-up/

[@nitesh9110]

I understand concept.I don't care of mistake.. I am nothing to appreciate u so I thank u sir as usually.

[@shilpabhat1409]

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.

[@ramkrishnaduttaroy4051]

Very clear . Good learning , Even IIM prof are not able to explain like this to general background student ,

[@arunkumar4u]

Professor sirf padhane ke liye hai... practical learning toh yahi se milegi

[@abhishekbhagat4710]

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.

[@SuryaPrakash-rv2yd]

Thank you sir ..i am ca student and it really helped me and i keep watching your videos of you...very useful ..

[@vinodagarwal9307]

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 .

[@fenserenewableenergy7628]

The video was too good. Appreciate your effort. Please keep up the good work.

[@satishsingh141]

Sir very nicely introduced to NPV. Hope to learn lot from your video in future

[@jiwanbhattarai1933]

You are an absolute genius in terms of expaining. JUST WOWWW!!!!!!. Able to understand each and every concept very easily.

[@AssetYogi]

Glad to hear that :)

[@abdullahyousafzai3293]

Ap ka channel bht pasand hien humien buhat kuch sekhtay hien ap sien,shukarya sir

[@adilsheikh1245]

I am Adil sheikh kashmiri from Kashmir and I appreciate your work in finance I really need it.... 💕 U bro

[@pavank67]

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.

[@ashutoshsahoo647]

Awsome Sir..
It was hard getting from the book. But quiet easy from your tutorial 👌👌

[@MohsinKhan-ub3xt]

Thanks for you I am very happy because I have confusion its topic so you have discuss the continue about financial management

[@pratika9811]

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]

Keep learning Pratik

[@sheikhberyal3290]

You have got another subscriber :).. thankyou for well explanation of topic..

[@rishuarora789]

Well explained sir g

[@vr1rvnot]

Concept has been very nicely explained..

[@navinbkk]

Excellent video Mukul ji 👍👍

[@AssetYogi]

Thanks Navin :)

[@shiwangijoshi2258]

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]

Thanks for appreciation Shiwangi :)

[@sujoyshil5674]

Well Explained. Thank You

[@LS-ex9tm]

Very good explanation. Thanks.

[@arvindkumar-xr6ok]

very nice video sir..what a way to make things understand..

[@khushboobano2108]

Sir apki vedios bhut understandable hoti h ...Plz ap pay back period ke advantages aur short coming pr vedios bna dijiye

[@Kesharwaniautomobile]

Thank you kya samjaya hai aapne majaaa aagayaaa ❤❤❤❤

[@iamsajalchakraborty]

Beautiful video. thank you

[@anandbhatt3117]

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.

[@AssetYogi]

Thanks for your support Anand :)

[@subhashisroy3069]

How the values are red and green? I am using excel 2007 but the values are black

[@KINSHUKJAIN-yh3mw]

best video on npv, very well explained, very helpful, thanks

[@AssetYogi]

Thanks 😊

[@marialazar5724]

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]

Pakistan ke bhi aise channel btao jinse hmein knowledge mile

[@marialazar5724]

@@shobhitsharma2137 I do wish to make a Channel, but have least knowledge in this regard...

[@gaindians100]

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]

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]

Absolutely right brother. Sir has made the mistake

[@anish123kumar]

Very nice, appreciate the way you explain..

[@AssetYogi]

Thank you so much for appreciation.

[@HiteshBhatia8786]

Really simple and clear videos

[@vikramsingh-kr3pn]

Great explanation, great initiative. Keep it up.

[@AssetYogi]

Thank you so much 😊

[@99drtahir]

Thanks for explaining NPV & IRR. love from Pakistan

[@AssetYogi]

Glad to hear that Tahir :)

[@awinashkhemka123]

Very clear concept

[@paryantshah1141]

Nice ! Quality content

[@paravej]

Asset yogi channel se woh सीखने को मिलता हैं जो MBA Finance me bhi सीखने को नहीं मिला. या ये कह सकते हैं ke lecturer ने explain ऐसे नहीं किया जो इस चैनल pe explain होता है....
Thanks a lot Sir....

[@sheerazghanisiddiqui777]

Explicitly defined. An awesome briefing.

[@AssetYogi]

Thanks 😊

[@samridhijain019]

@@AssetYogi Amazing explanation!

[@anand120556]

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

[@jaikishansingh7187]

Very nicely explained ...school me koi aise parhata to kitna achha hota

[@shataakshisrivastava9545]

Thank you so much Sir.

[@poojarao3092]

Great sir it is very useful for me

[@errupinderjindal3141]

@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

[@raje5360]

Mast sarji khup sopya bhashet sangitlat

[@rajagwadar5106]

you are best teacher, yau have good teaching ability.

[@AssetYogi]

Thank you for appreciation 😊

[@subhashisroy3069]

Do you know how the values are red and green? I am not getting that

[@plabanbhattacharjee8129]

Sir your explanation is really nice

[@AssetYogi]

Keep watching

[@nainarastogi2831]

Thanku sir for explaining NPV in excel sheet...

[@AssetYogi]

Thank you for appreciation.

[@priyankamourya9974]

nicely explained

[@RahulMehlawat2001]

Sir, your videos are very well explained!!!

[@AssetYogi]

Keep watching

[@umairkhalid7119]

goood work sir appriciate

[@sushmachaudhary9115]

Sir aap bhot acha smjhte h ek bar m hi smjh aajata thnq sir

[@AssetYogi]

Thanks for appreciation :)

[@jyotiprakash9774]

Acha samjhaya guruji...🙏

[@AssetYogi]

Dhanywaad :)

[@H.RAJ123]

Thanks for the video. Sir it's too informative. Although their is mistake in formula used by you. But, it's ok. I understand❤

[@rockybhagat]

Very Nicely explained... Thanks ☺️👍🏻

[@AssetYogi]

I hope this will be useful Raseek

[@amanverma5909]

Nice topic

[@Vijaysharma-po8vv]

Sir your teaching way is very nice
please make a video on estimate project cost. Thanks

[@nirmalasharma3475]

Thank you Sir for your valuable input.

[@AssetYogi]

Welcome Nirmala.

[@kisankadam6481]

Superb valuable information 😍

[@AssetYogi]

Hope it helps :)

[@AvadhootDandekar]

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]

i'm confused

[@jisnaponnu5499]

U r ri8 its 6237.05

[@AsadUllah-my2td]

Sir Y0 ko add ya minus mery khyal minus karna hai

[@SkyStudy72]

Right Y0 minus hoga

[@enchinamaraya]

correct!!!

[@akshaykala8674]

Very nice explaination!!Helpful!

[@AssetYogi]

Keep learning :)

[@anshikasharma3947]

Stupendous, video sir.👍

[@AssetYogi]

I hope this will be useful

[@PriyaRani-kb1fb]

Superb sir.... Well done.... Good job👌👍👏

[@AssetYogi]

Thank you for appreciation 😊

[@Gdscechelon]

nice explaination

[@gauravmohan9271]

Thank you bhai..

[@tauhidsarker3673]

Sir, Excellent Lecture...

[@AssetYogi]

Thanks 😊

[@gilitato697]

Thanks, Sir!!

[@ashishpal343]

Nicely explained

[@AssetYogi]

Thank you 😊

[@amanverma5909]

Bahut bahut thanks sir apka hinde me batane ke liye

[@priyabratas]

VERY NICE VIDEO

[@anshuvats5701]

Nice video sir

[@rahulagrawal5908]

Very nice video sir and clearly understandable.

[@AssetYogi]

Glad to hear that Rahul 🙂

[@ruchigupta6520]

Very nicely explained.

[@AssetYogi]

Thank you Ruchi 😊

[@ravindrathorat2627]

Sir,i like your teaching very much

[@AssetYogi]

Thank you 😊

[@jitendragorasiya6391]

nice explantion keep it up .

[@AssetYogi]

Thank you so much 😊

[@rkajalsingh3608]

Wow you are great sir thank you

[@AssetYogi]

Glad to know, hope it helps. 😊

[@ilajain1821]

Really explained well
Thanku sir

[@AssetYogi]

Keep learning

[@beboysub]

Thank You kind Sir

[@SANJAYKUMAR-sz1xz]

Very important information

[@AssetYogi]

Thank you for appreciation.

[@ManishaSingh-gn8tq]

Nicely explained!

[@AssetYogi]

Thanks Manisha

[@savlikanekar]

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

[@nikhilsharma2850]

Nice explanation

[@AssetYogi]

Thanks Nikhil

[@kashishagarwal5132]

Thank You so much for this video

[@AssetYogi]

Keep learning 😊

[@sandhyaverma9433]

Bahut aachachha sir

[@AssetYogi]

Thanks 😊

[@akshitabarbigahiya2057]

Excellent

[@AssetYogi]

Thanks Akshita

[@PujaKumari-zi9yg]

Great sir

[@AssetYogi]

I hope this will be useful :)

[@funwithsuyog]

Well explain sir

[@AssetYogi]

Hope it helps you Suyog

[@ragsclickin]

Very good explanation. One question- Why are you including year Zero? Shouldn’t we start from Yr 1 onwards? NPV= (Rate, Y1:Y5)+ Y0??

[@Channel-yi8ui]

0 year means at beginning of year. 1 yr means at completion of one yr from investment

[@vinitagarg5641]

Nice explaination sir

[@AssetYogi]

Thank you Vinita :)

[@hnnath7302]

Thanks a lot.

[@AssetYogi]

Most welcome!

[@bistrajendra1]

is the WACC always taken as the discount rate when calculating PV? OR is it that WACC and discount rate can be different?

[@sachinsaraswat8841]

thanks .........it is a greatvideo

[@AssetYogi]

Keep supporting :)

[@tejasbhute3732]

Plz make video on terminal value

[@sumitverma8762]

Bhut jayda Acha lga

[@AssetYogi]

Dhanyawad 😊

[@Arun_Verma_Official]

Very good

[@AssetYogi]

Hope this is useful

[@mahipriya2039]

Ur videos contents are very helpful for my credit officer exam. Thanks sir
R u a CA?

[@AssetYogi]

Thank you very much.

[@niravbhagat5885]

Sir very nice information. Please make a video on dcf and wacc soon.

[@funwithsuyog]

Thanks Sir.sir please make a vedio regarding advantage and disadvantages of Pay back period ,NPV,ROI,AND IRR
IN easy language

[@deepakkumaryadav9381]

Good sir👍👍👍

[@AssetYogi]

Thank you 😊

[@lear2grow468]

Thanks sir for this wonderful video. Can u make a video on yes bank revival.