Answer to Question #296474 in Excel for Jasleen

Question #296474

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.


1
Expert's answer
2022-02-11T11:02:51-0500
=IF(PMT($B$5/12;10;$B$6)<0;PMT($B$5/12;10;$B$6)*-1;PMT($B$5/12;10;$B$6))

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!

Comments

No comments. Be the first!

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS