Use Microsoft Excel Spreadsheet to answer the following questions;

1) If you invest $900 in a bank in which it will earn 6.5% compounded semi-annually, how much will you have at the end of 7 years?

2) To buy a new house, you take out a 25-year mortgage for $300,000. Using Microsoft Excel, prepare an amortization table. The interest rate on your mortgage is 8 percent. Repayment on the mortgage is done monthly.