Q: On the Loan worksheet in cell C9 enter PMT function to calculate the monthly payment for the Altamonte springs 2022 facilities loan. Ensure that the function returns a positive value and set the reference to cells B5 and B6 as absolute references.
ANSWER!! Click cell C9. On the Formulas tab, in the Function Library group, click Financial, scroll down, and then click PMT. In the Function Arguments dialog box, with the insertion point in the Rate box, type $B$5/12. Press TAB to select the Nper box. Type $B$6. Press TAB to select the Pv box. Type -B9. Click OK
*I saw many struggling like I was and couldn't add an answer myself sooo