Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Refer to the below. You borrow $10,000 for 3 years. You are required to repay the amount in equal monthly repayments commencing in 1 month
Refer to the below.
You borrow $10,000 for 3 years. You are required to repay the amount in equal monthly repayments commencing in 1 month from today. If the interest rate is 7.2% compounding monthly, the formula that we can enter to cell B5 to calculate the amount of the repayment is:
Select one or more:
A. =PMT(B4/B2,B2*B3,-B1)
B. =PMT(B2/B3,B3*B4,-B1)
C. =PMT(B4/B2,B2*B3,-B1,0,1)
D. =PMT(B4/B2,B2*B3,-B1,1,0)
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