Cash Flow Statement Sample Excel filePresented below is the latest income statement of Mandolin Ltd.:SalesCost of goods soldGross profit262,500Operating expenses127,500Income before income taxes135,000Income taxes42.00093,000CreditNet incomeIn addition, the following is the change in working capital accounts for the yearDebitCash$18,000Accounts receivable (net)15,000Inventories$25,000Salaries payable (operating expenses)8,000Accounts payable20,000Income tax payable800Mandolin Ltd. also reports that depreciation expense for the year was$15,550Instructionsa) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater of cash flows using the direct method.b) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater of cash flows using the indirect method.337.500 Cash Flow Statement Sample Excel filePresented below is the latest income statement of Mandolin Ltd.:SalesCost of goods soldGross profitOperating expensesIncome before income taxesIncome taxesNet incomeIn addition, the following is the change in working capital accounts for the yearDebit$18,00015,000CashAccounts receivable (net)InventoriesSalaries payable (operating expenses)Accounts payableIncome tax payableMandolin Ltd. also reports that depreciation expense for the year was $15,5508,000800600,000337.500262,500127,500135,00042.00093,000Credit$25,00020,000Instructionsa) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a staterof cash flows using the direct method.b) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a staterof cash flows using the indirect method.

The cash flow statement is prepared to record the cash flow from various activities during the…

Answered: Cash Flow Statement Sample Excel file…

Managerial Accounting

15th Edition

ISBN:9781337912020

Author:Carl Warren, Ph.d. Cma William B. Tayler

Publisher:Carl Warren, Ph.d. Cma William B. Tayler

Chapter15: Statement Of Cash Flows

Section: Chapter Questions

Problem 19E

See similar textbooks

Related questions

Question

Cash Flow Statement Sample Excel file Presented below is the latest income statement of Mandolin Ltd.: Sales Cost of goods sold Gross profit 262,500 Operating expenses 127,500 Income before income taxes 135,000 Income taxes 42.000 93,000 Credit Net income In addition, the following is the change in working capital accounts for the year Debit Cash $18,000 Accounts receivable (net) 15,000 Inventories $25,000 Salaries payable (operating expenses) 8,000 Accounts payable 20,000 Income tax payable 800 Mandolin Ltd. also reports that depreciation expense for the year was $15,550 Instructions a) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater of cash flows using the direct method. b) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater of cash flows using the indirect method. 337.500

Cash Flow Statement Sample Excel file
Presented below is the latest income statement of Mandolin Ltd.:
Sales
Cost of goods sold
Gross profit
Operating expenses
Income before income taxes
Income taxes
Net income
In addition, the following is the change in working capital accounts for the year
Debit
$18,000
15,000
Cash
Accounts receivable (net)
Inventories
Salaries payable (operating expenses)
Accounts payable
Income tax payable
Mandolin Ltd. also reports that depreciation expense for the year was $15,550
8,000
800
600,000
337.500
262,500
127,500
135,000
42.000
93,000
Credit
$25,000
20,000
Instructions
a) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater
of cash flows using the direct method.
b) Prepare a schedule calculating the net cash flow from operating activities that would be shown on a stater
of cash flows using the indirect method.

Expert Solution

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Knowledge Booster

Learn more about

Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.

Similar questions