Question: Answer Question from picture. Please provide functions/excel sheet that are used. Thanks Problem 3: You need to borrow $200,000 to buy your new home. You
Answer Question from picture. Please provide functions/excel sheet that are used. Thanks

Problem 3: You need to borrow $200,000 to buy your new home. You decide to enter into a 30-year mortgage with your local bank, Rady Financial Services, at an Annual Percentage Rate (APR) of 3% and monthly payments. Your first monthly payment will occur 1 month from today. a) After two years of making payments, what is the total amount of interest you will have paid Rady Financial Services? (3 points) b) After two years of making payments, you notice that interest rates have fallen and you are considering refinancing the existing principal on your loan at the new lower rate. You learn that the total cost of refinancing will be $14,630. To what APR must have rates fallen in order to make renancing your loan at this new, lower rate a good idea? Provide the new APR rounded to the nearest tenth of a percent leg, 1.7% or 2.1%]. (3 points)
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
