I've been looking for a way to do this on excel and none of the results made me understand and now i have finally been able to complete my Savings excel sheet! Thank you so much!
Is there a tweak for the FV function to work from day one? Also why does the function give a negative value and that I have to add a negative sign at the beginning?
Cheers for the information. This video made much more sense than anything else on youtube. I was wondering if you could rework your formula to deal with a long term investment. Say a stocks and shares isa being used as a retirement pot. Compound over 20 odd years.
THIS IS NOT ACCURATE! The error is marginal, but with the biggest numbers the error can increase to millions. You cannot divide the interest directly by months. The interest must be calculated with a higher root =(1 + r) ^ (1/12) -1 (1+1.5%)^(1/12)-1 NOT 1.5%/12
I've been looking for a way to do this on excel and none of the results made me understand and now i have finally been able to complete my Savings excel sheet! Thank you so much!
The most succinct explanation of this topic I've seen. Thank you!
Thank you very much!
Thank you! I have been looking for days for something like this.
Thank you! Short, simple and sweet 😊
Amazing this is the formula I was looking for. I did it in my ACCA a long time ago but your layout is amazing. Thank you Sir!
Thank you! That was very helpful, and easy to apply!
This example is well explained. Thanks a lot for your help.
Thank you very much, your an Absolute Legend 🙌
Is there a tweak for the FV function to work from day one? Also why does the function give a negative value and that I have to add a negative sign at the beginning?
Excellent exactly what I needed, thanks.
Glad it helped!
Excellent video, does exactly what I wanted.
Thank you!
Great Tips Sir, many many thanks for your time and efforts
You saved me, thank you!
Wonderful! Thank you
What if I contribute monthly with different amount and I put it in Term deposit of 1 year and rollover principle + interest. How do I calculate that?
Thank you heaps
Thanks for this. What do I do if I don't make equal contributions monthly? some months willl be more than others.
The formula =-FV(C7/C9,C8*C9,C10,C6,1) gave me this: #¿NOMBRE? Could you please direct me towards what I did wrong? Thanks!
Nice fit dude, I like the scalability / flexibility. A little too fast when describing the FL formula though.
Cheers for the information. This video made much more sense than anything else on youtube. I was wondering if you could rework your formula to deal with a long term investment. Say a stocks and shares isa being used as a retirement pot. Compound over 20 odd years.
Thanks for watching! Is there anything stopping you from using 20 as the length of time and 1 as the compound frequency if it compounds annually?
How about daily compound of 1 %?
Thank you. How to change for varying monthly contribution ?
Ty very much!!!
Could share that excel sheet
If we don't have contribution period. How can we use the table
Have you considered inputting 0 for the contribution per period input?
@@theexcelhub yes
Can someone please post the formula?
your website is down
what about inflation?;)
THIS IS NOT ACCURATE!
The error is marginal, but with the biggest numbers the error can increase to millions. You cannot divide the interest directly by months. The interest must be calculated with a higher root =(1 + r) ^ (1/12) -1
(1+1.5%)^(1/12)-1
NOT
1.5%/12
This formula is not accurate
orange is too hard to read