Question

In: Accounting

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 Operating Activities

0

Other Operating Activities

($168,000)

Liabilities

$4,457,000

Liabilities

$1,757,000

Net Cash Flow-Operating

$28,337,000

Net Cash Flow-Operating

$6,923,000

Cash Flows-Investing Activities

Cash Flows-Investing Activities

Capital Expenditures

($10,051,000)

Capital Expenditures

($2,533,000)

Investments

0

Investments

($55,000)

Other Investing Activities

$991,000

Other Investing Activities

($487,000)

Net Cash Flows-Investing

($9,060,000)

Net Cash Flows-Investing

($3,075,000)

Cash Flows-Financing Activities

Cash Flows-Investing Activities

Sale and Purchase of Stock

($8,304,000)

Sale and Purchase of Stock

($938,000)

Net Borrowings

($1,437,000)

Net Borrowings

($1,441,000)

Other Financing Activities

($3,320,000)

Other Financing Activities

0

Net Cash Flows-Financing

($19,875,000)

Net Cash Flows-Financing

($3,717,000)

Effect of Exchange Rate

$487,000

Effect of Exchange Rate

0

Net Cash Flow

($111,000)

Net Cash Flow

$131,000

·         What were the companies’ cash flows from operations? Were they positive?

·         Were operating cash flows smaller or larger than net income?

·         What are the major differences between operating cash and net income?

·         Did the company purchase new property and equipment (‘Capital expenditures’) during the years?

·         Did the company issue new debt during the year or was the debt repaid? (Hint: We must sometimes sum one or more-line items on this statement to determine total net debt activity.)

·         Did the company issue new stock?

·         Did the company pay dividends?

Solutions

Expert Solution

1) The cash flows from operations were:
Wallmart- $28,337,000
Target- $6,923,000
Yes, they were positive.
2) Operating cash flows were larger than net income.
3) Major differences between operating cash flow and net income are:
*Operating cash flow excludes depreciation, which is a non-cash
expense.
*Operating cash flow provides for changes in the current assets and current
liabilities.
4) Yes, the companies purchased new property and equipment during the year.
The are reported as capital expenditures in the 'Investing Section' of the
statement of cash flows.
5) Only 'net borrowings' are shown and it can be presumed that the companies
have both issued new debt and repaid debt.
6) It is mentioned as 'sale and purchase of stock' which description tells that
new stock was issued.
7) No, the companies did not pay dividends.

Related Solutions

Walmart company research project Walmart company cash - flow : monthly projection.explain.
Walmart company research project Walmart company cash - flow : monthly projection.explain.
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup window: LOADING... . Which company is doing a better job of getting sales dollars to net income? Where is the one company having an advantage over the other company in turning revenue into net income? Complete the table below: (Round to two decimal places. Net income to three decimal places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window: Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below: (Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart, Inc. Starbucks...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and...
Common-size financial statements. Prepare​ common-size income statements for Walmart and Starbucks using the January 2015 and September 2014 information in the popup​ window:   LOADING... . Which company is doing a better job of getting sales dollars to net​ income? Where is the one company having an advantage over the other company in turning revenue into net​ income? Complete the table​ below:  ​(Round to two decimal places. Net income to three decimal​ places.) Abbreviated Income Statements ($ in Millions) Company Walmart,...
Examine WALMART cash flow statement for the most recent year only (e.g.: 2017). Analyze whether the...
Examine WALMART cash flow statement for the most recent year only (e.g.: 2017). Analyze whether the cash flow is “healthy” or not.
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets...
Common-Size Balance Sheets Following is the balance sheet for Target Corporation. Prepare Target’s common-size balance sheets as of January 31, 2015 and February 1, 2014. (Round your answers to one decimal place.) ($ millions) January 31, 2015 February 1, 2014 Assets Cash and cash equivalents $2,210 $670 Inventory 8,790 8,278 Other current assets 3,087 2,625 Total current assets 14,087 11,573 Property and equipment, net 25,958 26,412 Other noncurrent assets 1,359 6,568 Total assets $41,404 $44,553 Liabilities and shareholders’ investment Accounts...
this is for a budget and analysis class at PBA WALMART VS. TARGET Wal-Mart's business operations...
this is for a budget and analysis class at PBA WALMART VS. TARGET Wal-Mart's business operations are 4 times the scope of rival Target. But, which company is financially healthier? 1. Let's retrieve the latest annual financial statements for each corporation and then calculate the profitability, liquidity, and solvency ratios for the two giant retailers. (See the syllabus for guidance to retrieve the latest financial statements for these companies; or see "Notes" below.) 2. After calculating the profitability, liquidity, solvency,...
short essay: why common- size analysis?
short essay: why common- size analysis?
Discuss the most common and current real-life uses of terminal values in cash flow analysis, and...
Discuss the most common and current real-life uses of terminal values in cash flow analysis, and the pros and con's of this calculation process. (Words should be between 400 to 500 with at least 3 paragraphs.
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual...
Cash flow series Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Annual Cash Flow ($ per year) Year Prob = 0.3 Prob = 0.22 Prob = 0.48 0 –5000 –6000 –4000 1 1000 500 3100 2 1000 1500 1200 3 1000 2000 100 Determine the expected present worth of the following cash flow series if each series may be realized with the probability shown at the head of each column. Let i = 20% per year....
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT