Question: Write a function to calculate the payment on a loan where the purchase price is in cell B 1 0 , the down payment is

Write a function to calculate the payment on a loan where the purchase price is in cell B10, the down payment is in cell B12, the APR is in B3, and the number of payments is in B4.
Group of answer choices
=-PMT(B3*12,B4/12,B12)
=-PMT(B3/12,B4,B10-B12)
=-PMT(B3*12,B4*12,B10*12)
=PMT(B3*12,B4,B10-B12)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!