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/...
-----------------------------------------------------------------------------------
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.co...
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/

[@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 .

[@paravej]

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

[@satishsingh141]

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

[@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

[@KINSHUKJAIN-yh3mw]

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

[@AssetYogi]

Thanks 😊

[@abdullahyousafzai3293]

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

[@sushmachaudhary9115]

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

[@AssetYogi]

Thanks for appreciation :)

[@MohsinKhan-ub3xt]

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

[@jaikishansingh7187]

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

[@poojarao3092]

Great sir it is very useful for me

[@kitabokasahar]

Thanks a lot by heartly ❤️❤️❤️👍👍👍🙏🙏🙏

[@AssetYogi]

Most welcome 😊

[@vr1rvnot]

Concept has been very nicely explained..

[@jaychakpro]

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.

[@rahulagrawal5908]

Very nice video sir and clearly understandable.

[@AssetYogi]

Glad to hear that Rahul 🙂

[@mohammadmeet2793]

Thanks for the video Can please make a video on How make KPI in the company

[@mahipriya2039]

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

[@AssetYogi]

Thank you very much.

[@awinashkhemka123]

Very clear concept

[@gilitato697]

Thanks, Sir!!

[@KrushangDesai-qu2ou]

Very informative videos! But likes by people are less.. Let's encourage people doing good work..

[@tauhidsarker3673]

Sir, Excellent Lecture...

[@AssetYogi]

Thanks 😊

[@ranitroy339]

Sir ye cash flows in every year kaise calculate karte hai?

[@bishwajeetpandey1570]

Compund intrest ka reverse hain , discount kar raha hai har sal ka cash inflows ko

[@kirankumari-kk4gi]

Please make vedio on adjust present value..!!

[@funwithsuyog]

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

[@UsamaTheGreat]

The future cash flows predicted are Net Profits or Operating Profits?

[@sumitverma8762]

Bhut jayda Acha lga

[@AssetYogi]

Dhanyawad 😊

[@kisankadam6481]

Pharmacy releted business ideas batao sir please Expand kese Kare Konsa business profitable hogs....

[@ramesh123499]

experienced accountant if changed a company need to develop in which aspects- please make a video please

[@AssetYogi]

Noted your topic suggestion Ramesh

[@abidsaleem1711]

Excellent sir, but is there any formula also for NPV.

[@nikhilchanshetti849]

you are god sir

[@AssetYogi]

Thanks Nikhil 😊

[@VivekSingh-fy7iw]

It means IRR and discount rate is same..kindly clarify sir..

[@ManishaSingh-gn8tq]

Nicely explained!

[@AssetYogi]

Thanks Manisha

[@akshitabarbigahiya2057]

Excellent

[@AssetYogi]

Thanks Akshita

[@kashishagarwal5132]

Thank You so much for this video

[@AssetYogi]

Keep learning 😊

[@sheikhberyal3290]

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

[@sahana7694]

Thank u sir 😊🙏

[@AssetYogi]

Keep learning 😊

[@anshikasharma3947]

Stupendous, video sir.👍

[@AssetYogi]

I hope this will be useful

[@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!!!

[@ooo652]

Dcf ke upar video banaiye

[@vasco9089]

Cost benefit analysis

[@richadoshi2390]

can you please explain the rationale behind this -ve value though it had higher expected return. Couldnt Understand the logic.

[@jajusriram]

Is NPV & DCF is one and the same? if not what is the difference between DCF & NPV? please explain Sir.

[@vernainterior]

Sir, bonus share produce kayse hota hai , share to 100%pahele se hi David hota hai

[@sachinsaraswat8841]

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

[@AssetYogi]

Keep supporting :)

[@sanjaykanojia8783]

Thanks sir

[@ravico0]

I think your Excel formula used should be revisit

[@AssetYogi]

Noted

[@ujjalroy1442]

Thku so mch sir

[@AssetYogi]

Hope it's helpful 😊

[@DrSuman-nr3yb]

please suggest reference book , from where u take this formula

[@khushboomehta4571]

Business economics ...fyb.com sem 2

[@durgeshtiwari678]

Use investopedia

[@niravbhagat5885]

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

[@vivekkhobragade817]

थँक्स

[@AssetYogi]

Keep learning

[@avengersassemble3482]

Sir agar interest rate 15% means 12% sa jayada hai to ya -ve Npv kyu de rha hai

[@ShabnamKhan-bc9xr]

Sir foir pr bhi video banao

[@entertainmentandlearning8368]

Great

[@AssetYogi]

Thanks Musa 😊

[@rajeshkumarupadhyay4688]

Sir, I've one question which is I don't understand can you help me

[@Arun_Verma_Official]

Very good

[@AssetYogi]

Hope this is useful

[@sakatpura]

thank u

[@funwithsuyog]

Sir please Explain about PAT(performance Achieve and Trade)

[@shataakshisrivastava9545]

Thank you so much Sir.

[@citygrowth7267]

How 6237 Please Explain it

[@skmgamer8214]

Mtlb IRR is just the reverse of NPV or vice versa, right?

[@AssetYogi]

No. IRR gives annual returns on an investment and NPV gives lumpsum value of an investment in today's value

[@GamingworldbyAKT]

Sir please scientific calculator se bh calculate kr k dikhaye q k hmain apna time bachana hai

[@sgavit411]

Sir plz make video on Annual statements rate, before 5 August 2018 sir , becz we have exam on that date ,plz sir upload videos as soon as possible ...

[@kritagyarajpoot3279]

interesting video

[@AssetYogi]

Thank you 😊

[@chbilal9720]

Hi Sir,I hope you are at good health.Your program are very informative. One of question I am unable to solve it. Can you help me out.The operating costs of your machine have been steadily increasing and you would like to replace it this year. You estimate that the efficiency of the new machine will bring savings of €8,500 per year. If the life of the boiler is 12 years, and your cost of capital is 9.2%, how much should you be willing to pay? Up to €60,000 Up to €102,000 Up to €35,000 Not enough information is provided to answer

[@sushilthakur4883]

Hi Yogi Jee , could you please explain sensitivity analysis...?? , it will be great help for me. Thanks Sushil.

[@AhmadRaza-gp1hx]

Sir Kindly Give a Concept of NFV(Net Future Value)

[@ankitarani3759]

Hey ... why didn't u add 1 as per the formula

[@rishavsharma8301]

discounted cash flow model

[@pravingaikwad6040]

I have your video just now but i not understand your answer become

[@sandipbhatt1092]

Sir agar 0 aye to

[@manojrana2816]

Hi

[@आदर्शवर्मा-द5छ]

Sir main Lesliganj Block (Jharkhand) main rhta hun mujhe apne purwaj ki Jamin ka Batwara karwna hai Kya Process hai

[@abhishekmishra7239]

Supppppppppppppp video

[@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

[@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

[@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

[@nitesh9110]

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

[@99drtahir]

Thanks for explaining NPV & IRR. love from Pakistan

[@AssetYogi]

Glad to hear that Tahir :)

[@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

[@hiraabdullah6383]

excel pe apne 1000000 jo value hai wo minus m nh li is lye ans change aya hai

[@adeelqureshi9339]

Thanks Sir

[@AssetYogi]

I hope this will be useful

[@anandbhatt3117]

I just want to say, Love you bro. :D Tussi Great ho..!! You know what, this is my first comment in KZbin ever. I never comment in KZbin; 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

[@mehakjaat8937]

Sir best method kon sa h plizz reply fast

[@rafaysaifi2635]

Sir please upload a video on terminal value

[@tejasbhute3732]

Plz make video on terminal value

[@beboysub]

Thank You kind Sir

[@chhavisoni1994]

Sir 1.12 kaise aaya

[@gauravmohan9271]

Thank you bhai..

[@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

[@TheGargiesharma]

sir top down and bottom up anlysys ko smjhaiye , iske alava RRR BHI BATAIYE

[@AssetYogi]

Stay tuned in master investor series: kzbin.info/aero/PLSiDKpku4U_Wvz5h6sGLRVnXjx42zqqGb

[@deathinventor]

Good

[@AssetYogi]

Thanks

[@priyabratas]

VERY NICE VIDEO

[@sidhantpathak463]

Waste

[@amanverma5909]

Nice topic

[@plabanbhattacharjee8129]

Sir your explanation is really nice

[@AssetYogi]

Keep watching

[@NavdeepKour-gs7do]

🙏🏾🙏🏾🙏🏾

[@parasmani8943]

PJ

[@subhashisroy3069]

How come you are getting positive values as green and negetive values as red? Please reply 😃

[@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.

[@tufelansari884]

👍👍👍👍

[@ashpreetkaur8038]

Thank you so much sir 😊😊

[@AssetYogi]

Most welcome Ashpreet.