Question

In: Accounting

Using the financial data below, prepare a statement of cash flows for the year ended December...

Using the financial data below, prepare a statement of cash flows for the year ended December 31, 2014 for Summer Peebles, Inc. using the indirect method.

Summer Peebles, Inc.
Income Statement Year Ending December 31, 2014

Sales

$1,000.00

Cost of Goods Sold

-$650.00

Depreciation Expense

-$100.00

Sales and General Expense

-$100.00

Interest Expense

-$50.00

Income Tax Expense

-$40.00

Net Income

$60.00

Summer Peebles, Inc.
Balance Sheets as of December 31, 2013 and 2014

Assets

2013

2014

Cash

$50.00

$60.00

Accounts Receivable, Net

$500.00

$520.00

Inventory

$750.00

$770.00

Current Assets

$1,300.00

$1,350.00

Fixed Assets, Net

$500.00

$550.00

Total Assets

$1,800.00

$1,900.00

Liabilities and Equity

Notes Payable to Banks

$100.00

$75.00

Accounts Payable

$590.00

$615.00

Interest Payable

$10.00

$20.00

Current Liabilities

$700.00

$710.00

Long-Term Debt

$300.00

$350.00

Deferred Income Tax

$300.00

$310.00

Capital Stock

$400.00

$400.00

Additional data for the period January 1, 2014 through December 31, 2014 are:

  1. Sales on account, $70,000.
  2. Purchases on account, $40,000.
  3. Depreciation, $5,000.
  4. Expenses paid in cash, $18,000 (including $4,000 of interest and $6,000 in taxes).
  5. Decrease in inventory, $2,000.
  6. Sales of fixed assets for $6,000 cash; cost $21,000 and two-thirds depreciated (loss or gain is included in income).
  7. Purchase of fixed assets for cash, $4,000.
  8. Fixed assets are exchanged for bonds payable of $30,000.
  9. Sale of investments for $9,000 cash.
  10. Purchase of treasury stock for cash, $11,500.
  11. Retire bonds payable by issuing common stock, $10,000.
  12. Collections on accounts receivable, $65,000.
  13. Sold unissued common stock for cash, $1,000.

please show calculations.

Solutions

Expert Solution

# Cash Flow from Operating Activities $ $
Net Proft before tax 91650
Adjustments for:-
+ Depreciation & Amortisation 100
+ Additional Depreciation 5000
+ Loss on Sale of Fixed Assets 1000 6100
- Increase in Current Assets 50 -50
+ Increase in Current Liabilities 10 10
- Increase in Account Receivable 20 -20
+ Increase in Accounts Payable 25 25
+ Increase in Interest Payable 10 10
- Increase in Invenories 20 -20
+ Cash Recvd of Accounts Receivable 65000 65000
-
Net Cash Flow from Operating Activities 162705
# Cash flow from Investing activities $ $
Purchase of Fixed Assets -4000 -4000
Sale of Fixed Assets 6000 6000
Net Cash used in Investing Activities 2000
# Cash Flow from Financing Activities $ $
Sale of Common Stock 1000 1000
- Purchase of treasury stock 11500 -11500
- Payments of Note Payable(100-75) 25 -25
Long Term Debt increase 50 50
Net Cash used in Financing Activities -10475
# Non Cash Investing & Financing Activities
Fixed Assets exchanged for bonds payable 30000
Retire bonds payable by issuing common stock 10000
WORKING
Sales 71000
Cost of goods sold 40650
cash exps -18000
Decrease in inventory -2000
Net Income 91650

Related Solutions

