Course Project

The scenario is designed to help you determine and evaluate the payment amount of a car loan and a mortgage, based on the assumption that your household income is $36,000 per year or $3,000 per month. Based on your income, you may spend 28% of your monthly income on housing, and 10% on a car loan. You are to put a 3% down payment on the house and a 10% down payment on the car.

Tasks:

Don't use plagiarized sources. Get Your Custom Essay on
Course Project
Just from $13/Page
Order Essay
  1. What is the maximum car payment and mortgage payment you can afford with the following conditions: your monthly household income, 10% for the car payment over 4 years, and 28% for the 15-year mortgage payments?

Maximum Monthly Payment in Car Loan

= $3,000 × 10%

= $300

So, car loan 10% on the monthly income is $300.

Maximum Monthly Payment in House Loan

= $3,000 × 28%

= $840

Housing loan consist 28% on your monthly income of $840.

The total amount of Loan is 840+300

= 1140

  1. Create a complete amortization schedule for the car, using the information above.

We have to determine the amount of loan

Annual income = $36,000

Monthly Income = $3,000.

Maximum Car Loan they can afford at 10% interest rate for 48 months is calculated in excel.

The car Loan would be 300*12(months) * 4(years) which is equivalent of $14,400.

We will assume the interest rate of 10% as advised.

Rate = 10%

Period = 48 months

Down payment = 10% of 14,400 = 1440.

Course Project You will evaluate the choices in purchasing stock via online brokerage accounts (where you can buy and sell stock via the Internet) and the use of dividend reinvestment plans (known as 1

Pv of Loan = $11,828.45.

Value of car they can afford is $11,828.45.

Complete Amortization Schedule for The Car using Excel amortization calculator

Loan amount11,828.45
Annual interest rate10.00%
Loan period in years
Start date of loan2021-04-03
Monthly payment$300.00
Number of payments48
Total interest$ 2,571.55
Total cost of loan$ 14,400.00
No.Payment
Date
Beginning
Balance
PaymentPrincipalInterestEnding
Balance
2021-05-03$11,828.45$300.00$201.43$98.57$11,627.02
2021-06-03$11,627.02$300.00$203.11$96.89$11,423.91
2021-07-03$11,423.91$300.00$204.80$95.20$11,219.11
2021-08-03$11,219.11$300.00$206.51$93.49$11,012.60
2021-09-03$11,012.60$300.00$208.23$91.77$10,804.37
2021-10-03$10,804.37$300.00$209.96$90.04$10,594.41
2021-11-03$10,594.41$300.00$211.71$88.29$10,382.70
2021-12-03$10,382.70$300.00$213.48$86.52$10,169.22
2022-01-03$10,169.22$300.00$215.26$84.74$9,953.96
102022-02-03$9,953.96$300.00$217.05$82.95$9,736.91
112022-03-03$9,736.91$300.00$218.86$81.14$9,518.05
122022-04-03$9,518.05$300.00$220.68$79.32$9,297.37
132022-05-03$9,297.37$300.00$222.52$77.48$9,074.85
142022-06-03$9,074.85$300.00$224.38$75.62$8,850.47
152022-07-03$8,850.47$300.00$226.25$73.75$8,624.23
162022-08-03$8,624.23$300.00$228.13$71.87$8,396.09
172022-09-03$8,396.09$300.00$230.03$69.97$8,166.06
182022-10-03$8,166.06$300.00$231.95$68.05$7,934.11
192022-11-03$7,934.11$300.00$233.88$66.12$7,700.23
202022-12-03$7,700.23$300.00$235.83$64.17$7,464.40
212023-01-03$7,464.40$300.00$237.80$62.20$7,226.60
222023-02-03$7,226.60$300.00$239.78$60.22$6,986.82
232023-03-03$6,986.82$300.00$241.78$58.22$6,745.05
242023-04-03$6,745.05$300.00$243.79$56.21$6,501.26
252023-05-03$6,501.26$300.00$245.82$54.18$6,255.43
262023-06-03$6,255.43$300.00$247.87$52.13$6,007.56
272023-07-03$6,007.56$300.00$249.94$50.06$5,757.63
282023-08-03$5,757.63$300.00$252.02$47.98$5,505.61
292023-09-03$5,505.61$300.00$254.12$45.88$5,251.49
302023-10-03$5,251.49$300.00$256.24$43.76$4,995.25
312023-11-03$4,995.25$300.00$258.37$41.63$4,736.87
322023-12-03$4,736.87$300.00$260.53$39.47$4,476.35
332024-01-03$4,476.35$300.00$262.70$37.30$4,213.65
342024-02-03$4,213.65$300.00$264.89$35.11$3,948.77
352024-03-03$3,948.77$300.00$267.09$32.91$3,681.67
362024-04-03$3,681.67$300.00$269.32$30.68$3,412.35
372024-05-03$3,412.35$300.00$271.56$28.44$3,140.79
382024-06-03$3,140.79$300.00$273.83$26.17$2,866.96
392024-07-03$2,866.96$300.00$276.11$23.89$2,590.85
402024-08-03$2,590.85$300.00$278.41$21.59$2,312.44
412024-09-03$2,312.44$300.00$280.73$19.27$2,031.71
422024-10-03$2,031.71$300.00$283.07$16.93$1,748.65
432024-11-03$1,748.65$300.00$285.43$14.57$1,463.22
442024-12-03$1,463.22$300.00$287.81$12.19$1,175.41
452025-01-03$1,175.41$300.00$290.20$9.80$885.21
462025-02-03$885.21$300.00$292.62$7.38$592.58
472025-03-03$592.58$300.00$295.06$4.94$297.52
482025-04-03$297.52$300.00$297.52$2.48$0.00
  1. Analyze the distributions of principal, interest and the balance over the life of the loan.

Car

Loan amount11,828.45
Annual interest rate10.00%
Loan period in years
Start date of loan2021-04-03
Monthly payment$ 300.00
Number of payments48
Total interest$ 2,571.55
Total cost of loan$ 14,400.00

This above table shows the distribution of the principal which is 11,828.45. the inters of the loan is 300 and the total interest paid is 2571.55. the loan is cleared within 48 months for car loan.

House

We have to know yearly Payment; 28% x $3000 per month x 1 years x 12 months

= $10,800 as yearly payment.

Mortgage: 28% x $3000 per month x 15 years x 12 months = $151,200 mortgage payment.

The principle would be = $104,626.95 arrived using excel =-PV(5%,15,10080)

Calculator

Calculate the price of your paper

Total price:$26
Our features

We've got everything to become your favourite writing service

Order your assignment today!
Ace that class.

Order your paper
Live Chat+1(978) 822-0999EmailWhatsApp