G H Prepare depreciation schedules using Straight-line, Units-of-production, and double-declining balance depreciation. Make use of Excel/sheets capabilities by using as many formulas and functions as possible. SBC Corp has purchased a new Machine on Jan 1, year 1 paying 10% of the purchase price in cash and signing a 2 year note for the balance. The following information is given: B Chapter & Course Outcomes: (demonstrated in this A Record the journal entry to capitalize a long term tan Calculate depreciation for long term tangible assets u line, units of production and double declining balance C Prepare the journal entry to record depreciation of an D Analyze the impact of each depreciaion method on the Use Microsoft Excel proficiently to record and summari E information used in business analysis and decision mak Numerous examples have been provided or completed in chapter 9. " Cost: $ 165,000 10 Estimated Residual: $ 15,000 Estimated Life in M years 4 Estimated Life in 9 hours 1,200 Month Purchased for 13 Actual hours per year recalculation question 4 14 1 360 Amount of cash for sale 75,000 W 2 300 16 3 320 17 4 220 18