# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.