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.

Explanation:

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

answer; ///blank(1); rate-buster; blank(2) systematic soldiering;

administrative jobs normally have someone answering phone calls and scheduling appointments, filing patient or customer information, making sure the front of the office looks nice to those who enter the building. administrative jobs can also include making sure the manager has everything they need for meetings, making delivers and much more. administrative jobs are important to most businesses as are customer service focused as they are often one of the first impressions a consumer sees of a business.