Balance Sheet

Assets

Cash $$200,000$

Accounts receivable $1,722,000$

Raw materials inventory $492,500$

Finished goods inventory $1,627,700$

Equipment $3,000,000$

Less: Accumulated depreciation $750,0002,250,000$

Total assets $$6,292,200$

Liabilities and Equity

Liabilities

Accounts payable $$1,005,000$

Loan payable $12,000$

Long$-$term note payable $2,500,0003,517,000$

Equity

Common stock $1,675,000$

Retained earnings $1,100,2002,775,200$

Total liabilities and equity $$6,292,200$

Please prepare a spreadsheet for below as shown in the picture:

g$.$ Monthly general and administrative expenses include $$60,000$ for administrative salaries and $0\mathrm{.}9\%$ monthly interest on the long$-$term note payable.