4. You decide to take out a 30-year mortgage to buy the home of your dreams. The purchase price is $230,000. Using the proceeds from the sale of your existing home you will make a $80,000 down payment, which means you will be borrowing $150,000. (A) Big Sky Savings bank quotes you a fixed annual loan rate of 6.3 percent. What will your monthly payment be? (B) Now assume that the lender offers to reduce the interest rate .50\% if you pay one point upfront. What is the new payment? Use the RATE function to compute the APR on this loan. [Hint: the point paid is a cash flow which effectively reduces the loan proceeds by that amount. (C) Ignoring the time value of money, how long will you have to live in the house to make paying the point worthwhile