1. USE EXCEL AND MAKE SURE YOU DO NOT DO NUMBER #8 or #1.

Time Value of Money Exercise: Question 1: Assume you deposit $2,000 every three months at a 8 percent annual rate, compounded quarterly. How much will you have at the end of 15 years? Question 2: You borrow a five-year $10,000 loan with monthly pavments of $250. What is the annual percentage rate (APR) on the loan? Question 3: How much would you have to invest today to receive $40,000 in 10 years at 7.5 percent per year? Question 4: Ms. Nelson will receive $15,000 a year for the next 20 years from her retirement fund. If a 5 percent interest rate is applied, what is the current value of her retirement fund? Question 5: Assume you deposit $2,000 every six months at 10 percent compounded semi-annually, How much will you have at the end of 10 years? Question 6: If you need $20,000 for your son's education in 10 years, how much must you deposit at the money ready? each year in the bank earning 5 percent in order to have the college Question 7: If you have $10,000 in a savings account earning 10 percent, how large an annuty can you draw out each year if you want nothing left at the end of 7 years? Question-8. Youborrom $1,000 at a 10 percent annual rate to be repaid in 3 equal payments at the end of each of the next 3 years. How large is the total interest payment over the three years? Question 9: I invested $800,000 in a cattle ranch and I sold that ranch for $2,500,000 ten years later. What was my annual percentage rate return? Question 10: How much can I borrow for the purchase of my first home if I can afford to make monthly payments of $500, and the annual interest rate is 6 percent on a 30-yeqi mortgage