How to use FV formula to calculate Future Value | Ms excel tutorial - 43 | FV Function in excel (CC)
ฝัง
- เผยแพร่เมื่อ 13 ก.ย. 2024
- How to use FV formula to calculate Future Value | Ms excel tutorial for beginners - 43 | FV Function in excel.
#financialfunction #fvformula #msexcelforbeginners #computergyanguruji
Our second channel
/ computergurujitechnical
www.amazon.in/shop/computergyanguruji
Follow us on
instagram
/ computergyanguruji
Twitter
/ c_g_guruji
Facebook
/ computer-gyan-guruji-1...
MS Excel Videos
• Hindi English Dictiona...
MS Excel for Beginners
• MS Excel Tutorial for ...
Excel VBA
• Excel VBA
MS Word
• MS Word
MS PowerPoint
• MS Power Point
MS Access
• MS Access tutorial for...
MS Paint
• MS Paint
MSW Logo
• MSWLogo
Notepad & HTML
• Notepad complete tutor...
CSS
• Introduction to CSS | ...
Computer Education
• Education
Other
• Other video
Tally
• Tally ERP.9 Rules of D...
Internet
• internet
Computer GK
• GK
Google Sheet
• google sheet
Reasoning
• Reasoning
Airthmatics
• Airthmetic
All vidéo great sir n Thanku so much sir for this class sach me bhut hi achha samjh aata hai thanku sir
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Sir really , literally koi bhi video itne aache se explain nhi Kiya tha deep me par apneee kiya thank you aasse hi video bnate rhe or aassseee hi deeply pdatee rheeee thankkkklkkkk youuuuuu veryytyyy muchhhjjj
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Very Good Sir
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Your videos are much informative .I learned lot of things from your videos .You are doing great job.
muhammad irfan from kashmir
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Sir aapki kirpa se mai free mai computer sikh rha hoon sir most thankful from heart.
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
It's very helpful video sir
Loan repayment farmula भी बताईये इसी प्रकार से
You learn IPMT,PPMT,PMT
Very good video sir
All video great sir
Keep watching
Nice video 👌👌👌
Thanks sir very helpful video sir
All the best
thank you sir ji 🎉
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Thank you sir😊👍🏻
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Nice Explaination keep it up
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
excellent sir
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Mind blowing sir
Thanks a lot
Nice
Nice sir
It makes sense to me to watch your two videos
Thank you sir
Avgraju
It is possible if interst is monthly compound for month wise future value calculation.
FV function doesn't give correct value if payment periods and compounding periods are different. Say, payments are made monthly but interest is compounded yearly or at tenure end.
excellent
Thanks!
Sir, apne formule mai pmt liya hai. aur pv ko chora hai
Nic sir
Sir, class mgmt ke liye kuch bataiye excel pe
Great 🔥🔥
2:51
❤
Sir, bahut achha laga.....lekin ek doubt......
RD Amount=1000
Rate of interest=8%
Time=24 months
Syntax of future value:-
=FV(rate,nper,pmt,[pv],[type])
syntax ke hisab se values denge to
=FV(8%/12,24,,1000,1)
Ans=1172.89 aa raha hai
pmt ko ignore karen to eisa ata hai
But apka ans 26106.08
Sir how..............?
Vo 1000rs. pv nahi pmt hai , sir se mistak ho gai hai 😂
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
Actually there is some error here, we are using pmt(payment) instead of pv(present value) in this FV function
@@ShivGarg-dx2nq Yes bro I am confuse in Pmt & Pv .
sir ap pmt ki keemat derahy ho or keh rahy ho k pmt ko chr kr pv ki value deni ha
ky ap drust kr rahy hain
sir I have worksheet in this table i have created coloumn like maturity amount in numeric and date column i have applied conditional formatting, according to date colour should be changed to Red, yellow, green, now I want to know that according to due date column how-to apply conditional formatting so that in maturity amount coloumn colour also change to Red yellow green according to due date column colour? please make video on this asap thanks in advance for your help
mujhe yeh bta dai k mujhe denomination banani hai
Denomination values hai merai pass
Like
1000*1=1000
500*1=500
100*9=900
50*2=100
Total =2500
Mane likha k 1500 k amount no of note Mai alag karai to wo Kasai hoga
Guide karai please
A.o.A
Why we divided rate of interest by 12
सर! 2 साल, 11 महीने और 29 दिन के लिए quarterly compound interest on fd के लिए कौन सा फॉर्मूला एक्सेल में लगाएंगे? जबकि मेरे बैंक ने 407895 के ऊपर 6.5% व्याज की दर से 494856.10 मैच्योरिटी अमाउंट ऊपर दिए गए अवधि के लिए बनाया है। कृपया मार्गदर्शन करें🙏🙏🙏
why my fv value is coming negative?
in the FV formula you skipped FV and entered PMT. but said the reverse. Please correct.
Dear sir
Ex Beginner lesson 43 main Fv amount
why the brakets on the both sides in the whole Amount pl tell me sir
Avgraju
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format.
th-cam.com/video/lYiHbaFvR60/w-d-xo.html
th-cam.com/video/6JLZ93I1LcE/w-d-xo.html
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
Good evening sir
Sir it's my humble request to you please help me sir
Sir excel mein office work mein kya kya knowledge chahiye kya kya sikhna parega please help me sir
Office mein different jobs hoti hain ar usi k hisab se excel ko use kia jata hy yeh depend krta hy k ap ki job kia hy.suppose ap data entry operator ki job kr rahe hain, cashier ki job kr rahe hain,time keeper hain,clerk hn,administrator hain so ap koi b job kr rhe hun usi k hisab se he excel ka use kia jata hy.basic bat yeh hy k excel k jo basic function hain wo ap ko ana chayen us k bad yeh formolas ka usage atna mushkl ni hota
bro office work ke liye kam se kam excel ki basic knowledge hona jaruri hai jaise- data enter karna, us data ke liye sahi format banana, baisc formulon ka gyan hona, or print karna etc. uske baad ye ki aap kis office me kaam karte hain yani aapka kaam kya hai jaise aap accountant hain ya clerk hain. uske anusar excel ke alag alag field me alag alag kaam hain.
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
Sir 1000/- ka 8% 80 hoga to ye 6.67 kaise
Sir Both of your Answers are wrong. As your inputted your PV value in pmt value so you are getting wrong answers. Please check your video.
Sir mera intrat drag nhi aa rha 0 value aa rhi drag krne prr
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
at 7.14 minutes you said end of period then y u didnt select "0"
Your second calculation is wrong, kindly recheck.
why the result came out in parentheses?
This is the default number format of financial formulas.If you want any other number format then you have to change the number format like general, date, currency etc. If you do general format then brackets will not come. But before that you have to use "-" sign in the formula. e.g. "= - FV (Syntax )" You can watch our video to know more about Custom Number Format.
th-cam.com/video/lYiHbaFvR60/w-d-xo.html
th-cam.com/video/6JLZ93I1LcE/w-d-xo.html
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
vae.fyi
great
thora kathin hei
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a
very detailed and informative video, thanks
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=dsP3xQvryzQWvEuQ
Nice sir
th-cam.com/video/7xhRJ7p1R_c/w-d-xo.htmlsi=AQDVzWMxIcBJ97-a