I do not understand how to input excel formula to obtain the double declining balance. Can you please show how you got each answer that is not already given.

Thank you.

John Riley, a certified public accountant, has worked for the past eight years as a payroll clerk for Southeast Industries, a small furniture manufacturing firm in the northeast. John recently experienced unfortunate circumstances. His teenage son required minor surgery and the medical bills not covered by John's insurance have financially strained John's family.

John works hard and is a model employee. Although he received regular performance raises during the first few years with Southeast, John's wages have not increased in three years. John asked his supervisor, Bill Jameson, for a raise. Bill agreed that John deserved a raise, but told him he could not currently approve one because of sluggish sales.

A disappointed John returned to his duties while the financial pressures in his life continued. Two weeks later, Larry Tyler, an assembly worker at Southeast, quit over a dispute with management. John conceived an idea. John's duties included not only processing employee terminations but also approving time cards before paychecks were issued and then distributing he paychecks to firm personnel. John decided to delay processing Larry's termination, to forge timecards for Larry for the next few weeks, and to cash the checks himself. Because he distributed paychecks, no one would find out and John reasoned that he was really entitled to the extra money anyway. In fact, no one did discover the maneuver and John stopped the practice after three weeks.

Questions:

Does John's scheme affect Southeast's balance sheet?

Specifically what accounts would be affected and why

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 val Required (1) Compute the depreciation for each of the five years, assuming that the company uses straight-line depreciation. (Use cell references from the given information above to complete this question.) Straight-line depreciation for each year (2) Compute the depreciation for each of the five years, assuming that the company uses double-declining-balance depreciation. (Use cell references from the given information above to complete this question.) (Leave no cell blank.) B17 fx=J2(100/L22)%J2 Aew computer system for $52,000. It is expected to have 6 7 nplete this question.) 8 9 10 11 ming that the company uses double-declining-balance depreciation. 12 13 nplete this question.) 14 15 16 (2) Compute the depreciation for each of the five years, assuming that the company uses double-declining-balance depreciation. (Use cell references from the given information above to complete this question.) (Leave no cell blank.) 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 (Use cell references from the given information above to complete this question.) c(1) Prepare the journal entries to recognize depreciation for each of the five years, assuming that the company uses straight-line depreciation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) (Use cell references from the given information above to complete this question.) c(2) Prepare the journal entries to recognize depreciation for each of the five years, assuming that the company uses double-declining-balance depreciation. (If no entry is required for a transaction/event, select "No journal entry required" in the first account field.) (Use cell references from the given information above to complete this question.)