Discover the answers to your questions at Westonci.ca, where experts share their knowledge and insights with you. Experience the ease of finding accurate answers to your questions from a knowledgeable community of professionals. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts.

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


Sagot :

We hope our answers were useful. Return anytime for more information and answers to any other questions you have. Thanks for using our service. We're always here to provide accurate and up-to-date answers to all your queries. Discover more at Westonci.ca. Return for the latest expert answers and updates on various topics.