Question

In: Accounting

prepare statement of cash flow: Sales revenue $454,707 Sales discount $56,240 Sales return and allowance $5,687...

prepare statement of cash flow: Sales revenue $454,707 Sales discount $56,240 Sales return and allowance $5,687 Beginning inventory $251,890 Purchases $511,692 Ending inventory $628,122 Operating expenses, including depreciation of $46,500 $58,910 Income tax expense $27,280 Interest expense $4,730 Loss on disposal of plant assets $7,500

Additional data:
1.  New equipment costing $85,000 was purchased for cash during the year
2.  Old equipment having an original cost of $57,000 was sold for $1,500 cash
3.  Bonds matured and were paid off at face value for cash
4.  A cash dividend of $40,350 was declared and paid during the year

Solutions

Expert Solution

In calculating the cash flows statement from indirect method, we will start with the net income. We will add back the non cash item of depreciation & loss on sale of plant asset in it.

For net income, let us first find out the net sales and cost of sales as per below:

Net sales = Sales revenue - Sales discount - Sales return and allowance

Net sales = $454707 - $56240 - $5687 = $392780

Cost of sales = Beginning inventory + Purchases - Ending inventory

Cost of sales = $251890 + $511692 - $628122 = $135460

Income statement

Net Sales $392780

Less: Cost of sales ($135460)

Gross margin     $257320

Less: Operating expenses ($58910)

(including depreciation)

Less: Loss on disposal of plant assets ($7500)

Less: Interest expense ($4730)

Earnings before tax $186180

Less: Income tax ($27280)

Net income $158900

Statement of cash flows:

Net income $158900

Add: Depreciation $46500

Add: Loss on disposal of plant assets $7500

Cash from operating activities $212900

Net Cash flow $212900


Related Solutions

Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . ....
Prepare a cash flow statement using the indirect method Lomax Income Statement Sales . . . . . . . . . . . . . . . . . . . . . . . . . . . . $2,000,000 Cost of goods sold . . . . . . . . . . . . . . . . . 1,300,000 Gross margin . . . . . . . . . . . . . ....
Create a Free Cash Flow and Discounted Cash Flow Statement. The tax rate and discount rate...
Create a Free Cash Flow and Discounted Cash Flow Statement. The tax rate and discount rate are not given, so the percentage below is an assumption. If there are better assumptions, then feel free to use that with a description as to why it is better. The EBIT is from the company that is trying to bought; their stand alone basis projected income statement and balance sheet. Show all calculations.   Would you say the merger is a good idea? 2015...
>Prepare t-accounts for cash, A/R, the allowance for DA, Income statement >Prepare journal entries for each...
>Prepare t-accounts for cash, A/R, the allowance for DA, Income statement >Prepare journal entries for each situation >Find net accounts receivable -Nonprofit organization begins 2019 with a balance in A/R of $14,000. -The company has an allowance for doubtful accounts beginning balance of 2000. -During 2019, the company has credit sales of $300,000. -Bad debt expense is 2% of credit sales. -Cash collections of A/R are $290,000. -Accounts written off were 4500 for the year.
1. Prepare t-accounts for cash A/R, the allowance for DA, and income statement 2. Prepare journal...
1. Prepare t-accounts for cash A/R, the allowance for DA, and income statement 2. Prepare journal entries for each situation 3. Find Net Accounts receivable A company begins business on 1/1/2019 Information for January: Credit sales 100,000 Cash collections 80,000 Bad debt expense is 3% of credit sales using the percentage of sales method (total credit sales * estimate percentage). No accounts were written off. At the end of January, the company reviews A/R and decides that $4000 of ending...
From the information given, prepare two of the three sections of the cash flow statement. Prepare...
From the information given, prepare two of the three sections of the cash flow statement. Prepare the “financing” and the “investing” sections.                                                                                                                          2019             2018 Assets Cash . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
Prepare statement of cash flow from the financial statement of Alfalah (Pvt) Ltd. For the year...
Prepare statement of cash flow from the financial statement of Alfalah (Pvt) Ltd. For the year ended. PROFIT AND LOSS STATEMENT 2017 RS. Sales 757,645 Cost of sales (628,143) Gross Profit 129,502 Administration expense 14,723 Other expenses 21,992 Gain on sale of fixed assets (2,000) Depreciation expenses 23,000 57,715 Profit before income tax 71,787 Income tax expenses(current) and deferred) 23,787 Net profit after tax 48,000 STATEMENT OF RETAINED EARNINGS Retained earnings, beginning of period 7,312 Net profit for the period...
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question...
Prepare an income statement, balance sheet and cash flow statement for the year 2023 The question no longer need to be answered
1.    Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below....
1.    Cash Flow Statements Prepare a cash flow statement for Anna’s Apples Ltd using the information below. Use the indirect method for operating cash flows. Net Profit for year ended 30 June 2017: $200,000                                                       30 June 2017                 1 July 2016 Cash                                                         ?                             $20,000 Inventory                                            $30,000                       $40,000 Accounts Payable                               $15,000                       $30,000 Unearned Revenue                              $12,000                       $15,000 Prepaid Insurance                               $18,000                       $33,000 Goodwill                                             $50,000                       $0 Equipment                                          $300,000                     450,000 Acc Dep’n Equipment $150,000                     $160,000 Loan Payable                                      $50,000                       $100,000 During the year equipment with a cost of $150,000 and accumulated depreciation of $50,000 was sold for $115,000. No other purchases or sales of equipment...
Prepare the cash flow statement for the company for the year 2018 (start with NPAT) and...
Prepare the cash flow statement for the company for the year 2018 (start with NPAT) and write down your answer for each section. (Do not show the full format, just write down the balance for each section.) (Depreciation Expense for the year 2018 is 500,000 USD) Cash flow from operations: ? Cash flow from investments:? Cash flow from financing:? Cash Surplus (Deficit) :? Z&B Company Balance Sheets (USD) Z&B Company Income Statement for the Year 2018 (USD) ASSETS 31.12.2017 31.12.2018...
Prepare a statement of cash flow (direct method). Include a reconciliation of net income to cash...
Prepare a statement of cash flow (direct method). Include a reconciliation of net income to cash flow from operations for the year ended December 31, 2012. During 2012, ABC Corporation paid $263 in cash towards new plant assets. They also financed an extra $55 in plant asset acquisitions. They borrowed this by issuing a N/P. Therefore, capital expenditures are $318. ABC sold plant assets for their book value in a cash transaction. ABC did not repay any debt during the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT