Resource: Financial Statements for Manpower Group.

profileCaroliz2
river_county-excel.xlsx

Sheet1

Step 1. List the relevant information
Capital Item Cost per item No. of Items to be Purchased Expected life
Garbage truck $ 150,000 2 10
Bulldozer $ 240,000 1 8
Bulldozer $ 16,000 3 5
Construction cost of an activity center $ 650,000 40
Step 2. Create the capital budget for River County
River County
Capital Project Budget
Capital Budget Item Estimated Lifetime (years) Per Unit Cost Total Cost
Two (2) New Garbage truck 10 $ 150,000 $ 300,000
One (1) New Bulldozer 8 $ 240,000 $ 240,000
Three (3) New Riding lawn mower 5 $ 16,000 $ 48,000
Activity center 40 $ 650,000 $ 650,000
County Total by Items $ 1,238,000

Sheet2

Sheet3