Question

In: Finance

Jebron Lames is considering the purchase of a car, which will cost him $125,000.   He will...

  1. Jebron Lames is considering the purchase of a car, which will cost him $125,000.   He will borrow the entire purchase price and make monthly payments over the next five years. The first payment is due next month and the interest rate is 3.10%. He will owe $____ on the car immediately following the 23rd payment.

Solutions

Expert Solution

EMI = Loan / PVAF (r%., n)

PVAF (r%, n) = SUm [ PVF(r%, n) ]

PVF (r%, n) = 1 /(1+r)^n

r - Int Rate per month

n - No. of months

= $ 125,000 / PVAF (0.2583%, 60)

= $ 125000 / 55.5150

= $ 2251.65

Loan Amortization:

Month opening Bal Instalment Int Principal Repay Closing Bal
1 $ 1,25,000.00 $ 2,251.65 $ 322.92 $ 1,928.73 $ 1,23,071.27
2 $ 1,23,071.27 $ 2,251.65 $ 317.93 $ 1,933.71 $ 1,21,137.56
3 $ 1,21,137.56 $ 2,251.65 $ 312.94 $ 1,938.71 $ 1,19,198.85
4 $ 1,19,198.85 $ 2,251.65 $ 307.93 $ 1,943.72 $ 1,17,255.14
5 $ 1,17,255.14 $ 2,251.65 $ 302.91 $ 1,948.74 $ 1,15,306.40
6 $ 1,15,306.40 $ 2,251.65 $ 297.87 $ 1,953.77 $ 1,13,352.63
7 $ 1,13,352.63 $ 2,251.65 $ 292.83 $ 1,958.82 $ 1,11,393.81
8 $ 1,11,393.81 $ 2,251.65 $ 287.77 $ 1,963.88 $ 1,09,429.94
9 $ 1,09,429.94 $ 2,251.65 $ 282.69 $ 1,968.95 $ 1,07,460.98
10 $ 1,07,460.98 $ 2,251.65 $ 277.61 $ 1,974.04 $ 1,05,486.95
11 $ 1,05,486.95 $ 2,251.65 $ 272.51 $ 1,979.14 $ 1,03,507.81
12 $ 1,03,507.81 $ 2,251.65 $ 267.40 $ 1,984.25 $ 1,01,523.56
13 $ 1,01,523.56 $ 2,251.65 $ 262.27 $ 1,989.38 $    99,534.18
14 $    99,534.18 $ 2,251.65 $ 257.13 $ 1,994.52 $    97,539.67
15 $    97,539.67 $ 2,251.65 $ 251.98 $ 1,999.67 $    95,540.00
16 $    95,540.00 $ 2,251.65 $ 246.81 $ 2,004.83 $    93,535.16
17 $    93,535.16 $ 2,251.65 $ 241.63 $ 2,010.01 $    91,525.15
18 $    91,525.15 $ 2,251.65 $ 236.44 $ 2,015.21 $    89,509.95
19 $    89,509.95 $ 2,251.65 $ 231.23 $ 2,020.41 $    87,489.53
20 $    87,489.53 $ 2,251.65 $ 226.01 $ 2,025.63 $    85,463.90
21 $    85,463.90 $ 2,251.65 $ 220.78 $ 2,030.86 $    83,433.04
22 $    83,433.04 $ 2,251.65 $ 215.54 $ 2,036.11 $    81,396.93
23 $    81,396.93 $ 2,251.65 $ 210.28 $ 2,041.37 $    79,355.56
24 $    79,355.56 $ 2,251.65 $ 205.00 $ 2,046.64 $    77,308.92
25 $    77,308.92 $ 2,251.65 $ 199.71 $ 2,051.93 $    75,256.99
26 $    75,256.99 $ 2,251.65 $ 194.41 $ 2,057.23 $    73,199.75
27 $    73,199.75 $ 2,251.65 $ 189.10 $ 2,062.55 $    71,137.21
28 $    71,137.21 $ 2,251.65 $ 183.77 $ 2,067.87 $    69,069.33
29 $    69,069.33 $ 2,251.65 $ 178.43 $ 2,073.22 $    66,996.12
30 $    66,996.12 $ 2,251.65 $ 173.07 $ 2,078.57 $    64,917.55
31 $    64,917.55 $ 2,251.65 $ 167.70 $ 2,083.94 $    62,833.60
32 $    62,833.60 $ 2,251.65 $ 162.32 $ 2,089.33 $    60,744.28
33 $    60,744.28 $ 2,251.65 $ 156.92 $ 2,094.72 $    58,649.56
34 $    58,649.56 $ 2,251.65 $ 151.51 $ 2,100.13 $    56,549.42
35 $    56,549.42 $ 2,251.65 $ 146.09 $ 2,105.56 $    54,443.86
36 $    54,443.86 $ 2,251.65 $ 140.65 $ 2,111.00 $    52,332.86
37 $    52,332.86 $ 2,251.65 $ 135.19 $ 2,116.45 $    50,216.41
38 $    50,216.41 $ 2,251.65 $ 129.73 $ 2,121.92 $    48,094.49
39 $    48,094.49 $ 2,251.65 $ 124.24 $ 2,127.40 $    45,967.09
40 $    45,967.09 $ 2,251.65 $ 118.75 $ 2,132.90 $    43,834.19
41 $    43,834.19 $ 2,251.65 $ 113.24 $ 2,138.41 $    41,695.79
42 $    41,695.79 $ 2,251.65 $ 107.71 $ 2,143.93 $    39,551.85
43 $    39,551.85 $ 2,251.65 $ 102.18 $ 2,149.47 $    37,402.38
44 $    37,402.38 $ 2,251.65 $    96.62 $ 2,155.02 $    35,247.36
45 $    35,247.36 $ 2,251.65 $    91.06 $ 2,160.59

