How to use FV formula to calculate Future Value | Ms excel tutorial - 43 | FV Function in excel (CC)

  Рет қаралды 68,053

Computer Gyan Guruji

Computer Gyan Guruji

2 жыл бұрын

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

Пікірлер: 77
@parthopratimdas175
@parthopratimdas175 Жыл бұрын
It's very helpful video sir
@afzalhameed3968
@afzalhameed3968 Жыл бұрын
very detailed and informative video, thanks
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@saverarajput2606
@saverarajput2606 2 жыл бұрын
All vidéo great sir n Thanku so much sir for this class sach me bhut hi achha samjh aata hai thanku sir
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@amansen1349
@amansen1349 Жыл бұрын
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
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@raheelabdulquddus8022
@raheelabdulquddus8022 4 ай бұрын
Very Good Sir
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@IKARCHIVE
@IKARCHIVE 2 жыл бұрын
Your videos are much informative .I learned lot of things from your videos .You are doing great job. muhammad irfan from kashmir
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@asishkumarpadhi2820
@asishkumarpadhi2820 Жыл бұрын
Very good video sir
@RahulKumar-ly6ly
@RahulKumar-ly6ly 2 жыл бұрын
Thanks sir very helpful video sir
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
All the best
@honeykansal
@honeykansal 2 жыл бұрын
Sir aapki kirpa se mai free mai computer sikh rha hoon sir most thankful from heart.
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@annabathulavekatagovindara8883
@annabathulavekatagovindara8883 2 жыл бұрын
It makes sense to me to watch your two videos Thank you sir Avgraju
@mundankumar562
@mundankumar562 2 жыл бұрын
All video great sir
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
Keep watching
@abodisom_official
@abodisom_official 7 ай бұрын
Nice video 👌👌👌
@sksumitkumarshakya
@sksumitkumarshakya 2 жыл бұрын
Great 🔥🔥
@satishcomputersportsedu.9440
@satishcomputersportsedu.9440 2 жыл бұрын
Mind blowing sir
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
Thanks a lot
@user-gd9wt8xd4x
@user-gd9wt8xd4x 5 ай бұрын
Thank you sir😊👍🏻
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@ramizraza3296
@ramizraza3296 2 жыл бұрын
Nice sir
@uniquemobiletipstricks7714
@uniquemobiletipstricks7714 Жыл бұрын
Nice Explaination keep it up
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@ibraheemmshezad400
@ibraheemmshezad400 2 жыл бұрын
Nice
@KanchanSharma-vj6mq
@KanchanSharma-vj6mq 6 ай бұрын
thank you sir ji 🎉
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@soumendas2242
@soumendas2242 2 жыл бұрын
It is possible if interst is monthly compound for month wise future value calculation.
@loknathchowdhury4742
@loknathchowdhury4742 10 ай бұрын
excellent sir
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@pamelchowdhury
@pamelchowdhury 2 жыл бұрын
excellent
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
Thanks!
@prajwalshetty2047
@prajwalshetty2047 8 ай бұрын
@skn3278
@skn3278 2 жыл бұрын
Loan repayment farmula भी बताईये इसी प्रकार से
@dhruvyadav8863
@dhruvyadav8863 Жыл бұрын
You learn IPMT,PPMT,PMT
@ruchibairagi8318
@ruchibairagi8318 2 жыл бұрын
Nic sir
@fragrenceful
@fragrenceful Жыл бұрын
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
@madhav600
@madhav600 2 жыл бұрын
Sir, class mgmt ke liye kuch bataiye excel pe
@BankerWriterMosharaf
@BankerWriterMosharaf Жыл бұрын
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.
@gaurabdeb1511
@gaurabdeb1511 Жыл бұрын
2:51
@sirajnasir7620
@sirajnasir7620 Жыл бұрын
A.o.A Why we divided rate of interest by 12
@umangvarshney8332
@umangvarshney8332 29 күн бұрын
Sir, apne formule mai pmt liya hai. aur pv ko chora hai
@hindisahityasargam608
@hindisahityasargam608 Жыл бұрын
सर! 2 साल, 11 महीने और 29 दिन के लिए quarterly compound interest on fd के लिए कौन सा फॉर्मूला एक्सेल में लगाएंगे? जबकि मेरे बैंक ने 407895 के ऊपर 6.5% व्याज की दर से 494856.10 मैच्योरिटी अमाउंट ऊपर दिए गए अवधि के लिए बनाया है। कृपया मार्गदर्शन करें🙏🙏🙏
@777southpaw
@777southpaw 11 ай бұрын
in the FV formula you skipped FV and entered PMT. but said the reverse. Please correct.
@annabathulavekatagovindara8883
@annabathulavekatagovindara8883 2 жыл бұрын
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
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
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. kzbin.info/www/bejne/oorMeZWXe9uFbJI kzbin.info/www/bejne/bHuvi2xpfpZ_mac
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@RSK90
@RSK90 Жыл бұрын
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
@dillipkumarmurmu3628
@dillipkumarmurmu3628 2 жыл бұрын
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..............?
@Nolongerravailable
@Nolongerravailable 2 жыл бұрын
Vo 1000rs. pv nahi pmt hai , sir se mistak ho gai hai 😂
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@saddamhussainsoomro2810
@saddamhussainsoomro2810 10 ай бұрын
why my fv value is coming negative?
@muneebkhattak123
@muneebkhattak123 Жыл бұрын
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
@saureenkhetal.5511
@saureenkhetal.5511 Жыл бұрын
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.
@sandeepbhatia7993
@sandeepbhatia7993 2 жыл бұрын
at 7.14 minutes you said end of period then y u didnt select "0"
@pknewknowledge6629
@pknewknowledge6629 2 жыл бұрын
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
@IKARCHIVE
@IKARCHIVE 2 жыл бұрын
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
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
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.
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@moviehub8887
@moviehub8887 Жыл бұрын
Sir 1000/- ka 8% 80 hoga to ye 6.67 kaise
@annjames4763
@annjames4763 2 жыл бұрын
vae.fyi great
@goldrush4513
@goldrush4513 2 жыл бұрын
why the result came out in parentheses?
@ComputerGyanGuruji
@ComputerGyanGuruji 2 жыл бұрын
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. kzbin.info/www/bejne/oorMeZWXe9uFbJI kzbin.info/www/bejne/bHuvi2xpfpZ_mac
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@psvvlogs9432
@psvvlogs9432 11 ай бұрын
Sir mera intrat drag nhi aa rha 0 value aa rhi drag krne prr
@ramkishoryadav9087
@ramkishoryadav9087 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=dsP3xQvryzQWvEuQ
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@amolrane1841
@amolrane1841 Жыл бұрын
Your second calculation is wrong, kindly recheck.
@behindthescene2727
@behindthescene2727 2 жыл бұрын
thora kathin hei
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
@navinkumarsah4997
@navinkumarsah4997 2 жыл бұрын
Nice sir
@akyadav080yadav8
@akyadav080yadav8 2 ай бұрын
kzbin.info/www/bejne/banLg31tpZaFlcUsi=AQDVzWMxIcBJ97-a
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 24 МЛН
WORLD'S SHORTEST WOMAN
00:58
Stokes Twins
Рет қаралды 93 МЛН
ПРОВЕРИЛ АРБУЗЫ #shorts
00:34
Паша Осадчий
Рет қаралды 7 МЛН
How to Use SUMPRODUCT in Excel
14:56
Leila Gharani
Рет қаралды 733 М.
Present Value - Explained in Hindi
12:09
Asset Yogi
Рет қаралды 164 М.
Most important tools in Excel -  Malayalam Tutorial
17:04
XL n CAD Malayalam
Рет қаралды 663 М.
FV of SIP
5:32
Sandip Mukherjee
Рет қаралды 14 М.
Heartwarming Unity at School Event #shorts
00:19
Fabiosa Stories
Рет қаралды 24 МЛН