In: Finance
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?
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