VII. Report for CEO

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.

Generate a projected balance sheet based on the given scenario.

Analyze the impact on the balance sheet based on the given scenario.

TARGET CORPORATION $($TGT$)$

CONSOLIDATED STATEMENTS OF FINANCIAL POSITION

amounts in millions January $28,2023$ January $29,2022$ January $30,2021$ February $1,2020$ February $2,2019$

Current Assets:

Cash and Cash Equivalents $$2,229$ $$5,911$ $$8,511$ $$2,577$ $$1,556$ Ratio of inventories to net ppe

Receivables, net $-----$

Merchandise Inventories $13,49913,90210,6538,9929,49756,54311,308\mathrm{.}60$

Other Current Assets $2,1181,7601,5921,3331,466$

Total Current Assets $17,84621,57320,75612,90212,519$

Property and Equipment, at cost $-----$

Less Accumulated Depreciation and Amortization $(22,631)(21,137)(20,278)(19,664)(18,687)$

Net Property and Equipment $31,51226,87926,28326,28325,533136,49027,298$

Goodwill $-----$

Other Assets $2,6571,5011,3861,3581,2730\mathrm{.}41426$

Total Assets $$52,015$ $$49,953$ $$48,425$ $$40,543$ $$39,325$

LIABILITIES AND STOCKHOLDERS$$ EQUITY

Current Liabilities

Short$-$Term Debt $$1,896$ $$254$ $$211$ $$200$ $$166$

Accounts Payable $13,48615,47812,8599,9209,761$

Accrued Salaries and Related Expenses $1,4921,7891,8461,3131,371$

Sales Taxes Payable $497424341333331$

Deferred Revenue $1128972$

Income Taxes Payable $473$

Current Installments of Long$-$Term Debt $1301711,1441611,052$

Other Accrued Expenses $5,5875,8445,4384,2064,035$

Total Current Liabilities $23,20024,04922,38416,13316,716$

Long$-$Term Debt, excluding current installments $14,06611,5829,77010,0359,300$

Other Long$-$Term Liabilities $1,7231,5841,8821,6171,740$

Deferred Income Taxes $2,1961,5669901,122972$

Total Liabilities $41,18538,78135,02628,90728,728$

STOCKHOLDERS' EQUITY

Common Stock $3839424243$

Paid$-$In Capital $6,6086,4216,3296,2266,042$

Retained Earnings $5,0056,9208,8256,4336,017$

Accumulated Other Comprehensive Loss $(419)(553)(756)(868)(805)$

Treasury Stock $(419)(553)(756)(868)(805)$

Total Stockholders$$ Equity $10,81312,27413,68410,96510,492$

Total Liabilities and Stockholders' Equity $$53,335$ $$53,811$ $$51,248$ $$42,779$ $$41,290$