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
Thank you! Short, simple and sweet 😊
The most succinct explanation of this topic I've seen. Thank you!
Thank you very much!
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! 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.
Thank you very much, your an Absolute Legend 🙌
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!
Excellent exactly what I needed, thanks.
Glad it helped!
Excellent video, does exactly what I wanted.
Thank you!
You saved me, thank you!
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.
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?
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?
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. 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.
Ty very much!!!
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!
How about daily compound of 1 %?
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?
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
your website is down
what about inflation?;)
This formula is not accurate
orange is too hard to read