ABCDE
1
loan$1,100,000,000Interest income$4,088,333
2
% rate4.5%Principal income$1,459,092
3
years30balloon paymentClosing principal
4
balloon yrs0Total Disposition$1,459,092
5
6
7
NumberPaymentInterestPrincipalClosing principal
8
1$5,547,425$4,088,333$1,459,092$1,098,540,908
9
2$5,547,425$4,082,910$1,464,515$1,097,076,393
10
3$5,547,425$4,077,467$1,469,958$1,095,606,436
11
4$5,547,425$4,072,004$1,475,421$1,094,131,014
12
5$5,547,425$4,066,520$1,480,905$1,092,650,110
13
6$5,547,425$4,061,016$1,486,409$1,091,163,701
14
7$5,547,425$4,055,492$1,491,933$1,089,671,767
15
8$5,547,425$4,049,947$1,497,478$1,088,174,289
16
9$5,547,425$4,044,381$1,503,044$1,086,671,245
17
10$5,547,425$4,038,795$1,508,630$1,085,162,614
18
11$5,547,425$4,033,188$1,514,237$1,083,648,377
19
12$5,547,425$4,027,560$1,519,865$1,082,128,512
20
13$5,547,425$4,021,911$1,525,514$1,080,602,998
21
14$5,547,425$4,016,241$1,531,184$1,079,071,814
22
15$5,547,425$4,010,550$1,536,875$1,077,534,939
23
16$5,547,425$4,004,838$1,542,587$1,075,992,352
24
17$5,547,425$3,999,105$1,548,320$1,074,444,032
25
18$5,547,425$3,993,350$1,554,075$1,072,889,957
26
19$5,547,425$3,987,574$1,559,851$1,071,330,106
27
20$5,547,425$3,981,777$1,565,648$1,069,764,458
28
21$5,547,425$3,975,958$1,571,467$1,068,192,990
29
22$5,547,425$3,970,117$1,577,308$1,066,615,683
30
23$5,547,425$3,964,255$1,583,170$1,065,032,512
31
24$5,547,425$3,958,371$1,589,054$1,063,443,458
32
25$5,547,425$3,952,465$1,594,960$1,061,848,498
33
26$5,547,425$3,946,537$1,600,888$1,060,247,610
34
27$5,547,425$3,940,587$1,606,838$1,058,640,771
35
28$5,547,425$3,934,615$1,612,810$1,057,027,961
36
29$5,547,425$3,928,621$1,618,805$1,055,409,157
37
30$5,547,425$3,922,604$1,624,821$1,053,784,336
38
31$5,547,425$3,916,565$1,630,860$1,052,153,476
39
32$5,547,425$3,910,504$1,636,921$1,050,516,554
40
33$5,547,425$3,904,420$1,643,005$1,048,873,549
41
34$5,547,425$3,898,313$1,649,112$1,047,224,437
42
35$5,547,425$3,892,184$1,655,241$1,045,569,196
43
36$5,547,425$3,886,032$1,661,393$1,043,907,803
44
37$5,547,425$3,879,857$1,667,568$1,042,240,235
45
38$5,547,425$3,873,660$1,673,766$1,040,566,470
46
39$5,547,425$3,867,439$1,679,986$1,038,886,483
47
40$5,547,425$3,861,195$1,686,230$1,037,200,253
48
41$5,547,425$3,854,928$1,692,498$1,035,507,755
49
42$5,547,425$3,848,637$1,698,788$1,033,808,967
50
43$5,547,425$3,842,323$1,705,102$1,032,103,866
51
44$5,547,425$3,835,986$1,711,439$1,030,392,427
52
45$5,547,425$3,829,625$1,717,800$1,028,674,627
53
46$5,547,425$3,823,241$1,724,184$1,026,950,442
54
47$5,547,425$3,816,832$1,730,593$1,025,219,850
55
48$5,547,425$3,810,400$1,737,025$1,023,482,825
56
49$5,547,425$3,803,944$1,743,481$1,021,739,344
57
50$5,547,425$3,797,465$1,749,961$1,019,989,384
58
51$5,547,425$3,790,961$1,756,465$1,018,232,919
59
52$5,547,425$3,784,432$1,762,993$1,016,469,926
60
53$5,547,425$3,777,880$1,769,545$1,014,700,381
61
54$5,547,425$3,771,303$1,776,122$1,012,924,259
62
55$5,547,425$3,764,702$1,782,723$1,011,141,536
63
56$5,547,425$3,758,076$1,789,349$1,009,352,187
64
57$5,547,425$3,751,426$1,796,000$1,007,556,187
65
58$5,547,425$3,744,750$1,802,675$1,005,753,512
66
59$5,547,425$3,738,051$1,809,375$1,003,944,138
67
60$5,547,425$3,731,326$1,816,099$1,002,128,038
68
61$5,547,425$3,724,576$1,822,849$1,000,305,189
69
62$5,547,425$3,717,801$1,829,624$998,475,565
70
63$5,547,425$3,711,001$1,836,424$996,639,141
71
64$5,547,425$3,704,175$1,843,250$994,795,891
72
65$5,547,425$3,697,325$1,850,100$992,945,791
73
66$5,547,425$3,690,449$1,856,977$991,088,814
74
67$5,547,425$3,683,547$1,863,878$989,224,936
75
68$5,547,425$3,676,619$1,870,806$987,354,130
76
69$5,547,425$3,669,666$1,877,759$985,476,371
77
70$5,547,425$3,662,687$1,884,738$983,591,633
78
71$5,547,425$3,655,682$1,891,743$981,699,890
79
72$5,547,425$3,648,651$1,898,774$979,801,116
80
73$5,547,425$3,641,594$1,905,831$977,895,285
81
74$5,547,425$3,634,511$1,912,914$975,982,371
82
75$5,547,425$3,627,401$1,920,024$974,062,347
83
76$5,547,425$3,620,265$1,927,160$972,135,187
84
77$5,547,425$3,613,102$1,934,323$970,200,864
85
78$5,547,425$3,605,913$1,941,512$968,259,352
86
79$5,547,425$3,598,697$1,948,728$966,310,624
87
80$5,547,425$3,591,454$1,955,971$964,354,654
88
81$5,547,425$3,584,185$1,963,240$962,391,413
89
82$5,547,425$3,576,888$1,970,537$960,420,876
90
83$5,547,425$3,569,564$1,977,861$958,443,016
91
84$5,547,425$3,562,213$1,985,212$956,457,804
92
85$5,547,425$3,554,835$1,992,590$954,465,213
93
86$5,547,425$3,547,429$1,999,996$952,465,217
94
87$5,547,425$3,539,996$2,007,429$950,457,788
95
88$5,547,425$3,532,535$2,014,890$948,442,897
96
89$5,547,425$3,525,046$2,022,379$946,420,518
97
90$5,547,425$3,517,530$2,029,896$944,390,623
98
91$5,547,425$3,509,985$2,037,440$942,353,183
99
92$5,547,425$3,502,413$2,045,012$940,308,170
100
93$5,547,425$3,494,812$2,052,613$938,255,557