RHIM - 4322 * * Homework 4 - * The - Time -Value of 'NoneyI Please complete and show work in an excel spreadsheet following the Demo Exercise. Do transfer the financial data to the spreadsheet. No need to show the explanatory notes like what is being provided in. the Demo Exercise. If Submit the Homework spreadsheet using this filename "RHM4322-Last Name-Homework 4" 1 1. To what amount will $5,000, invested for 10 years at 10% compounded annually, accumulate? 1 2. What is the present value of $800 to be received 10 years from now, discounted back to the present at: 10%? ? I 3. How many years will $500 thke to grow to $1,039.50 if invested at 5% compounded annually? I 4. At what annual compound rate would $500 investment grow to $1,948.00in12 years? I 5. To pay for your child's education, you wish to deposit an equal amount of 3500 into the bank at the: end of ench month for the next 15 years. If the bank is willing to pay an annual interest of 6% which. is to be compotinded monthly, how much will you have accumulated at the end of 15 years? -1 1. 6. Mr. Bills. Preston purchased a now house for $80,000. Ho paid 520,000 dewn and agreed to pay the: rest over the next 25 years in equal monthly payments that includo principal payments plus 9% annual. compound interest on the unpald balance. What will these equal monthly payments be? 7