calculating future value on excel

  Рет қаралды 330,341

Codible

Codible

Күн бұрын

Пікірлер: 71
@MichaelToub
@MichaelToub 8 жыл бұрын
This is a great video, and perfectly explains it in the best way possible: by doing a manual calculation first. Thank you!!!!
@aldamry6554
@aldamry6554 4 жыл бұрын
ركلات الترجيح في هذه الحياة لا ٥ من ٨ على ٨ ٨ على كل شيء ٥٤٨٥كتَامان على ٥٥ على خير البشر لا ٥٤٨٥كتَامان في هذه الساعة المباركة أن يتم الانتهاء منه أن تكون في كل مكان اللهم إني اسألك حسن الخاتمه من
@aldamry6554
@aldamry6554 4 жыл бұрын
رماده خلب من ٥ صباح الخير يا حلوين ٢٣ على كل شي قدير اللهم قدر لنا الخير في قلبك لا
@aldamry6554
@aldamry6554 4 жыл бұрын
رماده خلب من ٥ صباح الخير يا حلوين من خلال تثبيت قصاصات النص المنسوخ لمنع انقضائها بعد ساعة واحدةإزاحة القصاصات لحذفهاإزاحة القصاصات لحذفهاتثبيت قصاصات النص المنسوخ لمنع انقضائها بعد ساعة واحدة
@aldamry6554
@aldamry6554 4 жыл бұрын
ركلات الترجيح في كل من غاب عني و لا قوة إلا بالله من الشيطان في هذه الحياة الدنيا وهم يحسبون انهم ما
@aldamry6554
@aldamry6554 4 жыл бұрын
ركلات الترجيح في كل من قال ان يكون لك صديق قديم كان لك قلب كل من غاب الخاطر إليا عاف من خلال الرابط التالي
@thisiscrazy4122
@thisiscrazy4122 3 жыл бұрын
Very easy to follow the breakdown, understand and reproduce the same results ! We need a dedication section for youtube powered only by indians, were there are kind of explanations.
@kendallwoozy
@kendallwoozy 2 жыл бұрын
Thank you! Intermediate accounting student here. I need to ground the time value of money concept!
@mohameddesign342
@mohameddesign342 8 жыл бұрын
thank you for your clearly explain just i wanna ask you a question if the deposit have different value how should we calculate the f.v thank you again
@Pardon_My_Heels
@Pardon_My_Heels 7 жыл бұрын
Thank you so much for this, I paid $170 for a textbook for school that didn't even provide this great of an example. You've helped me tremendously!
@rainesilk9791
@rainesilk9791 4 ай бұрын
Excellent explanation. Thank you!
@kudratilla
@kudratilla 5 жыл бұрын
Fast and simple explanation which makes this video amazing
@someartlife01
@someartlife01 7 жыл бұрын
Do you have a video on how? How are you doing this? The formulas? How do you get the formula to appear?
@angel01876
@angel01876 4 жыл бұрын
Well done. Very easy to follow, understand, and reproduce the same results
@shubhamchoudhury7950
@shubhamchoudhury7950 Жыл бұрын
is the future value calculation same as Compound Interest calculation? Since we are getting interest on interest on the principal amount in every year
@JAYS040787
@JAYS040787 3 жыл бұрын
Great work, I learnt another small additional thing with the $ sign which I didn't know. Thanks
@darshanshetty1584
@darshanshetty1584 6 жыл бұрын
gr8 video !! very good explanation - just one query can we insert inflation component in it so that we get FV considering inflation.
@prabhurajan516
@prabhurajan516 4 жыл бұрын
Deposit is negative cash flow, which you are investing. That means when ever you calculate the FV it is said to be -ve if outflow. In this case it is -1000
@adu-boahendan8309
@adu-boahendan8309 5 жыл бұрын
Great Video with clear explanations. Thumbs up
@vamshikrishna-lp6iv
@vamshikrishna-lp6iv 3 жыл бұрын
This is good, could you pls help me with the same calculation in monthly, quarterly compounding?
@RavinderSingh-nz2ig
@RavinderSingh-nz2ig 3 жыл бұрын
Thank you for this video. Please may u also share similar video on showing calculation of EMI manually and using PMT function.
@rufetmohbalizade1148
@rufetmohbalizade1148 3 жыл бұрын
Firstly thank you so much for this video. Secondly i have one question. If i don't deposit every year, how can i calculate future value? (Interest rate:13.5%; year:5, i deposit just first year 100 000$)… I calculate first way (Fv=Pv*(1+Rate)^year) is correct, but i can not calculate in excel with "fv" function.
@RogueViral
@RogueViral 7 жыл бұрын
This helped with an urgent assignment and i passed!! Thanks for sharing
@stephenhirt2508
@stephenhirt2508 7 жыл бұрын
This was exactly what I was looking for. Thank you
@diwashshrestha5518
@diwashshrestha5518 3 жыл бұрын
which formula would be effective ?
@rahulprasad3929
@rahulprasad3929 2 жыл бұрын
Thanks sir, very well explianed
@userme2803
@userme2803 7 жыл бұрын
Thanks for this great video. The payment is = 1000. Lets say that the deposit was in these 5 years was not even 1000. for example one year deposited 1000 then the next one is 500. How you can write FV() in that case? thank you
@kdawgwade13
@kdawgwade13 9 жыл бұрын
Helped me out a lot! Thank you sir!
@unknownsbeing9912
@unknownsbeing9912 3 жыл бұрын
This is so helpful
@ProviderKnowledge
@ProviderKnowledge 2 жыл бұрын
Thank you, sir
@aftabuddin2050
@aftabuddin2050 6 жыл бұрын
why did you suddenly jump from simple fv to future value annuity? it creates confusion for new people/
@jiaqihuang5948
@jiaqihuang5948 7 жыл бұрын
Wow, I love Microsoft!!! Fantastic baby!!!
@veliem3935
@veliem3935 4 жыл бұрын
Nice work buddy
@poojaa369
@poojaa369 3 жыл бұрын
Thank you so much,understood very well 👍
@JDS928
@JDS928 6 жыл бұрын
Well explained, good vocabulary.
@nmoe2o
@nmoe2o 4 жыл бұрын
After enter the current value, why we enter 1 + 🤔
@akshaymagre5261
@akshaymagre5261 3 жыл бұрын
GREAT WORK!!!!
@akshaymagre5261
@akshaymagre5261 3 жыл бұрын
BUT IF WE USE THE EXCEL FUNCTION =NPV(NEGATIVE,POSITVE) = 112, THIS IS HOW EXCEL EXPLAINS US. WHAT SHOULD WE BELIEVE? MANUAL CALCULATION OR NPV FUNCTION??
@sachinkr6
@sachinkr6 2 жыл бұрын
Wow, Very easy to understand video on FV using excel. But i am getting some extraordinary figures for a simple amount . Suppose i invest ₹ 1858 per year for 5 years in a bank who gives 15.73% return , then how much i would make in 5 years?
@sarathadhikari3175
@sarathadhikari3175 4 жыл бұрын
very clear, let me know Present value calculation too
@danarose1169
@danarose1169 6 жыл бұрын
Sublime. Well done.
@virendravikram9425
@virendravikram9425 4 жыл бұрын
Good Explanation..Pal
@diwashshrestha5518
@diwashshrestha5518 3 жыл бұрын
first example's simple interest is 50 so it would be 50*6yrs=300 and finalvalue should be 1300 but how 1340.09??
@tatolin92
@tatolin92 10 жыл бұрын
Very well explained thank you.
@MrPoki-sf7cq
@MrPoki-sf7cq 10 жыл бұрын
Thank you very much for this useful video!!!
@asmaakter8607
@asmaakter8607 4 жыл бұрын
It's really a very helpful video and content is exactly according to this formula.
@hackbumlee725
@hackbumlee725 5 жыл бұрын
Great lesson I like it
@marlenemaymay128
@marlenemaymay128 2 жыл бұрын
Very helpful
@zakariaabdallah8065
@zakariaabdallah8065 2 жыл бұрын
Gonna pass my maths assessment now
@diwashshrestha5518
@diwashshrestha5518 3 жыл бұрын
thank you very much
@kelbeth5435
@kelbeth5435 8 жыл бұрын
Thank you soooo much!!
@Wolfvr123_vryt
@Wolfvr123_vryt 7 жыл бұрын
Excellent!!!!! Thank you so much!
@in2view
@in2view 11 жыл бұрын
Very informative. Thank you!
@steviebb2631
@steviebb2631 4 жыл бұрын
thanks
@Surrender2TheFlow
@Surrender2TheFlow 4 жыл бұрын
thanks fore nothing.
@taniyahb1761
@taniyahb1761 3 жыл бұрын
CovidImages need to be invested more than half19
NPV and IRR in Excel 2010
9:00
Codible
Рет қаралды 1,5 МЛН
Хаги Ваги говорит разными голосами
0:22
Фани Хани
Рет қаралды 2,2 МЛН
Microsoft Excel 2013 Training - Future Value and Present Value
16:42
Excel Finance Functions: PMT() • PV() • RATE() • NPER()
8:40
Using the New IFS Function in Excel
11:10
Technology for Teachers and Students
Рет қаралды 154 М.
Compound Interest (Future Value)
13:50
Nabifroese Math Videos!
Рет қаралды 564 М.
Introduction to Pivot Tables, Charts, and Dashboards in Excel (Part 1)
14:48
Excel Campus - Jon
Рет қаралды 14 МЛН