How To Use PV, FV, RATE & NPER Formula in Excel - Excel Financial Functions
ฝัง
- เผยแพร่เมื่อ 17 ก.ค. 2024
- 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
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...
You always Rocking sir Ji 🙏🏻🙏🏻🙏🏻🙏🏻
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
बेहतरीन दीपक जी
Apka bahut bahut dhanyawad sir 🙏
Great Masha Allah, Allah bless you
Explained very easy & nice way.
You helped me always by your video 😊
Sir thank you apne meri request mani sir thank you so much sir😘
thank you very much si you are great teacher 🎉
Just awesome 👍
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.️
Thanks for 🎉😊
Great sir jee… love you
Amazing 🤩 ... Got it all 👍
Great thanks
Very useful sir with Thanks
Good 👍
Thanks for sharing
Great sir 👏 👍
Thank you sir!!
Thank u sir 🔥
Very informative
So nice explanation sir
You are powerful video
Sir ji aap bahut achcha se samjha thanks sir ji aap bahut achcha se samjhte hai ❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤❤😂
th-cam.com/video/e0TsESsXBjk/w-d-xo.htmlsi=iG8fPaX-oQ7OJNaa
Thank you sir😇
Thank you so much sir
Thank you sir
I am from Nepal ❣🇳🇵🇳🇵🇳🇵🇳🇵
Nice video 👌👌👌
Thanks
Thanks Deepak ji 🎉🎉🎉❤❤❤... Will this work in excel365 ver.??
I am proud of you
thank you sir
🌹🌹 राधे राधे 🌹🌹🌺ARK 🔥🏹❤🌹🌹 🌹 सीखते रहो, सिखाते रहो l❤
🌺हमेशा हंसते मुस्कुराते रहे l कभी अपने लिए तो कभी अपनों के लिए l🌺🌹🌹❤
Hello sir have you also explained more financial formulas , because after this video I couldn't find more
nice sir ❤
Very nice sir
Very nice
700th like 👌👌👌👌👌
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
Sir ap Sacha sa padath ho
Sir please complete the excel series
Only 4 uploaded till now
Thanks Sir
Tq sr 😊
Hello sir
Please Explain how to make an Indian calendar thanks sir
Please make a video on MS publisher
Excl ki starting s video dalye pls sbhi with formulas plz😊
9:08 rate jo hai yealy diya hua hai us ko monthly convert karne ki jarurat hai.
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 ?
Sir school management software Excel me banana
Please share the calculation and formula. INR 100000 per year for 5 years and Returns at 10th years with IRR 8%
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
Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz
Sir Apne kounsa version use karrahe ho excell Ka??
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
First views
🏅🏅🎖️🎖️🎖️🎖️🏅🏅🏅🎖️🎖️**le bhai sare medal tu hi rakh le.. 😀😀😀
Sukriya bhai Saab 😃😃
Sir I have a question if PMT is 835 fv1500000 and NPER 10 so what is rate please answer me this question
Sir ek video hlookup Par publish kro jisme aage kisi cell me data likhe aur piche vali cell se ans nikal ke aajaye
Hlo sir
Aap telegram par aapka channel hai...
Please link de do..
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
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
Loan kisto me de rahe hai to kaise count kare??
(H3*I3)*(1-J3) Aise formule main "1" ka meaning kya hota hai?
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
दीपक जी! FV का formula RD पर गलत कैलकूलेट कर रहा है। क्योंकि? 2700 रूपए का 7.5% के हिसाब से एक साल के RD के लिए FV formula जो कैलकूलेट कर रहा है वो अमाऊंट बन रहा है 33537.28, जबकि बैंक का कैलकूलेशन है 33738.37। तो इस formula को सही कैसे माना।जाय??
Mera answer 99999.91
Sir loan amount 110000 me mera p.v 109,999.96 rs. Aa raha hai
Ekdam correct nhi aa raha hai
Mera bhi same problem hai
My amount is wrong in case of pv
Sir please hELP
SIR MUJHE "SAME NOTICE" bhut se LOGO KO भेजना है जिसमें उनका नाम, पता,मोबाइल नम्बर,बार बार लिखना ना पड़े एक्स्ल में सब एंट्री ह,,,कैसे करना है विडियो ह तो प्लीज़ सर लिंक भेजे
अति कृपा होगी।
Mail Merge ka use kriye.
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.
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
Because in the list of Excel I want to seperate some entries from list
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 ?
Thanks
Hello sir
Please Explain how to make an Indian calendar thanks sir
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
Sir Amazon and Flipkart profit & loss automatic excel sheet bnana btao plzz