Ask Question
17 January, 06:08

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

+1
Answers (1)
  1. 17 January, 07:23
    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?
Find 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 you're in doubt about the correctness of the answers or there's no answer, then try to use the smart search and find answers to the similar questions.
Search for Other Answers