$$

Cash Flows at Warf Computers, Inc. was nate by Nick and his friends, Over the yars, this same croup las supplied the lintied addional invectnent needed by the conpany in the form of buth equity and thort and lung ierm dehL. Fevently the compery has developed a sirtual keybourt $($VK$).$ The VK uses technolegi, the sydem is a full generaiken begond what is currenty on the maket. Io iniroduee the VK$.$ the company will require tegnificant outsile investment.

Nick tas made the decision to stek this outsibe finaneing in the ferm of new cquity investments and bank toans. Naturally, new invesers and the bank will require a detailed financial analysis. Your employer, Angus Jones a Partners. I. I.C$,$ has ashed you to evamine the financial satements previded ty Nick. Were are the halance sheets for the two most recent years and the most recent income statement:

WARE COMPUTERS BA$.$ANCE SIILLIS $($in thonsanids$)$

$2021,2022$

$2021$

$2022$

Current assets

Cash and equivalents

Accounts receivable

Inventories

Other

Total current assets

Fixed assets

Property, plant, and equipment

$$4\mathrm{.}197,$$$5\mathrm{.}476$

Less accumulated depreciation

$1,441,1,777$

Net property, plant, and equipment

Intangible assets and others

Total fixed assets

$$3,962,$$$4,746$

$$2,756$$$$3,699$

$936,1\mathrm{.}047$

Common stock

Capital surplus

Accumulated retaincd carnings

Less treasury stock

Total equity

$$6,069,$$$7,254$ Total liabilities and shareholders' equity

S $645$

$+,529$

$$1,174,$$$1,014$

$103,121$ longterm libbilites

$$2,377$$$2,505$ Deferred laxes

Long$-$term debt

$1,517,1,557$

Total long$-$term tabilities

$$1,727,$$$1,839$

Current tiabilities

Accounts payable

Accrued expenses

lotal current tiabilities

$$,210,$$$,282$

Longterm debt

olders' equity

Stockholders' equity

Preferred stock

$5,25,$$$,25$

$166-171$

$1,027,1,044$

$2,116,3,414$

$\backslash$table$[[166,253$

Prepare in Excel a Balance Sheet for $2021$ & $2022,$ and, an Income Statement, Account Statement of Cash Flows, and Financial Cash Flow for $2022.$

$$