Using the information below, conduct the following:

1. Make an income statment

2. Make a balance sheet

Using the information from the spreadsheet, find the following:

a) Return on Investment

b) Gross Margin Percentage

c) Debt-to-Equity

d) Earnings Per Share

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

Common Stock Outstanding = 5000 shares

Beginning Owner's Equity = $627,453