ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
ParametersEnterpriseWater
This rate model was developed by the Rural Community Assistance Corporation.
HCF
Asset value description
2
Column H is always reserved for your comments.
AllS.L. Only
Assets to be included in the CIP
3
System Name
Town Water System
Enter data in yellow cells only.
F9 to recalculate workbook.
WaterSewer
Solid Waste
RoadsElecticityLightsInternet
4
System Number
Field description are in the top row of columnar data.
5
Do not add columns or rows. If you do, you will regret it, because you will have to start over.
6
LegendEnter DataUnlocked
7
CalculatedLocked
8
Conditional Enter Data
Unlocked
9
10
Financial Constants
11
Return on Invested Funds
0.50%
12
Past Inflation2.10%
13
Future Inflation2.90%
14
15
Future Loan Interest Rate
4.50%
16
Future Loan fees, legal, costs
0.00%
(Included in loan)
17
18
Existing Capital Reserve
19
20
Default Funding of Asset Replacements
21
Replacement Value FromToCashGrantLoan
22
$0 $20,000 100%0%0%
23
$20,001 $100,000 25%0%75%
24
$100,001 $500,000 15%85%0%
25
$500,001 $9,999,999 15%85%0%
26
$10,000,000 $9,999,999 15%85%0%
27
28
Capitalization Threshold $ 5,000
Any asset purchased below this value is not included in the CIP. It assumed that this purchase was included in the annual maintenance budget.
29
30
31
Short-Lived Assets
32
If you want to reserve for Short-Lived Asset only, how many years is your definition of a "Short-Lived Asset?"
15
(USDA-RD is 5 years. Some states require 15 years.)
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