below is the questions and the template that has to be filled. Please provide a with formula version as well for my better understanding.

LO 8-2, 8-3 Exercise 8-9A Computing and recording straight-line versus double-declining-balance depreciation At the beginning of Year 1, Copeland Drugstore purchased a new computer system for $52,000. It is expected to have a five-year life and a $7,000 salvage value. Required a. Compute the depreciation for each of the five years, assuming that the company uses (1) Straight-line depreciation. (2) Double-declining-balance depreciation. b. Record the purchase of the computer system and the depreciation expense for the first year under straight-line and double- declining-balance methods in a financial statements model like the following one: Assets Equity Rev. - Exp. Net Inc. Cash Flow Cash + Book Value of Comp. Sys. Ret. Earn. c. Prepare the journal entries to recognize depreciation for each of the five years, assuming that the company uses (1) Straight-line depreciation. (2) Double-declining-balance depreciation.A B C D E F G H J NOUPON FINANCIAL STATEMENTS Income Reporting Income Statement Year 1 Year 2 Total Key: Mowing revenue 90,000 1,00,000 1,90,000 formula required 13 cells in column B + C Operating expenses except depreciation 45,000 50,000 95,000 manual entry 6 cells in column B + C 8 Income before depreciation and taxes 45,000 50,000 95,000 total points 19 cells worth 5.26 pts each 9 Depreciation expense (Straight-line) 10 Operating income 11 Gain (loss) on sale of equipment 0 12 Income before taxes 13 Income tax expense (30%) 14 Net income 15 Reporting of Equipment 17 Balance Sheet - Assets Year 1 Year 2 18 Equipment 19 Accumulated depreciation 20 Book value 21 22 Reporting of Cash Flows 23 Statement of Cash Flows Year 1 Year 2 Total 24 Investing Activities 25 Purchase equipment 26 Sell equipment 27 Operating Activities 28 Income taxes paid amounts given in instructions, do not grade 29 30 31 32 33