Question

In: Finance

After careful comparison shopping, Isabella Green decides to buy a new Toyota Camry. With some options...

After careful comparison shopping, Isabella Green decides to buy a new Toyota Camry. With some options added, the car has a price of $30,000 - including plates and taxes. Because she can't afford to pay cash for the car, she will use some savings and her old car as a trade-in to put down $8,500. She plans to finance the rest with a $21,500, 48-month loan at a simple interest rate of 9 percent.

What will her monthly payments be? Round the answer to the nearest cent.

$ ________per month

How much total interest will Isabella pay in the first year of the loan? Round the answer to the nearest cent.

$ _________

How much interest will Isabella pay over the full (48-month) life of the loan? Round the answer to the nearest cent.

$ __________

What is the APR on this loan? Round the answer to 1 decimal place.

___________%

Solutions

Expert Solution

Sol:

Given details,

Finance amount (P) = $ 21,500

Tenure of Loan (N) = 48 Months i.e 4 Years

Rate of interest (R) = 9% Per Annum i.e 9/12 = 0.75% or (0.0075) per month

Interest is Simple interest P.A.

i) Monthly Payment is

EMI calculation = [P x R x (1+R) ^n] / [(1+R)^ n-1]

= [$ 21500 x 0.0075] x (1+0.0075)48 / (1+0.0075)48 -1

= $ 161.25 x 1.4314 / (1.4314 -1 )

= $ 161.25 x 3.3180

= $ 535 ( rounded off 535.03) is Monthly payment.

ii)

Bifurcation of Interest and Principal :

Month 1 :

Loan amount $ 21500

Interest for 1st Month = $21500 x 0.0075

= $ 161 ( Round off 161.25 )

Principal for 1st Month = $ 535 - $ 161

= $ 374

Out standing loan amount at end of 1st month = $21500 - $ 374

= $ 21126

Note : Repeat the same calculation for next 11 months

Here I am giving a table for all the 11 months calculation.

Breakup of EMI payment of 1st Year Amount in $

Month Pricipal (A) Interest (B) Monthly Payment
(A+B)
Balance Loan
1 374 161 535 21126
2 377 158 535 20750
3 379 156 535 20370
4 382 153 535 19988
5 385 150 535 19603
6 388 147 535 19215
7 391 144 535 18824
8 394 141 535 18430
9 397 138 535 18033
10 400 135 535 17634
11 403 132 535 17231
12 406 129 535 16825
Total 4676 1744 6420

For the 1st year of loan Isabella have to pay $ 1744 .

iii)

Note: Here i am providing full table calculated answer

Month Pricipal (A) Interest (B) Monthly Payment
(A+B)
Balance Loan
1 374 161 535 21126
2 377 158 535 20750
3 379 156 535 20370
4 382 153 535 19988
5 385 150 535 19603
6 388 147 535 19215
7 391 144 535 18824
8 394 141 535 18430
9 397 138 535 18033
10 400 135 535 17634
11 403 132 535 17231
12 406 129 535 16825
Total 4676 1744 6420
13 409 126 535 16416
14 412 123 535 16004
15 415 120 535 15589
16 418 117 535 15171
17 421 114 535 14750
18 424 111 535 14325
19 428 107 535 13898
20 431 104 535 13467
21 434 101 535 13033
22 437 98 535 12596
23 441 94 535 12155
24 444 91 535 11711
Total 5114 1306 6420
25 447 88 535 11264
26 451 84 535 10814
27 454 81 535 10360
28 457 78 535 9902
29 461 74 535 9442
30 464 71 535 8977
31 468 67 535 8510
32 471 64 535 8038
33 475 60 535 7564
34 478 57 535 7085
35 482 53 535 6604
36 486 50 535 6118
Total 5594 827 6420
37 489 46 535 5629
38 493 42 535 5136
39 497 39 535 4640
40 500 35 535 4139
41 504 31 535 3635
42 508 27 535 3128
43 512 23 535 2616
44 515 20 535 2101
45 519 16 535 1581
46 523 12 535 1058
47 527 8 535 531
48 531 4 535 0
Total 6118 303 6420

Total Interest for 4 years is 1744+1306+827+303 = $ 4180 (Rounded off)

iv)

APR on this Loan

APR = [(Interest/Principal/n​​)×365]×100

where:

Interest=Total interest paid over life of the loan

Principal=Loan amount

n=Number of days in loan term​

APR = [4180 / 21500 /4*365] *365 *100

= 0.00013316 x 365 x 100

APR = 4.86 %

Assume 365 days in a year for all 4 years of Loan period.

___________________________***THE END***__________________________


Related Solutions

Financial Planning Exercise 8 Calculating payments, interest, and APR on auto loan After careful comparison shopping,...
Financial Planning Exercise 8 Calculating payments, interest, and APR on auto loan After careful comparison shopping, Isabella Green decides to buy a new Toyota Camry. With some options added, the car has a price of $22,500 - including plates and taxes. Because she can't afford to pay cash for the car, she will use some savings and her old car as a trade-in to put down $7,500. She plans to finance the rest with a $15,000, 60-month loan at a...
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%...
An analyst is trying to determine the capital structure for Big Dawg Incorporated. After some careful...
An analyst is trying to determine the capital structure for Big Dawg Incorporated. After some careful research, the analyst knows the following: --Big Dawg has 1.94 million shares of common stock trading today at $19.13 per share. The book value of Big Dawg common stock is $15.00 million. The cost of equity for the firm is estimated to be 16.00%. --Big Dawg has $9.00 million in long-term debt on its balance sheet. The debt is trading at 92.00% of face...
You just got to the register at JCrew after shopping for a new wardrobe. After ringing...
You just got to the register at JCrew after shopping for a new wardrobe. After ringing up all your items the bill is $1,285. The cashier offers you 10% off if you open up a new credit card. The credit card has an APR of 28% (compounding is daily). You planned on making $50 monthly payments on your credit card which has an APR of 14%. How long will it take to pay off the credit card (assuming that is...
Loans - You need a new car and have decided to buy a Toyota Tundra. Fortunately,...
Loans - You need a new car and have decided to buy a Toyota Tundra. Fortunately, you have a great credit rating and you have your choice of financing. The cost is $26,000 out of the door. You have $3,000 to put down for a down payment. You have two finance options and need to decide which one is the best. Option 1 - You can choose 0% financing for 60 months. The loan amount is $23,000. a. What is...
A consumer electronics company is planning to introduce a new device. After careful consideration of costs,...
A consumer electronics company is planning to introduce a new device. After careful consideration of costs, (e.g., there is a fixed cost of $5 million for developing the item),  the projected state of the economy, etc., the marketing manager came up with the following payoff table (in $millions) Courses of action Event Market item Do not market item Introduction successful $50                 -$5 Introduction not successful -$40 -$5 Calculate the regret table below. SHOW ALL WORK TO GET FULL CREDIT. (6 pts.)...
You are the new cost accountant for ABX Corporation. After careful review of the company’s operations...
You are the new cost accountant for ABX Corporation. After careful review of the company’s operations you have been tasked to determine the company’s break-even point, the numbers sold to meet the company’s target profit and contribution income statement for both outcomes. Management has also asked that you provide the pros and cons for variable, traditional and activity-based costing method. After providing the pros and cons of each method recommend one method for the company’s use and support your discussion....
You are interested to invest some money in the stock market, after careful research you have...
You are interested to invest some money in the stock market, after careful research you have short-listed Stock X and Stock Y as your potential purchase. Stock X is currently selling at $250 with an expected dividend of $15 and constant growth rate of 7%, while Stock Y is a preferred stock, currently selling at $100 with a $8 dividend paid each year. The required rates of return for both stocks are 10%. Answer on the basis of valuation of...
Dylan Jones kept careful records of the fuel efficiency of his new car. After the first...
Dylan Jones kept careful records of the fuel efficiency of his new car. After the first seven times he filled up the tank, he found the mean was 20.9 miles per gallon (mpg) with a sample standard deviation of 0.7 mpg. Compute the 95% confidence interval for his mpg. (Use t Distribution Table.) (Round your answers to 3 decimal places.) confidence interval for is mpg ____ and _____. How many times should he fill his gas tank to obtain a...
Dylan Jones kept careful records of the fuel efficiency of his new car. After the first...
Dylan Jones kept careful records of the fuel efficiency of his new car. After the first eleven times he filled up the tank, he found the mean was 27.3 miles per gallon (mpg) with a sample standard deviation of 1.3 mpg. Compute the 95% confidence interval for his mpg. (Use t Distribution Table.) (Round your answers to 3 decimal places.) How many times should he fill his gas tank to obtain a margin of error below 0.15 mpg? (Use z...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT