Answered step by step
Verified Expert Solution
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!
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started