In: Finance
Oppenheimer Bank is offering a 30-year mortgage with an APR of 5.06 % based on monthly compounding. With this mortgage your monthly payments would be $ 1 comma 972 per month. In addition, Oppenheimer Bank offers you the following deal: Instead of making the monthly payment of $ 1 comma 972 every month, you can make half the payment every two weeks (so that you will make 52 divided by 2 equals 26 payments per year). With this plan, how long will it take to pay off the mortgage if the EAR of the loan is unchanged? Note: Make sure to round all intermediate calculations to at least 8 decimal places.
SEE THE IMAGE. ANY DOUBTS, FEEL FREE TO ASK. THUMBS UP PLEASE
AS NOTHING WAS MENTIONED, SOLVED WITH EXCEL.