III. Financial Statement Preparation: The Statement of Cash Flows
Company X
Income Statement
For the Year Ended 2018
Revenues
$300,000
Expenses
$210,000
Net Income $90,000
Company X
Comparative Balance Sheet
12/31/18
December 31
2018 2017
Assets
Cash
$42,000 $10,000
Accounts
Receivable
33,000 15,000
Investments (Marketable
Securities)
38,000 25,000
Truck
48,000 22,000
Computer
19,000 12,000
Accumulated
Depreciation
(7,300) (3,500)
Total Assets
$172,700
$80,500
Liabilities & Stockholders’ Equity
Accounts
Payable
$7,500 $14,000
Bonds
Payable
30,000 20,000
Total Liabilities
$37,500
$34,000
Common
Stock
$82,000 $30,000
Retained Earnings
53,200 16,500
Total
Stockholders’ Equity
$135,200 $46,500
Total Liabilities and Stockholders’ Equity $172,700 $80,500
REQUIRED:
Answer- The amount was taken as depreciation expense = $3800.
Amount paid as dividends =Opening balance of retained earnings+ Net income-Closing balance of retained earnings
= $16500+$90000-$53200
= $53300
COMPANY X | ||
STATEMENT OF CASH FLOWS (USING INDIRECT METHOD) | ||
FOR THE YEAR ENDED 31 DECEMBER 2018 | ||
Particulars | Amount | |
$ | ||
Cash flow from operating activities | ||
Net Income | 90000 | |
Adjustments to reconcile net income to net cash provided by operating activities | ||
Adjustment for non cash effects | ||
Depreciation | 3800 | |
Change in operating assets & liabilities | ||
Increase in accounts receivable | -18000 | |
Decrease in accounts payable | -6500 | |
Net cash flow from operating activities (a) | 69300 | |
Cash Flow from Investing activities | ||
New truck purchased | -26000 | |
New computer purchased | -7000 | |
Investments purchased | -13000 | |
Net cash Flow from Investing activities (b) | -46000 | |
Cash Flow from Financing activities | ||
Cash dividends paid | ($16500+$90000-$53200) | -53300 |
Common stock issued | 52000 | |
Bonds issued | 10000 | |
Net cash Flow from Financing activities (c) | 8700 | |
Net Change in cash c=a+b+c | 32000 | |
Beginning cash balance | 10000 | |
Closing cash balance | 42000 |
III. Financial Statement Preparation: The Statement of Cash Flows Company X Income Statement For the Year...
prepares a “Statement of Cash Flows” for the year ended December 31, 2018. Keith corporation balance sheet December 31 Assets 2003 2002 Cash $1,500 $1,000 Marketable securities 1,800 1,200 Accounts receivable 2,000 1,800 Inventories 2,900 2,800 Total current assets $8,200 $6,800 Gross fixed assets $29,500 $28,100 Less: Accumulated depreciation 14,700 13,100 Net fixed assets $14,800 $15,000 Total Assets $23,000 $21,000 Liabilities and Stockholders’ Equity Accounts payable $1,600 $1,500 Notes payable 2,800 2,200 Accruals 200 300 Total current liabilities $4,600 $4,000 Long -term debt $5,000 $5,000 Common stock $10,000 $10,000 Retained earnings 3,400 2,800 Total stockholders’ equity $13,400 $12,800 Total Liabilities and stockholders” equity $23,000 $21,800 Income Statement Data(2003) Depreciation expense $1,600 Earning before interest taxes 2,700 Taxes 933 Net profits...
trouble with statement of cash flows Income Statement WFH Bookstore Income Statement Income Statement Sales Less: Cost of Goods Sold Gross Profit Less: Other Operating Expenses EBITDA (Earnings Before Interest, Taxes, Depreciation & Amz) Less: Depreciation & Amortization EBIT (Earnings Before Interest & Taxes) Less: Interest EBT(Earnings Before Taxes, i.e. Taxable income) Less: Taxes Net Income Less: Common Stock Dividends Addition to Retained Earnings 2018 $ 325 $ (81) $ 244 $ (125) $ 119 $ (50) 69 $ (35)...
E5.16 (L03) (Preparation of a Statement of Cash Flows) A comparative statement of financial position for for Orozco AG is presented below. December 31 Assets 2019 2018 Land € 71,000 €110,000 Equipment 270,000 200,000 Accumulated depreciation equipment (69,000) (42,000) Inventory 180,000 189,000 Accounts receivable 82,000 66,000 Cash 63.000 22.000 Total €597,000 €545,000 Equity and Liabilities Share capital-ordinary (€1 par) €214,000 €164,000 Retained earnings 199,000 134,000 Bonds payable 150,000 200,000 Accounts payable 34,000 47,000 Total €597,000 €545,000 Additional information: 1. Net...
MONTGOMERY, INC Statement of Cash Flows (Indirect Method) For Year Ended December 31, 2018 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operations: Changes in current operating assets and liabilities Depreciation expense Decrease in accounts receivable Decrease in accounts payable Decrease in salaries payable Increase in inventory Net cash used in operating activities Cash flows from investing activities 0) Cash flows from financing activities 0 0 Cash balance at beginning of...
Create a Spreadsheet for Statement of Cash Flows for the below ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of Goods Sold Gross Profit Operating Expenses: Salaries Expense Depreciation Expense Other Operating Expenses Total Operating Expenses Operating Income Other Income and (Expenses): Interest Revenue Interest Expense Total Other Income and (Expenses) Net Income Before Income Taxes Income Tax Expense Net Income 141,200 94,400 11,500 (24,400) (12,900) 81,500...
27. Prepare a statement of cash flows for the Crosby Corporation. Follow the general procedures indicated in Table 2–10 on page 38 .Statement of cash flows(L04)Current Assets LiabilitiesCash . . . . . . . . . . . . . . . . . . . . . . . . . $ 15,000 Accounts payable . . . . . . . . $ 20,000Accounts receivable . . . . . . . . . . . ....
Following are a statement of cash flows (indirect method) for Harris, Inc., for the year ended December 31, 2017, and the firm’s balance sheet at December 31, 2016: HARRIS, INC. Statement of Cash Flows For the year Ended December 31, 2017 Cash Flows from Operating Activities: Net income $ 13,600 Add (deduct) items not affecting cash: Depreciation expense 32,000 Increase in accounts receivable (7,000 ) Decrease in merchandise inventory 32,800 Increase in accounts payable 4,900 Net cash provided by operating...
Prepare a statement of cash flows based on the following financial statements: Balance Sheet 2017 2018 Assets Current assets Cash $5,000 $6,500 Accounts receivable $31,500 30,000 $42,000 Inventory 40,000 Total $75,000 $80,000 Fixed assets Net plant and equipment $393,750 375,000 $450,000 Total assets $473,750 Liabilities and Owners Equity Current liabilities Accounts payable $50,000 $53,750 Notes payable 25,000 $26,250 Total $75,000 $80,000 Long-term debt Owners' equity $85,000 $89,250 Common stock $60,000 $63,000 Accumulated retained 241,500 230,000 earnings Total $290,000 $304,500 Total...
Use the starting balance sheet and statement of cash flows to answer the question Nippon Technology Balance Sheet As of December 31, 2017 (amounts in thousands) Cash Accounts Receivable Inventory 137,000 Accounts Payable 20,000 36,000 9,000 65,000 72,000 245,000 317,000 382,000 32,000 Debt 51,000 Other Liabilities 227,000 Total Liabilities 73,000 Paid-In Capital 154,000 Retained Earnings Property Plant & Equipment, Gross Accumulated Depreciation Property Plant & Equipment, Net Other Assets Total Assets 8,000 Total Equity 382,000 Total Liabilities & Equity Nippon...
Prepare a Statement of Cash Flows for the current year using the indirect method. Robust Robots, Inc. Comparative Balance Sheet December 31, 2019 and 2018 2018 2019 $ Assets Current Assets: Cash Accounts Receivable, net Merchandise Inventory Supplies Prepaid Insurance Total Current Assets 65,000 150,000 135,000 9,700 30,000 389,700 $ $ $ $ $ $ 80,000 100,000 70,000 500 10,000 260,500 $ $ $ $ Property Plant, and Equipment: Equipment Less: Accumulated Depreciation - Equipment Total Property, Plant, and Equipment...