Reference no: EM131700801
Question - The following are comparative balance sheets and an income statement for the Cupcake Company.
Cupcake Company Balance Sheets As of December 31
As of December 31
2016 2015
Assets:
Cash $25,000 $100,000
Accounts receivable 163,500 125,000
Inventory 183,000 220,000
Property, Plant and Equipment 70,000 50,000
Less: Accumulated Depreciation (40,000) (35,000)
Long-term investments 20,000 65,000
Valuation Allowance - LT Investments 4,000 2,000
Totals $425,500 $527,000
Liabilities and shareholders' equity:
Accounts payable - Merchandise $60,000 $110,000
Operating expenses payable 29,500 25,000
Notes Payable 10,000 -0-
Bonds payable 60,000 110,000
Common stock 150,000 125,000
Treasury Stock, Common (10,000) -0-
Retained earnings 122,000 155,000
Accumulated Other Comprehensive Income 4,000 2,000
Totals $425,500 $527,000
Cupcake Company Income Statement For the Year Ended December 31, 2016
Sales $571,000
Cost of Goods sold 372,500
Gross Profit $198,500
Operating expenses (excluding depreciation expense) 182,000
Depreciation expense 5,000
Income from operations $11,500
Other expenses:
Loss on sale of long-term investment (4,500)
Net Income 7,000
Other comprehensive Income - Unrealized holding gains 2,000
Comprehensive Income $ 9,000
Additional Information 2016:
- Cash dividends were declared and paid in 2016.
- No stock dividends were declared or issued in 2016
- No Property, Plant or Equipment was sold in 2016
- During 2016, Property, Plant and Equipment of $10,000 was acquired by signing a $10,000 Notes Payable on the day of acquisition. All other acquisitions were paid with cash
- The following were purchased using cash: Long-term investments and Treasury Stock
- Any change in Bonds Payable relates to repayment of principle (face) amounts.
- All sales of Common Stock (No par value) were for cash
Prepare the Statement of Cash Flows of Cupcake Company for the year ended December 31, 2016.
A. Prepare a Statement of Cash Flows (direct method) using the "Spreadsheet Approach" we demonstrated in class.
B. Using your spreadsheet from A above prepare a Statement of Cash Flows, in good form, for the year ended December 31, 2016 (A reconciliation schedule is not required.)
C. Submit both A and B electronically in Canvas using separate tabs for each.