1 / 7

Management 3 Quantitative Methods

Management 3 Quantitative Methods. Quiz #6 Solution courtesy of Meena Tafazzoli. The Problem. A car dealer offers either 0% financing for 3 years or a $3,000 rebate on a $25,000 car.

eden
Download Presentation

Management 3 Quantitative Methods

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Management 3Quantitative Methods Quiz #6 Solution courtesy of Meena Tafazzoli

  2. The Problem A car dealer offers either 0% financing for 3 years or a $3,000 rebate on a $25,000 car. Assuming that you take the rebate (instead of the 0% financing) and can find a loan for 6% for 36 months, which deal gives you a smaller payment?

  3. My financing decision I want to buy a $25,000 car

  4. Finding the monthly payments on the loan (PLAN 2) Recall… PV (loan) = PV (loan payments) 22,000 = Loan payments * PVFA (r/12,t*12) r= 6% annual interest rate compounded monthly! t = 3 years So …… r /12= 0.06/12= 0.005 [1 point] t *12mt= 3*12 = 36 [1 point]

  5. The monthly payments on the loan (PLAN 2) 22,000 = Loan payments * PVFA Let’s do the PVFA first PVFA(r/12, t*12) = [ (1- (1+r/12)^(-t*12) ] / r = (1- 0.835645) / (.005) = 0.164355 / 0.005 = 32.87102

  6. The monthly payments on the loan (PLAN 2) 22,000 = Loan payment * PVFA $22,000 = Loan payment * 32.87102 $22,000 / 32.87102 = Loan payment Loan payment = $669.28 [2 points]

  7. ON EXCEL Monthly loan payments for plan 2 = PMT (rate, nper, pv) = PMT (.005, 36, 22000) =$669.28

More Related