Please answer in EXCEL FUNCTIONS! Feel free to correct any of my incorrect work as well

Dak's Cowboy Emporium

Pro Forma Balance Sheet

Problem $4$

Problem $5$

Total assets $($Answer about $$668,473)q,$

Liabilities and Owners' equity

Current assets

Cash

Accounts Receivable

Inventory

Total

Fixed assets

Net plant and equipment

Growth in assets $($Answer $=$$$33,113)$

Internal equity financing

External financing needed

External debt needed

$\backslash$table$[[$F$,10,400\mathrm{.}00$

$22,800\mathrm{.}00$