Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / Mortgages have an APR (annual percentage rate—a stated rate) of 3

Mortgages have an APR (annual percentage rate—a stated rate) of 3

Finance

Mortgages have an APR (annual percentage rate—a stated rate) of 3.84% on fixed-interest-rate loans. Payments and compounding are monthly.

 

  1. What is the periodic (effective) monthly rate?
  2. You wish to take out a 30-year, fixed-rate mortgage. You can afford monthly payments of $3,800. Assume that fees are included in the loan. How much can you afford to borrow?

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Computation of Periodic (Effective) Monthly Rate:

Periodic (Effective) Annual Rate = (1+i/n)^n - 1

Here,

Stated interest Rate (APR) = 3.84% 

n = Number of Compounding Periods = 12 

Periodic (Effective) Annual Rate = (1+3.84%/12)^12 - 1 = 1.039083 - 1 = 0.039083 or 3.91%

Periodic (Effective) Monthly Rate = 3.91%/12 = 0.326%

 

Computation of Borrowed Amount using PV Function in Excel:

=-pv(rate,nper,pmt,fv)

Here,

PV = Borrowed Amount = ?

Rate =  3.84%/12

Nper = 30 years * 12 months = 360 months 

PMT = $3,800

FV = 0

Substituting the values in formula:

=-pv(3.84%/12,360,3800,0)

PV or Borrowed Amount = $811,554.26