Ask Question
18 January, 08:13

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

+3
Answers (1)
  1. 18 January, 11:24
    0
    on an excel spreadsheet you have the following values:

    n = 12 interest rate = 4.5% principal = $16,450.95

    since I don't know which values correspond to B5 and B6, I will guess that they are n and interest rate.

    =PMT (4.5%,12,-16450.95) or = PMT ($B$5,$B$6,-16450.95)

    = $1,804.11

    *The $ sets the cell as absolute reference. If you input 16450.95, the value will be negative.
Know the Answer?
Not Sure About the Answer?
Get an answer to your question ✅ “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 ...” in 📙 Business if there is no answer or all answers are wrong, use a search bar and try to find the answer among similar questions.
Search for Other Answers