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
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
You have full access to this solution. To save a copy with all formatting and attachments, use the button below.
For ready-to-submit work, please order a fresh solution below.





