Question

In: Accounting

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                  33,750                  30,000
Occupancy Expense                  54,000                  54,000
Research & Development                  22,500                  20,000
Total Expenses                205,850                196,000
Income from Operations                  15,775                     1,500
Interest Expense                     1,200                     1,200
Income Before Taxes                  14,575                        300
Income Taxes (40%)                     5,830                        120
Net Income $                8,745 $                    180
SILVER CLOUD COMPUTING
Balance Sheets
February 28, 2018 and 2017 and February 29, 2016
At Inception
Feb 28 2018 Feb 28 2017 Feb 29 2016
(in thousands) (in thousands) (in thousands)
Cash $              55,755 $       22,300.00 $        10,000
Accounts Receivable                  18,000                 16,000                        -
Net Computer Equipment                  20,000                 40,000             60,000
Total Assets $              93,755 $             78,300 $        70,000
Accounts Payable $                9,000 $               8,000 $                  -  
Taxes Payable                     5,830                       120                        -
Long-term Debt                  30,000                 30,000             30,000
Common Stock                  40,000                 40,000             40,000
Retained Earnings                     8,925                       180                        -
Total Liabilities & Stockholders Equity $              93,755 $             78,300 $        70,000

Solutions

Expert Solution

CASH FLOW STATEMENT 2018 2017
Cash flows from operating activities
Profit before taxation 14,575.00          300.00
Adjustments for:
Depreciation 20,000.00     20,000.00
Investment income               -                   -  
Interest expense     1,200.00       1,200.00
Profit / (Loss) on the sale of property, plant & equipment               -                   -  
Working capital changes:
(Increase) / Decrease in trade and other receivables (2,000.00) (16,000.00)
(Increase) / (Decrease) in inventories               -                   -  
Increase / (Decrease) in trade payables     6,710.00       8,120.00
Cash generated from operations 40,485.00     13,620.00
Interest paid (1,200.00)    (1,200.00)
Income taxes paid (5,830.00)       (120.00)
Dividends paid               -                   -  
Net cash from operating activities 33,455.00     12,300.00
Cash flows from investing activities
Business acquisitions, net of cash acquired               -                   -  
Purchase of property, plant and equipment               -                   -  
Proceeds from sale of equipment               -                   -  
Acquisition of portfolio investments               -                   -  
Investment income               -                   -  
Net cash used in investing activities               -                   -  
Cash flows from financing activities
Proceeds from issue of share capital               -                   -  
Proceeds from long-term borrowings               -                   -  
Payment of long-term borrowings               -                   -  
Net cash used in financing activities               -                   -  
Net increase in cash and cash equivalents 33,455.00     12,300.00
Cash and cash equivalents at beginning of period 22,300.00     10,000.00
Cash and cash equivalents at end of period 55,755.00     22,300.00
Cash Balance Control Total               -                   -  

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...
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...
(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 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...
Use the following financial statements and additional information to prepare a statement of cash flows for...
Use the following financial statements and additional information to prepare a statement of cash flows for the year ended December 31, 2018 using the indirect method. Monterey Company Balance Sheets At December 31 2018 2017 Assets:   Cash $85,600 $65,200   Accounts receivable, net 72,850 56,750   Merchandise inventory 157,750 144,850   Prepaid expenses 6,080 12,680   Equipment 280,600 245,600   Accumulated depreciation-Equipment (80,600) (97,600) Total assets $522,280 $427,480 Liabilities:   Accounts payable $52,850 $45,450   Income taxes payable 15,240 12,240   Notes payable (long term)    59,200    79,200 Total...
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 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...
Prepare a statement of cash flows for the year ended June 30, 2017, using the indirect...
Prepare a statement of cash flows for the year ended June 30, 2017, using the indirect method Assets Cash $ 105,700 $ 47,000 Accounts receivable, net 69,500 54,000 Inventory 66,800 91,000 Prepaid expenses 4,700 6,000 Total current assets 246,700 198,000 Equipment 127,000 118,000 Accum. depreciation—Equipment (28,500 ) (10,500 ) Total assets $ 345,200 $ 305,500 Liabilities and Equity Accounts payable $ 28,000 $ 34,500 Wages payable 6,300 15,600 Income taxes payable 3,700 4,400 Total current liabilities 38,000 54,500 Notes payable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT