Question

In: Accounting

Loan Amortization Schedule You purchase a fully loaded Honda Accord with an MSRP of $32,000 for...

Loan Amortization Schedule

You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. You pay the 3% tax of $810 up front and put down $5,000. The dealer offers a simple interest installment loan with an annual rate of 5% for 3 years. The projected resale value of the car after 2 years is $17,000.

  1. Compute the loan value and monthly loan payments. (10 pts)
  2. Create a monthly amortization schedule over the entire loan period. (10 pts)
  3. Compute total interest over the entire loan period. (5 pts)
  4. Compute the total cash outflow (tax, plus down payment, plus total monthly loan payments). (8 pts)
  5. Compute the amount you would net after selling the car at 2 years. (7 pts)
  6. Does the principal portion of the payment increase or decrease as the months progress? (5 pts)
  7. Does the interest portion of the payment increase or decrease as the months progress? (5 pts)

Please show all calculations and complete monthly amortization schedule.

Solutions

Expert Solution

Loan value and monthly repayments given below

Hond accord MSRP cost price $        27,000
TAX $              810
TOTAL AMOUNT $        27,810
upfront payment $          5,810
Loan value $        22,000
Simple interest 5%
EMI montly payment $           (659)

Amortization table given below

SNO Prinicpal at the beginning Interest EMI Month end pricnipal Prinicipal paid
1 $                               22,000.00 $           92 $       (659) $                         21,432 $                (568)
2 $                                     21,432 $           89 $       (659) $                         20,862 $                (570)
3 $                                     20,862 $           87 $       (659) $                         20,290 $                (572)
4 $                                     20,290 $           85 $       (659) $                         19,715 $                (575)
5 $                                     19,715 $           82 $       (659) $                         19,138 $                (577)
6 $                                     19,138 $           80 $       (659) $                         18,558 $                (580)
7 $                                     18,558 $           77 $       (659) $                         17,976 $                (582)
8 $                                     17,976 $           75 $       (659) $                         17,392 $                (584)
9 $                                     17,392 $           72 $       (659) $                         16,805 $                (587)
10 $                                     16,805 $           70 $       (659) $                         16,215 $                (589)
11 $                                     16,215 $           68 $       (659) $                         15,624 $                (592)
12 $                                     15,624 $           65 $       (659) $                         15,029 $                (594)
13 $                                     15,029 $           63 $       (659) $                         14,433 $                (597)
14 $                                     14,433 $           60 $       (659) $                         13,833 $                (599)
15 $                                     13,833 $           58 $       (659) $                         13,232 $                (602)
16 $                                     13,232 $           55 $       (659) $                         12,627 $                (604)
17 $                                     12,627 $           53 $       (659) $                         12,021 $                (607)
18 $                                     12,021 $           50 $       (659) $                         11,411 $                (609)
19 $                                     11,411 $           48 $       (659) $                         10,800 $                (612)
20 $                                     10,800 $           45 $       (659) $                         10,185 $                (614)
21 $                                     10,185 $           42 $       (659) $                            9,568 $                (617)
22 $                                       9,568 $           40 $       (659) $                            8,949 $                (619)
23 $                                       8,949 $           37 $       (659) $                            8,327 $                (622)
24 $                                       8,327 $           35 $       (659) $                            7,702 $                (625)
25 $                                       7,702 $           32 $       (659) $                            7,075 $                (627)
26 $                                       7,075 $           29 $       (659) $                            6,445 $                (630)
27 $                                       6,445 $           27 $       (659) $                            5,812 $                (633)
28 $                                       5,812 $           24 $       (659) $                            5,177 $                (635)
29 $                                       5,177 $           22 $       (659) $                            4,540 $                (638)
30 $                                       4,540 $           19 $       (659) $                            3,899 $                (640)
31 $                                       3,899 $           16 $       (659) $                            3,256 $                (643)
32 $                                       3,256 $           14 $       (659) $                            2,610 $                (646)
33 $                                       2,610 $           11 $       (659) $                            1,962 $                (648)
34 $                                       1,962 $             8 $       (659) $                            1,311 $                (651)
35 $                                       1,311 $             5 $       (659) $                               657 $                (654)
36 $                                           657 $             3 $       (659) $                                  (0) $                (657)

Total interest over the loan

