JUST one page ASAP

profilevictoria.32
sample_excell.xlsx
Home>Human Resource Management homework help>JUST one page ASAP

Sheet1

River County
Capital Budget
asset number of units unit cost total cost estimated life
garbage truck 2 150000 300000 10
bull dozer 1 240000 240000 8
lawn mowers 3 16000 48000 5
activity center 1 650000 650000 40
total 1238000
PROFIT AND LOSS EXTRACT AMOUNT TO BE CHARGED AS DEPRECIATION FOR EACH OF THOSE ASSETS
depreciation for each of those assets
depreciation per annum=total cost/estimated life
garbage truck 300000/10=30000
bull dozer 240000/8=30000
lawn mowers 48000/5=9600
activity center 650000/40=16250
balance sheet extract
Net book value= Cost less accumulated depreciation
garbage truck year 1 year 2 year 3 year 4 year 5 year 6 year 7 year 8 year 9 year 10
cost 300000 300000 300000 300000 300000 300000 300000 300000 300000 300000
accumulated depreciation 30000 60000 90000 120000 150000 180000 210000 240000 270000 300000
net book value 270000 240000 210000 180000 150000 120000 90000 60000 30000 0
BULL DOZER
YEAR 1 2 3 4 5 6 7 8
COST 240000 240000 240000 240000 240000 240000 240000 240000
ACCUMULATED DEPRECIATION 30000 60000 90000 120000 150000 180000 210000 240000
NET BOOK VALUE 210000 180000 150000 120000 90000 60000 30000 0
LAWN MOWERS
YEAR 1 2 3 4 5
COST 48000 48000 48000 48000 48000
ACCUMULATED DEPRECIATION 9600 19200 28800 38400 48000
NET BOOK VALUE 38400 28800 19200 9600 0
ACTIVITY CENTER
YEAR 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40
COST 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000 650000
ACCUMULATED DEPRECIATION 16250 32500 48750 65000 81250 97500 113750 130000 146250 162500 178750 195000 211250 227500 243750 260000 276250 292500 308750 325000 341250 357500 373750 390000 406250 422500 438750 455000 471500 487500 503750 520000 536250 552750 568750 585000 601250 617500 633750 650000
NET BOOK VALUE 633750 617500 601250 585000 568750 552500 536750 520000 503750 487500 471250 455000 438750 422500 406750 390000 373750 357500 341250 325000 308750 292500 276250 260000 243750 227500 211250 195000 178500 162500 146250 130000 113750 97500 81250 65000 48750 32500 16250 0

Sheet2

Sheet3