INSTRUCTIONS: USE THIS FORM AND PLACE ALL EMBEDDED FORMULAS IN THE APPROPRIATE BLUE CELL. RETURN TO ME VIA EMAIL.
1	The XYZ Widget Company has sales of $1,200,000. Given the following ratios, fill in the balance sheet
	Total Assets Tiurnover	2.40	Times		$ 1,200,000.00	TOTAL SALES
	Cash to Total Assets	2.0%
	Accounts Receivable Turnover	8.00	Times
	Inventory Turnover	10.00	Times
	Current Ratio	2.00	Times
	Debt to Total Assets	61.0%
	XYZ WIDGET COMPANY
		ASSETS				LIABILITIES & SHAREHOLDER'S EQUITY
	Cash			?			Current debt			$ ? -
	Accounts Receivable		?			Long-term Debt		$ - ?
	Inventory			?			Total Debt			$ - ?
	Total Current Assets
							Equity			? $ -
	Fixed Assets		?
	TOTAL ASSETS		?			TOTAL LIAB & SH EQUITY	$ - ?

Find Cas/Account receivable/ Inventory/ Fixed assets/ total assets/ current debt/ long term debt/ total debt/ equity/ total liability and equity