You have just purchased a home and taken out a $480,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $480,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 6.80%.

a. How much will you pay in interest, and how much will you pay in principal, during the first year?

b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?

Solutions

Expert Solution

a. EMI for 360 months on a Loan of $480000 is $3129.

The formula to be used in Excel is =PMT(Annual Rate/periods,no.of periods in a year, Loan Amount)

Interest is calculated on opening principal

MONTHS	EMI	INTEREST	PRINCIPAL REPAYMENT	OST PRINCIPAL
0				480000
1	3,129	2720	409	479591
2	3,129	2718	412	479179
3	3,129	2715	414	478765
4	3,129	2713	416	478349
5	3,129	2711	419	477930
6	3,129	2708	421	477510
7	3,129	2706	423	477086
8	3,129	2703	426	476660
9	3,129	2701	428	476232
10	3,129	2699	431	475802
11	3,129	2696	433	475369
12	3,129	2694	435	474933

Hence, total interest during the first year is $29790.

Total principal during the first year is $4631 (($3129*12)-$29790)

(b) Opening principal following the table is $289999

229	3,129	1645	1484	288811
230	3,129	1637	1493	287318
231	3,129	1628	1501	285817
232	3,129	1620	1510	284307
233	3,129	1611	1518	282789
234	3,129	1602	1527	281262
235	3,129	1594	1535	279727
236	3,129	1585	1544	278183
237	3,129	1576	1553	276630
238	3,129	1568	1562	275068
239	3,129	1559	1571	273498
240	3,129	1550	1579	271918

Total interest during 20th year is $19155.

Total principal during 20th year is $18358

jeff jeffy answered 10 months ago

Next > < Previous

Related Solutions

You have just purchased a home and taken out a $410,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $410,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 5.12%. a. How much will you pay in interest, and how much will you pay in principal, during the first year? b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?

You have just purchased a home and taken out a $590,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $590,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 5.92%. a. How much will you pay in interest, and how much will you pay in principal, during the first year? b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?

You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 5.28%. a. How much will you pay in interest, and how much will you pay in principal, during the first year? b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?

You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $440,000 mortgage. The mortgage has a 30 year term with monthly payments and an APR of 5.92%. How much will you pay in interest, and how much will you pay in principal during the first year? How much will you pay in interest and how much will you pay in principal during the 20th year?

You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a...

You have just purchased a home and taken out a $540,000 mortgage. The mortgage has a 30-year term with monthly payments and an APR of 7.44%. a. How much will you pay in interest, and how much will you pay in principal, during the first year? b. How much will you pay in interest, and how much will you pay in principal, during the 20th year (i.e., between 19 and 20 years from now)?

Dagny Taggart has just purchased a home and taken out a $400,000 mortgage. The mortgage has...

Dagny Taggart has just purchased a home and taken out a $400,000 mortgage. The mortgage has a 30−year term with monthly payments and has an APR of 5.4%. The total amount of interest that Dagny will pay during the first three months of her mortgage is closest to: A. $1345 B. $6740 C. $5395 D. $5380

You have just taken out a 30‑year mortgage on your new home for$103,104. This mortgage...

You have just taken out a 30‑year mortgage on your new home for $103,104. This mortgage is to be repaid in 360 equal monthly installments. If the stated (nominal) annual interest rate is 13.35 percent, what is the amount of each of the monthly installments? (Note: The convention when periodic payments are involved is to assume that the compounding frequency is the same as the payment frequency, unless stated otherwise. Thus this implies 13.35 % APR, compounded monthly for this...

Assume you have just taken out a new home mortgage. You will borrow $200,000 and make...

Assume you have just taken out a new home mortgage. You will borrow $200,000 and make equal annual payments for 20 years. a. If the interest rate is 10% per year, how much will the payments be if you pay interest on the unpaid balance each year? b. Construct an amortization schedule for the first two years. (There should be 5 columns: end of year, Payment, interest, principal repayment, balance; remember, you borrow today, the end or year 0) c....

You have just purchased a car and taken out a $46000 loan. The loan has a...

You have just purchased a car and taken out a $46000 loan. The loan has a five-year term with monthly payments and an APR of 6.5 % a. How much will you pay in interest, and how much will you pay in principal, during the first month, second month, and first year? (Hint: Compute the loan balance after one month, two months, and one year.) b. How much will you pay in interest, and how much will you pay in...

You have just purchased a car and taken out a $50,000 loan. The loan has a...

You have just purchased a car and taken out a $50,000 loan. The loan has a 5-year term with monthly payments and an APR of 6%. How much will you pay in interest, and how much will you pay in principle, during the first month and second month? (Hint: construct an amortization table to show the breakdown of interest and principal paid in the first two months).

Subjects