Capital Cost Calculator - Explanation
Page
The linked spreadsheet is designed to provide information for
librarians dealing with building expansions or impact fee statements. The
linked sheet is in MS Excel format. Please test it out and provide
feedback to: thennen@haplr-index.com
Capital Costs Calculator
- Beta
Version only! You may also be interested in these links as well: Impact
Fees or Property Tax rates.
- Enter your library's name in Cell C1. Enter the Population served in cell C2,
and the total property tax base in cell C3. (Note that
property value assessments vary quite widely in the U.S. Some
jurisdictions require property to be assessed at or near full market value
while others allow assessment for tax purposes to be as little as 5 or 10%
of market value. In cell E23, the national "average" is
listed at $60,000 using full market value, but if your jurisdiction assesses
at, say, 33% of market value, you will want to re-set this value to 33%
$60,000 or $20,000 to get a proper comparison.)
- DO NOT
CHANGE ANY OTHER VALUES DIRECTLY IN THEIR CELLS, MOVE THE HORIZONTAL SLIDER
BARS BACK AND FORTH TO CHANGE THE VALUES.
 This is what a slider bar looks
like. On the spreadsheet, you can either pull the tab along
horizontally or press one of the left or right arrows to move it.
Moving it will change the values in the cells in column D. If you want
the value to be zero, move it all the way to the left.
- By moving the slider bar in
column C from left to right you can adjust building costs, equipment costs,
site costs, and other costs in lines 6 to 9, column D the combined cost per
square foot will total automatically. The National Averages in Column
E will remain the same and your new rate compared to the national average
will be automatically calculated as a percent in Column F.
- By moving the slider bar in column C from left to right you can change the number of square feet you
need in line 11, Column D. The total cost for buildings and
furnishings will be calculated in Column D, line 12.
- If you are adding
volumes, use the slider bars to specify the number and estimated cost in lines
13 and 14. - Combined building and volume costs will be calculated in line 16.
- Next, specify the percent of the costs in line 16 to be financed by
borrowing.
- Now select the bond interest rate in line 18 and the amortization
period for the loan in line 19. -- The annual payments as well as total
principle and interest are calculated in lines 20 and 21.
- The last four
calculations provide context.
- Tax capacity is used by planners, more affluent
communities have higher amounts. A tax capacity of $60,000 per person is cited
as "average." That would mean that the typical home with about
3 residents is worth a market value rate of about $180,000.
- The building size is indicated in square feet
per capita.
- Payments per capita and per $1000 of market value are provided
because these are the most commonly used measures for evaluating
taxes.
|
