In: Finance
Using this Company's information, please create a
Note: Please create these statements for the year 2018 only
|
2017 |
2018 |
|
|
Accounts Payable |
$81,000 |
$66,000 |
|
Accounts Receivable |
$110,000 |
$128,000 |
|
Accumulated Depreciation, PP&E |
$290,000 |
$356,000 |
|
Cash and Cash Equivalents |
$62,000 |
$54,000 |
|
Common Stock |
$415,000 |
$425,000 |
|
Cost of Goods Sold |
$359,000 |
$368,000 |
|
Depreciation Expense |
$62,000 |
$66,000 |
|
Dividends |
$20,000 |
$25,000 |
|
Income Tax Expense |
$18,000 |
$23,000 |
|
Interest Expense |
$44,000 |
$44,000 |
|
Inventory |
$48,000 |
$55,000 |
|
Long-Term Notes Payable |
$850,000 |
$810,000 |
|
Patents |
$678,000 |
$712,000 |
|
PP&E |
$875,000 |
$925,000 |
|
R&D Expense |
$141,000 |
$135,000 |
|
Retained Earnings |
$137,000 |
$217,000 |
|
Revenues |
$845,000 |
$912,000 |
|
SG&A Expense |
$158,000 |
$171,000 |
| Income Statement | ||
| Particulars | Amount($) | Amount($) |
| Net Sales | 912000 | |
| Less: Cost of goods sold | 368000 | |
| Gross profit | 544000 | |
| Less: Depreciation | 66000 | |
| R&D | 135000 | |
| S,G &A | 171000 | |
| EBIT | 172000 | |
| Less: Interest | 44000 | |
| Earnings before tax | 128000 | |
| Less: Taxes | 23000 | |
| Net Income | 105000 | |
| Less: Dividends paid | 25000 | |
| Additions to retained earnings | 80000 | |
| Balance Sheet | |||||
| LIABILITIES AND EQUITY | Amount($) | Amount($) | ASSETS | Amount($) | Amount($) |
| Current liabilities | Current Assets | ||||
| Accounts payable | 66000 | Cash | 54000 | ||
| Accounts receivable | 128000 | ||||
| Total current liabilities | 66000 | Inventory | 55000 | ||
| Total current assets | 237000 | ||||
| notes payable | 810000 | ||||
| Total liabilities | 876000 | Gross PPE | 925000 | ||
| Common stock | 425000 | Less: Accumulated dep | 356000 | ||
| Retained earnings | 217000 | Net Fixed assets | 569000 | ||
| Total Equity | 642000 | Patents | 712000 | ||
| Total liabilities and equity | 1518000 | Total assets | 1518000 | ||