How do prepare for Target Corp - I am basing it off of statements in 2018 Annual Report.

At the most recent strategic planning meeting, the board of directors of your company has voted to issue additional stock to raise capital for major expansions for the company in the next five years. The board is considering $5 billion. Take the most recent financial statements and prepare a set of projected financial statements based on the given assumptions. The CEO requests that you prepare a written report (including the financial statements) for her.

THANKS FOR YOUR HELP BUT I FIGURED IT OUT ON MY OWN.

SO Consolidated Statements of Operations 653 2017 2016 (millions, except per share data) 2018 As Adjusted As Adjusted Sales $ 74,433 $ 71,786 $ 69,414 Other revenue 923 928 857 Total revenue 75,356 72,714 70,271 Cost of sales 53,299 51,125 49,145 Selling general and administrative expenses 15,723 15,140 14.217 Depreciation and amortization (exclusive of depreciation included in cost of sales) 2,224 2.225 2,045 Operating income 4,110 4,224 4,864 Net interest expense 461 991 Net other (income) / expense (27) (59) (88 Earnings from continuing operations before income taxes 3,676 3,630 3,961 Provision for income taxes 746 722 1,295 Net earnings from continuing operations 2,930 2.908 2,666 Discontinued operations, net of tax Net earnings $ 2,937 $ 2,914 $ 2,734 Basic earnings per share Continuing operations $ 5.54 $ 5.32 $ 4.61 Discontinued operations 0.01 0.01 0.12 Net earnings per share $ 5.55 $ 5.32 $ 4.73 Diluted earnings per share Continuing operations $ 5.50 $ 5.29 $ 4.58 Discontinued operations 0.01 0.01 0.11 Net earnings per share $ 5.51 $ 5.29 $ 4.68 Weighted average common shares outstanding Basic 528.6 546.8 577 Diluted 533.2 550. 3 582. Antidilutive shares - 4.1 0. Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. Refer to Note 2 regarding the adopt nardina the adoption of new accounting standards for revenue recognition, leases, ar ow accounting standards pensions. Consolidated Statements of Financial Position 281 February 3 2018 February 2, (millions, except footnotes) 2019 As Adjusted Assets Cash and cash equivalents 1,556 $ 2.643 Inventory 9,497 8,597 Other current assets 1,466 1,300 Total current assets 12,519 12,540 Property and equipment Land 6,064 6,095 Buildings and improvements 29,240 28.131 Fixtures and equipment 5,912 5,623 Computer hardware and software 2,544 2,645 Construction-in-progress 460 440 Accumulated depreciation (18,687) (18,398) Property and equipment, net 25,533 24,536 Operating lease assets 1,965 1,884 Other noncurrent assets 1.273 1,343 Total assets $ 41.290 $ 40,303 Liabilities and shareholders' Investment Accounts payable 9,761 $ 8,677 Accrued and other current liabilities 4,201 4,094 Current portion of long-term debt and other borrowings 1,052 Total current liabilities 15,014 13,052 Long-term debt and other borrowings 10,223 11,117 Noncurrent operating lease liabilities 2,004 1,924 Deferred income taxes 972 693 Other noncurrent liabilities 1,780 1,866 Total noncurrent liabilities 14.979 15,600 Shareholders' investment Common stock 43 Additional paid-in capital 6,042 5,858 Retained earnings 6,017 6,495 Accumulated other comprehensive loss (805) Total shareholders' investment 11,297 11,651 Total liabilities and shareholders' investment $ 41,290 $ 40,303 Common Stock Authorized 6,000,000,000 shares, -0.0833 par value; 517,761,600 shares issued and outstandin at February 2, 2019; 541,681,670 shares issued and outstanding at February 3, 2018. Preferred Stock Authorized 5,000,000 share wit par value: no shares were issued or outstanding at February 2019 or February 3, 2018. See accompanying Notes to Consolidated Financial Statements Refer to Note 2 regarding the acopono new accounting standards for revenue recognition, leases, ar pensions. 45 (747) Consolidated Statements of Cash Flows 2018 As Aduale As Aquilos 2.914 $ 2.734 2.937 $ 2.030 2.908 2.656 2.474 2,318 2,476 112 113 322 (188) 123 208 422 (11) 293 (900) (299) (348) (156) 1,307 1.127 (166) (304) 5.970 6.861 5.337 107 5,444 5,973 6,935 (2.533) (1,547) milions) Operating activities Net earnings Eamings from discontinued operations, not of tax Net earnings from continuing operations Austments to reconcile net earings to cash provided by operations Depreciation and amortization Share-based compensation expense Deferred income taxes Loss on debt extinguishment Noncash losses/gains) and other net Changes in operating accounts: Inventory Other assets Accounts payable Accrued and other liabilities Cash provided by operating activities continuing operations Cash provided by operating activities disconti Cash provided by operations Investing activities Expenditures for property and equipment Proceeds from disposal of property and equipment Cash paid for acquisitions, net of cash assumed Other investments Cash required for investing activities Financing activities Additions to long-term debt Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises Cash required for financing activities Net (decrease]/increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental Information Interest paid, net of capitalized interest Income taxes paid Leased assets obtained in exchange for new finance lease liabilities Leased assets obtained in exchange for new operating lease liabilities (3,516) 85 46 (518) (55) (3.075) (3.416) (1,473) (281) (1.335) (2.124) 739 (2.192) (1,338) (1,046) 108 (3.729) 131 2,512 2.643 1.977 (2.649) (1.348) (3.706) 221 (5,505) (1,534) 4,046 (3.644) (1,087) 2.643 1.556 $ $ $ $ 2.512 678 $ 999 934 1.514 476 $ 373 130 246 139 212 See accompanying Notes to Consolidated Financial Statements Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. Consolidated Statements of Shareholders' Investment Common Stock Additional Retained Accumulated Other Stock Par Paid-in Faminas Comprehensive Shares Value Capital As Adjusted (Loss)/Income Total 602.2 $ 50 $ 5,348 $ 8,196 $ (629) $ 12,965 (43) (43) 2,734 2.734 (9) (1,359) (1.359) (50.9) (3,682) (3,686) 4.9 313 556.2 $ 46 $ 5,661 $ 5,846 $ (638) $ 10,915 2,914 - 2.914 - - (millions) January 30, 2016 Adoption of ASC Topic 842 (Leases) Net earnings Other comprehensive loss Dividends declared Repurchase of stock Stock options and awards January 28, 2017 Net earings Other comprehensive income Dividends declared Repurchase of stock Stock options and awards Reclassification of tax effects to retained earnings February 3, 2018 Net earnings Other comprehensive loss Dividends declared Repurchase of stock Stock options and awards February 2, 2019 (1,356) (1.026) - - - (1,356) (1,027) 197 (17.6) (1) 197 541.7 $ 45 $ 5,858 $ 117 6,495 $ 2.937 (117) - (747) $ 11,651 - 2,937 (58) (5 - (1.347 - (2,070 - 18 (805) $ 11.29 (1,347) (2,068) (27.2) 3.3 517.8 $ (2) - 43 $ 184 6,042 $ 6,017 S We declared $2.54, $2.46, and $2.36 dividends per share for the twelve months ended February 2, 2019, February 2018, and January 28, 2017, respectively. See accompanying Notes to Consolidated Financial Statements. Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases pensions. SO Consolidated Statements of Operations 653 2017 2016 (millions, except per share data) 2018 As Adjusted As Adjusted Sales $ 74,433 $ 71,786 $ 69,414 Other revenue 923 928 857 Total revenue 75,356 72,714 70,271 Cost of sales 53,299 51,125 49,145 Selling general and administrative expenses 15,723 15,140 14.217 Depreciation and amortization (exclusive of depreciation included in cost of sales) 2,224 2.225 2,045 Operating income 4,110 4,224 4,864 Net interest expense 461 991 Net other (income) / expense (27) (59) (88 Earnings from continuing operations before income taxes 3,676 3,630 3,961 Provision for income taxes 746 722 1,295 Net earnings from continuing operations 2,930 2.908 2,666 Discontinued operations, net of tax Net earnings $ 2,937 $ 2,914 $ 2,734 Basic earnings per share Continuing operations $ 5.54 $ 5.32 $ 4.61 Discontinued operations 0.01 0.01 0.12 Net earnings per share $ 5.55 $ 5.32 $ 4.73 Diluted earnings per share Continuing operations $ 5.50 $ 5.29 $ 4.58 Discontinued operations 0.01 0.01 0.11 Net earnings per share $ 5.51 $ 5.29 $ 4.68 Weighted average common shares outstanding Basic 528.6 546.8 577 Diluted 533.2 550. 3 582. Antidilutive shares - 4.1 0. Note: Per share amounts may not foot due to rounding. See accompanying Notes to Consolidated Financial Statements. Refer to Note 2 regarding the adopt nardina the adoption of new accounting standards for revenue recognition, leases, ar ow accounting standards pensions. Consolidated Statements of Financial Position 281 February 3 2018 February 2, (millions, except footnotes) 2019 As Adjusted Assets Cash and cash equivalents 1,556 $ 2.643 Inventory 9,497 8,597 Other current assets 1,466 1,300 Total current assets 12,519 12,540 Property and equipment Land 6,064 6,095 Buildings and improvements 29,240 28.131 Fixtures and equipment 5,912 5,623 Computer hardware and software 2,544 2,645 Construction-in-progress 460 440 Accumulated depreciation (18,687) (18,398) Property and equipment, net 25,533 24,536 Operating lease assets 1,965 1,884 Other noncurrent assets 1.273 1,343 Total assets $ 41.290 $ 40,303 Liabilities and shareholders' Investment Accounts payable 9,761 $ 8,677 Accrued and other current liabilities 4,201 4,094 Current portion of long-term debt and other borrowings 1,052 Total current liabilities 15,014 13,052 Long-term debt and other borrowings 10,223 11,117 Noncurrent operating lease liabilities 2,004 1,924 Deferred income taxes 972 693 Other noncurrent liabilities 1,780 1,866 Total noncurrent liabilities 14.979 15,600 Shareholders' investment Common stock 43 Additional paid-in capital 6,042 5,858 Retained earnings 6,017 6,495 Accumulated other comprehensive loss (805) Total shareholders' investment 11,297 11,651 Total liabilities and shareholders' investment $ 41,290 $ 40,303 Common Stock Authorized 6,000,000,000 shares, -0.0833 par value; 517,761,600 shares issued and outstandin at February 2, 2019; 541,681,670 shares issued and outstanding at February 3, 2018. Preferred Stock Authorized 5,000,000 share wit par value: no shares were issued or outstanding at February 2019 or February 3, 2018. See accompanying Notes to Consolidated Financial Statements Refer to Note 2 regarding the acopono new accounting standards for revenue recognition, leases, ar pensions. 45 (747) Consolidated Statements of Cash Flows 2018 As Aduale As Aquilos 2.914 $ 2.734 2.937 $ 2.030 2.908 2.656 2.474 2,318 2,476 112 113 322 (188) 123 208 422 (11) 293 (900) (299) (348) (156) 1,307 1.127 (166) (304) 5.970 6.861 5.337 107 5,444 5,973 6,935 (2.533) (1,547) milions) Operating activities Net earnings Eamings from discontinued operations, not of tax Net earnings from continuing operations Austments to reconcile net earings to cash provided by operations Depreciation and amortization Share-based compensation expense Deferred income taxes Loss on debt extinguishment Noncash losses/gains) and other net Changes in operating accounts: Inventory Other assets Accounts payable Accrued and other liabilities Cash provided by operating activities continuing operations Cash provided by operating activities disconti Cash provided by operations Investing activities Expenditures for property and equipment Proceeds from disposal of property and equipment Cash paid for acquisitions, net of cash assumed Other investments Cash required for investing activities Financing activities Additions to long-term debt Reductions of long-term debt Dividends paid Repurchase of stock Stock option exercises Cash required for financing activities Net (decrease]/increase in cash and cash equivalents Cash and cash equivalents at beginning of period Cash and cash equivalents at end of period Supplemental Information Interest paid, net of capitalized interest Income taxes paid Leased assets obtained in exchange for new finance lease liabilities Leased assets obtained in exchange for new operating lease liabilities (3,516) 85 46 (518) (55) (3.075) (3.416) (1,473) (281) (1.335) (2.124) 739 (2.192) (1,338) (1,046) 108 (3.729) 131 2,512 2.643 1.977 (2.649) (1.348) (3.706) 221 (5,505) (1,534) 4,046 (3.644) (1,087) 2.643 1.556 $ $ $ $ 2.512 678 $ 999 934 1.514 476 $ 373 130 246 139 212 See accompanying Notes to Consolidated Financial Statements Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases, and pensions. Consolidated Statements of Shareholders' Investment Common Stock Additional Retained Accumulated Other Stock Par Paid-in Faminas Comprehensive Shares Value Capital As Adjusted (Loss)/Income Total 602.2 $ 50 $ 5,348 $ 8,196 $ (629) $ 12,965 (43) (43) 2,734 2.734 (9) (1,359) (1.359) (50.9) (3,682) (3,686) 4.9 313 556.2 $ 46 $ 5,661 $ 5,846 $ (638) $ 10,915 2,914 - 2.914 - - (millions) January 30, 2016 Adoption of ASC Topic 842 (Leases) Net earnings Other comprehensive loss Dividends declared Repurchase of stock Stock options and awards January 28, 2017 Net earings Other comprehensive income Dividends declared Repurchase of stock Stock options and awards Reclassification of tax effects to retained earnings February 3, 2018 Net earnings Other comprehensive loss Dividends declared Repurchase of stock Stock options and awards February 2, 2019 (1,356) (1.026) - - - (1,356) (1,027) 197 (17.6) (1) 197 541.7 $ 45 $ 5,858 $ 117 6,495 $ 2.937 (117) - (747) $ 11,651 - 2,937 (58) (5 - (1.347 - (2,070 - 18 (805) $ 11.29 (1,347) (2,068) (27.2) 3.3 517.8 $ (2) - 43 $ 184 6,042 $ 6,017 S We declared $2.54, $2.46, and $2.36 dividends per share for the twelve months ended February 2, 2019, February 2018, and January 28, 2017, respectively. See accompanying Notes to Consolidated Financial Statements. Refer to Note 2 regarding the adoption of new accounting standards for revenue recognition, leases pensions