Question

In: Finance

Dr. Zoidberg decided to buy a 2019 Tesla Model S P100D Hatchback for $130,000. After paying...

Dr. Zoidberg decided to buy a 2019 Tesla Model S P100D Hatchback for $130,000. After paying a down payment and taxes, Dr. Zoidberg can finance the rest of the purchase price with a loan of 100,000 for 5 years at a promotional finance rate of 3% APR compounded quarterly. Please answer the following questions:

a. What is the effecting annual rate changed on this loan?

b. What would be the quarterly payment on this loan?

c. Dr. Zoidberg also discovers that instead of the special promotional rate he can make an additional down payment of $20,000 that would lower his loan amount accordingly (i.e. by $20,000). At what APR would Dr. Zoidberg have the same quarterly payment with this option as with the initial promotional rate of 3%?

d. Dr. Zoidberg finds that he can get 1.5% APR if he elects option (c). What will his quarterly payment be under this option? e. Now assume that that payment frequency changes to annual, preserving the same EAR. What is his payment now?

Solutions

Expert Solution

a]

Effective annual rate = (1 + (APR/n))n - 1

where n = number of compounding periods per year. This is 4, as the compounding is quarterly.

Effective annual rate = (1 + (3%/4))4 - 1

Effective annual rate = 3.03%

b]

Quarterly loan payment is calculated using PMT function in Excel :

rate = 3% / 4   (converting annual rate into Quarterly rate)

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pv = 100000 (loan amount)

PMT is calculated to be $5,403.06

c]

The quarterly rate to have the same quarterly payment is calculated using RATE function in Excel :

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pmt = -5403.06 (Quarterly payment. This is entered with a negative sign because it is a payment)

pv = 80000 (loan amount)

RATE is calculated to be 3.05%. This is the quarterly rate. To get APR, we multiply by 4.

APR = 12.21%

d]

Quarterly loan payment is calculated using PMT function in Excel :

rate = 1.5% / 4   (converting annual rate into Quarterly rate)

nper = 5*4 (5 year loan with 12 Quarterly payments each year)

pv = 80000 (loan amount)

PMT is calculated to be $4,159.37


Related Solutions

You borrow $90,000 to buy 2019 Tesla Model S, the annual interest rate is 6% and...
You borrow $90,000 to buy 2019 Tesla Model S, the annual interest rate is 6% and you have 5 years to pay off your loan with monthly payments. After 2 years you want to refinance the loan, how much do you still owe on the car? $54,371.73 $57,193.99 $62,295.11 $24,888.99 At a family gathering, your uncle hears that you are taking a finance course with many real life applications. He wants to consult you regarding a new house he likes...
Alset Motors is offering the 2019 Tesla Model S Sedan (basic model) for $79,900. You “wheel...
Alset Motors is offering the 2019 Tesla Model S Sedan (basic model) for $79,900. You “wheel and deal” and get the price down to $75,000 with no money down (100%-financing). The only difficulty is that the monthly payments on the 7.2%, six-year loan are at the beginning of the month. What is the monthly payment on this loan? How much of the first payment is interest and how much is principal? (label them) How much of the sixteenth payment is...
Mr. Brown wants to buy a Tesla Model S car, whose price is $100, 848. The...
Mr. Brown wants to buy a Tesla Model S car, whose price is $100, 848. The dealer offers a loan plan: $30, 000 down payment, $X at the end of year 1, year 2, year 3, and year 4. Assume the constant annual interest rate is 25%. (a) What is X? [Hint: you may want to use calculators.] (b) Suppose Mr. Brown accepts the offer. How much does Mr. Brown finance? (c) What is the principle payment at the end...
Prof. Finance decides to buy a 2019 Mazda 6 Signature Edition. After paying a down payment...
Prof. Finance decides to buy a 2019 Mazda 6 Signature Edition. After paying a down payment and taxes, Prof. Finance can finance the rest of the purchase price with a loan of $24,000 for 60 months at a special finance rate offered by Mazda of 1.9% APR compounded monthly. • He finds out that Mazda has a second offer of $1000 cash back (rebate) in place of the special 1.9% finance rate offered with the cash back being an additional...
You would like to buy Tesla Model 3 car. The car loan requires payments of $600...
You would like to buy Tesla Model 3 car. The car loan requires payments of $600 per month for the first year and payments of $800 per month during the second year and also payments of 1,200 per month during the third year. The APR is 24% and payments begin in one month. What is the present value of this 3-year loan?
Tesla’s product line current consists of the Model S sedan. Tesla is deciding whether to introduce...
Tesla’s product line current consists of the Model S sedan. Tesla is deciding whether to introduce the Model X SUV. If Tesla does introduce the Model X, it will sell 10,000 Model X annually in years 1-10 and 15,000 Model S annually in years 1-10. However, if Tesla does not introduce the Model X, it will sell 20,000 Model S annually in years 1-10. Moreover, Tesla can use its existing plant and equipment to produce the Model S. To manufacture...
Article: Anheuser-Busch Orders 40 Tesla Semi Trucks (Brewer hasn't yet decided whether to buy vehicles outright...
Article: Anheuser-Busch Orders 40 Tesla Semi Trucks (Brewer hasn't yet decided whether to buy vehicles outright or lease them as it seeks to cut fuel costs and vehicle emissions. Forget the Clydesdales. Anheuser-Busch has reserved 40 of Tesla Inc.’sTSLA -1.15% all-electric Semi trucks, as the maker of Budweiser seeks to reduce fuel costs and vehicle emissions. The U.S. subsidiary of Anheuser-Busch InBev BUD -2.22% NV plans to use the trucks for shipments to wholesalers within 150 to 200 miles of...
identify at least two distinct market segments for Tesla model S or X. Each market segment...
identify at least two distinct market segments for Tesla model S or X. Each market segment description must include at least three (more if needed) of the characteristics from amongst any of the four bases categories, e.g. one from demographic variables, one or two from psychographic variables, and one from behavioral variables, or a similar scheme. Be sure to explain your choices based on what customer need the product or service offering can fill for each segment.
Several years after graduation you decided to buy a condo for $235,000. a. Assuming you need...
Several years after graduation you decided to buy a condo for $235,000. a. Assuming you need a 15% down-payment which you have saved, what is the amount of the loan you need to borrow? b. Given your calculation in part a, what will your monthly mortgage payment be assuming a 30 years mortgage at 4.75%? c. What is the total amount you end up paying including principal and interest? d. For comparison purposes, you also look at a 15 year...
7. David Puddy is car shopping and plans to buy a 2019 Toyota Corolla. After making...
7. David Puddy is car shopping and plans to buy a 2019 Toyota Corolla. After making a down payment, David plans to borrow $21,000 from his bank. The bank offers 4-year (48-month) car loans. David’s budget allows him to pay $500 monthly (at the end of each month) for the car. What is the maximum monthly interest rate that David can accept to keep his monthly payments to no more than $500 per month? A. 6.70% B. 5.56% C. 0.56%...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT