How To Use PV, FV, RATE & NPER Formula in Excel - Excel Financial Functions

How To Use PV, FV, RATE & NPER Formula in Excel - Excel Financial Functions
Microsoft Excel me PV,FV,RATE,NPER financial formulas kab or kahan use kartey hain ye is video me maine detail me btaya hai. is se pahele video me maine bataya tha ki PMT, IPMT, PPMT and GOAL SEEK function excel me kaise use kartey hain aap neeche diye link pe click kar ke wo financial functions seekh saktey ho.
Excel Financial Functions - PMT, IPMT, PPMT & GOAL SEEK ( बारीकी से सीख लो )
• Excel Financial Functi...
pv function se hum kisi bhi loan ki present value ( principal amount ) nikalte hain. fv function se hum kisi investment ki future value nikalte hain. rate formula se hum loan par jo interest rate laga hua hai wo nikalte hain or nper formula se hum loan ka period nikalte hain. aasha hai ye video dekh ke aapke sare doubt clear ho jayenge.
in this video you will learn, how to use PV, FV, RATE & NPER function in Microsoft excel 2022 in hindi
Download Training File : bit.ly/3a0MmdX
My Channels :
A to Z Excel : bit.ly/3hQCRiw
Deepak Techworld : bit.ly/3qFrbl5
Deepak EduWorld :bit.ly/3zWWtIS
Deepak Nehra : bit.ly/364SVGV
00:00 Intro
00:29 PV Formula
07:02 FV Formula
09:35 RATE Formula
11:14 NPER Formula
#ExcelFormulas
#ExcelFinancialFunctions
#deepakeduworld
#Excel_online_course
Subscribe and Become Family Member of Deepak EduWorld ! Thanks For Watching Friends Have A Nice Day.
Deepak EduWorld Playlist's:
POWERPOINT COURSE ►
• MS Power Point Tutoria...
ADVANCED EXCEL ►
goo.gl/A6LdZA
ADVANCED EXCEL FORMULAS ►
goo.gl/bbHYu2
EXCEL TIPS & TRICKS ►
goo.gl/wAj1jh
MS WORD ►
goo.gl/B4TeSA
HTML5 & CSS3 ►
goo.gl/2PFgs8
COMPUTER TECHNICAL videos ►
goo.gl/paZmpn
AUTOMATIC INVOICE IN EXCEL ►
goo.gl/dFhg54
PHOTOSHOP ►
• How To Make Passport S...
Subscribe Deepak EduWorld ► / deepakeduworld
Instagram ► / deepakeduworld
Facebook page ► / deepakeduworld
LinkedIn ► / deepakeduworld
Facebook Group ► / deepakeduworld
financial functions in excel,excel financial functions,excel,formula,function,pv,present value,fv,future value,rate,nper,pmt,excel formula,excel formulas and functions,deepakeduworld,excel formula tutorial,excel formulas,2022,hindi

[@pinusahoo9243]

Thank u thank u thank u sir..maine cmptr class ke bad apke vdo dekhkar samjhti hun..hamare paas comptr ya laptop v nahi he..koi extra class karne ki sujog nahi he...me ese hi mobile me vdo dekhkar sikhti hun...nahi to mujhe thk se nahi ati he..again sia apko thank u..sabhi ko v thank u...aur jo v comptr ke vdo dalte hen...

[@monicachauhan8220]

Apka bahut bahut dhanyawad sir 🙏

[@sanjayparihar641]

You always Rocking sir Ji 🙏🏻🙏🏻🙏🏻🙏🏻

[@ghanisthsingh347]

Bhai itne video chhan mare ab ja k koi ye smjha pa rha h ki in formulae ko SIP calculation k liye kse use kr skta hu, mne ROI pta krne k liye video dekha vo kh rha h inflow likho phle to fir date likho, hadd h, ye best trika h bhai

[@HADI-UPDATE]

Whoever is watching my comment at this time, we are all unknown to each other, yet I pray to God that if there is any tension going on in your life, then it should go away. And may you always be happy.️

[@EnglishHub90]

Thanks for 🎉😊

