1. Create a single sheet that calculates the ratios listed below based on the financial statement
2. Please see Demo 1E for suggestions on how to complete this exercise (the ratios demo may not be exactly the same for this assignment. Please make sure to include the ratios listed HERE):
a. Ratios: Current, Quick, Inventory Turnover, Average Collection Period, Fixed Assets Turnover, Total Asset Turnover, Debt Ratio, Debt to Equity, Times Interest Earned, Gross Profit Margin, Net Profit Margin, Return on Assets, Return on Equity
Balance Sheet
Assets		Liabilities and Owners Equity
Current Assets		Current Liabilities
Cash	$ 20,000.00
Accounts Receivable	10,000.00	Accounts Payable	$ 10,000.00
Inventory	20,000.00	Notes Payable	10,000.00
Total Current Assets	50,000.00	Total Current Liabilities	$ 20,000.00
		Long Term Debt	$ 20,000.00
Fixed Assets
Net Fixed Assets	$ 85,000.00	Owners Equity
		Common Stock and paid-in surplus	$ 50,000.00
		Retained Earnings	45,000.00
		Total Owners Equity	$ 95,000.00
Total Assets	$ 135,000.00	Total Liabilities and Owners Equity	$ 135,000.00
Income Statement
Revenue (all sales are credit)	$ 100,000.00
COGS	45,000.00
Depreciation	15,000.00
EBIT	40,000.00
Interest expense	5,000.00
EBT	35,000.00
Taxes	10,000.00
Net Income	$ 25,000.00
Number of shares outstanding	100,000.00
EPS	$ 0.25