Trusted by Students Everywhere
Why Choose Us?
0% AI Guarantee

Human-written only.

24/7 Support

Anytime, anywhere.

Plagiarism Free

100% Original.

Expert Tutors

Masters & PhDs.

100% Confidential

Your privacy matters.

On-Time Delivery

Never miss a deadline.

Derek decides to buy a new car

Finance Sep 16, 2020

Derek decides to buy a new car. The dealership offers him a choice of paying $500.00 per month for 5 years (with the first payment due next month) or paying some $28,022.00 today. He can borrow money from his bank to buy the car. What interest rate makes him indifferent between the two options?

Expert Solution

We can calculate the interest rate by using the following formula in excel:-

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

Here,

Rate = Interest rate (monthly)

Nper = 5*12 = 60 periods (monthly)

Pmt = $500

PV = $28,022

FV = $0

Substituting the values in formula:

= rate(60,500,-28022,0)

= 0.23%

Interest rate = Rate * 12

= 0.23% * 12

= 2.72%

Archived Solution
Unlocked Solution

You have full access to this solution. To save a copy with all formatting and attachments, use the button below.

Already a member? Sign In
Important Note: This solution is from our archive and has been purchased by others. Submitting it as-is may trigger plagiarism detection. Use it for reference only.

For ready-to-submit work, please order a fresh solution below.

Or get 100% fresh solution
Get Custom Quote
Secure Payment