Related Solutions

You buy a car, which cost $100.000. The purchase can be financed with a payment of...
You buy a car, which cost $100.000. The purchase can be financed with a payment of 20% and the remaining 80% is covered by an 8-year annuity loan. The loan bears interest rate of 3% p.a., and it has monthly terms in the following you therefore also apply a discount rate of 3% p.a. a) Determine the size of the payment, U, and the monthly payment, Y, belonging to the loan. You consider if it is realistic to sell the...
You buy a car, which cost $320.000. The purchase can be financed with a payment of...
You buy a car, which cost $320.000. The purchase can be financed with a payment of 20% and the remaining 80% is covered by an 8-year annuity loan. The loan bears interest rate of 3% p.a., and it has monthly terms in the following you therefore also apply a discount rate of 3% p.a. a) Determine the size of the payment, U, and the monthly payment, Y, belonging to the loan. You consider if it is realistic to sell the...
You buy a car, which cost $320.000. The purchase can be financed with a payment of...
You buy a car, which cost $320.000. The purchase can be financed with a payment of 20% and the remaining 80% is covered by an 8-year annuity loan. The loan bears interest rate of 3% p.a., and it has monthly terms in the following you therefore also apply a discount rate of 3% p.a. ------------------------------------------------------------------------------------------------------------------------------------------------- >>>>>>>>>>>>>>>>>>>>>>>NOTE: I only need help with question e) and f) :)<<<<<<<<<<<<<<<<<<< ------------------------------------------------------------------------------------------------------------------------------------------------- a) Determine the size of the payment, U, and the monthly payment, Y,...
Ziggy is considering purchasing a new car. The cash purchase price for the car is $47913....
Ziggy is considering purchasing a new car. The cash purchase price for the car is $47913. What is the annual interest rate if Ziggy is required to make annual payments of $12000 at the end of the next five years? Use Factor Table. 8%. 11%. 6%. 10%.
You are considering buying a new car for $37,000. If you purchase the car you will...
You are considering buying a new car for $37,000. If you purchase the car you will pay $7,000 of the purchase price as a down payment. Below are two options to choose from. Option 1: Pay off the amount borrowed to purchase the car with a 5 year loan, and the annual percentage rate (APR) will be 0%. Option 2: Receive a $2,000 instant rebate. This will lower your loan amount. Pay off the amount borrowed to purchase the car...
You are considering buying a new car for $37,000. If you purchase the car you will...
You are considering buying a new car for $37,000. If you purchase the car you will pay $7,000 of the purchase price as a down payment. Below are two options to choose from. Option 1: Pay off the amount borrowed to purchase the car with a 5 year loan, and the annual percentage rate (APR) will be 0%. Option 2: Receive a $2,000 instant rebate. This will lower your loan amount. Pay off the amount borrowed to purchase the car...
Tom is trying to enter the used car business. He knows that Jean-Ralphio will sell him...
Tom is trying to enter the used car business. He knows that Jean-Ralphio will sell him a car that needs repairs. Once repaired, Tom can sell it for $100 more than he spent to purchase it. Further, he knows that each car has an 80% chance of being a good car, and a 20% chance of being a bad car. Good cars only cost $20 to repair, but bad cars cost $200 to repair. Mona-Lisa decides to sweeten the deal...
A friend proposes to him to invest in a business for which he has projected the...
A friend proposes to him to invest in a business for which he has projected the following costs and income: 1. Initial cost of $ 100 0002. Expenditure in year 1 of $ 50 0003. Annual expenses from year 2 to 10 of $ 10 000. Additionally he projects that from In year 4, these expenses will increase by $ 2,000 each year. 4. Annual income of $ 40,000 from year 1 to 10. Additionally, it projects that from year...
Veridian Dynamics is considering the purchase of a new cloning machine, which will cost $390 million...
Veridian Dynamics is considering the purchase of a new cloning machine, which will cost $390 million plus an additional $10 million to ship and install. The new machine will replace the existing machine, which has zero book value and could be sold today for $40 million. The new machine will have a 4 year useful life and willl be depreciated to zero using the straight line method. The machine will require $10 million worth of spare parts to be purchased...
Ravi Shankar plans to purchase a car for $62,800 and he has $8,200 as a down...
Ravi Shankar plans to purchase a car for $62,800 and he has $8,200 as a down payment.  He will need to borrow the rest and plans to get a loan for 3 years at 3.90%. His monthly payments on the loan will be closest to: A. $1,609.58. B. $1,432.13. C. $1,250.53.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT