Question

In: Accounting

Problem B, Cash Flow CWH (unrelated to Problem A) provides you with comparative statements of financial...

Problem B, Cash Flow CWH (unrelated to Problem A) provides you with comparative statements of financial position and some additional information. Using the indirect method, calculate cash flow from operating activities. Then as best you can, calculate cash inflow/outflow from Investing activities and from Financing activities (you’ll need to make assumptions, you do not have complete information and it isn’t available).

12/31/19 12/31/2020

Cash .................................................................. $ 5,000 $ 17,000

Accounts receivable .......................................... 35,000 45,000

Inventory........................................................... 75,000 63,000

Total current assets ........................................... 115,000 125,000

Land .................................................................. 100,000 100,000

Buildings........................................................... 5,000,000 5,000,000

Equipment......................................................... 12,000,000 21,000,000

Accumulated Depreciation................................ (4,000,000) (4,750,000)

Net PP&E.......................................................... 13,100,000 21,350,000

Patents............................................................... 7,000,000 5,800,000

Total Assets....................................................... $20,215,000 $27,275,000

Accounts payable .............................................. $ 21,000 $ 45,000

Accrued expenses.............................................. 25,000 60,000

Income taxes payable........................................ 12,000 35,000

Total current liabilities...................................... 58,000 140,000

Long term debt.................................................. 12,000,000 16,000,000

Common stock .................................................. 1,500,000 2,000,000

Retained earnings.............................................. 6,657,000 9,135,000

Total Liabilities and Equity .............................. $20,215,000 $27,275,000

[NOTE: I have posted an Excel spreadsheet with the above information for your use, if you wish. If you do that, please just cut and paste a copy into your word submission. Make sure it’s readable, probably need to format the page as landscape format, not portrait.]

Additional information provided:

• Net income = $2,600,000

• Dividends were declared and paid during the year.

• Depreciation expense = $750,000

• Make reasonable assumptions as need be.

Required:

1. Calculate cash flow from operating activities, showing your complete calculation. The number alone is not sufficient.

2. Calculate cash provided by/used in investing activities (you’ll need to make some assumptions).

3. Calculate cash provided by /used in financing activities (again, you’ll need to make some assumptions)

4. Show that the sum of the three cash flow numbers is equal to the change in cash.

Solutions

Expert Solution

The answer has been presented in the supporting sheet.

3


Related Solutions

Problem 12-26 Adjusted Cash Flow From Assets [LO3] You have looked at the current financial statements...
Problem 12-26 Adjusted Cash Flow From Assets [LO3] You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2,890,000 this year. Depreciation, the increase in net working capital, and capital spending were $227,000, $92,000, and $425,000, respectively. You expect that over the next five years, EBIT will grow at 18 percent per year, depreciation and capital spending will grow at 23 per year, and NWC will grow at 13 per year. The...
14.  Problem 3.14 (Free Cash Flow) eBook Arlington Corporation's financial statements (dollars and shares are in millions)...
14.  Problem 3.14 (Free Cash Flow) eBook Arlington Corporation's financial statements (dollars and shares are in millions) are provided here. Balance Sheets as of December 31 2019 2018 Assets Cash and equivalents $  15,000 $  11,000 Accounts receivable 35,000 30,000 Inventories 34,115 29,000   Total current assets $ 84,115 $ 70,000 Net plant and equipment 50,000 46,000 Total assets $134,115 $116,000 Liabilities and Equity Accounts payable $ 10,100 $  8,500 Accruals 7,500 7,000 Notes payable 6,600 5,000   Total current liabilities $ 24,200 $ 20,500 Long-term...
The comparative cash flow statements from Sears and Wal-Mart are presented above. Amounts presented are in...
The comparative cash flow statements from Sears and Wal-Mart are presented above. Amounts presented are in millions. Review both statements considering what you've learned in this chapter about the cash flow statement. Answer the following questions: When analyzing a company's cash flow statement, which section of the statement (operating, investing or financing) do you believe is the best predictor of a company's future profitability? Why? Which company do you believe is healthier based on the cash flow statements presented? Provide...
Walmart Target Common size comparative analysis-Cash Flow Common size comparative analysis- Cash Flow For the year...
Walmart Target Common size comparative analysis-Cash Flow Common size comparative analysis- Cash Flow For the year ended January 31, 2018 For the year ended February 3, 2018 Details 2018 Details 2018 $ $ Net Income $9,862,000 Net Income $2,934,000 Cash Flows-Operating Activities Cash Flows-Operating Activities Depreciation $10,529,000 Depreciation $2,445,000 Net Income Adjustments $4,042,000 Net Income Adjustments $229,000 Changes in Operating Activities Changes in Operating Activities Accounts Receivable ($1,074,000) Accounts Receivable 0 Changes in Inventories ($140,000) Changes in Inventories ($348,000) Other...
Adjusted Cash Flow from Assets. You have looked at the current financial statements for Reigle Homes,...
Adjusted Cash Flow from Assets. You have looked at the current financial statements for Reigle Homes, Co. The company has an EBIT of $2.95 million this year. Depreciation, the increase in net working capital, and capital spending were $235,000, $105,000, and $475,000, respectively. You expect that over the next five years, EBIT will grow at 15 percent per year, depreciation and capital spending will grow at 20 percent per year, and NWC will grow at 10 percent per year. The...
Discuss the interrelationship of the cash flow statement to the other financial statements. In your discussion...
Discuss the interrelationship of the cash flow statement to the other financial statements. In your discussion comment and explain operating activities, investing activities, and financing activities. What is the difference between an indirect and a direct cash flow statement? Which is GAAP? (250 words total and no plagiarirm please)
Problem 16-9 Headland Corporation is preparing the comparative financial statements to be included in the annual...
Problem 16-9 Headland Corporation is preparing the comparative financial statements to be included in the annual report to stockholders. Headland employs a fiscal year ending May 31. Income from operations before income taxes for Headland was $1,420,000 and $711,000, respectively, for fiscal years ended May 31, 2018 and 2017. Headland experienced a loss from discontinued operations of $415,000 on March 3, 2018. A 40% combined income tax rate pertains to any and all of Headland Corporation’s profits, gains, and losses....
Comparative financial statements for Weaver Company
Comparative financial statements for Weaver Company follow:During 2009, the company sold some equipment for $20 that had cost $40 and on which there was accumulated depreciation of $16. In addition, the company sold long-term investments for $10 that had cost $3 when purchased several years ago. Cash dividends totaling $30 were paid during 2009. Required:1. Using the indirect method, determine the net cash provided by operating activities for 2009.2. Using the information in (1) above, along with an analysis of...
Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions...
Using the below financial statements to complete the ratio analysis and statement of Cash Flow questions following the financial statements. Milky Way corp comparative Balance sheet December 31, 20XX and 20XX (Prior) Assets Current Prior Cash 1,580 1,080 Account Receivable 1,300 1,680 Inventory 12,420 12,000 Total Current Assets 15,300 14,760 Land 12,300 10,200 Equipment 11,480 9,600 Accumulated Depreciation (2,040) (1,080) Total Long-term Assets 37,040 33,480 Liabilities Account Payable 1,920 960 Salaries Payable 5,060 4,080 Total Current Liabilities 6,980 5,040 Long-term...
Problem 16-6 Skysong Corporation is preparing the comparative financial statements for the annual report to its...
Problem 16-6 Skysong Corporation is preparing the comparative financial statements for the annual report to its shareholders for fiscal years ended May 31, 2017, and May 31, 2018. The income from operations for the fiscal year ended May 31, 2017, was $1,775,000 and income from continuing operations for the fiscal year ended May 31, 2018, was $2,566,000. In both years, the company incurred a 10% interest expense on $2,446,000 of debt, an obligation that requires interest-only payments for 5 years....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT