Part 1: 10 concepts from Reading Chapter 9 "Obtaining Affordable Housing" (25 points possible) Please read Chapter 9. Like Chapter 8, this chapter deals with important decisions you will make throughout your life and can have a large impact on your long-term financial situation. After reading the chapter, describe the ten concepts that you found most interesting and relevant to you. Please make sure you include a brief explanation for why each of these concepts was interesting or relevant for you. IMPORTANT: Listing 10 concepts with no explanation of why they are interesting or relevant to you earns O points. Full 25 points credit will be earned only if you also include a brief explanation for why each of these concepts was interesting or relevant for you. Part 2: Analyze a home purchase for $550,000 using a $475,000 mortgage (50 points possible) #1 (10 points): Assume you obtain a fixed-rate mortgage like the example in the "Affordable Housing video. Assume the loan amount is $475,000. Assume it is a 30-year loan. It has a 4.75% APR. How much is your monthly payment? (Hint: You can use the "Excel PMT function spreadsheet. If your answer is more than $3,000 you've made a mistake.) #2 (10 points): At the end of 30 years, when you make your last monthly payment and your mortgage is paid off, what is the total amount (in S) that you will have paid in interest? (Hint: You will have made 360 payments. Multiply 360 by the monthly payment S amount you calculated in 11. Your total interest equals that number minus the amount of your loan.) #3 (10 points): Assume inflation is 3% per year. If the home you purchase today increases its value each year at the rate of inflation, what should the home you purchase today for $550,000 be worth in 30 years? (Hint: You can use the "Excel FV function spreadsheet. If your answer is less than $1 million you've made a mistake.) #4 (10 points): How much will you still owe on your mortgage at the end of the 42 month? Assume that the bank has received your monthly payment that month and credited it toward interest and principal appropriately. (Hint: You can use the "Amortization Schedule" spreadsheet. Make sure you're using the 42 month, not the 42" row of the spreadsheet! If your answer is more than $450,000 you've made a mistake) 5 (10 points): Suppose you made monthly payments of $3,000 each month. How many months would it take to pay off your loan? (Hint: You can use the "Excel NPER function spreadsheet. IMPORTANT: If you do this, make sure to tell the bank that you want the extra money you send in each month to pay down principal, not interest!)