Complete on an EXCEL spreadsheet and submit to HUSKYCT. 1. You have decided to retire. You would like to receive equal retirement payments each year for the next 10 years. You want to receive your rst retirement payment in one year. You currently have $1,500,000 of savings. You expect to receive another $1,500,000 in 5 years. You can earn 10 percent interest compounded annually on your savings. How large will your annual retirement payment be? 2. What is the present value of receiving $1500 per year for 6 years? Your annual required rate of return is 10%. 3. What is the Annual Percentage Rate (APR) if the E'ective Annual Rate (EAR) is 10% and your money is compounded semi-annually? 4. You take out a $150,000 ve-year loan with annual payments. You will pay 10% interest compounded annually. How much will your annual payments be? How much total interest will you pay? 5. You want to buy a car in ve years and a boat in ten years. Today, the car and boat cost $5,000 and $10,000, respectively. The price of the boat and car will grow by 4% each year. How much money do you need to put away each year (equal payments at the end of the year} for the next three years, to have enough money saved to buy the boat and car? You will receive 10% interest compounded annually. 6. How much money will you have in three years, if you deposit $1,000 today and $1,000 in one and one-half years (1 V2). You earn 10% interest compounded semi-annually