please complete and show work in an excel spreadsheet. do transfer the financial data to the spreadsheet.

1. To what amount will $5,000, invested for 10 years at 10% compounded annually, accumulate? 2. What is the present value of $800 to be received 10 years from now, discounted back to the present at 10%? 3. How many years will $500 take to grow to $1,039.50 if invested at 5% compounded annually? 4. At what annual compound rate would $500 investment grow to $1,948.00 in 12 years? 5. To pay for your child's education, you wish to deposit an equal amount of $500 into the bank at the end of each month for the next 15 years. If the bank is willing to pay an annual interest of 6% which is to be compounded monthly, how much will you have accumulated at the end of 15 years? 6. Mr. Bill S. Preston purchased a new house for $80,000. He paid $20,000 down and agreed to pay the rest over the next 25 years in equal monthly payments that include principal payments plus 9% annual compound interest on the unpaid balance. What will these equal monthly payments be