please show all parts on excel and formulas . thank you

8 Machine with a useful life of 5 years and a an estimated residual value of $6,000 was purchased on January 3, 2016, for $48.500. The machine was sold on January 5, 2021, for $13,000 A. What is the book value of the machine on January 5, 2021. Use Sraight line Depreciation Illustrate the effects on the accounts and the financial statements of the sale of the machine on January 5, 2021. B Assets Equipment Liabilities and Stockholder Equity Acct Payable Comm Stock Retained Eamings Cash Accum Depreciation Statement of Cash Flows Income Statement Illustrate the effects on the accounts and the financial statements of the sale of the machine if it had been sold for $18,000 instead. Assets Equipment Liabilities and Stockholder Equity Acct Payable Comm Stock Retained Earnings Cash Accum Depreciation Statement of Cash Flows Income Statement