Loan 1: $200,000 at 4.5% for 30 years, monthly payments, and no origination cost. APR = 4.80%Loan 2: $200,000 at 4.25% for 30 years, monthly payments, and no origination cost.What is the discount point charged on Loan 1 assuming there is no cost associated with the origination?How many points must be charged on the 2nd loan to equalize the APR on the two loans?Please show how to solve using an excel spreadsheet

ABCD1Loan2,000,0002,000,0002,000,0002years3030303Months360=B2*12360=C2*12360=D2*124APR4.80%4.50%4.25…

Answered: Loan 1: $200,000 at 4.5% for 30 years,…

7th Edition

ISBN:9780357033609

Author:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Publisher:Randall Billingsley, Lawrence J. Gitman, Michael D. Joehnk

Chapter7: Using Consumer Loans

Section: Chapter Questions

Problem 6FPE

Related questions

Question

Loan 1: $200,000 at 4.5% for 30 years, monthly payments, and no origination cost. APR = 4.80%
Loan 2: $200,000 at 4.25% for 30 years, monthly payments, and no origination cost.

What is the discount point charged on Loan 1 assuming there is no cost associated with the origination?
How many points must be charged on the 2^nd loan to equalize the APR on the two loans?

Please show how to solve using an excel spreadsheet

Expert Solution