No video

calculating future value on excel

  Рет қаралды 328,425

Codible

Codible

12 жыл бұрын

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

Пікірлер: 71
@rainesilk9791
@rainesilk9791 23 күн бұрын
Excellent explanation. Thank you!
@angel01876
@angel01876 4 жыл бұрын
Well done. Very easy to follow, understand, and reproduce the same results
@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 жыл бұрын
ركلات الترجيح في كل من قال ان يكون لك صديق قديم كان لك قلب كل من غاب الخاطر إليا عاف من خلال الرابط التالي
@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.
@kudratilla
@kudratilla 5 жыл бұрын
Fast and simple explanation which makes this video amazing
@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!
@adu-boahendan8309
@adu-boahendan8309 5 жыл бұрын
Great Video with clear explanations. Thumbs up
@kendallwoozy
@kendallwoozy 2 жыл бұрын
Thank you! Intermediate accounting student here. I need to ground the time value of money concept!
@kdawgwade13
@kdawgwade13 8 жыл бұрын
Helped me out a lot! Thank you sir!
@JAYS040787
@JAYS040787 2 жыл бұрын
Great work, I learnt another small additional thing with the $ sign which I didn't know. Thanks
@stephenhirt2508
@stephenhirt2508 7 жыл бұрын
This was exactly what I was looking for. Thank you
@rahulprasad3929
@rahulprasad3929 2 жыл бұрын
Thanks sir, very well explianed
@unknownsbeing9912
@unknownsbeing9912 2 жыл бұрын
This is so helpful
@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
@ProviderKnowledge
@ProviderKnowledge Жыл бұрын
Thank you, sir
@RogueViral
@RogueViral 6 жыл бұрын
This helped with an urgent assignment and i passed!! Thanks for sharing
@poojaa369
@poojaa369 2 жыл бұрын
Thank you so much,understood very well 👍
@JDS928
@JDS928 5 жыл бұрын
Well explained, good vocabulary.
@jiaqihuang5948
@jiaqihuang5948 6 жыл бұрын
Wow, I love Microsoft!!! Fantastic baby!!!
@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
@marlenemaymay128
@marlenemaymay128 2 жыл бұрын
Very helpful
@diwashshrestha5518
@diwashshrestha5518 3 жыл бұрын
thank you very much
@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.
@danarose1169
@danarose1169 6 жыл бұрын
Sublime. Well done.
@virendravikram9425
@virendravikram9425 4 жыл бұрын
Good Explanation..Pal
@MrPoki-sf7cq
@MrPoki-sf7cq 9 жыл бұрын
Thank you very much for this useful video!!!
@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?
@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??
@asmaakter8607
@asmaakter8607 4 жыл бұрын
It's really a very helpful video and content is exactly according to this formula.
@veliem3935
@veliem3935 3 жыл бұрын
Nice work buddy
@tatolin92
@tatolin92 10 жыл бұрын
Very well explained thank you.
@kelbeth5435
@kelbeth5435 8 жыл бұрын
Thank you soooo much!!
@hackbumlee725
@hackbumlee725 5 жыл бұрын
Great lesson I like it
@in2view
@in2view 11 жыл бұрын
Very informative. Thank you!
@Wolfvr123_vryt
@Wolfvr123_vryt 6 жыл бұрын
Excellent!!!!! Thank you so much!
@sarathadhikari3175
@sarathadhikari3175 3 жыл бұрын
very clear, let me know Present value calculation too
@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
@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.
@vamshikrishna-lp6iv
@vamshikrishna-lp6iv 3 жыл бұрын
This is good, could you pls help me with the same calculation in monthly, quarterly compounding?
@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
@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.
@diwashshrestha5518
@diwashshrestha5518 3 жыл бұрын
which formula would be effective ?
@zakariaabdallah8065
@zakariaabdallah8065 2 жыл бұрын
Gonna pass my maths assessment now
@steviebb2631
@steviebb2631 4 жыл бұрын
thanks
@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?
@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 + 🤔
@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??
@taniyahb1761
@taniyahb1761 2 жыл бұрын
CovidImages need to be invested more than half19
@Surrender2TheFlow
@Surrender2TheFlow 3 жыл бұрын
thanks fore nothing.
Excel Finance Functions: PMT() • PV() • RATE() • NPER()
8:40
Harley Quinn's desire to win!!!#Harley Quinn #joker
00:24
Harley Quinn with the Joker
Рет қаралды 6 МЛН
EVOLUTION OF ICE CREAM 😱 #shorts
00:11
Savage Vlogs
Рет қаралды 14 МЛН
The Giant sleep in the town 👹🛏️🏡
00:24
Construction Site
Рет қаралды 16 МЛН
10 Excel Formulas That Will Set You Apart (+Cheat Sheet)
18:04
MyOnlineTrainingHub
Рет қаралды 246 М.
How To Compare Excel Files and Find Differences
10:47
Kenji Explains
Рет қаралды 39 М.
Calculating stock beta using Excel
4:29
Codible
Рет қаралды 564 М.
Making a Compounding Interest Calculator in Excel
11:23
David McLachlan
Рет қаралды 54 М.
Harley Quinn's desire to win!!!#Harley Quinn #joker
00:24
Harley Quinn with the Joker
Рет қаралды 6 МЛН