[@rupeshmalik438]

Thanks

[@awadheshsrivastava5065]

Explained very easy & nice way.

[@paramrwt0795]

You helped me always by your video 😊

[@arunkumarsinghark3024]

🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤ 🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤

[@RohitSaccher]

बेहतरीन दीपक जी

[@azizullah775]

Great thanks

[@zaibkhan6834]

Great Masha Allah, Allah bless you

[@shivani-ur7pm]

thank you very much si you are great teacher 🎉

[@mhhasan2005]

Very useful sir with Thanks

[@shoaibmansuri810]

Sir thank you apne meri request mani sir thank you so much sir😘

[@Moizfoodi]

Great sir jee… love you

[@Its_Sushil_Official]

Just awesome 👍

[@rheapeter9709]

Thank you sir!!

[@thecodingboat9505]

9:08 rate jo hai yealy diya hua hai us ko monthly convert karne ki jarurat hai.

[@SajidKhan-wf1wr]

So nice explanation sir

[@madhusharma8557]

Very informative

[@MegaMindTech]

Good 👍 Thanks for sharing

[@Altaf_Alam]

Thank u sir 🔥

[@AyushiPal-hn1dn]

Tq sr 😊

[@SimarjeetSingh-zv8sc]

thank you sir

[@Kataria05]

Amazing 🤩 ... Got it all 👍

[@abodisom_official]

Nice video 👌👌👌

[@deepakkeshari1168]

You are powerful video

[@manishsingh7930]

Great sir 👏 👍

[@sayanidas8675]

Thank you sir😇

[@respect-bv4kj]

Thank you sir I am from Nepal ❣🇳🇵🇳🇵🇳🇵🇳🇵

[@rajnanera6955]

Thank you so much sir

[@MuhammadTanveer-9797]

Hello sir Please Explain how to make an Indian calendar thanks sir

[@user-un5uu6fv6j]

Sir ji aap bahut achcha se samjha thanks sir ji aap bahut achcha se samjhte hai ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤😂

[@ramkishoryadav9087]

kzbin.info/www/bejne/m2G3pHiJqL11oM0si=iG8fPaX-oQ7OJNaa

[@deepakkeshari1168]

I am proud of you

[@soumensamanta8966]

nice sir ❤

[@deepakkumardas4032]

Very nice sir

[@TVSCDN]

Thanks Deepak ji 🎉🎉🎉❤❤❤... Will this work in excel365 ver.??

[@aartijaatav8107]

Very nice

[@KARANKUMAR-lh5di]

Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz

[@Amiralig7983]

Hello sir have you also explained more financial formulas , because after this video I couldn't find more

[@Study-vishal]

700th like 👌👌👌👌👌

[@AyushiPal-hn1dn]

Excl ki starting s video dalye pls sbhi with formulas plz😊

[@historystudy1387]

Sir ap Sacha sa padath ho

[@himi1509]

Sir please complete the excel series Only 4 uploaded till now Thanks Sir

[@zaheerabass5419]

Sir ur videos are very helpful sir i hv a request to u plz make one video on e office as we see today after covid most of the works are done n through e office so plz make one video that how to send and make files online

[@RajivKumar-nr4dk]

Please make a video on MS publisher

[@shaikvalli1414]

Please share the calculation and formula. INR 100000 per year for 5 years and Returns at 10th years with IRR 8%

[@MukeshKumar-jq4vj]

Sir school management software Excel me banana

[@khustarnoorani4917]

Deepak bhai please assist me. Mere pass excel ka 3 work book hai lekin tino work book ka data ek hi column me lena hai vlookup ke jariye. Ya to fir ye samajh le ki ek hi column me do dafah vlookup use karna hai lekin first vlookup value jaise ke waise hi rahna chahiye. Hope you will help Thank you

[@village_style5237]

Mine is a very simple question unrelated to the above topic but related to excel. Lets say I want to enter "Sale" and "Purchase" in two consecutive rows leaving the third row blank. And I want to repeat this data for sufficiently long number of rows say till row number 5000. How do I achieve that ?

[@sangambuildway983]

