Enter Cost per Type-of-Measurement (Column F). Enter the replacement cost per Item as you defined in 2. above, expressed in current dollars. “type-of-measurement” Sources for this information include construction contractors, architects, property management firms, and cost estimating databases such as RS Means. Spreadsheet Calculates Replacement Costs per Item (Column G). This is simply quantity x cost per Type-of-Measure. Spreadsheet Calculates Replacement Cost per Dwelling Unit (Column H). This is the cost of an Item per dwelling unit. Clearly, the per-dwelling-unit cost may differ from the Item (type-of-measure) cost if a unit does not have exactly one Item per unit. See exercises below for more information. Enter Replacement Cost per Dwelling Unit (Column I). For Items being calculated using the Calculation Columns”, hand enter the calculated cost-per-unit from “Optional Column H. Remember, if you know that there is only one Item per dwelling unit then you can skip the Optional Calculation Columns and hard enter the Replacement Cost per Dwelling Unit directly in Column I. Useful Life (Column J). Enter useful life expectancy for each Item. HDC has inserted a comment which gives a range of useful life for each Item (e.g. 15-20 years). The cells contain a useful life that is in the middle of typical range. You may modify the provided useful life expectancy based on the quality of the Item and/or your experience. Hint: Note that the average useful life of individual Items used in the spreadsheet is based on information from Oregon Housing and Community Services. It can be found in their Consolidated Funding Cycle application materials on the OHCS website, . Another source of useful life data is USDA Rural Development’s MFH Loan Origination Handbook HB 1-3560.
Enter Cost per Type-of-Measurement (Column F). Enter the replacement cost per Item “type-of-measurement” as you defined in 2. above, expressed in current dollars. Sources for this information include construction contractors, architects, property management firms, and cost estimating databases such as RS Means. Spreadsheet Calculates Replacement Costs per Item (Column G). This is simply quantity x cost per Type-of-Measure. Spreadsheet Calculates Replacement Cost per Dwelling Unit (Column H). This is the cost of an Item per dwelling unit. Clearly, the per-dwelling-unit cost may differ from the Item (type-of-measure) cost if a unit does not have exactly one Item per unit. See exercises below for more information. Enter Replacement Cost per Dwelling Unit (Column I). For Items being calculated using the “Optional Calculation Columns”, hand enter the calculated cost-per-unit from Column H. Remember, if you know that there is only one Item per dwelling unit then you can skip the Optional Calculation Columns and hard enter the Replacement Cost per Dwelling Unit directly in Column I. Useful Life (Column J). Enter useful life expectancy for each Item. HDC has inserted a comment which gives a range of useful life for each Item (e.g. 15-20 years). The cells contain a useful life that is in the middle of typical range. You may modify the provided useful life expectancy based on the quality of the Item and/or your experience. Hint: Note that the average useful life of individual Items used in the spreadsheet is based on information from Oregon Housing and Community Services. It can be found in their Consolidated Funding Cycle application materials on the OHCS website, . Another source of useful life data is USDA Rural Development’s MFH Loan Origination Handbook HB 1-3560.
Cap-Needs-Instructions.docx