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!
Thank you! Short, simple and sweet 😊
The most succinct explanation of this topic I've seen. Thank you!
Thank you very much!
Thank you! That was very helpful, and easy to apply!
Thank you! I have been looking for days for something like this.
This example is well explained. Thanks a lot for your help.
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 very much, your an Absolute Legend 🙌
Excellent video, does exactly what I wanted.
Thank you!
Excellent exactly what I needed, thanks.
Glad it helped!
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?
Great Tips Sir, many many thanks for your time and efforts
Wonderful! Thank you
Thanks for this. What do I do if I don't make equal contributions monthly? some months willl be more than others.
You saved me, 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
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?
Thank you. How to change for varying monthly contribution ?
Nice fit dude, I like the scalability / flexibility. A little too fast when describing the FL formula though.
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!
Ty very much!!!
Could share that excel sheet
How about daily compound of 1 %?
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?
what about inflation?;)
your website is down
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