INSTRUCTION: Use Spreadsheet to answer the following questions; 1) If you invest $1,000,000 in a bank in which it will earn 8 percent compounded annually, how much will it be worth at the end of 7 years? 2) To buy a new house, you take out a 25-year mortgage for $28,000,000. Prepare an amortisation table if the interest rate on your mortgage is 8 percent. Spreadsheet to solve Amortisation Problems