Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please construct a statement of cash flows with the attached income statement and balance sheet. I also provided a statement of cashflows template given to

Please construct a statement of cash flows with the attached income statement and balance sheet. I also provided a statement of cashflows template given to us by the professor. (ignore values in template as they are from a different example)
thank you! image text in transcribed
image text in transcribed
image text in transcribed
please provide answer with a formula view as well
Target Income Statement Target Balance Sheet Consolidated Statements of Financial Position - USD (\$) \$ in Millions Jan. 29, 2022 Jan. 30, 2021 Assets Cash and cash equivalents Inventory Other current assets Total current assets \begin{tabular}{|r|r|} \hline$5,911 & $8,511 \\ \hline 13,902 & 10,653 \\ \hline 1,760 & 1,592 \\ \hline 21,573 & 20,756 \\ \hline \end{tabular} Property and equipment Land Buildings and improvements Fixtures and equipment Computer hardware and software Constrction-in-progress \begin{tabular}{|r|r|} \hline 6,164 & 6,141 \\ \hline 32,985 & 31,557 \\ \hline 6,407 & 5,914 \\ \hline 2,505 & 2,765 \\ \hline 1,257 & 780 \\ \hline \end{tabular} Accumulated depreciation Property and equipment, net Operating lease assets Other noncurrent assets Total assets \begin{tabular}{|r|r|} \hline(21,137) & (20,278) \\ \hline 28,181 & 26,879 \\ \hline 2,556 & 2,227 \\ \hline 1,501 & 1,386 \\ \hline 53,811 & 51,248 \\ \hline \end{tabular} Liabilities and shareholders' investment Accounts payable Accrued and other current liabilities Current portion of long-term debt and other borrowings Total current liabilities Long-term debt and other borrowings Noncurrent operating lease liabilities Deferred income taxes Other noncurrent liabilities Total noncurrent liabilities Shareholders' investment Common stock Additional paid-in capital Retained earnings Accumulated other comprehensive loss Total shareholders' investment Total liabilities and shareholders' investment Statement of Cash Flows Millions of dollars Jan. 29, 2022 Jan. 30, 2021 Feb. 01, 2020 Cash Flows from Operations Net Income Depreciation (combined with PP\&E) Change in Accounts Receivable Change in Inventories Change in Other Current Assets Change in Accounts Payable Change in Other Current Liabilities. Total Cash Flows from Operations Cash Flows from Investing Change in Net Plant \& Equipment Change in Other Long-term assets Total Cash Flows from Investing \begin{tabular}{|r|r|r|} \hline 294.00 & -296.00 & 1,001.00 \\ \hline 420.00 & -737.00 & 1,278.00 \\ \hline 1,271.00 & 545.00 & 1,788.00 \\ \hline 1,985.00 & -488.00 & 2,065.00 \\ \hline \end{tabular} Cash Flows from Financing Change in Short-term Debt Change in Long-tem Debt Change in Other Long-term Liabilities Change in Common Stock Change in Other Equity Cash Dividends Paid to Sharcholders Total Cash Flows from Financing Net Change in Cash Balance \begin{tabular}{|r|r|r|} \hline 134.00 & 113.00 & 82.00 \\ \hline-329.00 & 1,359.00 & 2,345.00 \\ \hline-75.00 & 119.00 & -2.00 \\ \hline 83.00 & 608.00 & 2,610.00 \\ \hline-57.00 & 5.00 & -11.00 \\ \hline3,098.01 & -29.00 & 0.00 \\ \hline3,342.01 & 2,175.00 & 5,024.00 \\ \hline-499.00 & 52.00 & 747.00 \\ \hline \end{tabular} Check ok \begin{tabular}{lll} \multicolumn{2}{c}{499.00} & \multicolumn{2}{c}{52.00} \\ & ok & ok \end{tabular} 747.00

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Police Auditing Standards And Applications

Authors: Allan Y. Jiao

2nd Edition

0398090750, 978-0398090753

More Books

Students also viewed these Accounting questions