a company has three products and three warehouses i want stock inventory to be made with auto matic product and godown how possible please help and share other tips this type

[@narendrasaini6264]

Sir ek video hlookup Par publish kro jisme aage kisi cell me data likhe aur piche vali cell se ans nikal ke aajaye

[@limsmonika5720]

Sir Apne kounsa version use karrahe ho excell Ka??

[@theinvisiblewings11]

9.23 par jab pmt apne lagaya hai toh rate ko 12 se divide kyu nh Kiya apne aur multiply bhi nh Kiya jabki jab bhi hm pmt nikalte hai tb usme ye use krte hai batayiye aap

[@jitendrasolanki3555]

Loan kisto me de rahe hai to kaise count kare??

[@SanjayKumar-em9yb]

Sir I have a question if PMT is 835 fv1500000 and NPER 10 so what is rate please answer me this question

[@inderrav5743]

Sir mobile me excel cell column ko lock kese kre jisse particular cell or column edit nhi ho ske baki sab editable ho Only mobile me

[@Paintingartnrush]

Are macro records krke password lgane ke bad macro cannot work aara he but sare option enable he enable macro work book me file save he Or bina password ke macro kam kar rha he dimag kgrab ho gya password k sath save ku ni ho rhi file jldi reply krna bro

[@TheCreatorKaran.K]

Hlo sir Aap telegram par aapka channel hai... Please link de do..

[@amitdesai8630]

(H3*I3)*(1-J3) Aise formule main "1" ka meaning kya hota hai?

[@hemantsaha_]

Mera answer 99999.91

[@esharoy3073]

My amount is wrong in case of pv

[@sonchiriya6872]

First views

[@piyushsharma8563]

🏅🏅🎖️🎖️🎖️🎖️🏅🏅🏅🎖️🎖️**le bhai sare medal tu hi rakh le.. 😀😀😀

[@sonchiriya6872]

Sukriya bhai Saab 😃😃

[@hindisahityasargam608]

दीपक जी! FV का formula RD पर गलत कैलकूलेट कर रहा है। क्योंकि? 2700 रूपए का 7.5% के हिसाब से एक साल के RD के लिए FV formula जो कैलकूलेट कर रहा है वो अमाऊंट बन रहा है 33537.28, जबकि बैंक का कैलकूलेशन है 33738.37। तो इस formula को सही कैसे माना।जाय??

[@vishalmajhwar9250]

Sir loan amount 110000 me mera p.v 109,999.96 rs. Aa raha hai Ekdam correct nhi aa raha hai

[@esharoy3073]

Mera bhi same problem hai

[@socialsite9842]

Sir please hELP SIR MUJHE "SAME NOTICE" bhut se LOGO KO भेजना है जिसमें उनका नाम, पता,मोबाइल नम्बर,बार बार लिखना ना पड़े एक्स्ल में सब एंट्री ह,,,कैसे करना है विडियो ह तो प्लीज़ सर लिंक भेजे अति कृपा होगी।

[@anilthakur9262]

Mail Merge ka use kriye.

[@BankerWriterMosharaf]

FV formula doesn't give accurate value if payment period and compounding period are different. Say, in Bangladesh Payments are made monthly but interest is compounded yearly or at the end of the tenure of the deposit scheme.

[@shubhamsingla7000]

I have a Question ⁉️ in Excel When we delete any data from cell and want to get deleted data to another cell so is it possible by using formula

[@shubhamsingla7000]

Because in the list of Excel I want to seperate some entries from list

[@village_style5237]

Mine is a very simple question unrelated to the above topic but related to excel. Lets say I want to enter "Sale" and "Purchase" in two consecutive rows leaving the third row blank. And I want to repeat this data for sufficiently long number of rows say till row number 5000. How do I achieve that ?

[@nihayatsabah2166]

Thanks

[@MuhammadTanveer-9797]

Hello sir Please Explain how to make an Indian calendar thanks sir

[@KARANKUMAR-lh5di]

Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz

[@sangambuildway983]

a company has three products and three warehouses i want stock inventory to be made with auto matic product and godown how possible please help and share other tips this type