Question

You are planning to buy 2019 MINI Cooper on a loan. Price of the car is $26,000. You are planning to make monthly payments for two years and your bank says they can offer the annual interest rate of 12%, compounded monthly. The first payment starts at the end of the first month. How much is your monthly payment?

Answer 1

Answer:

$1,223.91

Explanation:

As per the concept of time value of money, the value of money today is more than the value of money tomorrow.

Given:

Price of car = $26,000

Interest rate 12%, compounded monthly

Tenure = 2 years

Now, Price of the car is the value of money today to purchase the car. So, while computing the monthly payment for car $26,000 will be considered as present value.

Monthly payment for car can be computed easily using Microsoft excel.

Use the following mentioned formula to calculate the monthly payment.

"=PMT(rate,nper,pv,[fv])"

wherein,

Rate = 12%/2 (because it has been compounded monthly)

nper = 2*12 (because 2 years are to be compounded monthly.)

Pv = $26,000 (as mentioned earlier)

Since, there is no Fv so it blank.