help in homework

New User?

Fill This Form To Receive Instant Help

Help in Homework
trustpilot ratings
google ratings


Homework answers / question archive / You want to buy a car, and a local bank will lend you $30,000

You want to buy a car, and a local bank will lend you $30,000

Finance

You want to buy a car, and a local bank will lend you $30,000. The loan will be fully amortized over 4 years, and the nominal interest rate will be 6.5% with interest paid monthly. What will be the monthly loan payment? Answer with 2 decimals (ex. $1,000.00).

pur-new-sol

Purchase A New Answer

Custom new solution created by our subject matter experts

GET A QUOTE

Answer Preview

Computation of Monthly Payment using PMT Function in Excel:

=pmt(rate,nper,-pv,fv)

Here,

PMT = Monthly Loan Payment = ?

Rate = 6.5%/12 = 0.5417%

Nper = 4 years*12 months = 48 months

PV = $30,000

FV = 0

Substituting the values in formula:

=pmt(0.5417%,48,-30000,0)

PMT or Monthly Payment = $711.45

Sitejabber (5.0)

BBC (5.0)

Trustpilot (4.9)

Google (5.0)