Based on the financial information show below, compute the following ratios in excel

1.Current Ratio

2. Acid Test Ratio

3. Inventory Turnover

4. Average Collection Period

5. Debt Ratio

6. Times Interest Earned

7. Operating Profit Margin

8.Total Asset Turnover

9.Fixed Asset Turnover

10.Return on Equity

Balance Sheet
Cash	40,000
AR	20,000
Inventory	15,000
Total Current Assets	75,000
Land	50,000
Buildings and Equipment	90,000
Less: Accumulated Depreciation	20,000
Total Fixed Assets	70,000
Total Assets	195,000
AP	30,000
Notes Payable	25,000
Total Current Liabilites	55,000
Long Term Debt	40,000
Common Stock	50,000
Retained Earnings	50,000
Commom Equity	100,000
Total Debt and Equity	195,000
Income Statement
Sales (all credit)	250,000
Cost of Goods Sold	175,000
Gross Profit	75,000
Operating Expenses	40,000
EBIT	35,000
Interest Expense	(5,000)
EBT	30,000
Taxes	(7,500)
Net Income	22,500