The input data is simply a trial balance at Dec 31, 2019 as follows: Dr(Cr) Cash $2,535.01 Accounts

The input data is simply a trial balance at Dec 31, 2019 as follows:

Dr(Cr)

Cash

$2,535.01

Accounts receivable

$33,716.56

Inventory

$13,195.51

Net fixed assets

$60,000.00

Bank loan payable

($10,000.00)

Accounts payable

($11,862.73)

Wages payable

($2,765.43)

Proprietor's equity

($69,814.40)

Proprietor's drawings

$31,305.51

Sales

($378,409.26)

Cost of goods sold

$222,924.71

Advertising and promotion

$16,674.42

Depreciation expense

$15,913.02

Office supplies expense

$5,829.33

Shop supplies expense

$8,133.51

Wages and benefits

$62,624.24

Using Excel, please prepare:

1) Statement of Income & Equity

2) Balance Sheet