Тёмный
No video :(

calculating future value on excel 

Codible
Подписаться 19 тыс.
Просмотров 328 тыс.
50% 1

Demonstrates the concept of future value and shows how to use the FV function in Excel 2010 Follow us on twitter: / codible
Some good books on Excel and Finance:
Financial Modeling - by Benninga:
amzn.to/2tByGQ2
Principles of Finance with Excel - by Benninga:
amzn.to/2uaCyo6

Опубликовано:

 

12 июл 2012

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 71   
@Pardon_My_Heels
@Pardon_My_Heels 6 лет назад
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!
@mohameddesign342
@mohameddesign342 7 лет назад
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
@kdawgwade13
@kdawgwade13 8 лет назад
Helped me out a lot! Thank you sir!
@angel01876
@angel01876 4 года назад
Well done. Very easy to follow, understand, and reproduce the same results
@stephenhirt2508
@stephenhirt2508 7 лет назад
This was exactly what I was looking for. Thank you
@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.
@in2view
@in2view 11 лет назад
Very informative. Thank you!
@kelbeth5435
@kelbeth5435 8 лет назад
Thank you soooo much!!
@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 3 года назад
ركلات الترجيح في هذه الحياة لا ٥ من ٨ على ٨ ٨ على كل شيء ٥٤٨٥كتَامان على ٥٥ على خير البشر لا ٥٤٨٥كتَامان في هذه الساعة المباركة أن يتم الانتهاء منه أن تكون في كل مكان اللهم إني اسألك حسن الخاتمه من
@aldamry6554
@aldamry6554 3 года назад
رماده خلب من ٥ صباح الخير يا حلوين ٢٣ على كل شي قدير اللهم قدر لنا الخير في قلبك لا
@aldamry6554
@aldamry6554 3 года назад
رماده خلب من ٥ صباح الخير يا حلوين من خلال تثبيت قصاصات النص المنسوخ لمنع انقضائها بعد ساعة واحدةإزاحة القصاصات لحذفهاإزاحة القصاصات لحذفهاتثبيت قصاصات النص المنسوخ لمنع انقضائها بعد ساعة واحدة
@aldamry6554
@aldamry6554 3 года назад
ركلات الترجيح في كل من غاب عني و لا قوة إلا بالله من الشيطان في هذه الحياة الدنيا وهم يحسبون انهم ما
@aldamry6554
@aldamry6554 3 года назад
ركلات الترجيح في كل من قال ان يكون لك صديق قديم كان لك قلب كل من غاب الخاطر إليا عاف من خلال الرابط التالي
@vamshikrishna-lp6iv
@vamshikrishna-lp6iv 3 года назад
This is good, could you pls help me with the same calculation in monthly, quarterly compounding?
@kudratilla
@kudratilla 5 лет назад
Fast and simple explanation which makes this video amazing
@tatolin92
@tatolin92 10 лет назад
Very well explained thank you.
@adu-boahendan8309
@adu-boahendan8309 5 лет назад
Great Video with clear explanations. Thumbs up
@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?
@diwashshrestha5518
@diwashshrestha5518 3 года назад
which formula would be effective ?
@MrPoki-sf7cq
@MrPoki-sf7cq 9 лет назад
Thank you very much for this useful video!!!
@kendallwoozy
@kendallwoozy 2 года назад
Thank you! Intermediate accounting student here. I need to ground the time value of money concept!
@JDS928
@JDS928 5 лет назад
Well explained, good vocabulary.
@rainesilk9791
@rainesilk9791 9 дней назад
Excellent explanation. Thank you!
@danarose1169
@danarose1169 6 лет назад
Sublime. Well done.
@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.
@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
@Wolfvr123_vryt
@Wolfvr123_vryt 6 лет назад
Excellent!!!!! Thank you so much!
@thisiscrazy4122
@thisiscrazy4122 2 года назад
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.
@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
@RogueViral
@RogueViral 6 лет назад
This helped with an urgent assignment and i passed!! Thanks for sharing
@userme2803
@userme2803 6 лет назад
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
@JAYS040787
@JAYS040787 2 года назад
Great work, I learnt another small additional thing with the $ sign which I didn't know. Thanks
@hackbumlee725
@hackbumlee725 5 лет назад
Great lesson I like it
@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.
@jiaqihuang5948
@jiaqihuang5948 6 лет назад
Wow, I love Microsoft!!! Fantastic baby!!!
@unknownsbeing9912
@unknownsbeing9912 2 года назад
This is so helpful
@ProviderKnowledge
@ProviderKnowledge Год назад
Thank you, sir
@veliem3935
@veliem3935 3 года назад
Nice work buddy
@poojaa369
@poojaa369 2 года назад
Thank you so much,understood very well 👍
@virendravikram9425
@virendravikram9425 4 года назад
Good Explanation..Pal
@rahulprasad3929
@rahulprasad3929 2 года назад
Thanks sir, very well explianed
@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??
@marlenemaymay128
@marlenemaymay128 2 года назад
Very helpful
@sarathadhikari3175
@sarathadhikari3175 3 года назад
very clear, let me know Present value calculation too
@diwashshrestha5518
@diwashshrestha5518 3 года назад
thank you very much
@aftabuddin2050
@aftabuddin2050 6 лет назад
why did you suddenly jump from simple fv to future value annuity? it creates confusion for new people/
@nmoe2o
@nmoe2o 4 года назад
After enter the current value, why we enter 1 + 🤔
@steviebb2631
@steviebb2631 4 года назад
thanks
@asmaakter8607
@asmaakter8607 4 года назад
It's really a very helpful video and content is exactly according to this formula.
@zakariaabdallah8065
@zakariaabdallah8065 2 года назад
Gonna pass my maths assessment now
@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?
@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??
@Surrender2TheFlow
@Surrender2TheFlow 3 года назад
thanks fore nothing.
@taniyahb1761
@taniyahb1761 2 года назад
CovidImages need to be invested more than half19
Далее
NPV and IRR in Excel 2010
9:00
Просмотров 1,5 млн
10 Excel Formulas That Will Set You Apart (Cheat Sheet)
18:04
3 Essential Excel skills for the data analyst
18:02
Просмотров 1,5 млн
When You Should Use the New Excel LET Function
17:18
Просмотров 758 тыс.
How To Calculate Monthly Payment With Excel
10:28
Просмотров 8 тыс.
Time Value of Money Using Excel - 10 Examples
33:20
Просмотров 29 тыс.
Can You Pass This Excel Interview Test?
11:20
Просмотров 864 тыс.