Prepare an income statement and a balance sheet for this company using the information provided. Calculate $($and show your work in Excel using Excel formulas$)$:

Current Ratio

Total Net Profit $($Not $\%-$ in $$ $)$

Return on Equity

Working Cap to Assets

Accounts Receiveable Turnover

Net Working Capital to Assets Ratio

Net Profit Margin $(\%)$

Equity Multiplier

Inventory to Net Working Capital

Sales to Assets Ratio

$*$please show formulas

Sales $458790$

Operating costs $339395$

Depreciatiin expense $10000$

Interest expense $5000$

Tax expense $29408$

Cash $1664$

Receivables $37252$

Inventories $53818$

Fixed assets, net $50000$

Payables $11000$

Accrued expenses $10000$

Long$-$term loan $50000$

Common equity $71734$