Question description:
This user has given permission to use the problem statement for this
blog.
If you invest $50 at the start of every year at 4% compounded annually, what is the value of the annuity at the end of 20 days?
Solved by A. W. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
19/07/2018 - 11:52
Hello, I hope you are having a good day. I am here to help with your question.
Excelchat Expert
19/07/2018 - 11:53
so just to clarify
Excelchat Expert
19/07/2018 - 11:53
did you mean If you invest $50 at the start of every year at 4% compounded annually, what is the value of the annuity at the end of 20 years?
Excelchat Expert
19/07/2018 - 11:54
Are you with me?
Excelchat Expert
19/07/2018 - 11:57
you calculate the final value using the formula for Future value
Excelchat Expert
19/07/2018 - 11:58
the formula is =FY(rate, number of periods, payment per period, present value, 0 - for end of the period 1 for beginning of the period
Excelchat Expert
19/07/2018 - 11:59
the value is calculated in B5
Excelchat Expert
19/07/2018 - 11:59
Are you with me?
Excelchat Expert
19/07/2018 - 11:59
In case you are experiencing technical difficulties, this chart will be available for you for your reference.
Excelchat Expert
19/07/2018 - 12:00
I hope I answered your question satisfactorily.
Excelchat Expert
19/07/2018 - 12:00
Have a fantastic day :)
Excelchat Expert
19/07/2018 - 12:02
they payment at beginning of the period is calculated in cell B7
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.