Lindsay is 25 years old and has a new job in web development. She wants to make sure that she is financially sound by the age of 55, so she plans to invest the same amount into a retirement account at the end of every year for the next 30 years.

Construct a data table in Excel that will show Lindsay the balance of her retirement account for various levels of annual investment and return. If Lindsay invests $10,000 at return of 6%, what would be the balance at the end of 20th year in the account? If required, round your answers to two decimal places.

Please find the screenshot of the data table in the attachment. It show how future values will change with changes in invested amounts(PMT) . The future value increases with increase in recurring equal investment at 6% interest rate.

If Lindsay invests $10,000 every year at 6% interest rate, find the future balance in 20 years . You can use a financial calculator with the following inputs;

N = 20

PMT = -10,000

I = 6%

PV =0

then compute future value; CPT FV = $367,855.91

sohail09753 sohail09753 · Answer 2 · 2021-11-26T12:32:20+01:00

Future value is the financial value of today money to be expected in the future. It is determined taking into assumption the growth rate of money in accordance with the type of investment made.

If Lindsay invests $10,000 at a return of 6%, then his future value at the end of the 20th year will be $367,855.91.

As per the data table attached below it can be noticed or analyzed that as the value of the investment increases the future value also increase irrespective of the growth rate.

To know more about Future Value, refer to the link:

https://brainly.com/question/8286272