University car wash built a deluxe car wash across the street from campus. the new machines cost $231,000 including installation. the company estimates that the equipment will have a residual value of $25,500. university car wash also estimates it will use the machine for six years or about 12,500 total hours. actual use per year was as follows: year hours used 1 2,900 2 1,800 3 1,900 4 2,100 5 1,900 6 1,900

how do i create a depreciation schedule for end of the year amounts using all 3 forms of depreciation?