Epics Corporation
Assets Liabilities Cash $ 70,000 Accounts Payable $ 100,000 Accounts Receivable 150,000 Notes Payable 120,000 Inventory 280,000 Bonds Payable 300,000 Total Current Assets $ 500,000 Total Liabilities $ 520,000 Plant and Equipment $1,250,000 Equity Less: Accum. Deprec. 250,000 Common Stock 300,000 Net plant and Equipment $1,000,000 Paid In Capital 200,000 Retained Earnings 480,000 Total Assets $1,500,000 Total Equity $ 980,000 Total Liab. & Equity $1,500,000
Sales for 2003 were $2,000,000, with the cost of goods sold being 55% of sales. Depreciation expense was 10% of the gross plant and equipment at the beginning of the year. Interest expense was 9% on the notes payable and 11% on the bonds payable. Selling and administrative expenses were $200,000 and the firm's tax rate is 40%.
Prepare an income statement.
Sample Solution
Income Statement for 2003
Revenue
Sales $2,000,000
Cost of Goods Sold
Cost of Goods Sold (55% of Sales) $1,100,000
Gross Profit
Gross Profit $900,000
Operating Expenses
Depreciation Expense (10% of $1,500,000 Gross Plant and Equipment) $150,000 Interest Expense (9% on $120,000 Notes Payable) $10,800 Interest Expense (11% on $300,000 Bonds Payable) $33,000 Selling and Administrative Expenses $200,000
Total Operating Expenses $393,800
Income from Operations
Income from Operations $506,200
Income Tax Expense
Income Tax Expense (40% of $506,200) $202,480
Net Income
Net Income $303,720
Earnings per Share (Not possible to calculate without knowing number of shares outstanding)
Notes:
- Cost of Goods Sold is calculated as a percentage of Sales.
- Depreciation Expense is estimated based on 10% of the total gross plant and equipment (without considering accumulated depreciation).
- Interest Expense is calculated for both Notes Payable and Bonds Payable based on their respective interest rates and outstanding balances.