In: Accounting
|
These items are taken from the financial statements of |
|||
|
Beginning Retained Earnings |
$31,000 |
||
|
Utilities |
$2,000 |
||
|
Equipment |
$66,000 |
||
|
Accounts Payable |
$18,300 |
||
|
Cash |
$10,100 |
||
|
Salary & Wages Payable |
$3,000 |
||
|
Common Stock |
$40,000 |
||
|
Dividends |
$8,000 |
||
|
Service Revenue |
$64,000 |
||
|
Pre-Paid Insurance |
$3,500 |
||
|
Patent |
$14,000 |
||
|
Maintenance and Repairs Expense |
$1,800 |
||
|
Long-Term Debt |
$17,000 |
||
|
Depreciation Expense |
$3,600 |
||
|
Accounts Receivable |
$11,700 |
||
|
Insurance Expense |
$2,200 |
||
|
Salary & Wages Expense |
$37,000 |
||
|
Accumulated Depreciation - Equipment |
$17,600 |
||
|
Unearned Revenue |
$3,200 |
||
|
Copyright |
$5,000 |
||
|
Investment in ABC Corporation |
$9,900 |
||
|
Land Held for Investment |
$19,300 |
||
|
REQUIRED: |
|||
|
1) Label the account titles as asset, liability, equity, revenue or expense. |
|||
|
2) Prepare an income statement dated 12/31 of the prior year. |
|||
|
3) Prepare a retained earnings statement. |
|||
|
4) Prepare a Classified Balance Sheet. |
|||
|
5) Calculate the following ratios: |
|||
|
a) Earnings per share (assume there is no preferred stock dividends |
|||
|
and 15,000 average common shares outstanding) |
|||
|
b) Working Capital |
|||
|
c) Current Ratio |
|||
|
d) Debt to Total Assets |
|||
| TRIAL BALANCE | ||||
| 1 | Liabilities | Begining Retained Earnings | $31000 | |
| 2 | Expense | Utilities | $2000 | |
| 3 | Asset | Equipment | $66000 | |
| 4 | Liabilities | Accounts Payable | $18300 | |
| 5 | Asset | Cash | $10100 | |
| 6 | Liabilities | Salary & Wages payable | $3000 | |
| 7 | Equity | Common Stock | $40000 | |
| 8 | Equity | Dividends | $8000 | |
| 9 | Revenue | Service Revenue | $64000 | |
| 10 | Asset | Prepaid Insurance | $3500 | |
| 11 | Asset | Patent | $14000 | |
| 12 | Expense | Maintances & Repairs Expense | $1800 | |
| 13 | Liabilities | Long Term Debt | $17000 | |
| 14 | Expense | Depreciation Expense | $3600 | |
| 15 | Asset | Accounts Receivable | $11700 | |
| 16 | Expense | Insurance Expense | $2200 | |
| 17 | Expense | Salary & Wages Expense | $37000 | |
| 18 | Contra Asset | Accumulated Depreciation- Equipment | $17600 | |
| 19 | Liabilities | Unearned Revenue | $3200 | |
| 20 | Asset | Copyright | $5000 | |
| 21 | Asset | Investment in ABC Corporation | $9900 | |
| 22 | Asset | Land Held for Investment | $19300 | |
| TOTAL | $194100 | $194100 |
| INCOME STATMENT | ||
| Revenue | ||
| Service Revenue | 64000 | |
| Operating Expense | ||
| Maintances & Repairs Expense | 1800 | |
| Depreciation Expense | 3600 | |
| Insurance Expense | 2200 | |
| Salary & Wages Expense | 37000 | |
| Utilities | 2000 | |
| Total Operating Expense | 46600 | |
| Net Income | 17400 |
| RETAINED EARNINGS STATEMENT | ||
| Begining Retained Earnings | 31000 | |
| Add Net Income | 17400 | |
| 48400 | ||
| Less Dividends | 8000 | |
| Ending Retained Earnings | 40400 |
| BALANCE SHEET | ||
| ASSETS | ||
| CURRENT ASSET | ||
| Cash | 10100 | |
| Prepaid Insurance | 3500 | |
| Accounts Receivable | 11700 | 25300 |
| LONG TERM INVESTMENT | ||
| Investment in ABC Corporation | 9900 | |
| Land Held for Investment | 19300 | 29200 |
| PROPERTY & EQUIPMENT | ||
| Equipment | 66000 | |
| Less Accumulated Depreciation | 17600 | 48400 |
| INTANGABLE ASSET | ||
| Patent | 14000 | |
| Copyright | 5000 | 19000 |
| TOTAL ASSETS | 121900 | |
| LIABILITIES | ||
| CURRENT LIABILITIES | ||
| Accounts Payable | 18300 | |
| Salary & Wages payable | 3000 | |
| Unearned Revenue | 3200 | 24500 |
| LONG TERM LIABILITIES | ||
| Long Term Debt | 17000 | 17000 |
| STOCK HOLDER'S EQUITY | ||
| Common Stock | 40000 | |
| Retained Earnings | 40400 | 80400 |
| TOTAL LIABILITIES | 121900 |
| a) Earings Per Share= | Net Income - Preffered Stock Dividends |
| Average common shares outstanding |
| = | 17400-0 |
| 15000 |
= 1.16
b) Working capital = Current Asset - Current Liability
= 25300-24500
= 800
c) Current Ratio= Current Asset/ Current Liability
= 25300/24500
= 1.03
d) Debt to Asset ratio= Total Liabilities/Total Assets
= 24500+17000/121900
= 0.34