ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACAD
1
To use, click File --> Make a Copy, and enter numbers in highlighted cells
2
3
COSTSOCCUPANCY & INCOMELOAN INFORMATION
4
CONSTRUCTION COSTSEnter the expected rent contribution from as many occupants or housing units are expected. Enter as annual figure to account for seasonality, if applicable.LOAN PROGRAMINTERESTTERMMAX LOAN
5
Estimated Construction Cost
Farm Credit Farm Worker Housing Program, Up to $200K
0%10$200,000
6
Square FeetOccupant or Unit 1
FSA Direct Farm Ownership Loan, Up to $600K
5.5%40$600,000
7
Cost Per Sq FtOccupant or Unit 2Other -- Fill In Terms
8
FINANCING COSTSOccupant or Unit 3
Rural Development On-Farm Housing Loan -- REPAIRS ONLY, Up to $15K
1%33$15,000
9
Down Payment (Cash)Occupant or Unit 4
10
Mortage Amount$0Occupant or Unit 5AFFORDABILITY INDEX
11
Loan TypeFSA Direct Farm Ownership Loan, Up to $600KOccupant or Unit 6Hourly WageFull Time Monthly Income @ 40hrs/wkWorker Annual IncomeAnnual Housing Payments -- 30% of IncomeMonthly Housing Payments -- 30% of Income
12
Interest Rate5.5%Vacancy rate20%$13.50$2,250$27,000$8,100$675
13
Term40Annual Rental Income0$15.00$2,500$30,000$9,000$750
14
Mortgage Payment (Annual Cost)
$0.00Average Monthly Income0$18.00$3,000$36,000$10,800$900
15
Monthly$0.00$20.00$3,333$40,000$12,000$1,000
16
OPERATING COSTSNET$25.00$4,167$50,000$15,000$1,250
17
No taxes should be assessed on qualified farm worker housing
Annual Surplus or (Deficit)0.00
18
Maintenance$0
Monthly Average Surplus or (Deficit)
0.00
19
Insurance$0
20
Utilities - Electricity/Hot Water$0
21
Utilities - Heat$0
22
Other Costs
23
Total Annual Costs$0.00
24
Average Monthly Costs$0.00
25
26
Internet researched costs hold true -- use top number
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100