You borrowed $20,000 to purchase a new car. The loan was for 4 years at a...

You borrowed $20,000 to purchase a new car. The loan was for 4 years at a nominal rate of 6% per year compunded monthly. You have been making equal monthly payments on the loan. You just made your 18th payment.

A) What is your monthly payment

B) How much of your first payment was interest? How much of your current (18th) payment is interest?

C) How much of the loan has been repaid immediately after the 18th payment?

D) Based on your answer to part c, determine the total interest paid during the first 18 payments.

Expert Solution

Amount borrowed	$20,000			Loan amortization table
Rate	0.50%	(6%/12)		Time	EMI	Interest	Principal	Beg Value
NPER	48	(4 x 12)		0				20000
EMI(Mothly payment)	$469.70		Ans A	1	$ 469.70	$ 100.00	$ 369.70	$ 19,630.30
	=PMT(0.5%,48,-20000)			2	$ 469.70	$ 98.15	$ 371.55	$ 19,258.75
				3	$ 469.70	$ 96.29	$ 373.41	$ 18,885.35
Interest in first payment	$100.00		Ans B	4	$ 469.70	$ 94.43	$ 375.27	$ 18,510.07
	=IPMT(0.5%,1,48,-20000)			5	$ 469.70	$ 92.55	$ 377.15	$ 18,132.92
				6	$ 469.70	$ 90.66	$ 379.04	$ 17,753.89
Interest in 18th payment	$67.29			7	$ 469.70	$ 88.77	$ 380.93	$ 17,372.96
	=IPMT(0.5%,18,48,-20000)			8	$ 469.70	$ 86.86	$ 382.84	$ 16,990.12
				9	$ 469.70	$ 84.95	$ 384.75	$ 16,605.37
loan paid till 18th payment	$ (6,945.12)			10	$ 469.70	$ 83.03	$ 386.67	$ 16,218.70
	=CUMPRINC(0.5%,48,20000,1,18,0)			11	$ 469.70	$ 81.09	$ 388.61	$ 15,830.09
				12	$ 469.70	$ 79.15	$ 390.55	$ 15,439.54
	$6,945.12		Ans C	13	$ 469.70	$ 77.20	$ 392.50	$ 15,047.04
				14	$ 469.70	$ 75.24	$ 394.46	$ 14,652.58
Total interest paid till 18th payment	$ (1,509.49)			15	$ 469.70	$ 73.26	$ 396.44	$ 14,256.14
	=CUMIPMT(0.5%,48,20000,1,18,0)			16	$ 469.70	$ 71.28	$ 398.42	$ 13,857.72
				17	$ 469.70	$ 69.29	$ 400.41	$ 13,457.31
	$1,509.49		Ans D	18	$ 469.70	$ 67.29	$ 402.41	$ 13,054.89
				Total		$ 1,509.49	$ 6,945.11

ekkarill92 answered 1 year ago

On 1/1/20, you purchase a new car for $20,000 with a 12% loan (note) payable monthly....

On 1/1/20, you purchase a new car for $20,000 with a 12% loan (note) payable monthly. Payments of principal and interest are made at the end of each month for the next 30 months. Create an effective interest amortization table in Excel for the entire life of the car loan payable using the following columns: payment number, payment date, beginning carrying value, effective interest rate, interest expense, cash (principal and interest paid), note payable (reduction of principal), and ending carrying...

If you accept a car loan of $20,000 for 5 years at an interest rate of...

If you accept a car loan of $20,000 for 5 years at an interest rate of 3%, what is the monthly payment?

Recently you borrowed money for a new car. The loan amount is $15,000 to be paid...

Recently you borrowed money for a new car. The loan amount is $15,000 to be paid back in equal annual payments which begin today, and will continue to be payable at the beginning of each year for a total of five years. Interest on the loan is 8%. What is the amount of the loan payment? a $4,193.34 b $4528.81 c $3,478.31 d $4,891.12

A company borrowed $500,000 and repaid the loan through yearly payments of $20,000 for 24 years...

A company borrowed $500,000 and repaid the loan through yearly payments of $20,000 for 24 years plus a single lump-sum payment of $1,000,000 million at the end of 24 years. The interest rate on the loan was closest to: 6% per year 4% per year 0.5% per year 8% per year The following five alternatives that are evaluated by the rate of return method, If the alternatives are mutually exclusive and the MARR is 15% per year, the alternative to...

You are looking to purchase a new car with the assistance of a $22,000, five-year loan...

You are looking to purchase a new car with the assistance of a $22,000, five-year loan at an APR of 5.4%, compounded monthly. Required: a. What is the monthly payment on this loan? b. What is the amount of interest and principal on the loan’s first monthly payment? c. What is the amount of interest and principal on the loan’s sixteenth monthly payment? d. Show a second method to determine the amount of interest and principal on the loan’s sixteenth...

You take out a car loan at your local bank for the purchase of a new...

You take out a car loan at your local bank for the purchase of a new car. The total cost including taxes and preparation costs are: $25,985. Your bank’s nominal interest rate for car loans is at the moment 7 1⁄4 % for a 5-year amortization period. Calculate your monthly payments and the remaining balance after 3 years.

Jenny borrowed $50,000 to purchase a family car. The terms ofher loan require making quarterly...

Jenny borrowed $50,000 to purchase a family car. The terms of her loan require making quarterly payments of $2,830.1323 over 7 years. The discount rate is 14% per annum (compounded quarterly). How much sooner will she pay off the loan if she makes quarterly payments of $3,793 instead? Round your answer to the whole numbera. 10 quartersb. 12quartersc. 20 quartersd. 15 quarterse. 18 quarters

A business borrowed $150,000 from a bank to purchase new equipment. The interest on the loan...

A business borrowed $150,000 from a bank to purchase new equipment. The interest on the loan is 3% per year, and it must be paid in 8 years. Create a loan schedule for the payments

The longer a loan schedule lasts, the more interest you will pay. For a $20,000-car-loan at...

The longer a loan schedule lasts, the more interest you will pay. For a $20,000-car-loan at 6% APR (compounded monthly) for three years (36 monthly payments), how much will it incur in total interest? For the same loan amount, how much will it incur in total interest if the loan rate is over six years (72 payments)? a. Find the difference in total interest. (answers: 1888- 3904- 2016) b. Why would you be willing to pay this extra interest?

You want to buy a car, and a local bank will lend you $20,000.The loan...

You want to buy a car, and a local bank will lend you $20,000. The loan will be paid off over 5 years with equal monthly payment.a) If the nominal interest rate of the loan is quoted as 6% with monthly compounding assumption, what is your monthly payment?b)What is the effective annual rate of Part(1)?c) If the nominal interest rate of the loan is quoted as 6% with semiannual compounding assumption, what is your monthly payment?

Question