1. Suppose you deposit $20,000 in a savings account. After 210 days, you withdraw your funds. If the bank paid you $340 in interest for the 210-day period, what is your APY?
2. Suppose that the house of your dreams costs $1,200,000. You manage to scrap a 20 percent down payment. You borrow the rest from a bank. The terms of the loan are: ? 30 years ? 4.5 percent ? Monthly payments
a. Find the amount of each monthly payment.
b. Suppose you decide to sell the house after 12 years: (1) What is the loan balance at the end of 12 years? (2) What is the amount of your total payments over the 12 years? (3) What is the amount of your total principal payments over the 12 years? (4) What is the amount of your total interest payments over the 12 years?
c. Use Excel to set up an amortization table.