Question: Please answer this question in Excel with proper labels and all required formulas using the indirect method for a great rating. Thank you! P23-1 (SCF

Please answer this question in Excel with proper labels and all required formulas using the indirect method for a great rating. Thank you!
P23-1 (SCF Indirect Method) The following are Sullivan Corp.'s comparative balance sheet accounts at December 31, 2014 and 2013, with a column showing the increase (decrease) from 2013 to 2014. COMPARATIVE BALANCE SHEETS Increase 2014 Cash Accounts receivable Inventory Property, plant, and equipment Accumulated depreciation Investment in Myers Co. Loan receivable $815,000 1,128,000 1,850,000 3,307,000 (1,165,000) 310,000 250,000 2013 700,000 1,168,000 1,715,000 2,967,000 (1,040,000) 275,000 $115,000 (40,000) 135,000 340,000 (125,000) 35,000 250,000 $710,000 $6,495,000 $5,785,000 $ 955,000 100,000 500,000 Total assets Accounts payable Income taxes payable Dividends payable Lease liability Common stock, $1 par Paid-in capital in excess of $1,015,000 30,000 80,000 400,000 500,000 60,000 (20,000) (20,000) 400,000 50,000 par-common stoclk 1,500,000 2,970,000 $6,495,000 1,500,000 2,680,000 $5,785,000 Retained earnings 290,000 Total liabilities and stockholders' equity $710,000 Additional information: I. On December 31, 2013, Sullivan acquired 25% of Myers Co.'s common stock for $275,000. On that date, the carrying value of Myers's assets and liabilities, which approximated their fair values, was $1,100,000. Myers reported income of $140,000 for the year ended December 31, 2014. No dividend was paid on Myers's common stock during the year 2. During 2014, Sullivan loaned $300,000 to TLC Co., an unrelated company. TLC made the first semi- 3. On January 2, 2014, Sullivan sold equipment costing $60,000, with a carrying amount of $38,000, for 4. On December 31, 2014, Sullivan entered into a capital lease for an office building. The present value annual principal repayment of $50,000, plus interest at 10%, on December 31, 2014. $40,000 cash. of the annual rental payments is $400,000, which equals the fair value of the building. Sullivan made the first rental payment of $60,000 when due on January 2, 2015. 5. Net income for 2014 was $370,000. 6. Sullivan declared and paid the following cash dividends for 2014 and 2013. 2014 2013 December 15, 2014 February 28, 2015 $80,000 December 15, 2013 February 28, 2014 $100,000 Amount Prepare a statement of cash flows for Sullivan Corp. for the year ended December 31,2014, using the indirect method
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
