Question

Katie's Dinor spent $84,000 to refurbish its current facility. The firm borrowed 80 percent of the refurbishment cost at 9.2 percent interest for 5 years. What is the amount of each monthly payment?

Answer 1

Answer:

The question is missing the below options:

$1,333.33

$1,401.49

$1,108.91

$1,282.16

$1,487.06

Monthly payment is $1,401.49  as shown below

Explanation:

In calculating the amount of each monthly payment, PMT formula in excel comes very handy.The formula is stated below:

PMT(rate,nper,pv,-fv)

The rate is the percentage of interest payable on the loan considering that repayment is made monthly, hence the rate in this case 9.2% divided by number of repayments in a year,12

rate=9.2%/12=0.007666667

nper is the number of times repayment would be made, which is calculated as five years multiplied by the number of repayments in a year i.e 5*12=60

pv is the actual amount borrowed , 80%*$84000=$67200

The fv future value is nil

PMT(0.007666667 ,60,67200,0)

PMT=$1,401.49

Find attached as well.

Download xlsx