Question: 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,

 Write a function to calculate the payment on a loan where

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. O =PMT(B3 12,B4,B10-B12) O = PMT(B3 12,14 12,810*12) --PMT(B3*12,84/12.812) o --PMT(B3/12,B4,B10-B12) Question 10 2 pts Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the, the APR is in B13, and the number of years is in B14. O PMT(313/12,B14 12,-B5) = PMT(B5/12,B14-12,813) O=PMT(B13-12,B14/12-B5) 0 --PMT(B13/12,B14-12,85)

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 Accounting Questions!