The 1 depre In ad of e

Formula: Subtract; Cell Referencing Using Excel to Determine the Cash Flow Effects of Equipment Disposals PROBLEM The T accounts for equipment and the related accumulated depreciation for Trevis Corporation are as follows: 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 this work area What will be reported on the cash flow statement with regard to the sale of equipment if Trevis uses the indirect method? Hint: Prepare the journal entry to see Beg. Balance Purchases End. Balance Equipment 80,000 41,600 Disposals 97,600 24,000 44,500 12,000 51,000 the effects of the sale. Journal entry for the sale: Cash provided by disposal of equipment Reported as an operating activity Reported as an investing activity Reported as a financing activity Debit Credit Accumulated DepreciationEquipment Disposals Beg. balance Depreciation s,soo End. Balance In addition, Trevis's income statement reported a loss on the sale of equipment as follows: Loss on disposal of equipment S 1,500