Ask Question
BusinessBusiness
21 May, 01:14

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

+2
Answers (1)
  1. 21 May, 01:31
    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 the answers seem to be not correct or there’s no answer. Try a smart search to find answers to similar questions.
Search for Other Answers
You Might be Interested in
The velocity of money can best be described as A. the growth rate of the money supply. B. how quickly prices are increasing. C. the number of times each dollar in the money supply us used to buy goods and services included in GDP. D.
Answers (1)
An owner had a profit margin of 50,000 last year. She expects to receive $1,168,000 from sponsorship this year with no additional expenses. What is the estimated profit margin for the upcoming year?
Answers (1)
Which of the following is a potential drawback of the global area structure? A. It encourages fragmentation of the organization into highly autonomous entities. B. It is inconsistent with a localization strategy. C.
Answers (1)
What are 'sweeteners' in the context of fashion lines? A. high-priced special designs for a select few customers B. additional items designed to meet unexpected customer demand C. garments designed for teenagers and young people D.
Answers (2)
For a segmentation strategy to be successful, the customers in the segment must react similarly and positively to a firm's offering, corresponding to which of the following criteria for evaluating segment attractiveness?
Answers (1)
New Questions in Business
How can business owners attract qualified laborers and prevent employee turnover?
Answers (2)
On January 1, Kirk Corporation had total assets of $851,000. During the month, the following activities occurred: Kirk Corporation acquired equipment costing $6,100, promising to pay cash for it in 60 days.
Answers (1)
Antonio derives more utility from spending an additional dollar on boots than on gloves. We can assume that: a. the marginal utility per dollar spent on boots is greater than the marginal utility per dollar spent on gloves. b.
Answers (1)
Which profession is most likely to be concerned with the effect of supervisors management styles?
Answers (1)
The primary goals of inventory managers are to maintain a sufficient quantity of inventory to meet customers' needs, ensure inventory quality meets customers' expectations and company standards, and minimize the cost of acquiring and carrying an
Answers (1)
Home » Business » 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.
Sign Up Forgot Password?