mat Tools Table Window Help 21 Assignment 18 Equipment Depreciation (1) Saved to my Mac Mailings Review View ances ABC de AaBbccdee AaBbCcDc Aalbo No Spacing Heading Assignment 18 Equipment Depreciation (30 Points) 1. The company purchased a Scraper for $80,000(purchase price). It paid 8.5% sales tax and $500 shipping. The tires are valued at $4,000. The IRS allows this piece of equipment to be depreciated over 7 years. Make an excel chart and graph the depreciation for this equipment using the declining balance (200%) method for 5 years and converting to the straight line method for the remaining 2 years. The salvage value after 7 years is estimated as 20% of the purchase price. mat Tools Table Window Help 21 Assignment 18 Equipment Depreciation (1) Saved to my Mac Mailings Review View ances ABC de AaBbccdee AaBbCcDc Aalbo No Spacing Heading Assignment 18 Equipment Depreciation (30 Points) 1. The company purchased a Scraper for $80,000(purchase price). It paid 8.5% sales tax and $500 shipping. The tires are valued at $4,000. The IRS allows this piece of equipment to be depreciated over 7 years. Make an excel chart and graph the depreciation for this equipment using the declining balance (200%) method for 5 years and converting to the straight line method for the remaining 2 years. The salvage value after 7 years is estimated as 20% of the purchase price