Answered

The manager of a manufacturing company knows that they will need a new machine in one of their factories. The new machine will cost them $12,500. The manager has determined that they can afford to pay 15% of the cost of the machine in cash. They can then finance the rest through a credit union. The credit union will charge 2% per year compounded monthly. How much are their monthly payments for 3 years

Answer :

Answer:

The monthly repayment is $304.33

Explanation:

The actual cost of the machine is $12,500,the amount to be paid monthly over 3 years is $12500-(15%*$12,500)=$10625

$10,625  is to be repaid over three years on monthly basis

We can use pmt formula in excel

=pmt(rate,nper,pv.fv)

rate is 2% per year to be divided by  12 months in order to arrive at monthly

2%/12=0.001666667

nper is 3 multiplied by 12 as there are twelve repayments in a year which is 36

PV is the present value of the loan which is $10,625

FV is the future which is zero

=pmt(0.001666667 ,36,-10,625,0)

=$304.33

"When The monthly repayment of Three years is $304.33 To understand the calculations, check below".

Calculation of Cost of the machine

When The actual cost of the machine is $12,500, the amount to be paid monthly over 3 years is $12500-(15%*$12,500) is =$10625

Then the $10,625 is to be repaid over three years on monthly basis We can use the PMT formula in excel

=pmt(rate,nper,pv.fv)

After that rate is 2% per year to be divided by 12 months to arrive at monthly

Then 2%/12=0.001666667

Now n-per is 3 multiplied by 12 as there are twelve repayments in a year which is 36

After that PV is the present value of the loan which is $10,625

Then The FV is the future which is zero

= pmt(0.001666667,36,-10,625,0)

Therefore, =$304.33

Find more information about Cost of the machine here:

https://brainly.com/question/26415931

Other Questions