- Background Dott. Appliances needs to purchase new capital. They are contemplating a piece of equipment that has an average cost of $100,000. According to the IRS, this specific piece of equipment depreciates over 7. years. The salvage value is listed at $2,000. The company is treated as a "pass-through" entity responsible for paying self-employment tax (SET) each year at 15.3% of their net profit. 1 ) Dott.Appliances has forecasted the following gross revenue for the next seven (7) years. This information is as follows: 1 -Assignment 71 In Excel, assemble a table that calculates the following types of depreciation:1 Straight-Linef Sum-of-Years Digits! Double-Declining-Balance! 1 Next, create a chart tracking the trajectory of each form of depreciation across all seven years. 5 Which method provides Datt. Appliances with the least amount of aggregate depreciation? Given the revenues listed above, which year would this company not pay SET? Which accounting method is the best way to reduce SET over the next seven years