Loan and Property excel project

See attachment

Property and Loan Information

Purchase Price 10,000,000$

Loan to Value 75%

Interest Rate 5.35%

Loan Term 240

Loan Amount 7,500,000$

Fully Amortizing Loan Interest Only Loan

Monthly Payment (50,958.22)$ Monthly Payment (33,437.50)$

Annual Debt Service (611,498.65)$ Annual Debt Service (401,250.00)$

Loan Points 2%

Loan Points $ 150,000.00$

Effective Interest rate 5.60%

Effective Rate if Early Payoff

Month Loan Paid Off 120

Balance at Payoff $4,727,786.33

Effective Interest Rate 5.66%

Amortization Schedule

Quick Version

Loan Balance after 3 PMTs

Loan Balance $7,447,203.15

Full Schedule

PMT # Beg Bal Total PMT Interest PMT Principal PMT Ending Balance Cumulative Interest Cumulative Principal

1 7,500,000.00$ 50,958.22$ 33,437.50$ 17,520.72$ 7,482,479.28$ 33,437.50$ 17,520.72$
2 7,482,479.28$ 50,958.22$ 33,359.39$ 17,598.83$ 7,464,880.44$ 66,796.89$ 35,119.56$
3 7,464,880.44$ 50,958.22$ 33,280.93$ 17,677.30$ 7,447,203.15$ 100,077.81$ 52,796.85$
4 7,447,203.15$ 50,958.22$ 33,202.11$ 17,756.11$ 7,429,447.04$ 133,279.93$ 70,552.96$
5 7,429,447.04$ 50,958.22$ 33,122.95$ 17,835.27$ 7,411,611.77$ 166,402.88$ 88,388.23$
6 7,411,611.77$ 50,958.22$ 33,043.44$ 17,914.79$ 7,393,696.99$ 199,446.31$ 106,303.01$
7 7,393,696.99$ 50,958.22$ 32,963.57$ 17,994.66$ 7,375,702.33$ 232,409.88$ 124,297.67$
8 7,375,702.33$ 50,958.22$ 32,883.34$ 18,074.88$ 7,357,627.45$ 265,293.22$ 142,372.55$
9 7,357,627.45$ 50,958.22$ 32,802.76$ 18,155.47$ 7,339,471.98$ 298,095.97$ 160,528.02$

10 7,339,471.98$ 50,958.22$ 32,721.81$ 18,236.41$ 7,321,235.58$ 330,817.79$ 178,764.42$
11 7,321,235.58$ 50,958.22$ 32,640.51$ 18,317.71$ 7,302,917.86$ 363,458.30$ 197,082.14$
12 7,302,917.86$ 50,958.22$ 32,558.84$ 18,399.38$ 7,284,518.48$ 396,017.14$ 215,481.52$
13 7,284,518.48$ 50,958.22$ 32,476.81$ 18,481.41$ 7,266,037.07$ 428,493.95$ 233,962.93$
14 7,266,037.07$ 50,958.22$ 32,394.42$ 18,563.81$ 7,247,473.27$ 460,888.36$ 252,526.73$
15 7,247,473.27$ 50,958.22$ 32,311.65$ 18,646.57$ 7,228,826.70$ 493,200.02$ 271,173.30$
16 7,228,826.70$ 50,958.22$ 32,228.52$ 18,729.70$ 7,210,097.00$ 525,428.54$ 289,903.00$
17 7,210,097.00$ 50,958.22$ 32,145.02$ 18,813.21$ 7,191,283.79$ 557,573.55$ 308,716.21$
18 7,191,283.79$ 50,958.22$ 32,061.14$ 18,897.08$ 7,172,386.71$ 589,634.69$ 327,613.29$
19 7,172,386.71$ 50,958.22$ 31,976.89$ 18,981.33$ 7,153,405.38$ 621,611.58$ 346,594.62$
20 7,153,405.38$ 50,958.22$ 31,892.27$ 19,065.96$ 7,134,339.42$ 653,503.85$ 365,660.58$
21 7,134,339.42$ 50,958.22$ 31,807.26$ 19,150.96$ 7,115,188.47$ 685,311.11$ 384,811.53$
22 7,115,188.47$ 50,958.22$ 31,721.88$ 19,236.34$ 7,095,952.13$ 717,032.99$ 404,047.87$
23 7,095,952.13$ 50,958.22$ 31,636.12$ 19,322.10$ 7,076,630.03$ 748,669.11$ 423,369.97$
24 7,076,630.03$ 50,958.22$ 31,549.98$ 19,408.25$ 7,057,221.78$ 780,219.09$ 442,778.22$
25 7,057,221.78$ 50,958.22$ 31,463.45$ 19,494.77$ 7,037,727.01$ 811,682.54$ 462,272.99$
26 7,037,727.01$ 50,958.22$ 31,376.53$ 19,581.69$ 7,018,145.32$ 843,059.07$ 481,854.68$

27 7,018,145.32$ 50,958.22$ 28 6,998,476.33$ 50,958.22$ 29 6,978,719.65$ 50,958.22$ 30 6,958,874.88$ 50,958.22$ 31 6,938,941.65$ 50,958.22$ 32 6,918,919.54$ 50,958.22$ 33 6,898,808.17$ 50,958.22$ 34 6,878,607.13$ 50,958.22$ 35 6,858,316.04$ 50,958.22$ 36 6,837,934.47$ 50,958.22$ 37 6,817,462.04$ 50,958.22$ 38 6,796,898.34$ 50,958.22$ 39 6,776,242.96$ 50,958.22$ 40 6,755,495.49$ 50,958.22$ 41 6,734,655.52$ 50,958.22$ 42 6,713,722.64$ 50,958.22$ 43 6,692,696.43$ 50,958.22$ 44 6,671,576.48$ 50,958.22$ 45 6,650,362.37$ 50,958.22$ 46 6,629,053.68$ 50,958.22$ 47 6,607,649.99$ 50,958.22$ 48 6,586,150.87$ 50,958.22$ 49 6,564,555.91$ 50,958.22$ 50 6,542,864.67$ 50,958.22$ 51 6,521,076.72$ 50,958.22$ 52 6,499,191.63$ 50,958.22$ 53 6,477,208.97$ 50,958.22$ 54 6,455,128.31$ 50,958.22$ 55 6,432,949.20$ 50,958.22$ 56 6,410,671.21$ 50,958.22$ 57 6,388,293.90$ 50,958.22$ 58 6,365,816.82$ 50,958.22$ 59 6,343,239.53$ 50,958.22$ 60 6,320,561.59$ 50,958.22$ 61 6,297,782.54$ 50,958.22$ 62 6,274,901.93$ 50,958.22$ 63 6,251,919.31$ 50,958.22$ 31,289.23$ 19,668.99$ 6,998,476.33$ 874,348.30$ 501,523.67$
31,201.54$ 19,756.68$ 6,978,719.65$ 905,549.84$ 521,280.35$
31,113.46$ 19,844.76$ 6,958,874.88$ 936,663.30$ 541,125.12$
31,024.98$ 19,933.24$ 6,938,941.65$ 967,688.28$ 561,058.35$
30,936.11$ 20,022.11$ 6,918,919.54$ 998,624.40$ 581,080.46$
30,846.85$ 20,111.37$ 6,898,808.17$ 1,029,471.25$ 601,191.83$
30,757.19$ 20,201.03$ 6,878,607.13$ 1,060,228.43$ 621,392.87$
30,667.12$ 20,291.10$ 6,858,316.04$ 1,090,895.56$ 641,683.96$
30,576.66$ 20,381.56$ 6,837,934.47$ 1,121,472.22$ 662,065.53$
30,485.79$ 20,472.43$ 6,817,462.04$ 1,151,958.01$ 682,537.96$
30,394.52$ 20,563.70$ 6,796,898.34$ 1,182,352.52$ 703,101.66$
30,302.84$ 20,655.38$ 6,776,242.96$ 1,212,655.36$ 723,757.04$
30,210.75$ 20,747.47$ 6,755,495.49$ 1,242,866.11$ 744,504.51$
30,118.25$ 20,839.97$ 6,734,655.52$ 1,272,984.36$ 765,344.48$
30,025.34$ 20,932.88$ 6,713,722.64$ 1,303,009.70$ 786,277.36$
29,932.01$ 21,026.21$ 6,692,696.43$ 1,332,941.72$ 807,303.57$
29,838.27$ 21,119.95$ 6,671,576.48$ 1,362,779.99$ 828,423.52$
29,744.11$ 21,214.11$ 6,650,362.37$ 1,392,524.10$ 849,637.63$
29,649.53$ 21,308.69$ 6,629,053.68$ 1,422,173.63$ 870,946.32$
29,554.53$ 21,403.69$ 6,607,649.99$ 1,451,728.16$ 892,350.01$
29,459.11$ 21,499.11$ 6,586,150.87$ 1,481,187.27$ 913,849.13$
29,363.26$ 21,594.97$ 6,564,555.91$ 1,510,550.53$ 935,444.09$
29,266.98$ 21,691.24$ 6,542,864.67$ 1,539,817.50$ 957,135.33$
29,170.27$ 21,787.95$ 6,521,076.72$ 1,568,987.78$ 978,923.28$
29,073.13$ 21,885.09$ 6,499,191.63$ 1,598,060.91$ 1,000,808.37$
28,975.56$ 21,982.66$ 6,477,208.97$ 1,627,036.47$ 1,022,791.03$
28,877.56$ 22,080.66$ 6,455,128.31$ 1,655,914.03$ 1,044,871.69$
28,779.11$ 22,179.11$ 6,432,949.20$ 1,684,693.14$ 1,067,050.80$
28,680.23$ 22,277.99$ 6,410,671.21$ 1,713,373.37$ 1,089,328.79$
28,580.91$ 22,377.31$ 6,388,293.90$ 1,741,954.28$ 1,111,706.10$
28,481.14$ 22,477.08$ 6,365,816.82$ 1,770,435.43$ 1,134,183.18$
28,380.93$ 22,577.29$ 6,343,239.53$ 1,798,816.36$ 1,156,760.47$
28,280.28$ 22,677.94$ 6,320,561.59$ 1,827,096.64$ 1,179,438.41$
28,179.17$ 22,779.05$ 6,297,782.54$ 1,855,275.81$ 1,202,217.46$
28,077.61$ 22,880.61$ 6,274,901.93$ 1,883,353.42$ 1,225,098.07$
27,975.60$ 22,982.62$ 6,251,919.31$ 1,911,329.03$ 1,248,080.69$
27,873.14$ 23,085.08$ 6,228,834.23$ 1,939,202.17$ 1,271,165.77$

64 6,228,834.23$ 50,958.22$ 27,770.22$ 23,188.00$ 6,205,646.23$ 1,966,972.38$ 1,294,353.77$
65 6,205,646.23$ 50,958.22$ 27,666.84$ 23,291.38$ 6,182,354.85$ 1,994,639.22$ 1,317,645.15$
66 6,182,354.85$ 50,958.22$ 27,563.00$ 23,395.22$ 6,158,959.63$ 2,022,202.22$ 1,341,040.37$
67 6,158,959.63$ 50,958.22$ 27,458.70$ 23,499.53$ 6,135,460.10$ 2,049,660.92$ 1,364,539.90$
68 6,135,460.10$ 50,958.22$ 27,353.93$ 23,604.29$ 6,111,855.81$ 2,077,014.84$ 1,388,144.19$
69 6,111,855.81$ 50,958.22$ 27,248.69$ 23,709.53$ 6,088,146.27$ 2,104,263.53$ 1,411,853.73$
70 6,088,146.27$ 50,958.22$ 27,142.99$ 23,815.24$ 6,064,331.04$ 2,131,406.52$ 1,435,668.96$
71 6,064,331.04$ 50,958.22$ 27,036.81$ 23,921.41$ 6,040,409.63$ 2,158,443.33$ 1,459,590.37$
72 6,040,409.63$ 50,958.22$ 26,930.16$ 24,028.06$ 6,016,381.57$ 2,185,373.49$ 1,483,618.43$
73 6,016,381.57$ 50,958.22$ 26,823.03$ 24,135.19$ 5,992,246.38$ 2,212,196.52$ 1,507,753.62$
74 5,992,246.38$ 50,958.22$ 26,715.43$ 24,242.79$ 5,968,003.59$ 2,238,911.95$ 1,531,996.41$
75 5,968,003.59$ 50,958.22$ 26,607.35$ 24,350.87$ 5,943,652.72$ 2,265,519.30$ 1,556,347.28$
76 5,943,652.72$ 50,958.22$ 26,498.79$ 24,459.44$ 5,919,193.28$ 2,292,018.09$ 1,580,806.72$
77 5,919,193.28$ 50,958.22$ 26,389.74$ 24,568.48$ 5,894,624.80$ 2,318,407.83$ 1,605,375.20$
78 5,894,624.80$ 50,958.22$ 26,280.20$ 24,678.02$ 5,869,946.78$ 2,344,688.03$ 1,630,053.22$
79 5,869,946.78$ 50,958.22$ 26,170.18$ 24,788.04$ 5,845,158.74$ 2,370,858.21$ 1,654,841.26$
80 5,845,158.74$ 50,958.22$ 26,059.67$ 24,898.56$ 5,820,260.18$ 2,396,917.87$ 1,679,739.82$
81 5,820,260.18$ 50,958.22$ 25,948.66$ 25,009.56$ 5,795,250.62$ 2,422,866.53$ 1,704,749.38$
82 5,795,250.62$ 50,958.22$ 25,837.16$ 25,121.06$ 5,770,129.56$ 2,448,703.69$ 1,729,870.44$
83 5,770,129.56$ 50,958.22$ 25,725.16$ 25,233.06$ 5,744,896.50$ 2,474,428.85$ 1,755,103.50$
84 5,744,896.50$ 50,958.22$ 25,612.66$ 25,345.56$ 5,719,550.94$ 2,500,041.52$ 1,780,449.06$
85 5,719,550.94$ 50,958.22$ 25,499.66$ 25,458.56$ 5,694,092.38$ 2,525,541.18$ 1,805,907.62$
86 5,694,092.38$ 50,958.22$ 25,386.16$ 25,572.06$ 5,668,520.32$ 2,550,927.34$ 1,831,479.68$
87 5,668,520.32$ 50,958.22$ 25,272.15$ 25,686.07$ 5,642,834.26$ 2,576,199.50$ 1,857,165.74$
88 5,642,834.26$ 50,958.22$ 25,157.64$ 25,800.59$ 5,617,033.67$ 2,601,357.13$ 1,882,966.33$
89 5,617,033.67$ 50,958.22$ 25,042.61$ 25,915.61$ 5,591,118.06$ 2,626,399.74$ 1,908,881.94$
90 5,591,118.06$ 50,958.22$ 24,927.07$ 26,031.15$ 5,565,086.91$ 2,651,326.81$ 1,934,913.09$
91 5,565,086.91$ 50,958.22$ 24,811.01$ 26,147.21$ 5,538,939.70$ 2,676,137.82$ 1,961,060.30$
92 5,538,939.70$ 50,958.22$ 24,694.44$ 26,263.78$ 5,512,675.91$ 2,700,832.26$ 1,987,324.09$
93 5,512,675.91$ 50,958.22$ 24,577.35$ 26,380.87$ 5,486,295.04$ 2,725,409.61$ 2,013,704.96$
94 5,486,295.04$ 50,958.22$ 24,459.73$ 26,498.49$ 5,459,796.55$ 2,749,869.34$ 2,040,203.45$
95 5,459,796.55$ 50,958.22$ 24,341.59$ 26,616.63$ 5,433,179.92$ 2,774,210.93$ 2,066,820.08$
96 5,433,179.92$ 50,958.22$ 24,222.93$ 26,735.29$ 5,406,444.63$ 2,798,433.86$ 2,093,555.37$
97 5,406,444.63$ 50,958.22$ 24,103.73$ 26,854.49$ 5,379,590.14$ 2,822,537.59$ 2,120,409.86$
98 5,379,590.14$ 50,958.22$ 23,984.01$ 26,974.22$ 5,352,615.93$ 2,846,521.60$ 2,147,384.07$
99 5,352,615.93$ 50,958.22$ 23,863.75$ 27,094.48$ 5,325,521.45$ 2,870,385.34$ 2,174,478.55$

100 5,325,521.45$ 50,958.22$ 23,742.95$ 27,215.27$ 5,298,306.18$ 2,894,128.29$ 2,201,693.82$

101 5,298,306.18$ 50,958.22$ 23,621.62$ 27,336.61$ 5,270,969.57$ 2,917,749.91$ 2,229,030.43$
102 5,270,969.57$ 50,958.22$ 23,499.74$ 27,458.48$ 5,243,511.09$ 2,941,249.65$ 2,256,488.91$
103 5,243,511.09$ 50,958.22$ 23,377.32$ 27,580.90$ 5,215,930.19$ 2,964,626.97$ 2,284,069.81$
104 5,215,930.19$ 50,958.22$ 23,254.36$ 27,703.87$ 5,188,226.32$ 2,987,881.32$ 2,311,773.68$
105 5,188,226.32$ 50,958.22$ 23,130.84$ 27,827.38$ 5,160,398.95$ 3,011,012.17$ 2,339,601.05$
106 5,160,398.95$ 50,958.22$ 23,006.78$ 27,951.44$ 5,132,447.50$ 3,034,018.95$ 2,367,552.50$
107 5,132,447.50$ 50,958.22$ 22,882.16$ 28,076.06$ 5,104,371.44$ 3,056,901.11$ 2,395,628.56$
108 5,104,371.44$ 50,958.22$ 22,756.99$ 28,201.23$ 5,076,170.21$ 3,079,658.10$ 2,423,829.79$
109 5,076,170.21$ 50,958.22$ 22,631.26$ 28,326.96$ 5,047,843.25$ 3,102,289.36$ 2,452,156.75$
110 5,047,843.25$ 50,958.22$ 22,504.97$ 28,453.25$ 5,019,390.00$ 3,124,794.32$ 2,480,610.00$
111 5,019,390.00$ 50,958.22$ 22,378.11$ 28,580.11$ 4,990,809.89$ 3,147,172.44$ 2,509,190.11$
112 4,990,809.89$ 50,958.22$ 22,250.69$ 28,707.53$ 4,962,102.36$ 3,169,423.13$ 2,537,897.64$
113 4,962,102.36$ 50,958.22$ 22,122.71$ 28,835.51$ 4,933,266.85$ 3,191,545.84$ 2,566,733.15$
114 4,933,266.85$ 50,958.22$ 21,994.15$ 28,964.07$ 4,904,302.77$ 3,213,539.99$ 2,595,697.23$
115 4,904,302.77$ 50,958.22$ 21,865.02$ 29,093.20$ 4,875,209.57$ 3,235,405.00$ 2,624,790.43$
116 4,875,209.57$ 50,958.22$ 21,735.31$ 29,222.91$ 4,845,986.66$ 3,257,140.31$ 2,654,013.34$
117 4,845,986.66$ 50,958.22$ 21,605.02$ 29,353.20$ 4,816,633.46$ 3,278,745.34$ 2,683,366.54$
118 4,816,633.46$ 50,958.22$ 21,474.16$ 29,484.06$ 4,787,149.40$ 3,300,219.49$ 2,712,850.60$
119 4,787,149.40$ 50,958.22$ 21,342.71$ 29,615.51$ 4,757,533.88$ 3,321,562.20$ 2,742,466.12$
120 4,757,533.88$ 50,958.22$ 21,210.67$ 29,747.55$ 4,727,786.33$ 3,342,772.87$ 2,772,213.67$
121 4,727,786.33$ 50,958.22$ 21,078.05$ 29,880.17$ 4,697,906.16$ 3,363,850.92$ 2,802,093.84$
122 4,697,906.16$ 50,958.22$ 20,944.83$ 30,013.39$ 4,667,892.77$ 3,384,795.75$ 2,832,107.23$
123 4,667,892.77$ 50,958.22$ 20,811.02$ 30,147.20$ 4,637,745.57$ 3,405,606.77$ 2,862,254.43$
124 4,637,745.57$ 50,958.22$ 20,676.62$ 30,281.61$ 4,607,463.97$ 3,426,283.39$ 2,892,536.03$
125 4,607,463.97$ 50,958.22$ 20,541.61$ 30,416.61$ 4,577,047.35$ 3,446,825.00$ 2,922,952.65$
126 4,577,047.35$ 50,958.22$ 20,406.00$ 30,552.22$ 4,546,495.14$ 3,467,231.00$ 2,953,504.86$
127 4,546,495.14$ 50,958.22$ 20,269.79$ 30,688.43$ 4,515,806.71$ 3,487,500.79$ 2,984,193.29$
128 4,515,806.71$ 50,958.22$ 20,132.97$ 30,825.25$ 4,484,981.46$ 3,507,633.76$ 3,015,018.54$
129 4,484,981.46$ 50,958.22$ 19,995.54$ 30,962.68$ 4,454,018.78$ 3,527,629.31$ 3,045,981.22$
130 4,454,018.78$ 50,958.22$ 19,857.50$ 31,100.72$ 4,422,918.06$ 3,547,486.81$ 3,077,081.94$
131 4,422,918.06$ 50,958.22$ 19,718.84$ 31,239.38$ 4,391,678.68$ 3,567,205.65$ 3,108,321.32$
132 4,391,678.68$ 50,958.22$ 19,579.57$ 31,378.65$ 4,360,300.02$ 3,586,785.22$ 3,139,699.98$
133 4,360,300.02$ 50,958.22$ 19,439.67$ 31,518.55$ 4,328,781.47$ 3,606,224.89$ 3,171,218.53$
134 4,328,781.47$ 50,958.22$ 19,299.15$ 31,659.07$ 4,297,122.40$ 3,625,524.04$ 3,202,877.60$
135 4,297,122.40$ 50,958.22$ 19,158.00$ 31,800.22$ 4,265,322.19$ 3,644,682.04$ 3,234,677.81$
136 4,265,322.19$ 50,958.22$ 19,016.23$ 31,941.99$ 4,233,380.19$ 3,663,698.27$ 3,266,619.81$
137 4,233,380.19$ 50,958.22$ 18,873.82$ 32,084.40$ 4,201,295.79$ 3,682,572.09$ 3,298,704.21$

138 4,201,295.79$ 50,958.22$ 18,730.78$ 32,227.44$ 4,169,068.35$ 3,701,302.87$ 3,330,931.65$
139 4,169,068.35$ 50,958.22$ 18,587.10$ 32,371.12$ 4,136,697.22$ 3,719,889.96$ 3,363,302.78$
140 4,136,697.22$ 50,958.22$ 18,442.78$ 32,515.45$ 4,104,181.78$ 3,738,332.74$ 3,395,818.22$
141 4,104,181.78$ 50,958.22$ 18,297.81$ 32,660.41$ 4,071,521.37$ 3,756,630.55$ 3,428,478.63$
142 4,071,521.37$ 50,958.22$ 18,152.20$ 32,806.02$ 4,038,715.35$ 3,774,782.75$ 3,461,284.65$
143 4,038,715.35$ 50,958.22$ 18,005.94$ 32,952.28$ 4,005,763.06$ 3,792,788.69$ 3,494,236.94$
144 4,005,763.06$ 50,958.22$ 17,859.03$ 33,099.19$ 3,972,663.87$ 3,810,647.72$ 3,527,336.13$
145 3,972,663.87$ 50,958.22$ 17,711.46$ 33,246.76$ 3,939,417.11$ 3,828,359.18$ 3,560,582.89$
146 3,939,417.11$ 50,958.22$ 17,563.23$ 33,394.99$ 3,906,022.12$ 3,845,922.41$ 3,593,977.88$
147 3,906,022.12$ 50,958.22$ 17,414.35$ 33,543.87$ 3,872,478.25$ 3,863,336.76$ 3,627,521.75$
148 3,872,478.25$ 50,958.22$ 17,264.80$ 33,693.42$ 3,838,784.83$ 3,880,601.56$ 3,661,215.17$
149 3,838,784.83$ 50,958.22$ 17,114.58$ 33,843.64$ 3,804,941.19$ 3,897,716.14$ 3,695,058.81$
150 3,804,941.19$ 50,958.22$ 16,963.70$ 33,994.53$ 3,770,946.66$ 3,914,679.84$ 3,729,053.34$
151 3,770,946.66$ 50,958.22$ 16,812.14$ 34,146.08$ 3,736,800.58$ 3,931,491.97$ 3,763,199.42$
152 3,736,800.58$ 50,958.22$ 16,659.90$ 34,298.32$ 3,702,502.26$ 3,948,151.88$ 3,797,497.74$
153 3,702,502.26$ 50,958.22$ 16,506.99$ 34,451.23$ 3,668,051.03$ 3,964,658.87$ 3,831,948.97$
154 3,668,051.03$ 50,958.22$ 16,353.39$ 34,604.83$ 3,633,446.20$ 3,981,012.26$ 3,866,553.80$
155 3,633,446.20$ 50,958.22$ 16,199.11$ 34,759.11$ 3,598,687.09$ 3,997,211.37$ 3,901,312.91$
156 3,598,687.09$ 50,958.22$ 16,044.15$ 34,914.07$ 3,563,773.02$ 4,013,255.52$ 3,936,226.98$
157 3,563,773.02$ 50,958.22$ 15,888.49$ 35,069.73$ 3,528,703.29$ 4,029,144.01$ 3,971,296.71$
158 3,528,703.29$ 50,958.22$ 15,732.14$ 35,226.09$ 3,493,477.20$ 4,044,876.14$ 4,006,522.80$
159 3,493,477.20$ 50,958.22$ 15,575.09$ 35,383.14$ 3,458,094.07$ 4,060,451.23$ 4,041,905.93$
160 3,458,094.07$ 50,958.22$ 15,417.34$ 35,540.89$ 3,422,553.18$ 4,075,868.57$ 4,077,446.82$
161 3,422,553.18$ 50,958.22$ 15,258.88$ 35,699.34$ 3,386,853.84$ 4,091,127.45$ 4,113,146.16$
162 3,386,853.84$ 50,958.22$ 15,099.72$ 35,858.50$ 3,350,995.34$ 4,106,227.17$ 4,149,004.66$
163 3,350,995.34$ 50,958.22$ 14,939.85$ 36,018.37$ 3,314,976.98$ 4,121,167.03$ 4,185,023.02$
164 3,314,976.98$ 50,958.22$ 14,779.27$ 36,178.95$ 3,278,798.03$ 4,135,946.30$ 4,221,201.97$
165 3,278,798.03$ 50,958.22$ 14,617.97$ 36,340.25$ 3,242,457.78$ 4,150,564.27$ 4,257,542.22$
166 3,242,457.78$ 50,958.22$ 14,455.96$ 36,502.26$ 3,205,955.52$ 4,165,020.23$ 4,294,044.48$
167 3,205,955.52$ 50,958.22$ 14,293.22$ 36,665.00$ 3,169,290.52$ 4,179,313.45$ 4,330,709.48$
168 3,169,290.52$ 50,958.22$ 14,129.75$ 36,828.47$ 3,132,462.05$ 4,193,443.20$ 4,367,537.95$
169 3,132,462.05$ 50,958.22$ 13,965.56$ 36,992.66$ 3,095,469.39$ 4,207,408.76$ 4,404,530.61$
170 3,095,469.39$ 50,958.22$ 13,800.63$ 37,157.59$ 3,058,311.80$ 4,221,209.40$ 4,441,688.20$
171 3,058,311.80$ 50,958.22$ 13,634.97$ 37,323.25$ 3,020,988.55$ 4,234,844.37$ 4,479,011.45$
172 3,020,988.55$ 50,958.22$ 13,468.57$ 37,489.65$ 2,983,498.91$ 4,248,312.94$ 4,516,501.09$
173 2,983,498.91$ 50,958.22$ 13,301.43$ 37,656.79$ 2,945,842.12$ 4,261,614.38$ 4,554,157.88$
174 2,945,842.12$ 50,958.22$ 13,133.55$ 37,824.68$ 2,908,017.44$ 4,274,747.92$ 4,591,982.56$

175 2,908,017.44$ 50,958.22$ 12,964.91$ 37,993.31$ 2,870,024.13$ 4,287,712.83$ 4,629,975.87$
176 2,870,024.13$ 50,958.22$ 12,795.52$ 38,162.70$ 2,831,861.44$ 4,300,508.36$ 4,668,138.56$
177 2,831,861.44$ 50,958.22$ 12,625.38$ 38,332.84$ 2,793,528.60$ 4,313,133.74$ 4,706,471.40$
178 2,793,528.60$ 50,958.22$ 12,454.48$ 38,503.74$ 2,755,024.86$ 4,325,588.22$ 4,744,975.14$
179 2,755,024.86$ 50,958.22$ 12,282.82$ 38,675.40$ 2,716,349.45$ 4,337,871.04$ 4,783,650.55$
180 2,716,349.45$ 50,958.22$ 12,110.39$ 38,847.83$ 2,677,501.62$ 4,349,981.43$ 4,822,498.38$
181 2,677,501.62$ 50,958.22$ 11,937.19$ 39,021.03$ 2,638,480.60$ 4,361,918.63$ 4,861,519.40$
182 2,638,480.60$ 50,958.22$ 11,763.23$ 39,195.00$ 2,599,285.60$ 4,373,681.85$ 4,900,714.40$
183 2,599,285.60$ 50,958.22$ 11,588.48$ 39,369.74$ 2,559,915.86$ 4,385,270.34$ 4,940,084.14$
184 2,559,915.86$ 50,958.22$ 11,412.96$ 39,545.26$ 2,520,370.60$ 4,396,683.29$ 4,979,629.40$
185 2,520,370.60$ 50,958.22$ 11,236.65$ 39,721.57$ 2,480,649.03$ 4,407,919.95$ 5,019,350.97$
186 2,480,649.03$ 50,958.22$ 11,059.56$ 39,898.66$ 2,440,750.37$ 4,418,979.51$ 5,059,249.63$
187 2,440,750.37$ 50,958.22$ 10,881.68$ 40,076.54$ 2,400,673.83$ 4,429,861.18$ 5,099,326.17$
188 2,400,673.83$ 50,958.22$ 10,703.00$ 40,255.22$ 2,360,418.61$ 4,440,564.19$ 5,139,581.39$
189 2,360,418.61$ 50,958.22$ 10,523.53$ 40,434.69$ 2,319,983.92$ 4,451,087.72$ 5,180,016.08$
190 2,319,983.92$ 50,958.22$ 10,343.26$ 40,614.96$ 2,279,368.96$ 4,461,430.98$ 5,220,631.04$
191 2,279,368.96$ 50,958.22$ 10,162.19$ 40,796.03$ 2,238,572.93$ 4,471,593.17$ 5,261,427.07$
192 2,238,572.93$ 50,958.22$ 9,980.30$ 40,977.92$ 2,197,595.01$ 4,481,573.47$ 5,302,404.99$
193 2,197,595.01$ 50,958.22$ 9,797.61$ 41,160.61$ 2,156,434.40$ 4,491,371.09$ 5,343,565.60$
194 2,156,434.40$ 50,958.22$ 9,614.10$ 41,344.12$ 2,115,090.28$ 4,500,985.19$ 5,384,909.72$
195 2,115,090.28$ 50,958.22$ 9,429.78$ 41,528.44$ 2,073,561.84$ 4,510,414.97$ 5,426,438.16$
196 2,073,561.84$ 50,958.22$ 9,244.63$ 41,713.59$ 2,031,848.25$ 4,519,659.60$ 5,468,151.75$
197 2,031,848.25$ 50,958.22$ 9,058.66$ 41,899.56$ 1,989,948.69$ 4,528,718.25$ 5,510,051.31$
198 1,989,948.69$ 50,958.22$ 8,871.85$ 42,086.37$ 1,947,862.32$ 4,537,590.11$ 5,552,137.68$
199 1,947,862.32$ 50,958.22$ 8,684.22$ 42,274.00$ 1,905,588.32$ 4,546,274.33$ 5,594,411.68$
200 1,905,588.32$ 50,958.22$ 8,495.75$ 42,462.47$ 1,863,125.84$ 4,554,770.08$ 5,636,874.16$
201 1,863,125.84$ 50,958.22$ 8,306.44$ 42,651.79$ 1,820,474.06$ 4,563,076.51$ 5,679,525.94$
202 1,820,474.06$ 50,958.22$ 8,116.28$ 42,841.94$ 1,777,632.12$ 4,571,192.79$ 5,722,367.88$
203 1,777,632.12$ 50,958.22$ 7,925.28$ 43,032.94$ 1,734,599.17$ 4,579,118.07$ 5,765,400.83$
204 1,734,599.17$ 50,958.22$ 7,733.42$ 43,224.80$ 1,691,374.37$ 4,586,851.49$ 5,808,625.63$
205 1,691,374.37$ 50,958.22$ 7,540.71$ 43,417.51$ 1,647,956.86$ 4,594,392.20$ 5,852,043.14$
206 1,647,956.86$ 50,958.22$ 7,347.14$ 43,611.08$ 1,604,345.78$ 4,601,739.34$ 5,895,654.22$
207 1,604,345.78$ 50,958.22$ 7,152.71$ 43,805.51$ 1,560,540.27$ 4,608,892.05$ 5,939,459.73$
208 1,560,540.27$ 50,958.22$ 6,957.41$ 44,000.81$ 1,516,539.46$ 4,615,849.46$ 5,983,460.54$
209 1,516,539.46$ 50,958.22$ 6,761.24$ 44,196.98$ 1,472,342.47$ 4,622,610.70$ 6,027,657.53$
210 1,472,342.47$ 50,958.22$ 6,564.19$ 44,394.03$ 1,427,948.45$ 4,629,174.89$ 6,072,051.55$
211 1,427,948.45$ 50,958.22$ 6,366.27$ 44,591.95$ 1,383,356.50$ 4,635,541.16$ 6,116,643.50$

212 1,383,356.50$ 50,958.22$ 6,167.46$ 44,790.76$ 1,338,565.74$ 4,641,708.62$ 6,161,434.26$
213 1,338,565.74$ 50,958.22$ 5,967.77$ 44,990.45$ 1,293,575.29$ 4,647,676.40$ 6,206,424.71$
214 1,293,575.29$ 50,958.22$ 5,767.19$ 45,191.03$ 1,248,384.26$ 4,653,443.59$ 6,251,615.74$
215 1,248,384.26$ 50,958.22$ 5,565.71$ 45,392.51$ 1,202,991.75$ 4,659,009.30$ 6,297,008.25$
216 1,202,991.75$ 50,958.22$ 5,363.34$ 45,594.88$ 1,157,396.87$ 4,664,372.64$ 6,342,603.13$
217 1,157,396.87$ 50,958.22$ 5,160.06$ 45,798.16$ 1,111,598.71$ 4,669,532.70$ 6,388,401.29$
218 1,111,598.71$ 50,958.22$ 4,955.88$ 46,002.34$ 1,065,596.36$ 4,674,488.58$ 6,434,403.64$
219 1,065,596.36$ 50,958.22$ 4,750.78$ 46,207.44$ 1,019,388.93$ 4,679,239.36$ 6,480,611.07$
220 1,019,388.93$ 50,958.22$ 4,544.78$ 46,413.45$ 972,975.48$ 4,683,784.14$ 6,527,024.52$
221 972,975.48$ 50,958.22$ 4,337.85$ 46,620.37$ 926,355.11$ 4,688,121.99$ 6,573,644.89$
222 926,355.11$ 50,958.22$ 4,130.00$ 46,828.22$ 879,526.89$ 4,692,251.98$ 6,620,473.11$
223 879,526.89$ 50,958.22$ 3,921.22$ 47,037.00$ 832,489.89$ 4,696,173.21$ 6,667,510.11$
224 832,489.89$ 50,958.22$ 3,711.52$ 47,246.70$ 785,243.19$ 4,699,884.73$ 6,714,756.81$
225 785,243.19$ 50,958.22$ 3,500.88$ 47,457.35$ 737,785.84$ 4,703,385.60$ 6,762,214.16$
226 737,785.84$ 50,958.22$ 3,289.30$ 47,668.93$ 690,116.92$ 4,706,674.90$ 6,809,883.08$
227 690,116.92$ 50,958.22$ 3,076.77$ 47,881.45$ 642,235.47$ 4,709,751.67$ 6,857,764.53$
228 642,235.47$ 50,958.22$ 2,863.30$ 48,094.92$ 594,140.54$ 4,712,614.97$ 6,905,859.46$
229 594,140.54$ 50,958.22$ 2,648.88$ 48,309.34$ 545,831.20$ 4,715,263.85$ 6,954,168.80$
230 545,831.20$ 50,958.22$ 2,433.50$ 48,524.72$ 497,306.48$ 4,717,697.34$ 7,002,693.52$
231 497,306.48$ 50,958.22$ 2,217.16$ 48,741.06$ 448,565.41$ 4,719,914.50$ 7,051,434.59$
232 448,565.41$ 50,958.22$ 1,999.85$ 48,958.37$ 399,607.05$ 4,721,914.35$ 7,100,392.95$
233 399,607.05$ 50,958.22$ 1,781.58$ 49,176.64$ 350,430.41$ 4,723,695.94$ 7,149,569.59$
234 350,430.41$ 50,958.22$ 1,562.34$ 49,395.89$ 301,034.52$ 4,725,258.27$ 7,198,965.48$
235 301,034.52$ 50,958.22$ 1,342.11$ 49,616.11$ 251,418.41$ 4,726,600.38$ 7,248,581.59$
236 251,418.41$ 50,958.22$ 1,120.91$ 49,837.31$ 201,581.10$ 4,727,721.29$ 7,298,418.90$
237 201,581.10$ 50,958.22$ 898.72$ 50,059.51$ 151,521.59$ 4,728,620.01$ 7,348,478.41$
238 151,521.59$ 50,958.22$ 675.53$ 50,282.69$ 101,238.91$ 4,729,295.54$ 7,398,761.09$
239 101,238.91$ 50,958.22$ 451.36$ 50,506.86$ 50,732.04$ 4,729,746.90$ 7,449,267.96$
240 50,732.04$ 50,958.22$ 226.18$ 50,732.04$ 0.00$ 4,729,973.08$ 7,500,000.00$
241 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
242 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
243 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
244 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
245 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
246 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
247 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
248 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$

249 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
250 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
251 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
252 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
253 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
254 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
255 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
256 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
257 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
258 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
259 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
260 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
261 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
262 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
263 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
264 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
265 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
266 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
267 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
268 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
269 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
270 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
271 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
272 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
273 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
274 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
275 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
276 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
277 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
278 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
279 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
280 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
281 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
282 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
283 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
284 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
285 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$

286 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
287 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
288 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
289 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
290 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
291 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
292 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
293 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
294 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
295 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
296 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
297 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
298 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
299 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
300 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
301 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
302 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
303 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
304 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
305 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
306 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
307 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
308 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
309 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
310 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
311 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
312 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
313 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
314 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
315 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
316 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
317 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
318 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
319 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
320 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
321 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
322 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$

323 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
324 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
325 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
326 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
327 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
328 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
329 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
330 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
331 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
332 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
333 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
334 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
335 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
336 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
337 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
338 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
339 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
340 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
341 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
342 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
343 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
344 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
345 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
346 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
347 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
348 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
349 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
350 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
351 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
352 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
353 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
354 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
355 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
356 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
357 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
358 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$
359 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$

360 0.00$ -$ 0.00$ (0.00)$ 0.00$ 4,729,973.08$ 7,500,000.00$

Take Home Project 1
Loan & Property Analysis

DUE 7/7/2013 ON WEBCOURSES

PLEASE UPLOAD ONE FULLY FUNCTIONAL EXCEL FILE (note needs to be an .xlsm file)

Submit an Excel Workbook with the following items, fully linked, updatable, and functional.

Using a single property’s information

1. Amortized loan payment (up to 360 months)
2. Interest Only loan payment
3. Annual effective rate if points present
4. Full amortization schedule (up to 360 months) & ability to find balance at any month
5. Automatic maximum loan amount using both LTV and DSCR restrictions
6. Automatic Breakeven Occupancy Estimator (macro allowed)
7. Automatic NOI calculation (for proforma only)

Property Info

rmation

Gross Potential Rent 1,500,000.00$

Vacancy & Collection Loss 10%

Other Income 50,000.00$

Effective Gross Income 1,400,000.00$

Operating Expenses 45%

Net Operating Income 770,000.00$

Cap Rate for Valuation 8%

Purchase Price 9,625,000.00$

Loan Info

rmation

Purchase Price 9,625,000$ Loan Sizing

Net Operating Income 770,000$ Max Loan @ LTV Limit 7,218,750.00$

Max Loan to Value 75% Max Debt Service 570,370.37$

Max Debt Serv Coverage Ratio 1.35 Max Debt @ DSCR Limit 6,995,563.69$

Interest Rate 5.35%

Loan Term 240 Implied DSCR 1.35

Loan Amount 6,995,564$ Implied LTV 72.68%

Fully Amortizing Loan Interest Only Loan

Monthly Payment (47,530.86)$ Monthly Payment (31,188.55)$

Annual Debt Service (570,370.37)$ Annual Debt Service (374,262.66)$

Loan Points 2%

Loan Points $ 139,911.27$

Effective Interest rate 5.60%

Effective Rate if Early Payoff

Month Loan Paid Off 120

Balance at Payoff $4,409,804.05

Effective Interest Rate 5.66%

Amortization Schedule

Quick Version

Loan Balance after 3 PMTs

Loan Balance $6,946,317.86

Full Schedule

PMT # Beg Bal Total PMT Interest PMT Principal PMT Ending Balance Cumulative Interest Cumulative Principal

1 6,995,563.69$ 47,530.86$ 31,188.55$ 16,342.31$ 6,979,221.38$ 31,188.55$ 16,342.31$

2 6,979,221.38$ 47,530.86$ 31,115.70$ 16,415.17$ 6,962,806.21$ 62,304.25$ 32,757.48$

3 6,962,806.21$ 47,530.86$ 31,042.51$ 16,488.35$ 6,946,317.86$ 93,346.76$ 49,245.83$

4 6,946,317.86$ 47,530.86$ 30,969.00$ 16,561.86$ 6,929,755.99$ 124,315.76$ 65,807.70$

5 6,929,755.99$ 47,530.86$ 30,895.16$ 16,635.70$ 6,913,120.29$ 155,210.92$ 82,443.40$

6 6,913,120.29$ 47,530.86$ 30,820.99$ 16,709.87$ 6,896,410.42$ 186,031.92$ 99,153.27$

7 6,896,410.42$ 47,530.86$ 30,746.50$ 16,784.37$ 6,879,626.05$ 216,778.41$ 115,937.63$

8 6,879,626.05$ 47,530.86$ 30,671.67$ 16,859.20$ 6,862,766.85$ 247,450.08$ 132,796.83$

9 6,862,766.85$ 47,530.86$ 30,596.50$ 16,934.36$ 6,845,832.49$ 278,046.58$ 149,731.19$

10 6,845,832.49$ 47,530.86$ 30,521.00$ 17,009.86$ 6,828,822.63$ 308,567.59$ 166,741.06$

11 6,828,822.63$ 47,530.86$ 30,445.17$ 17,085.70$ 6,811,736.93$ 339,012.75$ 183,826.75$

12 6,811,736.93$ 47,530.86$ 30,368.99$ 17,161.87$ 6,794,575.06$ 369,381.75$ 200,988.62$

13 6,794,575.06$ 47,530.86$ 30,292.48$ 17,238.38$ 6,777,336.68$ 399,674.23$ 218,227.01$

14 6,777,336.68$ 47,530.86$ 30,215.63$ 17,315.24$ 6,760,021.44$ 429,889.85$ 235,542.24$

15 6,760,021.44$ 47,530.86$ 30,138.43$ 17,392.44$ 6,742,629.01$ 460,028.28$ 252,934.68$

16 6,742,629.01$ 47,530.86$ 30,060.89$ 17,469.98$ 6,725,159.03$ 490,089.17$ 270,404.66$

17 6,725,159.03$ 47,530.86$ 29,983.00$ 17,547.86$ 6,707,611.17$ 520,072.17$ 287,952.52$

18 6,707,611.17$ 47,530.86$ 29,904.77$ 17,626.10$ 6,689,985.07$ 549,976.94$ 305,578.62$

19 6,689,985.07$ 47,530.86$ 29,826.18$ 17,704.68$ 6,672,280.39$ 579,803.12$ 323,283.30$

20 6,672,280.39$ 47,530.86$ 29,747.25$ 17,783.61$ 6,654,496.77$ 609,550.37$ 341,066.91$

21 6,654,496.77$ 47,530.86$ 29,667.96$ 17,862.90$ 6,636,633.88$ 639,218.34$ 358,929.81$

22 6,636,633.88$ 47,530.86$ 29,588.33$ 17,942.54$ 6,618,691.34$ 668,806.66$ 376,872.35$

23 6,618,691.34$ 47,530.86$ 29,508.33$ 18,022.53$ 6,600,668.80$ 698,314.99$ 394,894.88$

24 6,600,668.80$ 47,530.86$ 29,427.98$ 18,102.88$ 6,582,565.92$ 727,742.98$ 412,997.76$

25 6,582,565.92$ 47,530.86$ 29,347.27$ 18,183.59$ 6,564,382.33$ 757,090.25$ 431,181.36$

26 6,564,382.33$ 47,530.86$ 29,266.20$ 18,264.66$ 6,546,117.67$ 786,356.45$ 449,446.02$

27 6,546,117.67$ 47,530.86$ 29,184.77$ 18,346.09$ 6,527,771.58$ 815,541.23$ 467,792.10$

28 6,527,771.58$ 47,530.86$ 29,102.98$ 18,427.88$ 6,509,343.70$ 844,644.21$ 486,219.99$

29 6,509,343.70$ 47,530.86$ 29,020.82$ 18,510.04$ 6,490,833.66$ 873,665.03$ 504,730.03$

30 6,490,833.66$ 47,530.86$ 28,938.30$ 18,592.56$ 6,472,241.10$ 902,603.33$ 523,322.59$

31 6,472,241.10$ 47,530.86$ 28,855.41$ 18,675.46$ 6,453,565.64$ 931,458.74$ 541,998.05$

32 6,453,565.64$ 47,530.86$ 28,772.15$ 18,758.72$ 6,434,806.92$ 960,230.89$ 560,756.77$

33 6,434,806.92$ 47,530.86$ 28,688.51$ 18,842.35$ 6,415,964.57$ 988,919.40$ 579,599.12$

34 6,415,964.57$ 47,530.86$ 28,604.51$ 18,926.36$ 6,397,038.22$ 1,017,523.91$ 598,525.47$

35 6,397,038.22$ 47,530.86$ 28,520.13$ 19,010.74$ 6,378,027.48$ 1,046,044.04$ 617,536.21$

36 6,378,027.48$ 47,530.86$ 28,435.37$ 19,095.49$ 6,358,931.99$ 1,074,479.41$ 636,631.70$

37 6,358,931.99$ 47,530.86$ 28,350.24$ 19,180.63$ 6,339,751.36$ 1,102,829.65$ 655,812.32$

38 6,339,751.36$ 47,530.86$ 28,264.72$ 19,266.14$ 6,320,485.22$ 1,131,094.38$ 675,078.46$

39 6,320,485.22$ 47,530.86$ 28,178.83$ 19,352.03$ 6,301,133.19$ 1,159,273.21$ 694,430.50$

40 6,301,133.19$ 47,530.86$ 28,092.55$ 19,438.31$ 6,281,694.88$ 1,187,365.76$ 713,868.81$

41 6,281,694.88$ 47,530.86$ 28,005.89$ 19,524.97$ 6,262,169.90$ 1,215,371.65$ 733,393.78$

42 6,262,169.90$ 47,530.86$ 27,918.84$ 19,612.02$ 6,242,557.88$ 1,243,290.49$ 753,005.81$

43 6,242,557.88$ 47,530.86$ 27,831.40$ 19,699.46$ 6,222,858.42$ 1,271,121.89$ 772,705.27$

44 6,222,858.42$ 47,530.86$ 27,743.58$ 19,787.29$ 6,203,071.13$ 1,298,865.47$ 792,492.55$

45 6,203,071.13$ 47,530.86$ 27,655.36$ 19,875.51$ 6,183,195.63$ 1,326,520.83$ 812,368.06$

46 6,183,195.63$ 47,530.86$ 27,566.75$ 19,964.12$ 6,163,231.51$ 1,354,087.58$ 832,332.18$

47 6,163,231.51$ 47,530.86$ 27,477.74$ 20,053.12$ 6,143,178.39$ 1,381,565.32$ 852,385.30$

48 6,143,178.39$ 47,530.86$ 27,388.34$ 20,142.53$ 6,123,035.86$ 1,408,953.65$ 872,527.83$

49 6,123,035.86$ 47,530.86$ 27,298.53$ 20,232.33$ 6,102,803.53$ 1,436,252.19$ 892,760.16$

50 6,102,803.53$ 47,530.86$ 27,208.33$ 20,322.53$ 6,082,481.00$ 1,463,460.52$ 913,082.69$

51 6,082,481.00$ 47,530.86$ 27,117.73$ 20,413.14$ 6,062,067.86$ 1,490,578.25$ 933,495.83$

52 6,062,067.86$ 47,530.86$ 27,026.72$ 20,504.14$ 6,041,563.72$ 1,517,604.97$ 953,999.97$

53 6,041,563.72$ 47,530.86$ 26,935.30$ 20,595.56$ 6,020,968.16$ 1,544,540.27$ 974,595.53$

54 6,020,968.16$ 47,530.86$ 26,843.48$ 20,687.38$ 6,000,280.78$ 1,571,383.76$ 995,282.91$

55 6,000,280.78$ 47,530.86$ 26,751.25$ 20,779.61$ 5,979,501.16$ 1,598,135.01$ 1,016,062.52$

56 5,979,501.16$ 47,530.86$ 26,658.61$ 20,872.25$ 5,958,628.91$ 1,624,793.62$ 1,036,934.78$

57 5,958,628.91$ 47,530.86$ 26,565.55$ 20,965.31$ 5,937,663.60$ 1,651,359.17$ 1,057,900.09$

58 5,937,663.60$ 47,530.86$ 26,472.08$ 21,058.78$ 5,916,604.82$ 1,677,831.25$ 1,078,958.87$

59 5,916,604.82$ 47,530.86$ 26,378.20$ 21,152.67$ 5,895,452.15$ 1,704,209.45$ 1,100,111.54$

60 5,895,452.15$ 47,530.86$ 26,283.89$ 21,246.97$ 5,874,205.18$ 1,730,493.34$ 1,121,358.51$

61 5,874,205.18$ 47,530.86$ 26,189.16$ 21,341.70$ 5,852,863.48$ 1,756,682.51$ 1,142,700.21$

62 5,852,863.48$ 47,530.86$ 26,094.02$ 21,436.85$ 5,831,426.63$ 1,782,776.52$ 1,164,137.06$

63 5,831,426.63$ 47,530.86$ 25,998.44$ 21,532.42$ 5,809,894.21$ 1,808,774.97$ 1,185,669.48$

64 5,809,894.21$ 47,530.86$ 25,902.45$ 21,628.42$ 5,788,265.79$ 1,834,677.41$ 1,207,297.90$

65 5,788,265.79$ 47,530.86$ 25,806.02$ 21,724.85$ 5,766,540.94$ 1,860,483.43$ 1,229,022.74$

66 5,766,540.94$ 47,530.86$ 25,709.16$ 21,821.70$ 5,744,719.24$ 1,886,192.59$ 1,250,844.45$

67 5,744,719.24$ 47,530.86$ 25,611.87$ 21,918.99$ 5,722,800.25$ 1,911,804.46$ 1,272,763.44$

68 5,722,800.25$ 47,530.86$ 25,514.15$ 22,016.71$ 5,700,783.54$ 1,937,318.62$ 1,294,780.15$

69 5,700,783.54$ 47,530.86$ 25,415.99$ 22,114.87$ 5,678,668.67$ 1,962,734.61$ 1,316,895.02$

70 5,678,668.67$ 47,530.86$ 25,317.40$ 22,213.47$ 5,656,455.20$ 1,988,052.01$ 1,339,108.49$

71 5,656,455.20$ 47,530.86$ 25,218.36$ 22,312.50$ 5,634,142.70$ 2,013,270.37$ 1,361,420.99$

72 5,634,142.70$ 47,530.86$ 25,118.89$ 22,411.98$ 5,611,730.72$ 2,038,389.26$ 1,383,832.97$

73 5,611,730.72$ 47,530.86$ 25,018.97$ 22,511.90$ 5,589,218.82$ 2,063,408.22$ 1,406,344.86$

74 5,589,218.82$ 47,530.86$ 24,918.60$ 22,612.26$ 5,566,606.56$ 2,088,326.82$ 1,428,957.13$

75 5,566,606.56$ 47,530.86$ 24,817.79$ 22,713.08$ 5,543,893.48$ 2,113,144.61$ 1,451,670.20$

76 5,543,893.48$ 47,530.86$ 24,716.53$ 22,814.34$ 5,521,079.14$ 2,137,861.14$ 1,474,484.54$

77 5,521,079.14$ 47,530.86$ 24,614.81$ 22,916.05$ 5,498,163.09$ 2,162,475.95$ 1,497,400.60$

78 5,498,163.09$ 47,530.86$ 24,512.64$ 23,018.22$ 5,475,144.87$ 2,186,988.59$ 1,520,418.82$

79 5,475,144.87$ 47,530.86$ 24,410.02$ 23,120.84$ 5,452,024.03$ 2,211,398.61$ 1,543,539.66$

80 5,452,024.03$ 47,530.86$ 24,306.94$ 23,223.92$ 5,428,800.10$ 2,235,705.55$ 1,566,763.58$

81 5,428,800.10$ 47,530.86$ 24,203.40$ 23,327.46$ 5,405,472.64$ 2,259,908.95$ 1,590,091.05$

82 5,405,472.64$ 47,530.86$ 24,099.40$ 23,431.47$ 5,382,041.17$ 2,284,008.35$ 1,613,522.51$

83 5,382,041.17$ 47,530.86$ 23,994.93$ 23,535.93$ 5,358,505.24$ 2,308,003.28$ 1,637,058.44$

84 5,358,505.24$ 47,530.86$ 23,890.00$ 23,640.86$ 5,334,864.38$ 2,331,893.29$ 1,660,699.31$

85 5,334,864.38$ 47,530.86$ 23,784.60$ 23,746.26$ 5,311,118.12$ 2,355,677.89$ 1,684,445.57$

86 5,311,118.12$ 47,530.86$ 23,678.73$ 23,852.13$ 5,287,265.99$ 2,379,356.63$ 1,708,297.70$

87 5,287,265.99$ 47,530.86$ 23,572.39$ 23,958.47$ 5,263,307.52$ 2,402,929.02$ 1,732,256.17$

88 5,263,307.52$ 47,530.86$ 23,465.58$ 24,065.28$ 5,239,242.24$ 2,426,394.60$ 1,756,321.45$

89 5,239,242.24$ 47,530.86$ 23,358.29$ 24,172.58$ 5,215,069.66$ 2,449,752.89$ 1,780,494.03$

90 5,215,069.66$ 47,530.86$ 23,250.52$ 24,280.35$ 5,190,789.32$ 2,473,003.41$ 1,804,774.37$

91 5,190,789.32$ 47,530.86$ 23,142.27$ 24,388.60$ 5,166,400.72$ 2,496,145.68$ 1,829,162.97$

92 5,166,400.72$ 47,530.86$ 23,033.54$ 24,497.33$ 5,141,903.39$ 2,519,179.21$ 1,853,660.29$

93 5,141,903.39$ 47,530.86$ 22,924.32$ 24,606.54$ 5,117,296.85$ 2,542,103.53$ 1,878,266.84$

94 5,117,296.85$ 47,530.86$ 22,814.62$ 24,716.25$ 5,092,580.60$ 2,564,918.15$ 1,902,983.09$

95 5,092,580.60$ 47,530.86$ 22,704.42$ 24,826.44$ 5,067,754.16$ 2,587,622.57$ 1,927,809.53$

96 5,067,754.16$ 47,530.86$ 22,593.74$ 24,937.13$ 5,042,817.03$ 2,610,216.31$ 1,952,746.66$

97 5,042,817.03$ 47,530.86$ 22,482.56$ 25,048.30$ 5,017,768.72$ 2,632,698.86$ 1,977,794.96$

98 5,017,768.72$ 47,530.86$ 22,370.89$ 25,159.98$ 4,992,608.75$ 2,655,069.75$ 2,002,954.94$

99 4,992,608.75$ 47,530.86$ 22,258.71$ 25,272.15$ 4,967,336.60$ 2,677,328.46$ 2,028,227.09$

100 4,967,336.60$ 47,530.86$ 22,146.04$ 25,384.82$ 4,941,951.77$ 2,699,474.51$ 2,053,611.91$

101 4,941,951.77$ 47,530.86$ 22,032.87$ 25,498.00$ 4,916,453.78$ 2,721,507.38$ 2,079,109.91$

102 4,916,453.78$ 47,530.86$ 21,919.19$ 25,611.67$ 4,890,842.10$ 2,743,426.56$ 2,104,721.58$

103 4,890,842.10$ 47,530.86$ 21,805.00$ 25,725.86$ 4,865,116.24$ 2,765,231.57$ 2,130,447.44$

104 4,865,116.24$ 47,530.86$ 21,690.31$ 25,840.55$ 4,839,275.69$ 2,786,921.88$ 2,156,288.00$

105 4,839,275.69$ 47,530.86$ 21,575.10$ 25,955.76$ 4,813,319.93$ 2,808,496.98$ 2,182,243.76$

106 4,813,319.93$ 47,530.86$ 21,459.38$ 26,071.48$ 4,787,248.45$ 2,829,956.37$ 2,208,315.24$

107 4,787,248.45$ 47,530.86$ 21,343.15$ 26,187.71$ 4,761,060.74$ 2,851,299.52$ 2,234,502.95$

108 4,761,060.74$ 47,530.86$ 21,226.40$ 26,304.47$ 4,734,756.27$ 2,872,525.91$ 2,260,807.42$

109 4,734,756.27$ 47,530.86$ 21,109.12$ 26,421.74$ 4,708,334.52$ 2,893,635.03$ 2,287,229.16$

110 4,708,334.52$ 47,530.86$ 20,991.32$ 26,539.54$ 4,681,794.98$ 2,914,626.36$ 2,313,768.70$

111 4,681,794.98$ 47,530.86$ 20,873.00$ 26,657.86$ 4,655,137.12$ 2,935,499.36$ 2,340,426.56$

112 4,655,137.12$ 47,530.86$ 20,754.15$ 26,776.71$ 4,628,360.41$ 2,956,253.52$ 2,367,203.27$

113 4,628,360.41$ 47,530.86$ 20,634.77$ 26,896.09$ 4,601,464.32$ 2,976,888.29$ 2,394,099.37$

114 4,601,464.32$ 47,530.86$ 20,514.86$ 27,016.00$ 4,574,448.32$ 2,997,403.15$ 2,421,115.37$

115 4,574,448.32$ 47,530.86$ 20,394.42$ 27,136.45$ 4,547,311.87$ 3,017,797.57$ 2,448,251.82$

116 4,547,311.87$ 47,530.86$ 20,273.43$ 27,257.43$ 4,520,054.44$ 3,038,071.00$ 2,475,509.25$

117 4,520,054.44$ 47,530.86$ 20,151.91$ 27,378.95$ 4,492,675.48$ 3,058,222.91$ 2,502,888.20$

118 4,492,675.48$ 47,530.86$ 20,029.84$ 27,501.02$ 4,465,174.46$ 3,078,252.75$ 2,530,389.22$

119 4,465,174.46$ 47,530.86$ 19,907.24$ 27,623.63$ 4,437,550.84$ 3,098,159.99$ 2,558,012.85$

120 4,437,550.84$ 47,530.86$ 19,784.08$ 27,746.78$ 4,409,804.05$ 3,117,944.07$ 2,585,759.63$

121 4,409,804.05$ 47,530.86$ 19,660.38$ 27,870.49$ 4,381,933.56$ 3,137,604.45$ 2,613,630.12$

122 4,381,933.56$ 47,530.86$ 19,536.12$ 27,994.74$ 4,353,938.82$ 3,157,140.57$ 2,641,624.87$

123 4,353,938.82$ 47,530.86$ 19,411.31$ 28,119.55$ 4,325,819.27$ 3,176,551.88$ 2,669,744.42$

124 4,325,819.27$ 47,530.86$ 19,285.94$ 28,244.92$ 4,297,574.35$ 3,195,837.82$ 2,697,989.34$

125 4,297,574.35$ 47,530.86$ 19,160.02$ 28,370.85$ 4,269,203.50$ 3,214,997.84$ 2,726,360.18$

126 4,269,203.50$ 47,530.86$ 19,033.53$ 28,497.33$ 4,240,706.17$ 3,234,031.37$ 2,754,857.52$

127 4,240,706.17$ 47,530.86$ 18,906.48$ 28,624.38$ 4,212,081.79$ 3,252,937.85$ 2,783,481.90$

128 4,212,081.79$ 47,530.86$ 18,778.86$ 28,752.00$ 4,183,329.79$ 3,271,716.72$ 2,812,233.90$

129 4,183,329.79$ 47,530.86$ 18,650.68$ 28,880.19$ 4,154,449.60$ 3,290,367.40$ 2,841,114.08$

130 4,154,449.60$ 47,530.86$ 18,521.92$ 29,008.94$ 4,125,440.66$ 3,308,889.32$ 2,870,123.03$

131 4,125,440.66$ 47,530.86$ 18,392.59$ 29,138.27$ 4,096,302.39$ 3,327,281.91$ 2,899,261.30$

132 4,096,302.39$ 47,530.86$ 18,262.68$ 29,268.18$ 4,067,034.20$ 3,345,544.59$ 2,928,529.48$

133 4,067,034.20$ 47,530.86$ 18,132.19$ 29,398.67$ 4,037,635.53$ 3,363,676.78$ 2,957,928.15$

134 4,037,635.53$ 47,530.86$ 18,001.13$ 29,529.74$ 4,008,105.79$ 3,381,677.91$ 2,987,457.89$

135 4,008,105.79$ 47,530.86$ 17,869.47$ 29,661.39$ 3,978,444.40$ 3,399,547.38$ 3,017,119.29$

136 3,978,444.40$ 47,530.86$ 17,737.23$ 29,793.63$ 3,948,650.77$ 3,417,284.61$ 3,046,912.92$

137 3,948,650.77$ 47,530.86$ 17,604.40$ 29,926.46$ 3,918,724.30$ 3,434,889.01$ 3,076,839.38$

138 3,918,724.30$ 47,530.86$ 17,470.98$ 30,059.89$ 3,888,664.42$ 3,452,359.99$ 3,106,899.27$

139 3,888,664.42$ 47,530.86$ 17,336.96$ 30,193.90$ 3,858,470.52$ 3,469,696.95$ 3,137,093.17$

140 3,858,470.52$ 47,530.86$ 17,202.35$ 30,328.52$ 3,828,142.00$ 3,486,899.30$ 3,167,421.69$

141 3,828,142.00$ 47,530.86$ 17,067.13$ 30,463.73$ 3,797,678.27$ 3,503,966.44$ 3,197,885.42$

142 3,797,678.27$ 47,530.86$ 16,931.32$ 30,599.55$ 3,767,078.72$ 3,520,897.75$ 3,228,484.97$

143 3,767,078.72$ 47,530.86$ 16,794.89$ 30,735.97$ 3,736,342.75$ 3,537,692.64$ 3,259,220.94$

144 3,736,342.75$ 47,530.86$ 16,657.86$ 30,873.00$ 3,705,469.75$ 3,554,350.50$ 3,290,093.94$

145 3,705,469.75$ 47,530.86$ 16,520.22$ 31,010.64$ 3,674,459.10$ 3,570,870.72$ 3,321,104.58$

146 3,674,459.10$ 47,530.86$ 16,381.96$ 31,148.90$ 3,643,310.20$ 3,587,252.69$ 3,352,253.49$

147 3,643,310.20$ 47,530.86$ 16,243.09$ 31,287.77$ 3,612,022.43$ 3,603,495.78$ 3,383,541.26$

148 3,612,022.43$ 47,530.86$ 16,103.60$ 31,427.26$ 3,580,595.16$ 3,619,599.38$ 3,414,968.52$

149 3,580,595.16$ 47,530.86$ 15,963.49$ 31,567.38$ 3,549,027.79$ 3,635,562.87$ 3,446,535.90$

150 3,549,027.79$ 47,530.86$ 15,822.75$ 31,708.12$ 3,517,319.67$ 3,651,385.61$ 3,478,244.02$

151 3,517,319.67$ 47,530.86$ 15,681.38$ 31,849.48$ 3,485,470.19$ 3,667,067.00$ 3,510,093.50$

152 3,485,470.19$ 47,530.86$ 15,539.39$ 31,991.48$ 3,453,478.72$ 3,682,606.39$ 3,542,084.97$

153 3,453,478.72$ 47,530.86$ 15,396.76$ 32,134.10$ 3,421,344.61$ 3,698,003.15$ 3,574,219.08$

154 3,421,344.61$ 47,530.86$ 15,253.49$ 32,277.37$ 3,389,067.24$ 3,713,256.64$ 3,606,496.45$

155 3,389,067.24$ 47,530.86$ 15,109.59$ 32,421.27$ 3,356,645.97$ 3,728,366.23$ 3,638,917.72$

156 3,356,645.97$ 47,530.86$ 14,965.05$ 32,565.82$ 3,324,080.15$ 3,743,331.28$ 3,671,483.54$

157 3,324,080.15$ 47,530.86$ 14,819.86$ 32,711.01$ 3,291,369.14$ 3,758,151.14$ 3,704,194.54$

158 3,291,369.14$ 47,530.86$ 14,674.02$ 32,856.84$ 3,258,512.30$ 3,772,825.16$ 3,737,051.39$

159 3,258,512.30$ 47,530.86$ 14,527.53$ 33,003.33$ 3,225,508.97$ 3,787,352.69$ 3,770,054.72$

160 3,225,508.97$ 47,530.86$ 14,380.39$ 33,150.47$ 3,192,358.50$ 3,801,733.08$ 3,803,205.19$

161 3,192,358.50$ 47,530.86$ 14,232.60$ 33,298.27$ 3,159,060.23$ 3,815,965.68$ 3,836,503.45$

162 3,159,060.23$ 47,530.86$ 14,084.14$ 33,446.72$ 3,125,613.51$ 3,830,049.83$ 3,869,950.17$

163 3,125,613.51$ 47,530.86$ 13,935.03$ 33,595.84$ 3,092,017.68$ 3,843,984.85$ 3,903,546.01$

164 3,092,017.68$ 47,530.86$ 13,785.25$ 33,745.62$ 3,058,272.06$ 3,857,770.10$ 3,937,291.63$

165 3,058,272.06$ 47,530.86$ 13,634.80$ 33,896.07$ 3,024,375.99$ 3,871,404.89$ 3,971,187.70$

166 3,024,375.99$ 47,530.86$ 13,483.68$ 34,047.19$ 2,990,328.80$ 3,884,888.57$ 4,005,234.89$

167 2,990,328.80$ 47,530.86$ 13,331.88$ 34,198.98$ 2,956,129.82$ 3,898,220.45$ 4,039,433.87$

168 2,956,129.82$ 47,530.86$ 13,179.41$ 34,351.45$ 2,921,778.37$ 3,911,399.87$ 4,073,785.32$

169 2,921,778.37$ 47,530.86$ 13,026.26$ 34,504.60$ 2,887,273.77$ 3,924,426.13$ 4,108,289.92$

170 2,887,273.77$ 47,530.86$ 12,872.43$ 34,658.44$ 2,852,615.33$ 3,937,298.56$ 4,142,948.36$

171 2,852,615.33$ 47,530.86$ 12,717.91$ 34,812.95$ 2,817,802.38$ 3,950,016.47$ 4,177,761.31$

172 2,817,802.38$ 47,530.86$ 12,562.70$ 34,968.16$ 2,782,834.21$ 3,962,579.17$ 4,212,729.47$

173 2,782,834.21$ 47,530.86$ 12,406.80$ 35,124.06$ 2,747,710.15$ 3,974,985.97$ 4,247,853.53$

174 2,747,710.15$ 47,530.86$ 12,250.21$ 35,280.66$ 2,712,429.50$ 3,987,236.18$ 4,283,134.19$

175 2,712,429.50$ 47,530.86$ 12,092.91$ 35,437.95$ 2,676,991.55$ 3,999,329.09$ 4,318,572.14$

176 2,676,991.55$ 47,530.86$ 11,934.92$ 35,595.94$ 2,641,395.60$ 4,011,264.01$ 4,354,168.08$

177 2,641,395.60$ 47,530.86$ 11,776.22$ 35,754.64$ 2,605,640.96$ 4,023,040.24$ 4,389,922.73$

178 2,605,640.96$ 47,530.86$ 11,616.82$ 35,914.05$ 2,569,726.91$ 4,034,657.05$ 4,425,836.77$

179 2,569,726.91$ 47,530.86$ 11,456.70$ 36,074.17$ 2,533,652.75$ 4,046,113.75$ 4,461,910.94$

180 2,533,652.75$ 47,530.86$ 11,295.87$ 36,235.00$ 2,497,417.75$ 4,057,409.62$ 4,498,145.94$

181 2,497,417.75$ 47,530.86$ 11,134.32$ 36,396.54$ 2,461,021.21$ 4,068,543.94$ 4,534,542.48$

182 2,461,021.21$ 47,530.86$ 10,972.05$ 36,558.81$ 2,424,462.40$ 4,079,515.99$ 4,571,101.29$

183 2,424,462.40$ 47,530.86$ 10,809.06$ 36,721.80$ 2,387,740.59$ 4,090,325.06$ 4,607,823.09$

184 2,387,740.59$ 47,530.86$ 10,645.34$ 36,885.52$ 2,350,855.07$ 4,100,970.40$ 4,644,708.61$

185 2,350,855.07$ 47,530.86$ 10,480.90$ 37,049.97$ 2,313,805.10$ 4,111,451.29$ 4,681,758.58$

186 2,313,805.10$ 47,530.86$ 10,315.71$ 37,215.15$ 2,276,589.96$ 4,121,767.01$ 4,718,973.73$

187 2,276,589.96$ 47,530.86$ 10,149.80$ 37,381.07$ 2,239,208.89$ 4,131,916.81$ 4,756,354.80$

188 2,239,208.89$ 47,530.86$ 9,983.14$ 37,547.72$ 2,201,661.16$ 4,141,899.95$ 4,793,902.52$

189 2,201,661.16$ 47,530.86$ 9,815.74$ 37,715.12$ 2,163,946.04$ 4,151,715.68$ 4,831,617.65$

190 2,163,946.04$ 47,530.86$ 9,647.59$ 37,883.27$ 2,126,062.77$ 4,161,363.28$ 4,869,500.92$

191 2,126,062.77$ 47,530.86$ 9,478.70$ 38,052.17$ 2,088,010.60$ 4,170,841.97$ 4,907,553.09$

192 2,088,010.60$ 47,530.86$ 9,309.05$ 38,221.82$ 2,049,788.78$ 4,180,151.02$ 4,945,774.90$

193 2,049,788.78$ 47,530.86$ 9,138.64$ 38,392.22$ 2,011,396.56$ 4,189,289.66$ 4,984,167.13$

194 2,011,396.56$ 47,530.86$ 8,967.48$ 38,563.39$ 1,972,833.17$ 4,198,257.14$ 5,022,730.52$

195 1,972,833.17$ 47,530.86$ 8,795.55$ 38,735.32$ 1,934,097.86$ 4,207,052.69$ 5,061,465.83$

196 1,934,097.86$ 47,530.86$ 8,622.85$ 38,908.01$ 1,895,189.84$ 4,215,675.54$ 5,100,373.84$

197 1,895,189.84$ 47,530.86$ 8,449.39$ 39,081.48$ 1,856,108.37$ 4,224,124.93$ 5,139,455.32$

198 1,856,108.37$ 47,530.86$ 8,275.15$ 39,255.71$ 1,816,852.65$ 4,232,400.08$ 5,178,711.03$

199 1,816,852.65$ 47,530.86$ 8,100.13$ 39,430.73$ 1,777,421.92$ 4,240,500.21$ 5,218,141.76$

200 1,777,421.92$ 47,530.86$ 7,924.34$ 39,606.52$ 1,737,815.40$ 4,248,424.55$ 5,257,748.29$

201 1,737,815.40$ 47,530.86$ 7,747.76$ 39,783.10$ 1,698,032.30$ 4,256,172.31$ 5,297,531.39$

202 1,698,032.30$ 47,530.86$ 7,570.39$ 39,960.47$ 1,658,071.83$ 4,263,742.71$ 5,337,491.86$

203 1,658,071.83$ 47,530.86$ 7,392.24$ 40,138.63$ 1,617,933.20$ 4,271,134.94$ 5,377,630.49$

204 1,617,933.20$ 47,530.86$ 7,213.29$ 40,317.58$ 1,577,615.62$ 4,278,348.23$ 5,417,948.07$

205 1,577,615.62$ 47,530.86$ 7,033.54$ 40,497.33$ 1,537,118.29$ 4,285,381.77$ 5,458,445.40$

206 1,537,118.29$ 47,530.86$ 6,852.99$ 40,677.88$ 1,496,440.41$ 4,292,234.75$ 5,499,123.27$

207 1,496,440.41$ 47,530.86$ 6,671.63$ 40,859.23$ 1,455,581.18$ 4,298,906.38$ 5,539,982.51$

208 1,455,581.18$ 47,530.86$ 6,489.47$ 41,041.40$ 1,414,539.78$ 4,305,395.85$ 5,581,023.91$

209 1,414,539.78$ 47,530.86$ 6,306.49$ 41,224.37$ 1,373,315.41$ 4,311,702.34$ 5,622,248.28$

210 1,373,315.41$ 47,530.86$ 6,122.70$ 41,408.17$ 1,331,907.24$ 4,317,825.03$ 5,663,656.45$

211 1,331,907.24$ 47,530.86$ 5,938.09$ 41,592.78$ 1,290,314.46$ 4,323,763.12$ 5,705,249.22$

212 1,290,314.46$ 47,530.86$ 5,752.65$ 41,778.21$ 1,248,536.25$ 4,329,515.77$ 5,747,027.44$

213 1,248,536.25$ 47,530.86$ 5,566.39$ 41,964.47$ 1,206,571.78$ 4,335,082.16$ 5,788,991.91$

214 1,206,571.78$ 47,530.86$ 5,379.30$ 42,151.57$ 1,164,420.21$ 4,340,461.46$ 5,831,143.48$

215 1,164,420.21$ 47,530.86$ 5,191.37$ 42,339.49$ 1,122,080.72$ 4,345,652.84$ 5,873,482.97$

216 1,122,080.72$ 47,530.86$ 5,002.61$ 42,528.25$ 1,079,552.47$ 4,350,655.45$ 5,916,011.22$

217 1,079,552.47$ 47,530.86$ 4,813.00$ 42,717.86$ 1,036,834.61$ 4,355,468.45$ 5,958,729.08$

218 1,036,834.61$ 47,530.86$ 4,622.55$ 42,908.31$ 993,926.30$ 4,360,091.01$ 6,001,637.39$

219 993,926.30$ 47,530.86$ 4,431.25$ 43,099.61$ 950,826.69$ 4,364,522.26$ 6,044,737.00$

220 950,826.69$ 47,530.86$ 4,239.10$ 43,291.76$ 907,534.93$ 4,368,761.36$ 6,088,028.76$

221 907,534.93$ 47,530.86$ 4,046.09$ 43,484.77$ 864,050.16$ 4,372,807.46$ 6,131,513.53$

222 864,050.16$ 47,530.86$ 3,852.22$ 43,678.64$ 820,371.51$ 4,376,659.68$ 6,175,192.17$

223 820,371.51$ 47,530.86$ 3,657.49$ 43,873.37$ 776,498.14$ 4,380,317.17$ 6,219,065.55$

224 776,498.14$ 47,530.86$ 3,461.89$ 44,068.98$ 732,429.16$ 4,383,779.06$ 6,263,134.52$

225 732,429.16$ 47,530.86$ 3,265.41$ 44,265.45$ 688,163.71$ 4,387,044.47$ 6,307,399.97$

226 688,163.71$ 47,530.86$ 3,068.06$ 44,462.80$ 643,700.91$ 4,390,112.53$ 6,351,862.78$

227 643,700.91$ 47,530.86$ 2,869.83$ 44,661.03$ 599,039.88$ 4,392,982.37$ 6,396,523.81$

228 599,039.88$ 47,530.86$ 2,670.72$ 44,860.14$ 554,179.74$ 4,395,653.09$ 6,441,383.95$

229 554,179.74$ 47,530.86$ 2,470.72$ 45,060.15$ 509,119.59$ 4,398,123.80$ 6,486,444.10$

230 509,119.59$ 47,530.86$ 2,269.82$ 45,261.04$ 463,858.55$ 4,400,393.63$ 6,531,705.14$

231 463,858.55$ 47,530.86$ 2,068.04$ 45,462.83$ 418,395.72$ 4,402,461.66$ 6,577,167.96$

232 418,395.72$ 47,530.86$ 1,865.35$ 45,665.52$ 372,730.21$ 4,404,327.01$ 6,622,833.48$

233 372,730.21$ 47,530.86$ 1,661.76$ 45,869.11$ 326,861.10$ 4,405,988.77$ 6,668,702.59$

234 326,861.10$ 47,530.86$ 1,457.26$ 46,073.61$ 280,787.49$ 4,407,446.02$ 6,714,776.20$

235 280,787.49$ 47,530.86$ 1,251.84$ 46,279.02$ 234,508.47$ 4,408,697.87$ 6,761,055.22$

236 234,508.47$ 47,530.86$ 1,045.52$ 46,485.35$ 188,023.12$ 4,409,743.38$ 6,807,540.57$

237 188,023.12$ 47,530.86$ 838.27$ 46,692.59$ 141,330.53$ 4,410,581.65$ 6,854,233.16$

238 141,330.53$ 47,530.86$ 630.10$ 46,900.77$ 94,429.76$ 4,411,211.75$ 6,901,133.93$

239 94,429.76$ 47,530.86$ 421.00$ 47,109.86$ 47,319.90$ 4,411,632.75$ 6,948,243.79$

240 47,319.90$ 47,530.86$ 210.97$ 47,319.90$ (0.00)$ 4,411,843.72$ 6,995,563.69$

241 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

242 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

243 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

244 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

245 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

246 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

247 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

248 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

249 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

250 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

251 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

252 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

253 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

254 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

255 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

256 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

257 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

258 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

259 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

260 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

261 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

262 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

263 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

264 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

265 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

266 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

267 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

268 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

269 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

270 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

271 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

272 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

273 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

274 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

275 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

276 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

277 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

278 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

279 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

280 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

281 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

282 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

283 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

284 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

285 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

286 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

287 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

288 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

289 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

290 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

291 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

292 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

293 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

294 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

295 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

296 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

297 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

298 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

299 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

300 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

301 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

302 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

303 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

304 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

305 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

306 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

307 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

308 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

309 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

310 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

311 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

312 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

313 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

314 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

315 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

316 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

317 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

318 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

319 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

320 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

321 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

322 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

323 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

324 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

325 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

326 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

327 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

328 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

329 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

330 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

331 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

332 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

333 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

334 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

335 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

336 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

337 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

338 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

339 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

340 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

341 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

342 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

343 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

344 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

345 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

346 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

347 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

348 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

349 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

350 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

351 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

352 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

353 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

354 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

355 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

356 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

357 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

358 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

359 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

360 (0.00)$ -$ (0.00)$ 0.00$ (0.00)$ 4,411,843.72$ 6,995,563.69$

Breakeven Occupancy

Gross Potential Rent 1,500,000.00$

Vacancy & Collection Loss 10% Test Vacancy & Collection Loss 34.20%

Other Income 50,000.00$

Effective Gross Income 1,400,000.00$ Test EGI 1,037,037.04$

Operating Expenses 45%

Net Operating Income 770,000.00$ Test NOI 570,370.37$

Annual Debt Service (570,370.37)$

Before Tax Cash Flow 199,629.63$ Test BTCF -$

Run

Breakeven

Macro

Turn in your highest-quality paper
Get a qualified writer to help you with

“ Loan and Property excel project ”

Get high-quality paper

NEW! AI matching with writer

Still stressed with your coursework?

Get quality coursework help from an expert!

Order now