What I need is some ratios but they have to be done through Excel.

The RATIOS I need include: ROI (Return on Investment)

Gross Margin Percentage (GM%), Current Ratio (CR), Debt to Equity (DE), and Earnings Per Share (EPS).

The instructions also require to use as less steps as possible to find all these ratios, which is what I am kind of struggling

with. Thank you for who ever does this.

Acct No. Name 1010 Cash 1030 Accounts Receivable 1035 Allowance for Bad Debt 1050 Inventory 1700 Fixed Assets 1750 Accumulated Depreciation 2010 Accounts Payable 2030 Payroll W/H&Taxes Payable 2070 Interest Payable 2080 Income Tax Payable 2700 Long-term Notes Payable 3900 Capital Stock 3999 Retained Earnings 4010 Sales 4020 Sales Returns 4030 Sales Discounts 5000 Purchases 5010 Purchase Returns 5020 Purchase Discounts 5999 Cost of Goods Sold 6000 Wage & Salary Expense 6010 Rent Expense 6020 Utilities Expense 6030 Office Supplies Expense 6040 Payroll Tax Expense 6050 Depreciation 6060 Bad Debt Expense 6070 Interest Expense 6080 Provision for Income Tax YTD 174535.7 582380 -61488.3 1733000 917500 -39202 -630000 -9527.95 -5000 -236949 -600000 -700000 -177453 -6174020 320280 59910 0 0 0 4205114 70878 122650 72820 35800 27135.25 11750 57938.3 5000 236948.9