Cash flows ki ek series ko aaj ke paise mein discount karein aur net present value, saal-dar-saal table, IRR, payback aur NPV profile dekhein — aapke device par calculate hota hai.
NPV Calculator
Cash flows ki ek series ko aaj ke paise mein discount karein aur net present value, saal-dar-saal table, IRR, payback aur NPV profile dekhein — aapke device par calculate hota hai.
NPV Calculator poori tarah aapke browser mein chalta hai. Jo discount rates aur cash flows aap dalte hain woh aapke device par rehte hain aur kabhi upload nahi hote.
Net present value ek sawaal ka jawab deta hai: har aane wale cash flow ko aapke zaroori rate of return par discount karne ke baad, kya project ki keemat uski laagat se zyada hai? Initial investment, ek discount rate aur har period ka cash flow dein — saalana, timahi ya maasik, period ke ant ya shuru mein aate hue, optional terminal value ke saath. Calculator accept ya reject reading ke saath NPV dikhata hai, discount factors aur cumulative present value wali discounted cash-flow table, aur saath mein IRR, MIRR, payback, discounted payback aur profitability index. 365-din ke XNPV ke liye dated mode par jaayein, do projects ko side by side compare karein, ya NPV profile padhein ki project kahan kamaana band karta hai. Har figure aapke browser mein compute hota hai; jo numbers aap type karte hain woh kabhi upload nahi hote.
Features
Saaf accept, reject ya break-even reading aur lagaye gaye exact discount ke saath NPV
Discounted cash-flow table: har period ka cash flow, discount factor, present value aur cumulative PV
Saalana, timahi ya maasik periods, har period ke ant ya shuru mein aate cash ke saath
Dated mode jo asli dates ko 365-din ke saal par discount karta hai, jaise Excel ka XNPV
Ek hi cash flows se IRR, MIRR, payback, discounted payback aur profitability index
Doosre project ko test karne ke liye Compare on karein, ya result dohraane ke liye Excel formula copy karein
Example
Input
Discount rate: 10 %
Initial investment: 1,000
Cash flows (end of year 1-3): 300, 400, 500
Output
NPV: -21.04 (reject)
PV of the flows: 272.73 + 330.58 + 375.66 = 978.96
IRR: 8.90 % Profitability index: 0.979
Payback: 2.60 years Discounted payback: not recovered
Excel: =NPV(0.1,300,400,500)-1000
Project lagbhag 8.9 % deta hai, jo 10 % hurdle se kam hai, isliye uska NPV negative hai.
Common errors aur troubleshooting
Mera Excel NPV is result se zyada hai. — Excel ka NPV function pehli value ko poore ek period se discount karta hai. Initial investment ko function ke bahar rakhein aur baad mein jodein, jaise =NPV(rate, flows)+initial, use range mein shaamil karne ke bajaye.
IRR undefined dikhta hai. — IRR ko kam se kam ek outflow aur ek inflow chahiye. Agar har flow ka sign ek jaisa ho to koi rate NPV ko zero nahi bana sakta, isliye NPV aur payback figures use karein.
Maasik periods par jaate hi result bahut badal jaata hai. — Discount rate saalana hai, isliye maasik rate ke liye use 12 se baanta (ya compound karke ghataya) jaata hai. Pakka karein ki cash flows sach mein maasik amounts hain, aur zaroori ho to Advanced ke neeche conversion method chunein.
Ek dated row reject ho jaati hai. — Har date start date par ya uske baad ka asli calendar din honi chahiye. Dated mode start date ko time zero maanta hai, bilkul waise jaise XNPV apni pehli date ko maanta hai.
Aksar pooche jaane wale sawaal
NPV Calculator har cash flow ko kaise discount karta hai?
Har flow ko 1 bhaag (1 + r) ke us ghaat se guna kiya jaata hai jitne periods mein woh aata hai, phir saari present values ko initial outlay ke saath jod diya jaata hai. 10 % par do saal baad ka 400 ka flow aaj 400 / 1.21 = 330.58 ka hai.
Mere project ke liye negative NPV ka kya matlab hai?
Iska matlab hai ki aapke chune discount rate par cash flows aaj investment se kam keemat ke hain, isliye project aapke zaroori return se kam kamaata hai. Positive NPV us rate se zyada kamaata hai, aur zero ke paas NPV lagbhag usi rate jitna kamaata hai.
Kya main poore periods ke bajaye asli dates se NPV calculate kar sakta hoon?
Haan. Dated mode par jaayein, initial investment ke liye start date set karein, aur har cash flow ko uski apni date dein. Flows ko asli dino ko 365 se baant kar discount kiya jaata hai, jo Excel ke XNPV se mel khata hai.
Projects mein se chunne ke liye NPV ki jagah IRR kab use karna chahiye?
Jab projects size ya timing mein alag hon ya flows ka sign ek se zyada baar badle tab NPV use karein, kyunki IRR unhe galat rank kar sakta hai ya kai jawab de sakta hai. Compare mode aur NPV profile dikhate hain ki dono measures kahan asahmat hote hain.
End-of-period aur start-of-period cash flows mein kya fark hai?
End-of-period flows samay 1, 2, 3 aur aage par aate hain, aam annuity ki tarah. Start-of-period flows samay 0, 1, 2 par aate hain, annuity due ki tarah, isliye har ek ek period kam discount hota hai aur NPV zyada hota hai.
NPV calculation mein terminal value ko kaise maana jaata hai?
Terminal value ek akela extra cash flow hai, jaise resale value ya chalte operations ki keemat, jo aakhri period ke ant par rakha jaata hai aur kisi bhi doosre flow ki tarah discount hota hai. Agar project bas khatam ho jaata hai to ise khaali chhod dein.