Calculate value of the items below. You can use your spreadsheet for time value of money.

a)A student wants to begin saving for a car in the future. To save for the down payment he will invest $1,040 at the end of each year ($20 per week) for the next 3 years. The interest rate is estimated at 10%. What is the future value?

b)You were fortunate enough to have family money of $50,000 given to you in which you invest. It will grow on an average of 12% interest for 8 years, but compounded semi-annually. What will your investment grow to?

c)After 20 years, some shares of stock originally purchased for $600 total were sold for $5,000 total. What was the yield on the investment?

d)A young family is buying their first house. If they borrowed $200,000 with a loan interest percentage of 4% and promised to repay the loan in 15 years. What is their payment amount annually? What would their payment be monthly?