In: Finance
A borrower is interested in comparing the monthly payments on two otherwise equivalent 30 year FRMs. Both loans are for $100,000 and have a 3.35% interest rate. Loan 1 is fully amortizing, where as Loan 2 has negative amortization with a $120,000 balloon payment due at the end of the life of the loan. How much higher is the monthly payment on loan 1 versus loan 2? (Hint: calculate both payments and take the difference. Only the future values of the loans are different. Round your answer to two decimal places.)
Please refer to below spreadsheet for calculation and answer. Cell reference also provided.
Cell reference -