Answer to Question #63882 in Excel for Samantha Wyszynski

Question #63882
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
Expert's answer
2016-12-09T02:56:09-0500
The answer to the question is available in the PDF file https://www.assignmentexpert.com/https://www.assignmentexpert.com/homework-answers/programming-answer-63882.pdf

Need a fast expert's response?

Submit order

and get a quick answer at the best price

for any assignment or question with DETAILED EXPLANATIONS!

Comments

Thank you Ash
06.11.23, 01:47

Thank you so much Ash. If it weren't for you taking the time for that correction I would've failed. Thank you for being you.

Lily
03.11.20, 22:08

Ash you are the BEST I have looked for this answer EVERYWHERE!!

Nikos
22.09.20, 22:51

I had 1 attempt left, much appreciated Ash!

AR
08.04.20, 09:36

Ash thanks !!!

Josh B.
12.04.19, 12:01

You solved one of life's very long questions!!! 3 hours long give or take! THANKS!!! lol

Jake Dunham
09.02.19, 23:55

ASH YOU LEGEND

Cris
06.12.18, 01:37

Thanks Ash!!

Ash
17.03.18, 03:43

THIS IS WroNG! 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.

Leave a comment

LATEST TUTORIALS
New on Blog
APPROVED BY CLIENTS