Question

1. Construct a loan amortization schedule for a 15-year, 7.25% loan of $7,000,000. The loan requires equal, end-of-year payments, and interest is compounded monthly.

         
     -  What is the total amount of interest paid over the life of the  
         loan?

    
     2. Re-construct this amortization schedule assuming that                     
     interest is compounded annually.

  -  What total amount of interest is paid over the life of the loan?

  -  What is the difference between those total interest amounts?

3. Assume that in sections 1 and 2 above, there is a requirement to repay the whole remaining loan balance at the end of the tenth year, immediately after making the last equal payment.

What is the loan balance to be paid in section 1?

What is the loan balance to be paid in Section 2?

What is the difference between these amounts?

    

 B.-  1. Construct a loan amortization schedule for a $3,000,000, 3-year loan, made at
6.50% quoted annual rate. Interest is compounded daily, and the loan requires equal end-of-period monthly payments.(use 360-day year for computation) 

-    What is the total amount of interest paid on this loan?

Answer 1

As per rules I am answering the first 4 subparts of the question

1: Table

Loan Amount	Interest Rate	Term in Years	Monthly Payment
$7,000,000.00	7.25%	15	$63,900.40
Month	StartingBalance	Interest	Principal	EndingBalance	TotalInterest
1	$7,000,000.00	$42,291.67	$21,608.74	$6,978,391.26	$42,291.67
2	$6,978,391.26	$42,161.11	$21,739.29	$6,956,651.98	$84,452.78
3	$6,956,651.98	$42,029.77	$21,870.63	$6,934,781.35	$126,482.55
4	$6,934,781.35	$41,897.64	$22,002.76	$6,912,778.58	$168,380.19
5	$6,912,778.58	$41,764.70	$22,135.70	$6,890,642.89	$210,144.89
6	$6,890,642.89	$41,630.97	$22,269.43	$6,868,373.45	$251,775.86
7	$6,868,373.45	$41,496.42	$22,403.98	$6,845,969.47	$293,272.28
8	$6,845,969.47	$41,361.07	$22,539.34	$6,823,430.14	$334,633.35
9	$6,823,430.14	$41,224.89	$22,675.51	$6,800,754.63	$375,858.24
10	$6,800,754.63	$41,087.89	$22,812.51	$6,777,942.12	$416,946.13

Formulae

2: Total interest =

$4,502,072.30

Last 10 payments as follows

171	$618,273.68	$3,735.40	$60,165.00	$558,108.68	$4,485,077.37
172	$558,108.68	$3,371.91	$60,528.50	$497,580.19	$4,488,449.28
173	$497,580.19	$3,006.21	$60,894.19	$436,686.00	$4,491,455.49
174	$436,686.00	$2,638.31	$61,262.09	$375,423.91	$4,494,093.80
175	$375,423.91	$2,268.19	$61,632.22	$313,791.70	$4,496,361.99
176	$313,791.70	$1,895.82	$62,004.58	$251,787.12	$4,498,257.81
177	$251,787.12	$1,521.21	$62,379.19	$189,407.93	$4,499,779.03
178	$189,407.93	$1,144.34	$62,756.06	$126,651.87	$4,500,923.37
179	$126,651.87	$765.19	$63,135.21	$63,516.66	$4,501,688.55
180	$63,516.66	$383.75	$63,516.66	$0.00	$4,502,072.30

3: TABLE

Loan Amount	Interest Rate	Term in Years	Annual Payment
$7,000,000.00	7.250%	15	$780,742.56
Year	StartingBalance	Interest	Principal	EndingBalance	TotalInterest
1	$7,000,000.00	$507,500.00	$273,242.56	$6,726,757.44	$507,500.00
2	$6,726,757.44	$487,689.91	$293,052.64	$6,433,704.80	$995,189.91
3	$6,433,704.80	$466,443.60	$314,298.96	$6,119,405.84	$1,461,633.51
4	$6,119,405.84	$443,656.92	$337,085.63	$5,782,320.21	$1,905,290.44
5	$5,782,320.21	$419,218.22	$361,524.34	$5,420,795.87	$2,324,508.65
6	$5,420,795.87	$393,007.70	$387,734.86	$5,033,061.02	$2,717,516.35
7	$5,033,061.02	$364,896.92	$415,845.63	$4,617,215.38	$3,082,413.28
8	$4,617,215.38	$334,748.12	$445,994.44	$4,171,220.94	$3,417,161.39
9	$4,171,220.94	$302,413.52	$478,329.04	$3,692,891.91	$3,719,574.91
10	$3,692,891.91	$267,734.66	$513,007.89	$3,179,884.01	$3,987,309.57
11	$3,179,884.01	$230,541.59	$550,200.97	$2,629,683.05	$4,217,851.16
12	$2,629,683.05	$190,652.02	$590,090.54	$2,039,592.51	$4,408,503.19
13	$2,039,592.51	$147,870.46	$632,872.10	$1,406,720.41	$4,556,373.64
14	$1,406,720.41	$101,987.23	$678,755.33	$727,965.09	$4,658,360.87
15	$727,965.09	$52,777.47	$727,965.09	$0.00	$4,711,138.34

4: Interest =

$4,711,138.34

Formulae