Answered step by step
Verified Expert Solution
Question
1 Approved Answer
need help Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the APR is in
need help
Write a formula to calculate the monthly payment for a loan where the purchase price is in cell B5, the APR is in B3, and the number of years is in B4. O =PMT(B3/12,B4 12,-B5) O =-PMT(B5/12,B4 12,-B5) --PMT(B5 12,84/12,-B5) O =PMT(B3 12,14/12,-B5) Write a function to calculate the payment on a loan where the purchase price is in cell B10, the down payment is in cell B12, the APR is in B3, and the number of payments is in B4. O E-PMT(B3/12,B4,B10-B12) O =PMT(B3'12,B4,B10-B12) O =-PMT(B3' 12,B4 12,B10 12) O =-PMT(B3 12,B4/12,B12) Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started