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

  • @AssetYogi
    @AssetYogi10 ай бұрын

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

  • @shilpabhat1409
    @shilpabhat14092 жыл бұрын

    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.

  • @nitesh9110
    @nitesh91104 жыл бұрын

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

  • @SuryaPrakash-rv2yd
    @SuryaPrakash-rv2yd5 жыл бұрын

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

  • @fenserenewableenergy7628
    @fenserenewableenergy76286 жыл бұрын

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

  • @abhishekbhagat4710
    @abhishekbhagat47104 жыл бұрын

    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.

  • @satishsingh141
    @satishsingh1415 жыл бұрын

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

  • @ashutoshsahoo647
    @ashutoshsahoo6475 жыл бұрын

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

  • @sheikhberyal3290
    @sheikhberyal32905 жыл бұрын

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

  • @rishuarora789
    @rishuarora7895 жыл бұрын

    Well explained sir g

  • @abdullahyousafzai3293
    @abdullahyousafzai32935 жыл бұрын

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

  • @pavank67
    @pavank675 жыл бұрын

    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.

  • @sujoyshil5674
    @sujoyshil56746 жыл бұрын

    Well Explained. Thank You

  • @vr1rvnot
    @vr1rvnot5 жыл бұрын

    Concept has been very nicely explained..

  • @LS-ex9tm
    @LS-ex9tm5 жыл бұрын

    Very good explanation. Thanks.

  • @ramkrishnaduttaroy4051
    @ramkrishnaduttaroy40513 жыл бұрын

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

  • @arunkumar4u

    @arunkumar4u

    11 ай бұрын

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

  • @MohsinKhan-ub3xt
    @MohsinKhan-ub3xt4 жыл бұрын

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

  • @vinodagarwal9307
    @vinodagarwal93074 жыл бұрын

    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 .

  • @arvindkumar-xr6ok
    @arvindkumar-xr6ok4 ай бұрын

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

  • @Kesharwaniautomobile
    @Kesharwaniautomobile5 ай бұрын

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

  • @HiteshBhatia8786
    @HiteshBhatia87865 жыл бұрын

    Really simple and clear videos

  • @jiwanbhattarai1933
    @jiwanbhattarai19333 жыл бұрын

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

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Glad to hear that :)

  • @khushboobano2108
    @khushboobano21084 жыл бұрын

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

  • @iamsajalchakraborty
    @iamsajalchakraborty4 ай бұрын

    Beautiful video. thank you

  • @paryantshah1141
    @paryantshah11415 жыл бұрын

    Nice ! Quality content

  • @anish123kumar
    @anish123kumar6 жыл бұрын

    Very nice, appreciate the way you explain..

  • @AssetYogi

    @AssetYogi

    6 жыл бұрын

    Thank you so much for appreciation.

  • @adilsheikh1245
    @adilsheikh12453 жыл бұрын

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

  • @shataakshisrivastava9545
    @shataakshisrivastava95456 жыл бұрын

    Thank you so much Sir.

  • @vikramsingh-kr3pn
    @vikramsingh-kr3pn6 жыл бұрын

    Great explanation, great initiative. Keep it up.

  • @AssetYogi

    @AssetYogi

    6 жыл бұрын

    Thank you so much 😊

  • @awinashkhemka123
    @awinashkhemka123 Жыл бұрын

    Very clear concept

  • @pratika9811
    @pratika98113 жыл бұрын

    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

    @AssetYogi

    3 жыл бұрын

    Keep learning Pratik

  • @gaindians100
    @gaindians1005 жыл бұрын

    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

    @VampPalash

    4 жыл бұрын

    I was consfused in the way sir calculated it. Thank you for the correction :)

  • @ashishsonone5614

    @ashishsonone5614

    Жыл бұрын

    @AssetYogi please mention this correction in the video or as a pinned comment - people might get confused otherwise.

  • @herrytech1644

    @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

    @vev1989

    10 ай бұрын

    Absolutely right brother. Sir has made the mistake

  • @bistrajendra1
    @bistrajendra14 жыл бұрын

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

  • @poojarao3092
    @poojarao30924 жыл бұрын

    Great sir it is very useful for me

  • @raje5360
    @raje53605 жыл бұрын

    Mast sarji khup sopya bhashet sangitlat

  • @paravej
    @paravej5 жыл бұрын

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

  • @AvadhootDandekar
    @AvadhootDandekar6 жыл бұрын

    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

    @marialazar5724

    5 жыл бұрын

    i'm confused

  • @jisnaponnu5499

    @jisnaponnu5499

    5 жыл бұрын

    U r ri8 its 6237.05

  • @AsadUllah-my2td

    @AsadUllah-my2td

    5 жыл бұрын

    Sir Y0 ko add ya minus mery khyal minus karna hai

  • @SkyStudy72

    @SkyStudy72

    4 жыл бұрын

    Right Y0 minus hoga

  • @enchinamaraya

    @enchinamaraya

    4 жыл бұрын

    correct!!!

  • @jaikishansingh7187
    @jaikishansingh71875 жыл бұрын

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

  • @gilitato697
    @gilitato6973 жыл бұрын

    Thanks, Sir!!

  • @nainarastogi2831
    @nainarastogi28315 жыл бұрын

    Thanku sir for explaining NPV in excel sheet...

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you for appreciation.

  • @amanverma5909
    @amanverma59094 жыл бұрын

    Bahut bahut thanks sir apka hinde me batane ke liye

  • @shiwangijoshi2258
    @shiwangijoshi22584 жыл бұрын

    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

    @AssetYogi

    4 жыл бұрын

    Thanks for appreciation Shiwangi :)

  • @gauravmohan9271
    @gauravmohan92712 жыл бұрын

    Thank you bhai..

  • @priyankamourya9974
    @priyankamourya99745 жыл бұрын

    nicely explained

  • @Vijaysharma-po8vv
    @Vijaysharma-po8vv6 жыл бұрын

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

  • @sheerazghanisiddiqui777
    @sheerazghanisiddiqui7773 жыл бұрын

    Explicitly defined. An awesome briefing.

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Thanks 😊

  • @samridhijain019

    @samridhijain019

    3 жыл бұрын

    @@AssetYogi Amazing explanation!

  • @KINSHUKJAIN-yh3mw
    @KINSHUKJAIN-yh3mw3 жыл бұрын

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

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Thanks 😊

  • @navinbkk
    @navinbkk2 жыл бұрын

    Excellent video Mukul ji 👍👍

  • @AssetYogi

    @AssetYogi

    2 жыл бұрын

    Thanks Navin :)

  • @umairkhalid7119
    @umairkhalid71193 жыл бұрын

    goood work sir appriciate

  • @rockybhagat
    @rockybhagat4 жыл бұрын

    Very Nicely explained... Thanks ☺️👍🏻

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    I hope this will be useful Raseek

  • @akshaykala8674
    @akshaykala86744 жыл бұрын

    Very nice explaination!!Helpful!

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    Keep learning :)

  • @savlikanekar
    @savlikanekar4 жыл бұрын

    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

  • @amanverma5909
    @amanverma59094 жыл бұрын

    Nice topic

  • @nirmalasharma3475
    @nirmalasharma34752 жыл бұрын

    Thank you Sir for your valuable input.

  • @AssetYogi

    @AssetYogi

    2 жыл бұрын

    Welcome Nirmala.

  • @anshikasharma3947
    @anshikasharma39474 жыл бұрын

    Stupendous, video sir.👍

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    I hope this will be useful

  • @UsamaTheGreat
    @UsamaTheGreat5 жыл бұрын

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

  • @kisankadam6481
    @kisankadam64815 жыл бұрын

    Superb valuable information 😍

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Hope it helps :)

  • @99drtahir
    @99drtahir5 жыл бұрын

    Thanks for explaining NPV & IRR. love from Pakistan

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Glad to hear that Tahir :)

  • @RahulMehlawat2001
    @RahulMehlawat20013 жыл бұрын

    Sir, your videos are very well explained!!!

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Keep watching

  • @jisnaponnu5499
    @jisnaponnu54995 жыл бұрын

    Sir i would like to know salvage value adjustment in terminal value cashflow

  • @beboysub
    @beboysub10 ай бұрын

    Thank You kind Sir

  • @jyotiprakash9774
    @jyotiprakash97744 жыл бұрын

    Acha samjhaya guruji...🙏

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    Dhanywaad :)

  • @Gdscechelon
    @Gdscechelon7 ай бұрын

    nice explaination

  • @PriyaRani-kb1fb
    @PriyaRani-kb1fb5 жыл бұрын

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

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you for appreciation 😊

  • @priyabratas
    @priyabratas5 жыл бұрын

    VERY NICE VIDEO

  • @kalyancoari8508
    @kalyancoari85084 жыл бұрын

    Please make a Video on "Other Comprehensive Income"

  • @anshuvats5701
    @anshuvats57015 жыл бұрын

    Nice video sir

  • @arunabhsingh2603
    @arunabhsingh26034 жыл бұрын

    sir i got project work on golden quadrilateral- cost ratio benefit. can you help me ?

  • @tauhidsarker3673
    @tauhidsarker36734 жыл бұрын

    Sir, Excellent Lecture...

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    Thanks 😊

  • @rkajalsingh3608
    @rkajalsingh36086 жыл бұрын

    Wow you are great sir thank you

  • @AssetYogi

    @AssetYogi

    6 жыл бұрын

    Glad to know, hope it helps. 😊

  • @H.RAJ123
    @H.RAJ1235 ай бұрын

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

  • @ashishpal343
    @ashishpal3436 жыл бұрын

    Nicely explained

  • @AssetYogi

    @AssetYogi

    6 жыл бұрын

    Thank you 😊

  • @plabanbhattacharjee8129
    @plabanbhattacharjee81292 жыл бұрын

    Sir your explanation is really nice

  • @AssetYogi

    @AssetYogi

    2 жыл бұрын

    Keep watching

  • @sushmachaudhary9115
    @sushmachaudhary91154 жыл бұрын

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

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    Thanks for appreciation :)

  • @niravbhagat5885
    @niravbhagat58855 жыл бұрын

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

  • @rajagwadar5106
    @rajagwadar51065 жыл бұрын

    you are best teacher, yau have good teaching ability.

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you for appreciation 😊

  • @subhashisroy3069

    @subhashisroy3069

    3 жыл бұрын

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

  • @ravindrathorat2627
    @ravindrathorat26275 жыл бұрын

    Sir,i like your teaching very much

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you 😊

  • @anandbhatt3117
    @anandbhatt31174 жыл бұрын

    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

    @AssetYogi

    4 жыл бұрын

    Thanks for your support Anand :)

  • @subhashisroy3069

    @subhashisroy3069

    3 жыл бұрын

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

  • @ilajain1821
    @ilajain18214 жыл бұрын

    Really explained well Thanku sir

  • @AssetYogi

    @AssetYogi

    4 жыл бұрын

    Keep learning

  • @rahulagrawal5908
    @rahulagrawal59083 жыл бұрын

    Very nice video sir and clearly understandable.

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Glad to hear that Rahul 🙂

  • @ruchigupta6520
    @ruchigupta65205 жыл бұрын

    Very nicely explained.

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you Ruchi 😊

  • @jitendragorasiya6391
    @jitendragorasiya63916 жыл бұрын

    nice explantion keep it up .

  • @AssetYogi

    @AssetYogi

    6 жыл бұрын

    Thank you so much 😊

  • @anand120556
    @anand1205565 жыл бұрын

    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

    @bishwajeetpandey1570

    Жыл бұрын

    Correct

  • @mukulnaharia8906
    @mukulnaharia89065 жыл бұрын

    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??

  • @funwithsuyog
    @funwithsuyog5 жыл бұрын

    Sir please Explain about PAT(performance Achieve and Trade)

  • @kashishagarwal5132
    @kashishagarwal51323 жыл бұрын

    Thank You so much for this video

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Keep learning 😊

  • @lear2grow468
    @lear2grow4683 жыл бұрын

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

  • @mohammadmeet2793
    @mohammadmeet27934 жыл бұрын

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

  • @SANJAYKUMAR-sz1xz
    @SANJAYKUMAR-sz1xz5 жыл бұрын

    Very important information

  • @AssetYogi

    @AssetYogi

    5 жыл бұрын

    Thank you for appreciation.

  • @funwithsuyog
    @funwithsuyog4 жыл бұрын

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

  • @vishushettar8877
    @vishushettar88775 жыл бұрын

    How to calculate net cash flows of a company .please make a video.Thanks

  • @sandhyaverma9433
    @sandhyaverma94333 жыл бұрын

    Bahut aachachha sir

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Thanks 😊

  • @marialazar5724
    @marialazar57245 жыл бұрын

    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

    @shobhitsharma2137

    3 жыл бұрын

    Pakistan ke bhi aise channel btao jinse hmein knowledge mile

  • @marialazar5724

    @marialazar5724

    3 жыл бұрын

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

  • @ManishaSingh-gn8tq
    @ManishaSingh-gn8tq3 жыл бұрын

    Nicely explained!

  • @AssetYogi

    @AssetYogi

    3 жыл бұрын

    Thanks Manisha

  • @sanjaykanojia8783
    @sanjaykanojia87834 ай бұрын

    Thanks sir

  • @tejasbhute3732
    @tejasbhute37324 жыл бұрын

    Plz make video on terminal value

  • @hnnath7302
    @hnnath73022 жыл бұрын

    Thanks a lot.

  • @AssetYogi

    @AssetYogi

    2 жыл бұрын

    Most welcome!

  • @sanjupandey2934
    @sanjupandey29344 жыл бұрын

    hello sir very good evening , what is (APR) average price realization .

  • @nikhilsharma2850
    @nikhilsharma2850 Жыл бұрын

    Nice explanation

  • @AssetYogi

    @AssetYogi

    Жыл бұрын

    Thanks Nikhil

  • @errupinderjindal3141
    @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

    @AssetYogi

    Жыл бұрын

    Thanks a lot

Келесі