DEP’s Simplified Spreadsheet for Asset Management

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.