Description
Unformatted Attachment Preview
Purchase answer to see full attachment
Explanation & Answer
Attached.
amount
rate
amortization
payment
payment
month 1
month 2
month 3
month 4
month 5
month 6
month 7
month 8
month 9
month 10
month 11
month 12
month 13
month 14
month 15
month 16
month 17
month 18
month 19
month 20
month 21
month 22
month 23
month 24
month 25
month 26
month 27
month 28
month 29
month 30
month 31
month 32
month 33
month 34
month 35
month 36
month 37
month 38
month 39
$ 3,000,000.00
5.50%
30
$
17,033.67 monthly
$
204,404.04 year
starting balance
interest
principal
3,000,000.00
2,996,716.33
2,993,417.61
2,990,103.77
2,986,774.74
2,983,430.46
2,980,070.84
2,976,695.83
2,973,305.35
2,969,899.33
2,966,477.70
2,963,040.38
2,959,587.32
2,956,118.42
2,952,633.63
2,949,132.86
2,945,616.05
2,942,083.12
2,938,534.00
2,934,968.61
2,931,386.88
2,927,788.73
2,924,174.09
2,920,542.89
2,916,895.04
2,913,230.47
2,909,549.11
2,905,850.87
2,902,135.68
2,898,403.47
2,894,654.15
2,890,887.64
2,887,103.88
2,883,302.76
2,879,484.23
2,875,648.20
2,871,794.58
2,867,923.30
2,864,034.28
13,750.00
13,734.95
13,719.83
13,704.64
13,689.38
13,674.06
13,658.66
13,643.19
13,627.65
13,612.04
13,596.36
13,580.60
13,564.78
13,548.88
13,532.90
13,516.86
13,500.74
13,484.55
13,468.28
13,451.94
13,435.52
13,419.03
13,402.46
13,385.82
13,369.10
13,352.31
13,335.43
13,318.48
13,301.46
13,284.35
13,267.16
13,249.90
13,232.56
13,215.14
13,197.64
13,180.05
13,162.39
13,144.65
13,126.82
$3,283.67
$3,298.72
$3,313.84
$3,329.03
$3,344.29
$3,359.61
$3,375.01
$3,390.48
$3,406.02
$3,421.63
$3,437.31
$3,453.07
$3,468.89
$3,484.79
$3,500.77
$3,516.81
$3,532.93
$3,549.12
$3,565.39
$3,581.73
$3,598.15
$3,614.64
$3,631.21
$3,647.85
$3,664.57
$3,681.36
$3,698.24
$3,715.19
$3,732.21
$3,749.32
$3,766.51
$3,783.77
$3,801.11
$3,818.53
$3,836.03
$3,853.62
$3,871.28
$3,889.02
$3,906.85
total
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
ending balance
2,996,716.33
2,993,417.61
2,990,103.77
2,986,774.74
2,983,430.46
2,980,070.84
2,976,695.83
2,973,305.35
2,969,899.33
2,966,477.70
2,963,040.38
2,959,587.32
2,956,118.42
2,952,633.63
2,949,132.86
2,945,616.05
2,942,083.12
2,938,534.00
2,934,968.61
2,931,386.88
2,927,788.73
2,924,174.09
2,920,542.89
2,916,895.04
2,913,230.47
2,909,549.11
2,905,850.87
2,902,135.68
2,898,403.47
2,894,654.15
2,890,887.64
2,887,103.88
2,883,302.76
2,879,484.23
2,875,648.20
2,871,794.58
2,867,923.30
2,864,034.28
2,860,127.44
month 40
month 41
month 42
month 43
month 44
month 45
month 46
month 47
month 48
month 49
month 50
month 51
month 52
month 53
month 54
month 55
month 56
month 57
month 58
month 59
month 60
month 61
month 62
month 63
month 64
month 65
month 66
month 67
month 68
month 69
month 70
month 71
month 72
month 73
month 74
month 75
month 76
month 77
month 78
month 79
month 80
month 81
month 82
month 83
month 84
month 85
month 86
2,860,127.44
2,856,202.68
2,852,259.94
2,848,299.13
2,844,320.16
2,840,322.96
2,836,307.44
2,832,273.51
2,828,221.10
2,824,150.11
2,820,060.46
2,815,952.06
2,811,824.84
2,807,678.70
2,803,513.56
2,799,329.33
2,795,125.91
2,790,903.24
2,786,661.21
2,782,399.74
2,778,118.73
2,773,818.10
2,769,497.77
2,765,157.63
2,760,797.60
2,756,417.58
2,752,017.49
2,747,597.24
2,743,156.72
2,738,695.85
2,734,214.54
2,729,712.69
2,725,190.20
2,720,646.98
2,716,082.95
2,711,497.99
2,706,892.02
2,702,264.94
2,697,616.65
2,692,947.05
2,688,256.06
2,683,543.56
2,678,809.47
2,674,053.67
2,669,276.08
2,664,476.59
2,659,655.11
13,108.92
13,090.93
13,072.86
13,054.70
13,036.47
13,018.15
12,999.74
12,981.25
12,962.68
12,944.02
12,925.28
12,906.45
12,887.53
12,868.53
12,849.44
12,830.26
12,810.99
12,791.64
12,772.20
12,752.67
12,733.04
12,713.33
12,693.53
12,673.64
12,653.66
12,633.58
12,613.41
12,593.15
12,572.80
12,552.36
12,531.82
12,511.18
12,490.46
12,469.63
12,448.71
12,427.70
12,406.59
12,385.38
12,364.08
12,342.67
12,321.17
12,299.57
12,277.88
12,256.08
12,234.18
12,212.18
12,190.09
$3,924.75
$3,942.74
$3,960.81
$3,978.97
$3,997.20
$4,015.52
$4,033.93
$4,052.42
$4,070.99
$4,089.65
$4,108.39
$4,127.22
$4,146.14
$4,165.14
$4,184.23
$4,203.41
$4,222.68
$4,242.03
$4,261.47
$4,281.00
$4,300.63
$4,320.34
$4,340.14
$4,360.03
$4,380.01
$4,400.09
$4,420.26
$4,440.52
$4,460.87
$4,481.31
$4,501.85
$4,522.49
$4,543.21
$4,564.04
$4,584.96
$4,605.97
$4,627.08
$4,648.29
$4,669.59
$4,691.00
$4,712.50
$4,734.10
$4,755.79
$4,777.59
$4,799.49
$4,821.49
$4,843.58
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
2,856,202.68
2,852,259.94
2,848,299.13
2,844,320.16
2,840,322.96
2,836,307.44
2,832,273.51
2,828,221.10
2,824,150.11
2,820,060.46
2,815,952.06
2,811,824.84
2,807,678.70
2,803,513.56
2,799,329.33
2,795,125.91
2,790,903.24
2,786,661.21
2,782,399.74
2,778,118.73
2,773,818.10
2,769,497.77
2,765,157.63
2,760,797.60
2,756,417.58
2,752,017.49
2,747,597.24
2,743,156.72
2,738,695.85
2,734,214.54
2,729,712.69
2,725,190.20
2,720,646.98
2,716,082.95
2,711,497.99
2,706,892.02
2,702,264.94
2,697,616.65
2,692,947.05
2,688,256.06
2,683,543.56
2,678,809.47
2,674,053.67
2,669,276.08
2,664,476.59
2,659,655.11
2,654,811.52
month 87
month 88
month 89
month 90
month 91
month 92
month 93
month 94
month 95
month 96
month 97
month 98
month 99
month 100
month 101
month 102
month 103
month 104
month 105
month 106
month 107
month 108
month 109
month 110
month 111
month 112
month 113
month 114
month 115
month 116
month 117
month 118
month 119
month 120
month 121
month 122
month 123
month 124
month 125
month 126
month 127
month 128
month 129
month 130
month 131
month 132
month 133
2,654,811.52
2,649,945.74
2,645,057.66
2,640,147.17
2,635,214.17
2,630,258.57
2,625,280.25
2,620,279.11
2,615,255.05
2,610,207.97
2,605,137.75
2,600,044.30
2,594,927.50
2,589,787.25
2,584,623.43
2,579,435.95
2,574,224.70
2,568,989.56
2,563,730.42
2,558,447.18
2,553,139.73
2,547,807.95
2,542,451.73
2,537,070.97
2,531,665.54
2,526,235.34
2,520,780.25
2,515,300.15
2,509,794.94
2,504,264.50
2,498,708.71
2,493,127.45
2,487,520.62
2,481,888.08
2,476,229.73
2,470,545.45
2,464,835.11
2,459,098.60
2,453,335.80
2,447,546.59
2,441,730.84
2,435,888.43
2,430,019.25
2,424,123.17
2,418,200.07
2,412,249.81
2,406,272.29
12,167.89
12,145.58
12,123.18
12,100.67
12,078.06
12,055.35
12,032.53
12,009.61
11,986.59
11,963.45
11,940.21
11,916.87
11,893.42
11,869.86
11,846.19
11,822.41
11,798.53
11,774.54
11,750.43
11,726.22
11,701.89
11,677.45
11,652.90
11,628.24
11,603.47
11,578.58
11,553.58
11,528.46
11,503.23
11,477.88
11,452.41
11,426.83
11,401.14
11,375.32
11,349.39
11,323.33
11,297.16
11,270.87
11,244.46
11,217.92
11,191.27
11,164.49
11,137.59
11,110.56
11,083.42
11,056.14
11,028.75
$4,865.78
$4,888.09
$4,910.49
$4,933.00
$4,955.61
$4,978.32
$5,001.14
$5,024.06
$5,047.08
$5,070.22
$5,093.46
$5,116.80
$5,140.25
$5,163.81
$5,187.48
$5,211.26
$5,235.14
$5,259.13
$5,283.24
$5,307.45
$5,331.78
$5,356.22
$5,380.77
$5,405.43
$5,430.20
$5,455.09
$5,480.09
$5,505.21
$5,530.44
$5,555.79
$5,581.26
$5,606.84
$5,632.53
$5,658.35
$5,684.28
$5,710.34
$5,736.51
$5,762.80
$5,789.21
$5,815.75
$5,842.40
$5,869.18
$5,896.08
$5,923.11
$5,950.25
$5,977.53
$6,004.92
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
2,649,945.74
2,645,057.66
2,640,147.17
2,635,214.17
2,630,258.57
2,625,280.25
2,620,279.11
2,615,255.05
2,610,207.97
2,605,137.75
2,600,044.30
2,594,927.50
2,589,787.25
2,584,623.43
2,579,435.95
2,574,224.70
2,568,989.56
2,563,730.42
2,558,447.18
2,553,139.73
2,547,807.95
2,542,451.73
2,537,070.97
2,531,665.54
2,526,235.34
2,520,780.25
2,515,300.15
2,509,794.94
2,504,264.50
2,498,708.71
2,493,127.45
2,487,520.62
2,481,888.08
2,476,229.73
2,470,545.45
2,464,835.11
2,459,098.60
2,453,335.80
2,447,546.59
2,441,730.84
2,435,888.43
2,430,019.25
2,424,123.17
2,418,200.07
2,412,249.81
2,406,272.29
2,400,267.37
month 134
month 135
month 136
month 137
month 138
month 139
month 140
month 141
month 142
month 143
month 144
month 145
month 146
month 147
month 148
month 149
month 150
month 151
month 152
month 153
month 154
month 155
month 156
month 157
month 158
month 159
month 160
month 161
month 162
month 163
month 164
month 165
month 166
month 167
month 168
month 169
month 170
month 171
month 172
month 173
month 174
month 175
month 176
month 177
month 178
month 179
month 180
2,400,267.37
2,394,234.92
2,388,174.83
2,382,086.96
2,375,971.19
2,369,827.39
2,363,655.42
2,357,455.18
2,351,226.51
2,344,969.29
2,338,683.40
2,332,368.69
2,326,025.05
2,319,652.33
2,313,250.40
2,306,819.12
2,300,358.37
2,293,868.01
2,287,347.90
2,280,797.91
2,274,217.90
2,267,607.73
2,260,967.26
2,254,296.36
2,247,594.88
2,240,862.68
2,234,099.64
2,227,305.59
2,220,480.40
2,213,623.93
2,206,736.04
2,199,816.58
2,192,865.40
2,185,882.36
2,178,867.32
2,171,820.13
2,164,740.63
2,157,628.69
2,150,484.15
2,143,306.87
2,136,096.69
2,128,853.46
2,121,577.03
2,114,267.26
2,106,923.98
2,099,547.05
2,092,136.30
11,001.23
10,973.58
10,945.80
10,917.90
10,889.87
10,861.71
10,833.42
10,805.00
10,776.45
10,747.78
10,718.97
10,690.02
10,660.95
10,631.74
10,602.40
10,572.92
10,543.31
10,513.56
10,483.68
10,453.66
10,423.50
10,393.20
10,362.77
10,332.19
10,301.48
10,270.62
10,239.62
10,208.48
10,177.20
10,145.78
10,114.21
10,082.49
10,050.63
10,018.63
9,986.48
9,954.18
9,921.73
9,889.13
9,856.39
9,823.49
9,790.44
9,757.25
9,723.89
9,690.39
9,656.73
9,622.92
9,588.96
$6,032.44
$6,060.09
$6,087.87
$6,115.77
$6,143.80
$6,171.96
$6,200.25
$6,228.67
$6,257.22
$6,285.89
$6,314.70
$6,343.65
$6,372.72
$6,401.93
$6,431.27
$6,460.75
$6,490.36
$6,520.11
$6,549.99
$6,580.01
$6,610.17
$6,640.47
$6,670.90
$6,701.48
$6,732.19
$6,763.05
$6,794.05
$6,825.19
$6,856.47
$6,887.89
$6,919.46
$6,951.18
$6,983.04
$7,015.04
$7,047.19
$7,079.49
$7,111.94
$7,144.54
$7,177.28
$7,210.18
$7,243.23
$7,276.43
$7,309.78
$7,343.28
$7,376.94
$7,410.75
$7,444.71
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
2,394,234.92
2,388,174.83
2,382,086.96
2,375,971.19
2,369,827.39
2,363,655.42
2,357,455.18
2,351,226.51
2,344,969.29
2,338,683.40
2,332,368.69
2,326,025.05
2,319,652.33
2,313,250.40
2,306,819.12
2,300,358.37
2,293,868.01
2,287,347.90
2,280,797.91
2,274,217.90
2,267,607.73
2,260,967.26
2,254,296.36
2,247,594.88
2,240,862.68
2,234,099.64
2,227,305.59
2,220,480.40
2,213,623.93
2,206,736.04
2,199,816.58
2,192,865.40
2,185,882.36
2,178,867.32
2,171,820.13
2,164,740.63
2,157,628.69
2,150,484.15
2,143,306.87
2,136,096.69
2,128,853.46
2,121,577.03
2,114,267.26
2,106,923.98
2,099,547.05
2,092,136.30
2,084,691.59
month 181
month 182
month 183
month 184
month 185
month 186
month 187
month 188
month 189
month 190
month 191
month 192
month 193
month 194
month 195
month 196
month 197
month 198
month 199
month 200
month 201
month 202
month 203
month 204
month 205
month 206
month 207
month 208
month 209
month 210
month 211
month 212
month 213
month 214
month 215
month 216
month 217
month 218
month 219
month 220
month 221
month 222
month 223
month 224
month 225
month 226
month 227
2,084,691.59
2,077,212.75
2,069,699.64
2,062,152.10
2,054,569.96
2,046,953.06
2,039,301.26
2,031,614.39
2,023,892.29
2,016,134.79
2,008,341.74
2,000,512.97
1,992,648.31
1,984,747.62
1,976,810.71
1,968,837.42
1,960,827.59
1,952,781.04
1,944,697.62
1,936,577.15
1,928,419.45
1,920,224.37
1,911,991.73
1,903,721.36
1,895,413.08
1,887,066.72
1,878,682.10
1,870,259.06
1,861,797.41
1,853,296.98
1,844,757.59
1,836,179.05
1,827,561.21
1,818,903.86
1,810,206.83
1,801,469.94
1,792,693.01
1,783,875.85
1,775,018.28
1,766,120.11
1,757,181.15
1,748,201.23
1,739,180.15
1,730,117.72
1,721,013.76
1,711,868.07
1,702,680.46
9,554.84
9,520.56
9,486.12
9,451.53
9,416.78
9,381.87
9,346.80
9,311.57
9,276.17
9,240.62
9,204.90
9,169.02
9,132.97
9,096.76
9,060.38
9,023.84
8,987.13
8,950.25
8,913.20
8,875.98
8,838.59
8,801.03
8,763.30
8,725.39
8,687.31
8,649.06
8,610.63
8,572.02
8,533.24
8,494.28
8,455.14
8,415.82
8,376.32
8,336.64
8,296.78
8,256.74
8,216.51
8,176.10
8,135.50
8,094.72
8,053.75
8,012.59
7,971.24
7,929.71
7,887.98
7,846.06
7,803.95
$7,478.83
$7,513.11
$7,547.55
$7,582.14
$7,616.89
$7,651.80
$7,686.87
$7,722.10
$7,757.50
$7,793.05
$7,828.77
$7,864.65
$7,900.70
$7,936.91
$7,973.29
$8,009.83
$8,046.54
$8,083.42
$8,120.47
$8,157.69
$8,195.08
$8,232.64
$8,270.37
$8,308.28
$8,346.36
$8,384.61
$8,423.04
$8,461.65
$8,500.43
$8,539.39
$8,578.53
$8,617.85
$8,657.35
$8,697.03
$8,736.89
$8,776.93
$8,817.16
$8,857.57
$8,898.17
$8,938.95
$8,979.92
$9,021.08
$9,062.43
$9,103.96
$9,145.69
$9,187.61
$9,229.72
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
$
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
17,033.67
2,077,212.75
2,069,699.64
2,062,152.10
2,054,569.96
2,046,953.06
2,039,301.26
2,031,614.39
2,023,892.29
2,016,134.79
2,008,341.74
2,000,512.97
1,992,648.31
1,984,747.62
1,976,810.71
1,968,837.42
1,960,827.59
1,952,781.04
1,944,697.62
1,936,577.15
1,928,419.45
1,920,224.37
1,911,991.73
1,903,721.36
1,895,413.08
1,887,066.72
1,878,682.10
1,870,259.06
1,861,797.41
1,853,296.98
1,844,757.59
1,836,179.05
1,827,561.21
1,818,903.86
1,810,206.83
1,801,469.94
1,792,693.01
1,783,875.85
1,775,018.28
1,766,120.11
1,757,181.15
1,748,201.23
1,739,180.15
1,730,117.72
1,721,013.76
1,711,868.07
1,702,680.46
1,693,450.74
month 228
month 229
month 230
month 231
month 232
month 233
month 234
month 235
month 236
month 237
month 238
month 239
month 240
month 241
month 242
month 243
month 244
month 245
month 246
month 247
month 248
month 249
month 250
month 251
month 252
month 253
month 254
month 255
month 256
month 257
month 258
month 259
month 260
month 261
month 262
month 263
month 264
month 265
month 266
month 267
month 268
month 269
month 270
month 271
month 272
month 273
month 274
1,693,450.74
1,684,178.72
1,674,864.20
1,665,506.99
1,656,106.90
1,646,663.72
1,637,177.26
1,627,647.31
1,618,...