Question #63882

How do I find the monthly payment for this question:

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.

Interest rate is 4.5%
Number of payments is 12
cost of altamonte facilities is $16,450.95

Expert's answer

Answer on Question#63882- Programming & Computer Science / Excel

How do I find the monthly payment for this question:

On the Loan worksheet, in cell C9, enter a PMT function to calculate the monthly payment for the Altamonte Springs 2018 facilities loan. Ensure that the function returns a positive value and set the references to cells B5 and B6 as absolute references.

Interest rate is 4.5%

Number of payments is 12

cost of altamonte facilities is 16,450.95Solution.excel=PMT(16,450.95 Solution. ```excel =-PMT(B5,5,B$6,B7)

```



https://www.assignmentexpert.com/

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

LATEST TUTORIALS
APPROVED BY CLIENTS