|
Salem Area Transit
<br />Expense
<br />Assumption
<br /> Condo OINce Maintenance Fee (ze,eeasf ~ 5.29~s~
<br />1 Cleaning Expense
<br />2 Personnel Experne
<br />3 Mina Mafntenance
<br />4 Olher Maintenance
<br />5 HVAC Maintenance
<br />6 ElecMCal Maintenance
<br />7 Utllitles
<br />e SecurltylLHe Safety
<br />9 Insuranee
<br />10 Misceilaneous Costs
<br />Transit Mall
<br />11 Cieaning Expense (.5 PTE Service woricer)
<br />12 Maintenance (ee.eza s~
<br />13 Udlitles (88,824 s~
<br />Other Expensea
<br />74 Maja Malntenance Reserve
<br />15 OtAce Cleaning (.5 FTE Service worker)
<br />16 PaAcing Maintenance
<br />17 Leasing Apent (5%)
<br />18 Property Taxes on 6578sf of Leased Space if
<br />Total Expenses
<br />RevenuelExpenae Reductions
<br />Expense Reductions
<br />Current Downtown Funds:
<br />19 Rent (savings)
<br />20 U8litlea (aavings)
<br />21 Storape Unlt (savings)
<br />Reve~ue
<br />22 Tranait Retall (~889aq (s% vacancy a~bwed) #
<br />23 T2nsk Expanslon (27oes~ (5%vacancy a~bwed) #
<br />24 Parking Revenue (4o spaces- ~2 rented)
<br />25 Private Land Lease on 20,000 sf
<br />Total Revenuea and Expanse Reductlons
<br />Annual Net Cash Flow
<br />Cumulative Net Cash Flow
<br />10 Year CH2 Operating Pro Forma
<br />BASED ON CURRENT REDESIGN & 3-1&98 MMDC PROFORMA
<br />Prepared 3-25-98
<br />Monthy Annual Annuai Annual Annual Annuai
<br />Rate/sf Amount Amount Amount Amount Amount
<br />Year 7 Year 2 Year 3 Year 4 Year S
<br />Annual Annual Annual Annual Annual
<br />Amount Amount Amount Amount Amount
<br />Year 8 Year 7 Ysa~ 8 Year 9 Year 10
<br />S 0.089 3 28,712•71 S 29,660•80 S 31,055.02 a 32,297.22 b 33,589.11 a 34,932.67 a 36,329.98 S 37,783.18 S 39,294.51 S 40,866.29
<br />0.025 8,065.20 8,387.81 8,723.32 9,072.25 9,435.14 9,812.55 10,205.05 10,613.25 11,037.78 11,4~9.29
<br />0.002 645.22 671.02 697.87 725.78 754.81 785.00 816.40 849.08 883.02 918.34
<br />0.018 5,808.94 6,039.22 6.280.79 6,532.02 8,793.30 7,065.04 7,347.64 7,641.54 7,947.20 8,265.09
<br />0.023 7,419.96 7.778.78 8,025.45 8,348.47 8,680.33 9,027.55 9,388.65 9,764.19 10,154.76 10,560.95
<br />0.005 1,613.04 1.677.56 1,744.66 1,814.45 1,887.03 1,962.51 2,041.01 2,122.65 2,207.56 2,295.86
<br />0.101 32,583.41 33,886.74 35,242.21 36,651.80 38,117.98 39,642.70 41,228.41 42,877.54 44,592.64 46,378.35
<br />0.004 1,290.43 1,342.05 1,396.73 1,461.56 1,509.82 1,570.01 1,832.81 1,898.12 1,766.05 1,836.89
<br />0.014 4,518.51 4,697.77 4,885.06 5,080.48 5,283.68 5,495.03 5,714.83 5,943.42 6,181.78 6,428.40
<br />0.009 2,903.47 3,079.61 3,140.40 3,266.01 3,396.65 3,532.52 3,873.82 3,820.77 3,973.60 4,132.55
<br />a 0.290 S 93,556.32 S 97,298.57 E 101,190.52 S 105,238.14 S 109,447.66 E 113,825.57 a 118.378.59 E 123,113.73 E 128,038.28 a 133,159.82
<br />S 15,480.00 S 16,410.35 S 17,396.61 $ 18,442.15 Z 19,550.52 S 20.725.51 S 21.971.11 $ 23,291.57 a 24,691.40 a 26.175.35
<br />a 0.040 32,075.52 33,358.54 34,692.68 36,080.60 37,523.82 39,024.77 40,585.77 42,209.20 43,897.56 45,653.47
<br />0.010 8,018.88 8,339.84 8,673.22 9,020.16 9,380.96 9,756.19 10,146.44 10,552.30 10,974.39 11,413.37
<br />a 0.050 $ 55,574.40 S 58,108.52 3 60,762.71 a 63,542.89 S 66,455.30 S 69,506.47 $ 72,703.32 s 76,053.07 S 79,563.35 S 83,242.18
<br />0.020 S 6,452.16 $ 6,710.25 E 8,978.66 E 7,257.80 S 7,548.11 5 7,850.04 S 8,164.04 a 8,490.60 S 8,830.23 s 9,183.44
<br />15,480.00 16,410.35 17,396.61 18,442.75 19,550.52 20,725.51 21,971.11 23,291.57 24,691.40 26,175.35
<br />0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br />0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00
<br />0.160 12,629.76 13,008.65 13,398.91 13,800.88 14,214.9 7 14,641.35 15,080.59 15,533.01 15,999.00 16,478.97
<br />E 34,561.92 S 36,12925 S 37,774.18 E 39,600.83 S 41,313.54 S 43,276.90 S 45,215.74 S 47,315.19 S 49,520.62 S 51,837.76
<br />
<br />S 183,682.64 S 191,536.34 S 189,727.41 S 208,281.86 S 217,218.50 S 228.548.94 S 258,287.65 S 246,487.89 S 257,122.26 S 268,239.75
<br />S 17,184.00 S 17,699.52 E 18,230.51 S 18,777.42 S 19.340.74 S 19.920.97 S 20,518.59 E 21,134.15 a 21,768.18 S 22,421.22
<br />4,560.00 4,742.40 4,932.10 5,129.38 5,334.56 5,547.94 5,769.85 8,000.65 6,240.67 6,490.30
<br />S 21,744.00 $ 22,441.92 a 23,162.60 $ 23,908.80 a 24,87b.30 a 25,468.90 S 26,288.45 E 27.134.80 S 28,008.85 $ 28.911.52
<br />924.00 951.72 980.27 1,009.68 1,039.97 1,071.17 1,103.30 1,136.40 1,170.50 7,205.61
<br />E 2.00 88,213.20 90,998.33 93,868.42 98,832.38 99,891.13 103,047.82 108,306.81 109,687.78 113,137.74 118,719.00
<br />a 1.60 49,412.16 50,990.26 52,619.53 54,301.67 56,038.41 57,831.56 59,682.98 61,594.61 63,568.43 65,606.b0
<br />a 50.00 19,200.00 19,968.00 20,766.72 21,597.39 22,481.28 23,359.74 24,294.13 25,265.89 26,276.53 27,327.59
<br />15,098.00 15,098.00 15,098.00 15,096.00 15.098.00 15,098.00 15,098.00 15,098.00 15,096.00 15,098.00
<br />S 194,588.38 S 200,444.23 S 206,493.54 S 212,743.89 S 219,202.09 S 225,875.79 S 232,770.47 S 239,895.49 S 247,258.05 S 254,668.23
<br />S 10,898.72 S 8,907.88 f 8,788.14 S 4,482.04 S 1,885.58 S (873.75) j(3,527.18) S(6,588.50) S(9,864.21) S(19,373.53)
<br /># Property tax on leased spacea Induded in rent
<br />Conference Roam rent not InGuded - undetertninable
<br />
|