- Calculate thecash flow from assets of the most recent ONE yearforyour company by using either equation in the video of this week.The data you will need will be from the three financial statements of the company. Show your calculation in the same Excel file but in a new tab of "CF Calculation".Show the steps of calculation.
Income Statement Consolidated Statement of Income - USD ($) shares in Millions, $ in Millions12 Months EndedCommon Size Income Statement Dec. 26, 2020Dec. 28, 2019Dec. 29, 2018Dec.26, 2020Dec.28,2019Dec.29, 2018 Income Statement [Abstract] Net Revenue$ 70,372$ 67,161$ 64,661100%100%100% Cost of sales31,79730,13229,38145.18%44.87%45.44% Gross profit38,57537,02935,28054.82%55.13%54.56% Selling, general and administrative expenses28,49526,73825,17040.49%39.81%38.93% Operating Profit10,08010,29110,11014.32%15.32%15.64% Other pension and retiree medical benefits income/(expense)117(44)2980.17%-0.07%0.46% Net interest expense and other(1,128)(935)(1,219)-1.60%-1.39%-1.89% Income before income taxes9,0699,3129,18912.89%13.87%14.21% Provision for/(benefit from) income taxes (See Note 5)1,8941,959(3,370)2.69%2.92%-5.21% Net income7,1757,35312,55910.20%10.95%19.42% Less: Net income attributable to noncontrolling interests5539440.08%0.06%0.07% Net Income Attributable to PepsiCo$ 7,120$ 7,314$ 12,51510.12%10.89%19.35% Net Income Attributable to PepsiCo per Common Share Basic$ 5.14$ 5.23$ 8.840.01%0.01%0.01% Diluted$ 5.12$ 5.20$ 8.780.01%0.01%0.01% Weighted-average common shares outstanding Basic1,3851,3991,4151.97%2.08%2.19% Diluted1,3921,4071,4251.98%2.09%2.20% Balance Sheet Consolidated Balance Sheet - USD ($) shares in Millions, $ in MillionsDec. 26, 2020Dec. 28, 2019Dec.29, 2018Common Size Balance Sheet ASSETSDec. 26,2020Dec.28,2019Dec.29, 2018 Cash and cash equivalents$ 8,185$ 5,509$8,7218.81%7.01%11.23% Short-term Investments1,3662292721.47%0.29%0.35% Accounts and notes receivable, net8,4047,8227,1249.04%9.96%9.17% Inventories4,1723,3383,1284.49%4.25%4.03% Prepaid expenses and other current assets8747476330.94%0.95%0.82% Assets, Current23,00117,64521,89324.75%22.46%28.20% Property, Plant and Equipment, net21,36919,30517,58923.00%24.58%22.65% Amortizable Intangible Assets, net1,7031,4331,6441.83%1.82%2.12% Goodwill18,75715,50114,80820.19%19.73%19.07% Indefinite-lived Intangible Assets (Excluding Goodwill)17,61214,61014,81818.95%18.60%19.08% Indefinite-Lived Intangible Assets36,36930,11128,98939.14%38.34%37.33% Equity Method Investments2,7922,6832,4093.00%3.42%3.10% Deferred Income Tax Assets, Net4,3724,3594,3644.71%5.55%5.62% Other Assets3,3123,0117603.56%3.83%0.98% Total Assets92,91878,54777,648100.00%100.00%100.00% LIABILITIES AND EQUITY Short-term debt obligations3,7802,9204,0264.07%3.72%5.18% Accounts payable and other current liabilities19,59217,54118,11221.09%22.33%23.33% Liabilities, Current23,37220,46122,13825.15%26.05%28.51% Long-Term Debt Obligations40,37029,14828,29543.45%37.11%36.44% Deferred Income Tax Liabilities, Net4,2844,0913,4994.61%5.21%4.51% Other Liabilities, Noncurrent11,3409,9799,11412.20%12.70%11.74% Liabilities79,36663,67963,04685.42%81.07%81.19% Commitments and contingencies PepsiCo Common Shareholders’ Equity Common stock, par value 12/3¢ per share (authorized 3,600 shares, issued, net of repurchased common stock at par value: 1,380 and 1,391 shares, respectively)$ 23$ 23$230.02%0.03%0.03% Common stock, par value$ 0.0167$ 0.0167$0.01670.00%0.00%0.00% Common stock, authorized3,6003,6003,6003.87%4.58%4.64% Common stock, issued1,3801,3911,4201.49%1.77%1.83% Additional Paid in Capital, Common Stock$ 3,910$ 3,886$3,9534.21%4.95%5.09% Retained Earnings (Accumulated Deficit)63,44361,94659,94768.28%78.86%77.20% Accumulated Other Comprehensive Income (Loss), Net of Tax(15,476.00)(14,300.00)(15,119.00)-16.66%-18.21%-19.47% Repurchased common stock, shares(38,446)(36,769)(34,286.00)-41.38%-46.81%-44.16% Stockholders' Equity Attributable to Parent$ 13,454$ 14,78614,51814.48%18.82%18.70% Stockholders' Equity Attributable to Noncontrolling Interest9882840.11%0.10%0.11% Total Equity13,55214,86814,60214.58%18.93%18.81% Liabilities and Equity$ 92,918$ 78,54777,648100.00%100.00%100.00% Common stock, authorized3,6003,6003,600 Repurchased common stock, shares487476446 Common stock, issued1,3801,3911,420 Retained Earnings [Member] PepsiCo Common Shareholders’ Equity Total Equity$ 63,443$ 61,946$59,947 AOCI Attributable to Parent [Member] PepsiCo Common Shareholders’ Equity Total Equity(15,476.00)(14,300.00)(15,119.00) Treasury Stock [Member] PepsiCo Common Shareholders’ Equity Treasury Stock, Value(38,446.00)(36,769.00)(15,119.00) Common Stock PepsiCo Common Shareholders’ Equity Stockholders' Equity Attributable to Parent$ 23$ 23$23 Cash Flow Consolidated Statement of Cash Flows - USD ($) $ in Millions12 Months Ended Dec. 26, 2020Dec. 28, 2019Dec. 29, 2018 Operating Activities Net income$ 7,175$ 7,353$ 12,559 Depreciation and amortization2,5482,4322,399 Share-based compensation expense264237256 Restructuring and impairment charges289370308 Cash payments for restructuring charges(255)(350)(255) Inventory fair value adjustments and merger and integration costs2555575 Payments for Merger Related Costs(131)(10)(73) Pension and retiree medical plan expenses408519221 Pension and retiree medical plan contributions(562)(716)(1,708) Deferred income taxes and other tax charges and credits361453(531) Tax Cuts and Jobs Act, Income Tax Expense (Benefit)0(8)(28) Tax payments related to the TCJ Act(78)(423)(115) Other net tax benefits related to international reorganizations0(2)(4,347) Change in assets and liabilities [Abstract] Accounts and notes receivable(420)(650)(253) Inventories(516)(190)(174) Prepaid expenses and other current assets26(87)9 Accounts payable and other current liabilities766735882 Income taxes payable(159)(287)448 Other, net642218(258) Net Cash Provided by (Used in) Operating Activities10,6139,6499,415 Investing Activities Capital spending(4,240)(4,232)(3,282) Sales of property, plant and equipment55170134 Acquisitions, net of cash acquired, and investments in noncontrolled affiliates(6,372)(2,717)(1,496) Divestitures4253505 Short-term investments, by original maturity: More than three months - purchases(1,135)0(5,637) More than three months - maturities01612,824 More than three months - sales0621,498 Three months or less, net271916 Other investing, net42(8)2 Net Cash (Used for)/Provided by Investing Activities(11,619)(6,437)4,564 Financing Activities Proceeds from issuances of long-term debt13,8094,6210 Payments of long-term debt(1,830)(3,970)(4,007) Proceeds from (Repayments of) Other Long-term Debt(1,100)(1,007)(1,589) Short-term borrowings, by original maturity More than three months - proceeds4,07763 More than three months - payments(3,554)(2)(17) Three months or less, net(109)(3)(1,352) Cash dividends paid(5,509)(5,304)(4,930) Share repurchases - common(2,000)(3,000)(2,000) Proceeds from exercises of stock options179329281 Withholding tax payments on RSUs, PSUs and PEPunits converted(96)(114)(103) Other financing(48)(45)(55) Net Cash Provided by/(Used for) Financing Activities3,819(8,489)(13,769) Effect of exchange rate changes on cash and cash equivalents and restricted cash(129)78(98) Cash and Cash Equivalents and Restricted Cash, Period Increase (Decrease)2,684(5,199)112 Cash and cash equivalents and restricted cash$ 8,254$ 5,570$ 10,769 CF Calculation CF Calculation 2020 OCF=EBITDEPRECIATION(TAXES) OCF=$ 10,080$ 2,548$ (1,894)$ 10,734 NCS=Ending Net FA(beginning net FA)depreciation NCS=$ 40,370$ (29,148)$ 2,548$ 13,770 Δ NWC=Ending NWC(beginning NWC) Δ NWC=$ 13,552$ 14,868$ 28,420 CFFA=OCF(NCS)(Δ NWC) CFFA=$ 10,734$ (13,770)$ (28,420)$ (31,456) Sheet3 10,080 Income Statement AutoZone (AZO) Consolidated Statements of Income - USD ($) shares in Thousands, $ in Thousands12 Months EndedCommon-SizeChange Aug. 29, 2020Aug. 31, 2019Aug. 25, 2018Aug. 29, 2020Aug. 31, 2019Aug. 25, 20182019 to 20202018 to 2019 Income Statement [Abstract](B#/$B$4)(C#/$C$4)(D#/$D$4)(F#-G#)(G#-H#) Net sales$12,631,967$11,863,743$11,221,077100.00%100.00%100.00%0.00%0.00% Cost of sales, including warehouse and delivery expenses5,861,2145,498,7425,247,33146.40%46.35%46.76%0.05%-0.41% Gross profit6,770,7536,365,0015,973,74653.60%53.65%53.24%-0.05%0.41% Operating, selling, general and administrative expenses4,353,0744,148,8644,162,89034.46%34.97%37.10%-0.51%-2.13% Operating profit2,417,6792,216,1371,810,85619.14%18.68%16.14%0.46%2.54% Interest expense, net201,165184,804174,5271.59%1.56%1.56%0.03%0.00% Income before income taxes2,216,5142,031,3331,636,32917.55%17.12%14.58%0.42%2.54% Income tax expense483,542414,112298,7933.83%3.49%2.66%0.34%0.83% Net income$1,732,972$1,617,221$1,337,53613.72%13.63%11.92%0.09%1.71% Weighted average shares for basic earnings per share23,54024,96626,9700.19%0.21%0.24%-0.02%-0.03% Effect of dilutive stock equivalents5535324540.00%0.00%0.00%-0.00%0.00% Weighted average shares for diluted earnings per share24,09325,49827,4240.19%0.21%0.24%-0.02%-0.03% Balance Sheet AutoZone (AZO) Consolidated Balance Sheets - USD ($) $ in ThousandsCommon-SizeChange Aug. 29, 2020Aug. 31, 2019Aug. 31, 2018Aug. 29, 2020Aug. 31, 2019Aug. 31, 20182019 to 20202018 to 2019 Current assets:B#/$B$23C#/$C$23D#/$D$23(F#-G#)(G#-H#) Cash and cash equivalents$1,750,815$176,300$217,82412.14%1.78%2.33%10.36%-0.55% Accounts receivable364,774308,995258,1362.53%3.12%2.76%-0.59%0.36% Merchandise inventories4,473,2824,319,1133,943,67031.01%43.65%42.19%-12.63%1.45% Other current assets223,001224,277216,2391.55%2.27%2.31%-0.72%-0.05% Total current assets6,811,8725,028,6854,635,86947.23%50.82%49.60%-3.59%1.22% Property and equipment:B#/$B$23C#/$C$23D#/$D$23(F#-G#)(G#-H#) Land1,205,2281,147,7091,107,0928.36%11.60%11.84%-3.24%-0.25% Buildings and improvements4,020,2713,895,5593,698,01027.87%39.37%39.56%-11.49%-0.20% Equipment2,158,2511,991,0421,841,33014.96%20.12%19.70%-5.16%0.42% Leasehold improvements586,839552,018504,6564.07%5.58%5.40%-1.51%0.18% Construction in progress165,953126,868140,5351.15%1.28%1.50%-0.13%-0.22% Property and equipment8,136,5427,713,1967,291,62356.41%77.94%78.01%-21.53%-0.07% Less: Accumulated depreciation and amortization-3,627,321-3,314,44515,301,849-25.15%-33.49%163.71%8.35%-197.20% Property and equipment, net4,509,2214,398,7514,218,40031.26%44.45%45.13%-13.19%-0.68% Operating lease right-of-use assets2,581,67717.90%0.00%0.00%17.90%0.00% Goodwill302,645302,645302,6452.10%3.06%3.24%-0.96%-0.18% Deferred income taxes27,84326,86134,6200.19%0.27%0.37%-0.08%-0.10% Other long-term assets190,614138,971155,4461.32%1.40%1.66%-0.08%-0.26% Other long-term assets, total3,102,779468,477492,71121.51%4.73%5.27%16.78%-0.54% Assets14,423,8729,895,9139,346,980100.00%100.00%100.00%0.00%0.00% Current liabilities:B#/$B$43C#/$C$43D#/$D$43(F#-G#)(G#-H#) Accounts payable5,156,3244,864,9124,409,37235.75%49.16%47.17%-13.41%1.99% Current portion of operating lease liabilities223,8461.55%0.00%0.00%1.55%0.00% Accrued expenses and other827,668621,932606,8945.74%6.28%6.49%-0.55%-0.21% Income taxes payable75,25325,29712,4150.52%0.26%0.13%0.27%0.12% Total current liabilities6,283,0915,512,1415,028,68143.56%55.70%53.80%-12.14%1.90% Long-term debt5,513,3715,206,3445,005,93038.22%52.61%53.56%-14.39%-0.95% Operating lease liabilities, less current portion2,501,56017.34%0.00%0.00%17.34%0.00% Deferred income taxes354,186311,980285,2042.46%3.15%3.05%-0.70%0.10% Other long-term liabilities649,641579,299547,5204.50%5.85%5.86%-1.35%-0.00% Commitments and contingencies Stockholders' deficit:B#/$B$43C#/$C$43D#/$D$43(F#-G#)(G#-H#) Preferred stock, authorized 1,000 shares; no shares issued Common stock, par value $.01 per share, authorized 200,000 shares; 23,697 shares issued and 23,376 shares outstanding as of August 29, 2020; 25,445 shares issued and 24,038 shares outstanding as of August 31, 20192372542750.00%0.00%0.00%-0.00%-0.00% Additional paid-in capital1,283,4951,264,4481,155,4268.90%12.78%12.36%-3.88%0.42% Retained deficit-1,450,970-1,305,347-1,208,824-10.06%-13.19%-12.93%3.13%-0.26% Accumulated other comprehensive loss-354,252-269,322-235,805-2.46%-2.72%-2.52%0.27%-0.20% Treasury stock, at cost-356,487-1,403,884-1,231,427-2.47%-14.19%-13.17%11.71%-1.01% Total stockholders' deficit-877,977-1,713,851-1,520,355-6.09%-17.32%-16.27%11.23%-1.05% Liabilities and Stockholders' Deficit$14,423,872$9,895,913$9,346,980100.00%100.00%100.00%0.00%0.00% Statement of Cash Flows AutoZone (AZO) Consolidated Statements of Cash Flows - USD ($) $ in Thousands12 Months Ended Aug. 29, 2020Aug. 31, 2019Aug. 25, 2018 Cash flows from operating activities: Net income$1,732,972$1,617,221$1,337,536 Adjustments to reconcile net income to net cash provided by operating