Assignment:

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$)$:

Inventory to Net Working Capital

Return on Equity

Net Profit Margin $(\%)$

Quick Ratio

Accounts Receiveable Turnover

Average Receiveables Collection Ratio Period

Net Working Capital to Assets

Current Ratio

Sales to Assets Ratio

Inventory Turnover Ratio