Prepare a depreciation schedule for the life of the asset

include

depr amount .depr rate , depr expense accum depr and carrying amount

On April 22, 2023, Cullumber Enterprises purchased equipment for $130,300. The company expects to use the equipment for 11,500 working hours during its four-year life and that it will have a residual value of $13,000. Cullumber has a December 31 year end and prorates depreciation to the nearest month. The actual machine usage was: 1,500 hours in 2023; 2,500 hours in 2024; 4,000 hours in 2025; 2,600 hours in 2026; and 1,100 hours in 2027