$        27,000
TAX $              810
TOTAL AMOUNT $        27,810
A.Period $                36
upfront payment $          5,810
B.Loan value $        22,000
Simple interest 5%
c.EMI montly payment $     (659.36)
Total interest total amount paid -loan taken
AXC-B
659.36*36-22000
Total interest $        (1,737)

Total cashoutflow given below

Total cashoutlow
Ouflow during the beginning $     5,810
EMI Of 659 .36 paid for 36 months $   23,737
Total cashoutflow $   29,547

Amount if car is sold in 2 years

Ouflow during the beginning $     5,810
EMI Of 659 .36 paid for 24 months $   15,825
Prinicpal balance to be paid $     7,702
Total cashoutlow $   29,337
Sale of Car $   17,000
Cashoutflow if the car is sold in 2 years $   12,337

Prinicipal portion of the payment increase over the month progress as given in the amortization schedule


Interestl portion of the payment Decrease over the month progress as given in the amortization schedule

SN

Related Solutions

You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. You pay...
You purchase a fully loaded Honda Accord with an MSRP of $32,000 for $27,000. You pay the 3% tax of $810 up front and put down $5,000. The dealer offers a simple interest installment loan with an annual rate of 5% for 3 years. The projected resale value of the car after 2 years is $17,000. Compute the loan value and monthly loan payments. Create a monthly amortization schedule over the entire loan period. Compute total interest over the entire...
a. Complete an amortization schedule for a $32,000 loan to be repaid in equal installments at...
a. Complete an amortization schedule for a $32,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 10% compounded annually. If an amount is zero, enter "0". Do not round intermediate calculations. Round your answers to the nearest cent. b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Do not round intermediate calculations. Round your answers to two...
AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal...
AMORTIZATION SCHEDULE a. Complete an amortization schedule for a $25,000 loan to be repaid in equal installments at the end of each of the next three years. The interest rate is 8% compounded annually. Round all answers to the nearest cent. Beginning Repayment Ending Year Balance Payment Interest of Principal Balance 1 $ $ $ $ $ 2 3 b. What percentage of the payment represents interest and what percentage represents principal for each of the three years? Round all...
You purchased a new 2020 Honda Accord. You borrowed $30,710 to make the purchase. A bank...
You purchased a new 2020 Honda Accord. You borrowed $30,710 to make the purchase. A bank lends you the money at an annual fixed interest rate of 3.75% for 5 years. The terms of the amortization loan include making monthly payments. Build the loan amortization schedule in Excel
Amortization schedule Set up an amortization schedule for a $36,000 loan to be repaid in equal...
Amortization schedule Set up an amortization schedule for a $36,000 loan to be repaid in equal installments at the end of each of the next 3 years. The interest rate is 6% compounded annually. Round all answers to the nearest cent. Beginning Remaining Year Balance Payment Balance 1 $   $   $   2 $   $   $   3 $   $   $   What percentage of the payment represents interest and what percentage represents principal for each of the 3 years? Round all answers...
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two...
Finance- Amortization Schedule Create the amortization schedule for a loan of $5,000, paid monthly over two years using an 8 percent APR.
Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly...
Problem 5-50 Amortization Schedule (LG9) Create the amortization schedule for a loan of $4,300, paid monthly over two years using an 9 percent APR. (Round your answers to 2 decimal places.)       Month   Beginning Balance   Total Payment   Interest Paid   Principal Paid   Ending Balance 1                               2                               3                               4                               5                               6                               7  ...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly...
Problem 5-49 Amortization Schedule (LG9) Create the amortization schedule for a loan of $14,000, paid monthly over three years using a 9 percent APR. (Round your answers to 2 decimal places.)    Month Beginning Balance Total Payment Interest Paid Principal Paid Ending Balance 1                2                3                4                5                6                7...
Amortization Schedule You will be creating an amortization schedule for a house on the market. To...
Amortization Schedule You will be creating an amortization schedule for a house on the market. To do so, you will need the principal amount, the interest rate, and the amount of years you will borrow the loan. The amount you put as a down payment is up to you, but it can range from a minimum of 3.5% for an FHA loan or 5% for a traditional loan to a maximum of whatever. Traditionally you only need to go as...
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid...
Create a loan amortization schedule in excell for a $27,000 car loan that will be repaid over 48 months at an annual interest rate of 6%. What is your monthly payment? _$_ What is the total dollar amount of payments made over the life of this loan? $____ What is the total dollar amount of interest paid over the life of this loan? $___________ How many months will it take to pay off the loan if you pay an extra...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT