Help! I need formulas to give me numbers from January 2010 to December 2012.
Whomever did my amort spreadsheet was attacked by the formula monster because he is doing too much to accomplish a little, IMO. A 48-month schedule started 12/1/10 but he only ran the formulas out to the end of 2011 and I need numbers to extend to 2012 but just look at his nasty formulas:
<b>Building Improvements</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:103px;" /><col style="width:102px;" /><col style="width:99px;" /><col style="width:80px;" /><col style="width:103px;" /><col style="width:16px;" /><col style="width:57px;" /><col style="width:320px;" /><col style="width:93px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td><td >AF</td><td >AG</td><td >AH</td><td >AI</td><td >AJ</td><td >AK</td><td >AL</td><td >AM</td><td >AN</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:left; border-style:solid; border-width:1px; border-color:#000000; ">$20,799.46</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 497.48 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">1311</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:2px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 497.48 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 4,650.37 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:2px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 374.82 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 122.66 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 377.09 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 120.39 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 381.66 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 115.82 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 383.96 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 386.28 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 111.20 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 388.62 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 390.96 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 393.33 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 101.78 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 99.39 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 96.98 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">$6,491.14</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 155.25 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1313</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 155.25 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 1,451.30 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 411.76 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 116.98 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 38.28 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 37.57 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 118.39 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 36.86 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 119.11 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 36.15 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 35.43 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 120.55 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 34.70 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 121.28 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 33.97 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 33.24 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 32.50 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 123.49 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 31.76 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 124.24 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 31.02 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 124.99 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 30.27 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">$3,839.00</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 91.82 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 243.52 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.18 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 22.64 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.60 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 22.22 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.02 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.80 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.44 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.38 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.87 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.95 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 71.30 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.09 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.66 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 72.60 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.22 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.04 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.79 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.48 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.92 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 87.91 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1315</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 87.91 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 821.75 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.67 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 66.63 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 67.04 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 67.44 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.06 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 68.26 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.65 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.24 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.82 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.50 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.40 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.92 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.98 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.35 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.56 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.77 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.14 </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >J9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I9/12,H9,F9,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I9/12,H9,F9,0,1)</span>)</td></tr><tr><td >L9</td><td >=+A9</td></tr><tr><td >M9</td><td >=D9</td></tr><tr><td >N9</td><td >=J9</td></tr><tr><td >O9</td><td >=SUM(Q9,S9,U9,W9,Y9,AA9,AC9,AE9,AG9,AI9,AK9,AM9)</td></tr><tr><td >P9</td><td >=SUM(R9,T9,V9,X9,Z9,AB9,AD9,AF9,AH9,AJ9,AL9,AN9)</td></tr><tr><td >Q9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,Q$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,Q$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >R9</td><td >=IF(Q9=0,0,+$J9-Q9)</td></tr><tr><td >S9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,S$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,S$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >T9</td><td >=IF(S9=0,0,+$J9-S9)</td></tr><tr><td >U9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,U$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,U$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >V9</td><td >=IF(U9=0,0,+$J9-U9)</td></tr><tr><td >W9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,W$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,W$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >X9</td><td >=IF(W9=0,0,+$J9-W9)</td></tr><tr><td >Y9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,Y$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,Y$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >Z9</td><td >=IF(Y9=0,0,+$J9-Y9)</td></tr><tr><td >AA9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AA$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AA$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AB9</td><td >=IF(AA9=0,0,+$J9-AA9)</td></tr><tr><td >AC9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AC$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AC$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AD9</td><td >=IF(AC9=0,0,+$J9-AC9)</td></tr><tr><td >AE9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AE$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AE$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AF9</td><td >=IF(AE9=0,0,+$J9-AE9)</td></tr><tr><td >AG9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AG$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AG$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AH9</td><td >=IF(AG9=0,0,+$J9-AG9)</td></tr><tr><td >AI9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AI$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AI$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AJ9</td><td >=IF(AI9=0,0,+$J9-AI9)</td></tr><tr><td >AK9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AK$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AK$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AL9</td><td >=IF(AK9=0,0,+$J9-AK9)</td></tr><tr><td >AM9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AM$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AM$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AN9</td><td >=IF(AM9=0,0,+$J9-AM9)</td></tr><tr><td >J10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I10/12,H10,F10,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I10/12,H10,F10,0,1)</span>)</td></tr><tr><td >L10</td><td >=+A10</td></tr><tr><td >M10</td><td >=D10</td></tr><tr><td >N10</td><td >=J10</td></tr><tr><td >O10</td><td >=SUM(Q10,S10,U10,W10,Y10,AA10,AC10,AE10,AG10,AI10,AK10,AM10)</td></tr><tr><td >P10</td><td >=SUM(R10,T10,V10,X10,Z10,AB10,AD10,AF10,AH10,AJ10,AL10,AN10)</td></tr><tr><td >Q10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,Q$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,Q$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >R10</td><td >=IF(Q10=0,0,+$J10-Q10)</td></tr><tr><td >S10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,S$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,S$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >T10</td><td >=IF(S10=0,0,+$J10-S10)</td></tr><tr><td >U10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,U$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,U$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >V10</td><td >=IF(U10=0,0,+$J10-U10)</td></tr><tr><td >W10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,W$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,W$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >X10</td><td >=IF(W10=0,0,+$J10-W10)</td></tr><tr><td >Y10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,Y$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,Y$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >Z10</td><td >=IF(Y10=0,0,+$J10-Y10)</td></tr><tr><td >AA10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AA$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AA$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AB10</td><td >=IF(AA10=0,0,+$J10-AA10)</td></tr><tr><td >AC10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AC$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AC$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AD10</td><td >=IF(AC10=0,0,+$J10-AC10)</td></tr><tr><td >AE10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AE$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AE$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AF10</td><td >=IF(AE10=0,0,+$J10-AE10)</td></tr><tr><td >AG10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AG$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AG$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AH10</td><td >=IF(AG10=0,0,+$J10-AG10)</td></tr><tr><td >AI10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AI$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AI$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AJ10</td><td >=IF(AI10=0,0,+$J10-AI10)</td></tr><tr><td >AK10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AK$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AK$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AL10</td><td >=IF(AK10=0,0,+$J10-AK10)</td></tr><tr><td >AM10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AM$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AM$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AN10</td><td >=IF(AM10=0,0,+$J10-AM10)</td></tr><tr><td >J11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I11/12,H11,F11,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I11/12,H11,F11,0,1)</span>)</td></tr><tr><td >L11</td><td >=+A11</td></tr><tr><td >M11</td><td >=D11</td></tr><tr><td >N11</td><td >=J11</td></tr><tr><td >O11</td><td >=SUM(Q11,S11,U11,W11,Y11,AA11,AC11,AE11,AG11,AI11,AK11,AM11)</td></tr><tr><td >P11</td><td >=SUM(R11,T11,V11,X11,Z11,AB11,AD11,AF11,AH11,AJ11,AL11,AN11)</td></tr><tr><td >Q11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,Q$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,Q$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >R11</td><td >=IF(Q11=0,0,+$J11-Q11)</td></tr><tr><td >S11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,S$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,S$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >T11</td><td >=IF(S11=0,0,+$J11-S11)</td></tr><tr><td >U11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,U$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,U$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >V11</td><td >=IF(U11=0,0,+$J11-U11)</td></tr><tr><td >W11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,W$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,W$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >X11</td><td >=IF(W11=0,0,+$J11-W11)</td></tr><tr><td >Y11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,Y$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,Y$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >Z11</td><td >=IF(Y11=0,0,+$J11-Y11)</td></tr><tr><td >AA11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AA$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AA$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AB11</td><td >=IF(AA11=0,0,+$J11-AA11)</td></tr><tr><td >AC11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AC$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AC$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AD11</td><td >=IF(AC11=0,0,+$J11-AC11)</td></tr><tr><td >AE11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AE$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AE$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AF11</td><td >=IF(AE11=0,0,+$J11-AE11)</td></tr><tr><td >AG11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AG$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AG$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AH11</td><td >=IF(AG11=0,0,+$J11-AG11)</td></tr><tr><td >AI11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AI$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AI$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AJ11</td><td >=IF(AI11=0,0,+$J11-AI11)</td></tr><tr><td >AK11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AK$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AK$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AL11</td><td >=IF(AK11=0,0,+$J11-AK11)</td></tr><tr><td >AM11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AM$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AM$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AN11</td><td >=IF(AM11=0,0,+$J11-AM11)</td></tr><tr><td >J12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I12/12,H12,F12,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I12/12,H12,F12,0,1)</span>)</td></tr><tr><td >L12</td><td >=+A12</td></tr><tr><td >M12</td><td >=D12</td></tr><tr><td >N12</td><td >=J12</td></tr><tr><td >O12</td><td >=SUM(Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12)</td></tr><tr><td >P12</td><td >=SUM(R12,T12,V12,X12,Z12,AB12,AD12,AF12,AH12,AJ12,AL12,AN12)</td></tr><tr><td >Q12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,Q$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,Q$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >R12</td><td >=IF(Q12=0,0,+$J12-Q12)</td></tr><tr><td >S12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,S$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,S$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >T12</td><td >=IF(S12=0,0,+$J12-S12)</td></tr><tr><td >U12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,U$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,U$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >V12</td><td >=IF(U12=0,0,+$J12-U12)</td></tr><tr><td >W12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,W$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,W$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >X12</td><td >=IF(W12=0,0,+$J12-W12)</td></tr><tr><td >Y12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,Y$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,Y$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >Z12</td><td >=IF(Y12=0,0,+$J12-Y12)</td></tr><tr><td >AA12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AA$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AA$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AB12</td><td >=IF(AA12=0,0,+$J12-AA12)</td></tr><tr><td >AC12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AC$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AC$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AD12</td><td >=IF(AC12=0,0,+$J12-AC12)</td></tr><tr><td >AE12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AE$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AE$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AF12</td><td >=IF(AE12=0,0,+$J12-AE12)</td></tr><tr><td >AG12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AG$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AG$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AH12</td><td >=IF(AG12=0,0,+$J12-AG12)</td></tr><tr><td >AI12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AI$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AI$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AJ12</td><td >=IF(AI12=0,0,+$J12-AI12)</td></tr><tr><td >AK12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AK$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AK$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AL12</td><td >=IF(AK12=0,0,+$J12-AK12)</td></tr><tr><td >AM12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AM$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AM$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AN12</td><td >=IF(AM12=0,0,+$J12-AM12)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1
Whomever did my amort spreadsheet was attacked by the formula monster because he is doing too much to accomplish a little, IMO. A 48-month schedule started 12/1/10 but he only ran the formulas out to the end of 2011 and I need numbers to extend to 2012 but just look at his nasty formulas:
<b>Building Improvements</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Arial,Arial; font-size:10pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; "> <colgroup><col style="font-weight:bold; width:30px; " /><col style="width:103px;" /><col style="width:102px;" /><col style="width:99px;" /><col style="width:80px;" /><col style="width:103px;" /><col style="width:16px;" /><col style="width:57px;" /><col style="width:320px;" /><col style="width:93px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /><col style="width:82px;" /></colgroup><tr style="background-color:#cacaca; text-align:center; font-weight:bold; font-size:8pt; "><td > </td><td >F</td><td >G</td><td >H</td><td >I</td><td >J</td><td >K</td><td >L</td><td >M</td><td >N</td><td >O</td><td >P</td><td >Q</td><td >R</td><td >S</td><td >T</td><td >U</td><td >V</td><td >W</td><td >X</td><td >Y</td><td >Z</td><td >AA</td><td >AB</td><td >AC</td><td >AD</td><td >AE</td><td >AF</td><td >AG</td><td >AH</td><td >AI</td><td >AJ</td><td >AK</td><td >AL</td><td >AM</td><td >AN</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >9</td><td style="text-align:left; border-style:solid; border-width:1px; border-color:#000000; ">$20,799.46</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 497.48 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">1311</td><td style="text-align:left; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:2px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 497.48 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 4,650.37 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:2px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 374.82 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 122.66 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 377.09 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 120.39 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 381.66 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 115.82 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 383.96 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 386.28 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 111.20 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 388.62 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 390.96 </td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 393.33 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 101.78 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 99.39 </td><td style="color:#0000ff; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-top-style:solid; border-right-style:solid; border-bottom-style:solid; border-top-width:1px; border-right-width:1px; border-bottom-width:1px; border-top-color:#000000; border-right-color:#000000; border-bottom-color:#000000; "> $ 96.98 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">$6,491.14</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 155.25 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; "> </td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1313</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 155.25 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 1,451.30 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 411.76 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 116.98 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 38.28 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 37.57 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 118.39 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 36.86 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 119.11 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 36.15 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 35.43 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 120.55 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 34.70 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 121.28 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 33.97 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 33.24 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 32.50 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 123.49 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 31.76 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 124.24 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 31.02 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 124.99 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 30.27 </td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >11</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">$3,839.00</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 91.82 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 243.52 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.18 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 22.64 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.60 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 22.22 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.02 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.80 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.44 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.38 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.87 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.95 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 71.30 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.09 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.66 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 72.60 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.22 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.04 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.79 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.48 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 73.92 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td></tr><tr style="height:17px ;" ><td style="font-size:8pt; background-color:#cacaca; text-align:center; " >12</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-left-style:solid; border-right-width:1px; border-bottom-width:1px; border-left-width:1px; border-right-color:#000000; border-bottom-color:#000000; border-left-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">12/01/10</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">48</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">7.25%</td><td style="background-color:#c0c0c0; text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 87.91 </td><td style=" border-right-style:solid; border-right-width:1px; border-right-color:#000000; ">XXX</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">1315</td><td style="text-align:left; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">Parking lot re-slurry</td><td style="text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 87.91 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 821.75 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:2px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 21.67 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 66.63 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 67.04 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 67.44 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 20.06 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 68.26 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.65 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 19.24 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; ">XXX</td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.82 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.50 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 18.40 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 69.92 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.98 </td><td style="background-color:#c0c0c0; color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.35 </td><td style="background-color:#c0c0c0; color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.56 </td><td style="color:#0000ff; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 70.77 </td><td style="color:#008000; text-align:center; border-right-style:solid; border-bottom-style:solid; border-right-width:1px; border-bottom-width:1px; border-right-color:#000000; border-bottom-color:#000000; "> $ 17.14 </td></tr></table><br /><table style="font-family:Arial; font-size:10pt; border-style: groove ;border-color:#00ff00;background-color:#fffcf9; color:#000000; "><tr><td ><b>Spreadsheet Formulas</b></td></tr><tr><td ><table border = "1" cellspacing="0" cellpadding="2" style="font-family:Arial; font-size:9pt;"><tr style="background-color:#cacaca; font-size:10pt;"><td >Cell</td><td >Formula</td></tr><tr><td >J9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I9/12,H9,F9,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I9/12,H9,F9,0,1)</span>)</td></tr><tr><td >L9</td><td >=+A9</td></tr><tr><td >M9</td><td >=D9</td></tr><tr><td >N9</td><td >=J9</td></tr><tr><td >O9</td><td >=SUM(Q9,S9,U9,W9,Y9,AA9,AC9,AE9,AG9,AI9,AK9,AM9)</td></tr><tr><td >P9</td><td >=SUM(R9,T9,V9,X9,Z9,AB9,AD9,AF9,AH9,AJ9,AL9,AN9)</td></tr><tr><td >Q9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,Q$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,Q$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >R9</td><td >=IF(Q9=0,0,+$J9-Q9)</td></tr><tr><td >S9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,S$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,S$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >T9</td><td >=IF(S9=0,0,+$J9-S9)</td></tr><tr><td >U9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,U$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,U$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >V9</td><td >=IF(U9=0,0,+$J9-U9)</td></tr><tr><td >W9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,W$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,W$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >X9</td><td >=IF(W9=0,0,+$J9-W9)</td></tr><tr><td >Y9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,Y$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,Y$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >Z9</td><td >=IF(Y9=0,0,+$J9-Y9)</td></tr><tr><td >AA9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AA$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AA$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AB9</td><td >=IF(AA9=0,0,+$J9-AA9)</td></tr><tr><td >AC9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AC$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AC$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AD9</td><td >=IF(AC9=0,0,+$J9-AC9)</td></tr><tr><td >AE9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AE$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AE$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AF9</td><td >=IF(AE9=0,0,+$J9-AE9)</td></tr><tr><td >AG9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AG$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AG$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AH9</td><td >=IF(AG9=0,0,+$J9-AG9)</td></tr><tr><td >AI9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AI$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AI$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AJ9</td><td >=IF(AI9=0,0,+$J9-AI9)</td></tr><tr><td >AK9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AK$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AK$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AL9</td><td >=IF(AK9=0,0,+$J9-AK9)</td></tr><tr><td >AM9</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I9/12,DATEDIF<span style=' color:#ff0000; '>($G9,AM$27,"m")</span>+1,$H9,$F9,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I9/12,DATEDIF<span style=' color:#0000ff; '>($G9,AM$27,"m")</span>+1,$H9,$F9,0,1)</span>)</td></tr><tr><td >AN9</td><td >=IF(AM9=0,0,+$J9-AM9)</td></tr><tr><td >J10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I10/12,H10,F10,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I10/12,H10,F10,0,1)</span>)</td></tr><tr><td >L10</td><td >=+A10</td></tr><tr><td >M10</td><td >=D10</td></tr><tr><td >N10</td><td >=J10</td></tr><tr><td >O10</td><td >=SUM(Q10,S10,U10,W10,Y10,AA10,AC10,AE10,AG10,AI10,AK10,AM10)</td></tr><tr><td >P10</td><td >=SUM(R10,T10,V10,X10,Z10,AB10,AD10,AF10,AH10,AJ10,AL10,AN10)</td></tr><tr><td >Q10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,Q$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,Q$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >R10</td><td >=IF(Q10=0,0,+$J10-Q10)</td></tr><tr><td >S10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,S$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,S$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >T10</td><td >=IF(S10=0,0,+$J10-S10)</td></tr><tr><td >U10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,U$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,U$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >V10</td><td >=IF(U10=0,0,+$J10-U10)</td></tr><tr><td >W10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,W$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,W$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >X10</td><td >=IF(W10=0,0,+$J10-W10)</td></tr><tr><td >Y10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,Y$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,Y$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >Z10</td><td >=IF(Y10=0,0,+$J10-Y10)</td></tr><tr><td >AA10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AA$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AA$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AB10</td><td >=IF(AA10=0,0,+$J10-AA10)</td></tr><tr><td >AC10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AC$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AC$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AD10</td><td >=IF(AC10=0,0,+$J10-AC10)</td></tr><tr><td >AE10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AE$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AE$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AF10</td><td >=IF(AE10=0,0,+$J10-AE10)</td></tr><tr><td >AG10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AG$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AG$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AH10</td><td >=IF(AG10=0,0,+$J10-AG10)</td></tr><tr><td >AI10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AI$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AI$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AJ10</td><td >=IF(AI10=0,0,+$J10-AI10)</td></tr><tr><td >AK10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AK$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AK$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AL10</td><td >=IF(AK10=0,0,+$J10-AK10)</td></tr><tr><td >AM10</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I10/12,DATEDIF<span style=' color:#ff0000; '>($G10,AM$27,"m")</span>+1,$H10,$F10,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I10/12,DATEDIF<span style=' color:#0000ff; '>($G10,AM$27,"m")</span>+1,$H10,$F10,0,1)</span>)</td></tr><tr><td >AN10</td><td >=IF(AM10=0,0,+$J10-AM10)</td></tr><tr><td >J11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I11/12,H11,F11,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I11/12,H11,F11,0,1)</span>)</td></tr><tr><td >L11</td><td >=+A11</td></tr><tr><td >M11</td><td >=D11</td></tr><tr><td >N11</td><td >=J11</td></tr><tr><td >O11</td><td >=SUM(Q11,S11,U11,W11,Y11,AA11,AC11,AE11,AG11,AI11,AK11,AM11)</td></tr><tr><td >P11</td><td >=SUM(R11,T11,V11,X11,Z11,AB11,AD11,AF11,AH11,AJ11,AL11,AN11)</td></tr><tr><td >Q11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,Q$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,Q$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >R11</td><td >=IF(Q11=0,0,+$J11-Q11)</td></tr><tr><td >S11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,S$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,S$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >T11</td><td >=IF(S11=0,0,+$J11-S11)</td></tr><tr><td >U11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,U$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,U$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >V11</td><td >=IF(U11=0,0,+$J11-U11)</td></tr><tr><td >W11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,W$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,W$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >X11</td><td >=IF(W11=0,0,+$J11-W11)</td></tr><tr><td >Y11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,Y$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,Y$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >Z11</td><td >=IF(Y11=0,0,+$J11-Y11)</td></tr><tr><td >AA11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AA$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AA$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AB11</td><td >=IF(AA11=0,0,+$J11-AA11)</td></tr><tr><td >AC11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AC$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AC$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AD11</td><td >=IF(AC11=0,0,+$J11-AC11)</td></tr><tr><td >AE11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AE$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AE$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AF11</td><td >=IF(AE11=0,0,+$J11-AE11)</td></tr><tr><td >AG11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AG$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AG$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AH11</td><td >=IF(AG11=0,0,+$J11-AG11)</td></tr><tr><td >AI11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AI$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AI$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AJ11</td><td >=IF(AI11=0,0,+$J11-AI11)</td></tr><tr><td >AK11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AK$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AK$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AL11</td><td >=IF(AK11=0,0,+$J11-AK11)</td></tr><tr><td >AM11</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I11/12,DATEDIF<span style=' color:#ff0000; '>($G11,AM$27,"m")</span>+1,$H11,$F11,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I11/12,DATEDIF<span style=' color:#0000ff; '>($G11,AM$27,"m")</span>+1,$H11,$F11,0,1)</span>)</td></tr><tr><td >AN11</td><td >=IF(AM11=0,0,+$J11-AM11)</td></tr><tr><td >J12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PMT<span style=' color:#0000ff; '>(I12/12,H12,F12,0,1)</span>)</span>,"",-PMT<span style=' color:008000; '>(I12/12,H12,F12,0,1)</span>)</td></tr><tr><td >L12</td><td >=+A12</td></tr><tr><td >M12</td><td >=D12</td></tr><tr><td >N12</td><td >=J12</td></tr><tr><td >O12</td><td >=SUM(Q12,S12,U12,W12,Y12,AA12,AC12,AE12,AG12,AI12,AK12,AM12)</td></tr><tr><td >P12</td><td >=SUM(R12,T12,V12,X12,Z12,AB12,AD12,AF12,AH12,AJ12,AL12,AN12)</td></tr><tr><td >Q12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,Q$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,Q$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >R12</td><td >=IF(Q12=0,0,+$J12-Q12)</td></tr><tr><td >S12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,S$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,S$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >T12</td><td >=IF(S12=0,0,+$J12-S12)</td></tr><tr><td >U12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,U$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,U$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >V12</td><td >=IF(U12=0,0,+$J12-U12)</td></tr><tr><td >W12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,W$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,W$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >X12</td><td >=IF(W12=0,0,+$J12-W12)</td></tr><tr><td >Y12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,Y$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,Y$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >Z12</td><td >=IF(Y12=0,0,+$J12-Y12)</td></tr><tr><td >AA12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AA$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AA$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AB12</td><td >=IF(AA12=0,0,+$J12-AA12)</td></tr><tr><td >AC12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AC$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AC$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AD12</td><td >=IF(AC12=0,0,+$J12-AC12)</td></tr><tr><td >AE12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AE$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AE$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AF12</td><td >=IF(AE12=0,0,+$J12-AE12)</td></tr><tr><td >AG12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AG$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AG$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AH12</td><td >=IF(AG12=0,0,+$J12-AG12)</td></tr><tr><td >AI12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AI$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AI$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AJ12</td><td >=IF(AI12=0,0,+$J12-AI12)</td></tr><tr><td >AK12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AK$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AK$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AL12</td><td >=IF(AK12=0,0,+$J12-AK12)</td></tr><tr><td >AM12</td><td >=IF(ISERROR<span style=' color:008000; '>(-PPMT<span style=' color:#0000ff; '>($I12/12,DATEDIF<span style=' color:#ff0000; '>($G12,AM$27,"m")</span>+1,$H12,$F12,0,1)</span>)</span>,0,-PPMT<span style=' color:008000; '>($I12/12,DATEDIF<span style=' color:#0000ff; '>($G12,AM$27,"m")</span>+1,$H12,$F12,0,1)</span>)</td></tr><tr><td >AN12</td><td >=IF(AM12=0,0,+$J12-AM12)</td></tr></table></td></tr></table> <br /><br /><span style="font-family:Arial; font-size:9pt; font-weight:bold;background-color:#ffffff; color:#000000; ">Excel tables to the web >> </span><a style ="font-family:Arial; font-size:9pt; color:#fcf507; background-color:#800040; font-weight:bold;" href="http://www.excel-jeanie-html.de/index.php?f=1
