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.

After a long confinement period, you are looking for a tour around the world

Finance Apr 01, 2021

After a long confinement period, you are looking for a tour around the world. To finance yo dream, the bank Take It For Granted offers you a $58,600 loan in the form of a 60-month fix payment at an annual rate of 52%. 
(a) Compute what the monthly payment will be. 
(6 mar 
 

Expert Solution

Computation of Monthly Payment using PMT Function in Excel:

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

Here,

PMT = Monthly Payment = ?

Rate = 5.2%/12 

Nper = 60 months

PV = $58,600
FV = 0

Substituting the values in formula:

=pmt(5.2%/12,60,-58600,0)

PMT or Monthly Payment = $1,111.23

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