(Total Marks: 13)Timothy Smith is looking to purchase a Mercedes Benz Roadster

Question # 00107160 Posted By: echo7 Updated on: 09/24/2015 07:44 PM Due on: 10/24/2015
Subject Business Topic General Business Tutorials:
Question
Dot Image

Q. 1 (Total Marks: 13)Timothy Smith is looking to purchase a Mercedes Benz Roadster, whichhas a total cost of $340,000. Timothy plans to deposit $130,000 and willpay the rest by taking on a 7.5% 5-year loan.

Required:

a) What is the monthly payment on this car loan?

b) Prepare an amortisation table.

c) What is the loan balance at the end of year 3?

(Round the numbers to the nearest $)

Dot Image
Tutorials for this Question
  1. Tutorial # 00101589 Posted By: echo7 Posted on: 09/24/2015 07:44 PM
    Puchased By: 3
    Tutorial Preview
    The solution of (Total Marks: 13)Timothy Smith is looking to purchase a Mercedes Benz Roadster...
    Attachments
    8781552.xlsx (16.74 KB)
    8781552.xlsx (16.74 KB)
    aaannnnssswwweerr_filllee.xlsx (16.74 KB)
    Recent Feedback
    Rated By Feedback Comments Rated On
    ama...avi Rating Diverse range of tutorials on all subjects 10/24/2015

Great! We have found the solution of this question!

Whatsapp Lisa