HOUSING OPERATING BUDGET - EXPENSES
<br /> ~roje~t Nam~ Appl~ 0r~t~rcl
<br /> Date: 08t08/03 :: Annual Inflation Rai~ F~ci0l:i :4;00°/.
<br /> Annual per
<br /> Annual Operating Expenses Unit 1 2 3 4 5 10 15 20 30
<br />
<br /> insurance 265 '1'ii(~-4 11,465 - 1~,924 -1-~401 '1~(~§~ ' ~§,~6 - 22,33-3 .... 33.058
<br /> Utiliti_es:(common_ a?e~s) [ L
<br /> Gas/Oil 0 a 0 c 0 0 0 0 0
<br /> .... - ~lec_tric_._ - __ -~ .1~ ~$~ ' 51~.-i - --5;9_70_ - -~,~0~ _ _. _61_-4_~8 7,857 -~ ~59 .___~"J~- 6~0
<br /> __ _Water&Sewer ....... 7987 _ 8_,3_0_7 8,_639_ 8,~985 10,9_31 13,299_ 16,181 23,951
<br /> Garbage Removal 1746!960 7,238 __ 7_,_528 7, S_2_9 8,142 _9-,~06 12,05_2 _ 14,664 21,706
<br /> ...... Cable TV _ _ I 0 0 0 O 0 0 0 0 0
<br /> Repairs ...... ~240 6,490 6,749 7,019 8,540 10,390 12,641 18,712
<br /> ~_en_e_ral Maintenance __ 1~8_0_ ~;200 7,48~8_ ..... 7~,788 8_,_0_99 8,423 10,_2.48- __ 12,46~8 .._ 1~5,169 _2_2,454
<br /> Landscape Maintenance 198 ~929 8,237 8,566 8,909 9,265 11,273 13,715 16,686 24,70¢
<br /> Replacement Reserve 250 ~0~000 10,400 10 816 11,249 11 699 14 233 17,317 21,068 31,187
<br /> Proper{y-"Management: .......... ~ I
<br /> O~-site 390 ;;;;; ;; ;;15;600 16 224 16 873 17 548 18,250 22 204 27,014i 32,867 48,651
<br /> ..... ~ontracte~(8~fLSite) .... ~;3~-~ - 14,926 ~1~'~- q~i4.4 ~t~ 23,897 -2~9,075
<br />
<br /> Resident Services 162 6,739 7,009 7,289 7,581 9,223 11,221 13,652 20,209
<br /> Case Management 0 0 0 0 0 0 0 0 0
<br /> Legal ~ 416 433 450 468 569 693 843 1,247
<br /> Account~n~-~j - ...... ~.~-6~) 4,32~ --4~8'.~ '- - 4,879 -- 5,(~' -- - 6,927 -8,427
<br /> Compliance Monitoing Fees 25 ;~000; 1 040 1,082 1,125 1,170 1,423 1,732 2,107 3,119
<br /> Office ~ Administr~{i~)~'-~ 40 ; ;; ;~;;6eg; 1,664 1,731 1,800 1,872 2,277 2,771 3,371 4,990
<br /> Advertising/Marketing & Promotion 30 1,248 1,298 1,350 1,404 1,708 2,078 2,528 3,742
<br /> .init Turnover 74 3,078 3,202 3,330 3,463 4,213 5,126 6,236 9,231
<br /> Taxes(non-real estate) 0 0 0 0 0 0 0 0 0
<br /> Real Estate Taxes 0 0 0 0 0 0 0 0 0
<br /> Payroll Taxes 61 2,538 2,639 2,745 2,854 3,473 4,225 5,141 7,610
<br /> 5ther:---~ ............ 1,24§ --q~2-~§ ....... 1,350-- 1,404 ~(~' ~078 2,528 3,742
<br /> Other - ' '
<br /> : j U :: 0 0 0 0 0 0 0 0
<br />
<br />Total Annual Operating Expe__n_ses!. 2,814 112,560 !~_7,06~2 _._1_21_,745_ 126,615 13_1,_679 1_60_,2~0~8 194,918 237z!4_7 351,035
<br />Less Debt Service:
<br />Permanent loan
<br />;Rate ITerm (Years) Loan Amount
<br /> ~23i~62 '--- 845 33,785 33,785 -- -3-~B~ 33,785 33,785 33,78~ - 3~,7~8-5 33,78~ .... -3-.~,~7~
<br />DAHTC Permanent loan
<br />;Rate JTerm (Years) Loan Amount
<br /> 0.00%j 30 0 0 0 0 0 0 0 0 0 0
<br />
<br />Portion of perm loan wlo OAHTC (if applicable)
<br />:: O 0 0 0 0 0 0 0 0 0 0
<br />Deferred Developer Fee
<br />Rate [Term (Years) I Loan Amount
<br />; 0 0 0 O 0 0 0 0 0 0
<br />Amortized Debt (HOME Loan,,
<br />Partnership Loans,etc.)
<br />Rate I Term (Years) I Loan Amount
<br /> 4~5% 35 ~0~000 ---~ 587 23,465 23,465 23,465 23,465 23,465 ~. 23,465 23,465 23,465_ _ _ -_~-3 ,-4(~'5
<br />~.0~¢/~ ~ ~ 178 7,114 7,114 7,114 7,114 7,114 7,114 7,114 7,114 7,114
<br />:
<br />I
<br />WITHOUT OAHTC
<br />
<br /> Effective Gross Income: 4,488 179,539 184,925 190,473 196,187 202,072 234,257 271,568 314,822 423,094
<br />Total Annual Operating Expens~e_s_( ..... ~2,_814 112,560 117,062 121,745 126,615 131,679 160,208 194,918 237,147 351,035
<br />Net Operating Income: ____1,_674 66,979 67,862 68.728 69,572 70,393 74,049 76,651 77,675 72,059
<br />Primary Debt Service 845 33,78_5_ 33,785 33,785 33,785 33,785 33,78~ 33,785 33,785 33,785
<br />Total Debt Service 1,609 64,364 64,364 64,364 64,364 64,364 64,364 64,364 64,364 64,364
<br />Cash Flow PerYear 65 ___2,6~1__5_ 3,498 4,364 5,208 6,029 9,685 ___12,287 13,311-- ___ 7,~6_9_5-
<br />Primary Debt Coveraqe~Ratio 1.98 1.98 2.01 2.03 2.06 2.08 2.19 2.27 2.30 2.13
<br />Total Debt C~ overage Rati 1 .~04 1.04 1.05 1.07 1.08 1.09 1.15 1.19 ._ 1.21 1.12
<br />
<br /> 2003 CFC Application - Tab 6: Pro Forma Pages
<br /> Apple Orchard 5
<br /> August 8, 2003
<br />
<br />
<br />
|