Page 2 CITY OF ROSEVILLE HR A
<br />HAR MAR APARTMENTS - TAX INCREMENT ANALYSIS
<br />CASH FLOW AND PRESENT VALUE
<br /><---------------ANNUAL -------------> <---------------------------------- SEMI - ANNUAL ------------------------------------------->
<br />(a)(b)(c)(d)(e)(f)(g)(h)(i)(j)
<br />OriginalEstimatedCapturedEst. T.I.Less:AvailableCumulative<------ Present Value ------>
<br />TaxTaxTax(d) xAdminTaxAvail. TaxSemi AnnualCumulative
<br />DateCapacityCapacityCapacity 0.94501 FeesIncrementIncrementBalanceBalance
<br />(see assumptions)(c) - (b)- St. Aud. Fe e (e) x(e) - (f)Total of (g)P.V. of (g)Total of (i)
<br />2.50 %Inflation (prev. year)0.360 %10.00 %6.50 %06/01/08
<br />06/01/0639,96239,962000000
<br />12/01/0639,96239,962000000
<br />06/01/0739,96239,9620000000
<br />12/01/0739,96239,9620000000
<br />06/01/0839,96239,9620000000
<br />12/01/0839,96239,9620000000
<br />106/01/0939,96256,3250000000
<br />12/01/0939,96256,3250000000
<br />206/01/1039,96295,82516,3637,7047706,9336,9336,1016,101
<br />12/01/1039,96295,82516,3637,7047706,93313,8675,90912,009
<br />306/01/1139,96295,82555,86326,3002,63023,67037,53719,53731,547
<br />12/01/1139,96295,82555,86326,3002,63023,67061,20718,92250,469
<br />406/01/1239,96298,22155,86326,3002,63023,67084,87818,32768,796
<br />12/01/1239,96298,22155,86326,3002,63023,670108,54817,75086,546
<br />506/01/1339,962100,67658,25827,4282,74324,685133,23317,928104,474
<br />12/01/1339,962100,67658,25827,4282,74324,685157,91917,364121,838
<br />606/01/1439,962103,19360,71428,5842,85825,726183,64517,526139,364
<br />12/01/1439,962103,19360,71428,5842,85825,726209,37116,975156,339
<br />706/01/1539,962105,77363,23129,7692,97726,792236,16317,122173,461
<br />12/01/1539,962105,77363,23129,7692,97726,792262,95616,583190,044
<br />806/01/1639,962108,41765,81130,9843,09827,886290,84116,716206,760
<br />12/01/1639,962108,41765,81130,9843,09827,886318,72716,190222,950
<br />906/01/1739,962111,12868,45532,2293,22329,006347,73316,310239,260
<br />12/01/1739,962111,12868,45532,2293,22329,006376,73815,797255,057
<br />1006/01/1839,962113,90671,16533,5053,35030,154406,89315,906270,963
<br />12/01/1839,962113,90671,16533,5053,35030,154437,04715,405286,368
<br />1106/01/1939,962116,75373,94434,8133,48131,332468,37915,502301,870
<br />12/01/1939,962116,75373,94434,8133,48131,332499,71115,015316,885
<br />1206/01/2039,962119,67276,79136,1543,61532,538532,24915,102331,987
<br />12/01/2039,962119,67276,79136,1543,61532,538564,78714,627346,613
<br />1306/01/2139,962122,66479,71037,5283,75333,775598,56214,705361,318
<br />12/01/2139,962122,66479,71037,5283,75333,775632,33714,242375,560
<br />1406/01/2239,962125,73182,70238,9363,89435,043667,38014,311389,871
<br />12/01/2239,962125,73182,70238,9363,89435,043702,42313,861403,732
<br />1506/01/2339,962128,87485,76840,3804,03836,342738,76513,922417,654
<br />12/01/2339,962128,87485,76840,3804,03836,342775,10713,484431,138
<br />1606/01/2439,962132,09688,91241,8604,18637,674812,78113,538444,676
<br />12/01/2439,962132,09688,91241,8604,18637,674850,45513,112457,788
<br />1706/01/2539,962135,39892,13443,3774,33839,039889,49413,159470,948
<br />12/01/2539,962135,39892,13443,3774,33839,039928,53312,745483,693
<br />1806/01/2639,962138,78395,43644,9324,49340,438968,97212,787496,479
<br />12/01/2639,962138,78395,43644,9324,49340,4381,009,41012,384508,863
<br />1906/01/2739,962142,25398,82146,5254,65341,8731,051,28312,420521,283
<br />12/01/2739,962142,25398,82146,5254,65341,8731,093,15612,029533,312
<br />2006/01/2839,962145,809102,29148,1594,81643,3431,136,49912,059545,371
<br />12/01/2839,962145,809102,29148,1594,81643,3431,179,84111,680557,050
<br />2106/01/2939,962149,454105,84749,8334,98344,8501,224,69111,705568,756
<br />12/01/2939,962149,454105,84749,8334,98344,8501,269,54111,337580,092
<br />2206/01/3039,962153,191109,49251,5495,15546,3941,315,93511,358591,450
<br />12/01/3039,962153,191109,49251,5495,15546,3941,362,33011,001602,451
<br />2306/01/3139,962157,020113,22853,3085,33147,9781,410,30711,018613,469
<br />12/01/3139,962157,020113,22853,3085,33147,9781,458,28510,671624,140
<br />2406/01/3239,962160,946117,05855,1115,51149,6001,507,88510,685634,824
<br />12/01/3239,962160,946117,05855,1115,51149,6001,557,48510,348645,173
<br />2506/01/3339,962164,970120,98456,9605,69651,2641,608,74910,359655,531
<br />12/01/3339,962164,970120,98456,9605,69651,2641,660,01310,033665,564
<br />2606/01/3439,962169,094125,00758,8545,88552,9691,712,98110,040675,604
<br />12/01/3439,962169,094125,00758,8545,88552,9691,765,9509,724685,328
<br />1,962,167196,2171,765,9501,765,950685,328685,328
<br />Har Mar Apartments 2.xlsPrepared by Krass Monroe, P.A.10/13/2006
|