Prepare a simplified balance sheet and income statement projecting the growth of Walgreens-Boots Alliance, Inc. for the fiscal year ending 8/31/2022. Assume no new issues of equity. Projections can be based on trend line, average, or some combination of techniques. Historical data below.

As Reported Annual Balance Sheet Report Date Scale Cash & cash equivalents Accounts receivable, gross Allowances for doubtful accounts Accounts receivable, net Inventories Other current assets Total current assets. Land & land improvements Buildings & building improvements Fixtures & equipment Capitalized system development costs & software Finance lease properties Property, plant & equipment, gross Less: accumulated depreciation & amortization Property, plant & equipment, net Operating lease right-of-use asset Goodwill Intangible assets, net Equity method investments Other non-current assets Total non-current assets Total assets Commercial paper Credit facilities Unsecured notes Unsecured Pound sterling notes Other short-term borrowings Short-term debt Trade accounts payable Operating lease obligation Accrued expenses & other liabilities Income taxes Total current liabilities Unsecured notes Unsecured Pound Sterling notes Unsecured Euro notes Other long-term debt. Long-term debt Operating lease obligation Deferred income taxes Other non-current liabilities Total non-current liabilities Total liabilities Redeemable noncontrolling interest Common stock Paid-in capital Retained earnings Pension/post-retirement obligations Unrealized gain (loss) on cash flow hedges Net investment hedges Unrealized gain (loss) on available for sale securities Share of OCI of equity method investments Cumulative translation adjustments Accumulated other comprehensive income (loss) Treasury stock Total Walgreens Boots Alliance, Inc. shareholders' equity Noncontrolling interests Total equity As Reported Annual Income Statement Report Date Scale Sales Cost of sales Gross profit Selling, general & administrative expenses Equity earnings (loss) in AmerisourceBergen Corporation (AmerisourceBergen") Operating income Other income (expense) Earnings before interest & income tax provision Interest expense, net Earnings before income tax provision - United States Earnings before income tax rovision non-United States Earnings before income tax provision Current federal provision for income taxes Current state provision for income taxes Current non-United States provision for income taxes Total current provision for income taxes Deferred federal provision for (benefit from) income taxes - tax law change Deferred federal provision for (benefit from) income taxes - excluding tax law change Deferred federal income tax provision Deferred state provision for income taxes Deferred non-United States provision for income taxes - tax law change Deferred non-United States provision for (benefit from) income taxes - excluding tax law change Total non-current provision for (benefit from) income taxes Income tax provision Post tax earnings from other equity method investments Net earnings from continuing operations Net earnings from discontinued operations Net earnings Net earnings (loss) attributable to noncontrolling interests - continuing operations Net earnings (loss) attributable to noncontrolling interests - discontinued operations Net earnings (loss) attributable to noncontrolling interests Net earnings attributable to Walgreens Boots Alliance, Inc. - continuing operations Net earnings attributable to Walgreens Boots Alliance, Inc. - discontinued operations Net earnings attributable to Walgreens Boots Alliance, Inc. Weighted average shares outstanding - basic Weighted average shares outstanding - diluted Year end shares outstanding Earnings per common share continuing operations - basic Earnings per common share - discontinued operations - basic Net earnings per common share - basic Earnings per common share - continuing operations - diluted Earnings per common share - discontinued operations - diluted Net earnings per common share - diluted Number of full time employees Number of part time employees Total number of employees Number of common stockholders Dividends declared per share Foreign currency translation adjustments As Reported Annual Retained Earnings Report Date Scale Previous retained earnings Dividends declared & distributions Adoption f new accounting standards Noncontrolling interests contribution & other retained earnings Retained earnings As Reported Annual Cash Flow Report Date Scale Net earnings Depreciation & amortization Loss (gain) on previously held equity interest Deferred income taxes Stock compensation expense Equity loss (earnings) from equity method investments Goodwill & intangible impairments Loss (gain) on early extinguishment of debt Loss (gain) on sale of business. Loss (gain) on sale of equity method investment Other adjustments Accounts receivable, net Inventories Other current assets Trade accounts payable Accrued expenses & other liabilities Income taxes Other non-current assets & liabilities Net cash flows from operating activities Additions to property, plant & equipment Proceeds from sale-leaseback transactions Proceeds from sale of business, net of cash disposed Proceeds from sale of other assets Business, investment & asset acquisitions, net of cash acquired Other business & intangible asset acquisitions, net of cash acquired Proceeds from debt Other investing activities Net cash flows from investing activities Net change in short-term debt with maturities of 3 months or less Payments of debt Stock purchases Proceeds related to employee stock plans Cash dividends paid Early debt extinguishment Other financing activities Net cash flows from financing activities Effect of exchange rate changes on cash, cash equivalents & restricted cash Net increase (decrease) in cash, cash equivalents, & restricted cash Cash, cash equivalents & restricted cash at beginning of period Cash, cash equivalents & restricted cash at end of period Effect of exchange rate changes on cash & cash equivalents Net (decrease) increase in cash & cash equivalents Cash & cash equivalents at beginning of period Cash & cash equivalents at end of period 08/31/2017 08/31/2018 08/31/2019 08/31/2020 08/31/2021 Thousands Thousands Thousands Thousands Thousands 3,301,000 1,193,000 516,000 785,000 6,648,000 6,686,000 1,023,000 7,321,000 7,193,000 95,000 5,716,000 158,000 61,000 53,000 75,000 6,528,000 6,573,000 7,226,000 7,132,000 5,663,000 8,159,000 8,899,000 9,565,000 9,333,000 9,451,000 1,025,000 923,000 1,118,000 974,000 800,000 19,753,000 17,846,000 18,700,000 18,073,000 15,814,000 3,470,000 3,593,000 3,507,000 3,253,000 2,798,000 7,431,000 7,874,000 8,023,000 8,023,000 7,569,000 9,209,000 9,750,000 9.786.000 10,290,000 10,314,000 2,105,000 2,464,000 2.770,000 3,215,000 3,624,000 703,000 745,000 743,000 1,016,000 1,016,000 22,960,000 24,424,000 24,789,000 25,797,000 25,321,000 9,318,000 10,513,000 11,310,000 12,456,000 13,073,000 13.642.000 13.911.000 13.478.000 13.342.000 12.247.000 21,724,000 21,893,000 15,632,000 16,914,000 16,560,000 15,268,000 12,421,000 10,156,000 11,783,000 10,876,000 10,753,000 9,936,000 6,320,000 6,610,000 6,851,000 7,338,000 6,987,000 506,000 1,060,000 1,133,000 46,256,000 50,278,000 48,899,000 677,000 1,987,000 69,101,000 87,174,000 66,009,000 68,124,000 67,598,000 430,000 2,400,000 1.517,000 999,000 1,624,000 1,071,000 249,000 1,250,000 251,000 288,000 464,000 56,000 1,966,000 5,738,000 3,538.000 1.305.000 251.000 12,494,000 13,566,000 14,341,000 14,458,000 11,136,000 2,259,000 7,260,000 2,426,000 5,473,000 5,862,000 5,474,000 6,539,000 329,000 273.000 216,000 110,000 18,547,000 21,667,000 25,769,000 27,070,000 94,000 9,397,000 10,890,000 10,879,000 10,636,000 897,000 904,000 853,000 398,000 884,000 868,000 824,000 891,000 24,000 23,000 25,000 24,000 12.684,000 12.431.000 11.098.000 12,203.000 2,281,000 1,815,000 1,785,000 1,498,000 4,223,000 5,522,000 4,795,000 3,294,000 19,188,000 19,768,000 17,678,000 38,968,000 12,000 12,000 12,000 12,000 10,339,000 10,493,000 10,639,000 10,761,000 30,137,000 33,551,000 35,815,000 34,210,000 (139,000) 101,000 (48,000) (748,000) (33,000) (30,000) 31,000 (31,000) (34,000) (306,000) (24,000) (80,000) (24,000) (434.000) (324.000) 760.000 998.000 8,000 54,000 (23,000) 4 866,000 103,000 353.000 4 235,000 110,000 345,000 63,275 (35,000) 96,000 (2,000) 3,000 (10,000) (29,000) 3,000 (3,884,000) (2,948,000) (1,772,000) (3,897,000) (3,771,000) (2,109,000) (2,877,000) (3,076,000) (3,051,000) (3,002,000) 9,971,000 15,047,000 19,057,000 20,575,000 20,593,000 27,466,000 26,007,000 23,512,000 20,637,000 23,419,000 808,000 682,000 641,000 498,000 402,000 28,274,000 26,689,000 24,152,000 21,136,000 23,822,000 1.322.000 (648,000) 304,000 08/31/2017 08/31/2018 08/31/2019 08/31/2020 08/31/2021 Thousands Thousands Thousands Thousands Thousands 118,214,000 131,537,000 136,866,000 139,537,000 132,509,000 89,052,000 100,745,000 106,790,000 111,520,000 104,442,000 29,162,000 30.792.000 30.076.000 28.017.000 28.067.000 23,740,000 24,569,000 25.242.000 27,045,000 24,586,000 135,000 191,000 164,000 341,000 (1,139,000) 6.414.000 4.998,000 1,312.000 2,342.000 5.557.000 (11,000) 558,000 177,000 233,000 70,000 6.591.000 5.231.000 1.382,000 5.546.000 2.900.000 693,000 616,000 639,000 905,000 704,000 3,292,000 1,898,000 1,953,000 759,000 61,000 2,900,000 2,683,000 2,629,000 (16,000) 4.853.000 5.975.000 4.527.000 743.000 759,000 150,000 45,000 49,000 390,000 204,000 1.194,000 403,000 4.101.000 5,031,000 3,962.000 (434,000) 91,000 (143,000) (7,000) 4,078,000 5,024,000 3,982,000 1,073,500 921,500 1,078,500 923,500 1,023,849 895,388 991,000 995,000 952,133 59,000 201,000 46,000 241,000 488.000 78,000 2,000 139,000 (58,000) (55,000) (101,000) 100.000 (43,000) 588.000 360.000 23,000 41,000 5 151,000 4,000 533,000 418,000 5 244,000 232,000 110,000 110,000 354,000 342,000 56,000 52,800 2 2 (169,000) (198,000) (820,000) 20,000 4 7,675,000 21,973,000 22,153,000 1,850,000 3,413,000 35,091,000 57,145,000 (45,000) (98,000) (12,934,000) (5,295,000) 20,000 15,000 (6,506,000) (2,516,000) 9,807,000 3,301,000 3,301,000 785,000 (83,000) 424.000 32,000 65,471,000 81,285,000 1 1,250,000 223.000 108,000 331,000 50,600 958,000 364,000 296,000 302,000 464,000 163,000 63,000 (153,000) (391,000) (789,000) 98,000 331,000 141,000 (22,000) (112,000) (31,000) 954,000 (25,000) 22,054,000 6,365,000 408,000 873,000 29,000 319,000 12,000 117,000 655,000 90,000 (4,793,000) (741,000) (718,000) 10,988,000 35,121,000 (359,000) (10,000) 1,934,000 1.995.000 79,000 115,000 234,000 428.000 1,994,000 548,000 456,000 2,542,000 879,400 864,800 880,300 866,400 865,604 865,374 (10,000) (46,000) 344,000 (49,000) 239.000 667.000 627,000 1,955,000 557,000 2.512.000 08/31/2017 08/31/2018 08/31/2019 08/31/2020 08/31/2021 Thousands Thousands Thousands Thousands Thousands 27,684,000 30,137,000 33,551,000 35,815,000 34,210,000 1,625,000 1,610,000 1,629,000 1,618,000 (88,000) (442,000) (1,000) 30,137,000 33,551,000 35,815,000 34,210,000 35,121,000 1,629,000 (3,000) 39,000 (9,000) 08/31/2017 08/31/2018 08/31/2019 08/31/2020 08/31/2021 Thousands Thousands Thousands Thousands Thousands 4,101,000 5,031,000 3,962,000 424,000 2,512,000 1,654,000 1,770,000 2,038,000 1,927,000 1,973,000 (337,000) (322,000) 130,000 100,000 (43,000) 119,000 137,000 (244,000) (187,000) (382,000) 2,016,000 2 1 3 2 1 3 202,000 113,000 315,000 48,077 2 1,690,000 1,323,000 (374,000) 1,008,000 1,046,000 (406,000) (221,000) 160,000 (128,000) 281,000 44,000 694,000 67,000 (275,000) (154,000) (16,000) (288,000) 7,251,000 8,265,000 5,594,000 5,484,000 5,555,000 (1,351,000) (1,367,000) 444,000 (1,702,000) (1,374,000) (1,379,000) 3,000 724,000 856,000 5,527,000 453,000 (1,431,000) 233,000 155,000 498,000 49,000 414,000 (322,000) (321,000) (64,000) (1,451,000) 165,000 (46,000) 842,000 (88,000) 12,726,000 5,900,000 12,433,000 20,367,000 93,000 4,000 16,000 (19,000) 46,000 (843,000) (5,501,000) (2,307,000) (1,297,000) 4,072,000 33,000 586,000 536,000 (161,000) (909,000) (6,196,000) (4,890,000) (10,461,000) (21,414,000) (15,257,000) (5,220,000) (5,228,000) (4,160,000) (1,589,000) (110,000) 217,000 174,000 174,000 55,000 (1,723,000) (1,739,000) (1,643,000) (1,747,000) 59,000 (1,617,000) (3,687,000) 75,000 (157,000) (241,000) (3,047,000) (4,647,000) (9,036,000) (9,000) (1,000) (66,000) 232,000 (460,000) 525,000 975,000 1,207,000 746,000 1,207,000 746,000 1,270,000