Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

You have reviewed your budget and determined that you can afford to pay $300 per

ID: 2791750 • Letter: Y

Question

You have reviewed your budget and determined that you can afford to pay $300 per month as a car payment. How much can you borrow if your credit is good and the interest rate is 4 percent using a 48 month loan? How much can you borrow if your credit is bad and the interest rate is 8 percent using the same loan term? In this example, if you have bad credit but the car you want requires that you borrow $13,250, how could the financing be changed to allow you to borrow more money without increasing your payment?

Explanation / Answer

when credit is good

FV = 0, rate = 4%/12 n = 48 pmt = 300

use PV function in Excel

amount to be borrowed = 13,286.65

when credit is bad, just replace rate = 8%/12

amount to be borrowed = 12,288.57

in the final case the number of months can be increased

PV = 13250 FV = 0 rate = 8/12 PMT = -300

use nper function inExcel

number of months = 52.49 months

Hire Me For All Your Tutoring Needs
Integrity-first tutoring: clear explanations, guidance, and feedback.
Drop an Email at
drjack9650@gmail.com
Chat Now And Get Quote