Using the financial data below, prepare a statement of cash flows for the year ended December...
Using the financial data below, prepare a statement of cash flows for the year ended December 31, 2014 for Summer Peebles, Inc. using the indirect method. Include the Excel spreadsheet picture with all calculations. Summer Peebles, Inc. Income Statement Year Ending December 31, 2014 Sales $1,000.00 Cost of Goods Sold -$650.00 Depreciation Expense -$100.00 Sales and General Expense -$100.00 Interest Expense -$50.00 Income Tax Expense -$40.00 Net Income $60.00 Summer Peebles, Inc. Balance Sheets as of December 31, 2013 and...
Using the financial data below, prepare a statement of cash flows for the year ended December...
Using the financial data below, prepare a statement of cash flows for the year ended December 31, 2014 for Summer Peebles, Inc. using the indirect method. Summer Peebles, Inc. Income Statement Year Ending December 31, 2014 Sales $1,000.00 Cost of Goods Sold -$650.00 Depreciation Expense -$100.00 Sales and General Expense -$100.00 Interest Expense -$50.00 Income Tax Expense -$40.00 Net Income $60.00 Summer Peebles, Inc. Balance Sheets as of December 31, 2013 and 2014 Assets 2013 2014 Cash $50.00 $60.00 Accounts...
Prepare the statement of cash flows for the year ended December 31,2017 using the indirect method
XS supply company is developing its annual financial statement at December 31,2017. The statements are complete except for the statement of cash flows. The completed comparative balance sheets and income statement are summarized Particulars 2017 2018 Balance sheet at December 31     Cash $ 50,720 $ 34,800 Accounts Receivable 42,850 36,100 Merchandise Inventory 49,750 43,700 Property & Equipment 1,64,000 1,38,000 Less : Accumulated Depreciation (39,600) (34,500)   2,67,720 2,18,100 Accounts Payable 40,050 30,700 Wages Payable 1,910 2,400 Note Payable,Long...
Prepare Stoughton's statement of cash flows for the year ended December​ 31, 2018​, using the indirect...
Prepare Stoughton's statement of cash flows for the year ended December​ 31, 2018​, using the indirect method. Evaluate the​ company's cash flows for the year. In your​ evaluation, mention all three categories of cash flows and give the rationale for your evaluation. Evaluate the​ company's cash flows for the year. In your​ evaluation, mention all three categories of cash flows and give the rationale for your evaluation. Revenues: Service revenue                                 $283,000 Dividend revenue                                     8,700                                                                                                                             $291,700 Expenses: Cost of goods...
Prepare Statement of cash flows for Travel Products Inc. for year ended December 31,2014 using the...
Prepare Statement of cash flows for Travel Products Inc. for year ended December 31,2014 using the indirect method. Service revenue.......$235,000 Dividend revenue.....8,200 Total revenues.......$243,000 Expenses: Cost of goods sold $103,000 Salary expense $58,000 Depreciation expense $21,000 Advertising expense 2,900 Interest expense $3,300 Income tax expense $6,000 Total expenses 194,200 Net Income $49,000 Additional Data Aquisition of plant assets was $125,000. Of this amount 75,000 was paid in cash and $50,000 by signing a note payable. Proceeds from sale of land...
Prepare the financing section of the statement of cash flows for the year ended December 31,...
Prepare the financing section of the statement of cash flows for the year ended December 31, 2018. 13) Dakota Telescopes Company uses the indirect method to prepare the statement of cash flows. Refer to the following income statement:                                    Dakota Telescopes Company                                              Income Statement                                  Year Ended December 31, 2019 Sales Revenue                                                   $275,000 Interest Revenue                                                     2,600 Total Revenues                                                                                   $277,600 Cost of Goods Sold                                             135,000 Salary Expense                                                      66,500 Depreciation Expense                                          32,000 Other Operating Expenses                                 35,900 Interest Expense                                                      2,400 Income Tax...
Based on the financial statements provided, prepare a statement of cash flows for the year ended...
Based on the financial statements provided, prepare a statement of cash flows for the year ended February 28, 2018. SILVER CLOUD COMPUTING Income Statements For the Years Ended February 28, 2018 and 2017 fye 2/28/2018 fye 2/28/2017 (in thousands) (in thousands) Sales $            225,000 $            200,000 Sales Discounts                     3,375                     2,500 Net Sales                221,625                197,500 Wages and Salaries                  73,500                  70,000 Bad Debt Expense                     2,100                     2,000 Depreciation                  20,000                  20,000 Marketing Expense                 ...
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the...
(a) Prepare a Statement of Cash Flows for the year ended 30 June 2020 using the direct method, ignoring GST. Show all workings on the Workings page. (b) Using the relevant information from the question above, identify two (2) specific items (including their values) which causes a difference between Net Profit and Net Cash from Operating Activities and analyse why it causes a difference. The following financial statements relate to Clarke Ltd for the financial year ended 30 June 2020....
Prepare a statement of cash flows for PepsiCo for the fiscal year ended December 28, 2019...
Prepare a statement of cash flows for PepsiCo for the fiscal year ended December 28, 2019 using the Direct method.
Prepare a statement of cash flows for Henderson ?Industries, Inc., for the year ended December? 31,...
Prepare a statement of cash flows for Henderson ?Industries, Inc., for the year ended December? 31, 2017?, using the indirect method. Henderson Industries, Inc. Income Statement For the Year Ended December 31, 2017 Sales revenues $950,000 Less: Cost of goods sold 378,000 Gross profit $572,000 Less operating expenses: Salaries and wages expense $187,000 Insurance expense 14,500 Depreciation expense 48,400 Other operating expenses 88,000 Total operating expenses 337,900 Operating income $234,100 Plus other income and less other expenses: Interest expense $5,900...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT