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.
You want to borrow $94,000 from your local bank to buy a new sailboat
You want to borrow $94,000 from your local bank to buy a new sailboat. You can afford to make monthly payments of $1,900, but no more. Assuming monthly compounding, what is the highest rate you can afford on a 60-month APR loan? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places, e.g., 32.16.)
Upload Choose a File
Expert Solution
Computation of Interest Rate using Rate Function in Excel:
=rate(nper,pmt,-pv,fv)*12
Here,
Rate = Interest Rate = ?
Nper = 60
PMT = $1,900
PV = $94,000
FV = 0
Substituting the values in formula:
=rate(60,1900,-94000,0)*12
Rate or Interest Rate = 7.87%
So, highest rate you can afford on a 60-month APR loan is 7.87%.
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.
