1 Formula: Subtract; Cell Referencing 2 3 BE13.6 Using Excel to Determine the Cash Flow Effects...

Transcribed Image Text:

1 Formula: Subtract; Cell Referencing 2 3 BE13.6 Using Excel to Determine the Cash Flow Effects of 4 Equipment Disposals 5 PROBLEM 6 The T accounts for equipment and accumulated depreciation for 7 Trevis Ltd. are shown Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. 8 9 Equipment 0 Jan. 1 80,000 1 Acquisition 40,000 2 Disposals 20,000 3 Dec. 31 100,000 4 5 Accumulated Depreciation-Equipment 6 Jan. 1 44,500 7 Depreciation 20,000 8 Disposals 5,500 9 Dec. 31 59,000 20 a. What amount was reported on the statement of cash flows as "cash provided by disposal of equipment"? Hint: Prepare the journal entry to determine the effects of the sale. Debit Credit 21 In addition, Trevis's statement of income reported the following 22 amount. 23 24 25 26 Loss on disposal of equipment $ 1,500 Cash provided by disposal of equipment b. In what section of the statement of cash flows would the effects of this disposal transaction be reported? Reported as an operating activity 27 28 29 30 123456 37 Enter Answer Reported as an investing activity Reported as a financing activity 1 Formula: Subtract; Cell Referencing 2 3 BE13.6 Using Excel to Determine the Cash Flow Effects of 4 Equipment Disposals 5 PROBLEM 6 The T accounts for equipment and accumulated depreciation for 7 Trevis Ltd. are shown Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area and work area as indicated. 8 9 Equipment 0 Jan. 1 80,000 1 Acquisition 40,000 2 Disposals 20,000 3 Dec. 31 100,000 4 5 Accumulated Depreciation-Equipment 6 Jan. 1 44,500 7 Depreciation 20,000 8 Disposals 5,500 9 Dec. 31 59,000 20 a. What amount was reported on the statement of cash flows as "cash provided by disposal of equipment"? Hint: Prepare the journal entry to determine the effects of the sale. Debit Credit 21 In addition, Trevis's statement of income reported the following 22 amount. 23 24 25 26 Loss on disposal of equipment $ 1,500 Cash provided by disposal of equipment b. In what section of the statement of cash flows would the effects of this disposal transaction be reported? Reported as an operating activity 27 28 29 30 123456 37 Enter Answer Reported as an investing activity Reported as a financing activity