DEP's Simplified Spreadsheet for Asset Management - Southwest Environmental Finance Center

DEP’s Simplified Spreadsheet for Asset Management

This spreadsheet helps a system develop a basic Asset Management Program by taking current and estimated future assets, costs, and revenue, and creates a fiscal forecast.

Categories: Long Term Funding, The Five Core Components of Asset Management

Resource
Description

Resource

Title	Document Type	View in new tab
DEP’s Simplified Spreadsheet for Asset Management	Excel	Open

Description

This spreadsheet helps a system develop a basic Asset Management Program by taking current and estimated future assets, costs, and revenue, and creates a fiscal forecast. The Forecast Worksheet is used to forecast surplus/deficit. The worksheet uses data entered in the Inventory Worksheet. The Forecast Chart Worksheet graphs the reserve fund balance, total cash needs and total revenues based on the Forecast Worksheet.