In: Accounting
Presented below is the comparative balance sheet for Wildhorse
Inc., a private company reporting under ASPE, at December 31, 2021,
and 2020:
WILDHORSE INC. Balance Sheet December 31 |
||||||
Assets | 2021 | 2020 | ||||
Cash | $54,900 | $98,000 | ||||
Accounts receivable | 101,000 | 75,000 | ||||
Inventory | 205,000 | 155,500 | ||||
Long-term investment | 101,500 | 0 | ||||
Property, plant, and equipment | 535,000 | 460,000 | ||||
Less: Accumulated depreciation | (162,500 | ) | (140,000 | ) | ||
$834,900 | $648,500 | |||||
Liabilities and Shareholders' Equity | ||||||
Accounts payable | $57,500 | $47,000 | ||||
Dividends payable | 6,000 | 0 | ||||
Income tax payable | 14,000 | 15,000 | ||||
Long-term notes payable | 25,000 | 0 | ||||
Common shares | 630,000 | 525,000 | ||||
Retained earnings | 102,400 | 61,500 | ||||
$834,900 | $648,500 |
WILDHORSE INC. Income Statement Year Ended December 31, 2021 |
||||||
Sales | $650,900 | |||||
Cost of goods sold | 432,000 | |||||
Gross profit | 218,900 | |||||
Operating expenses | $147,500 | |||||
Loss on sale of equipment | 3,000 | 150,500 | ||||
Profit from operations | 68,400 | |||||
Interest expense | 3,000 | |||||
Interest revenue | (4,500 | ) | (1,500 | ) | ||
Profit before income tax | 69,900 | |||||
Income tax expense | 14,000 | |||||
Profit | $55,900 |
Additional information: | ||
1. | Cash dividends of $15,000 were declared. | |
2. | A long-term investment was acquired for cash at a cost of $101,500. | |
3. | Depreciation expense is included in the operating expenses. | |
4. | The company issued 10,500 common shares for cash on March 2, 2021. The fair value of the shares was $10 per share. The proceeds were used to purchase additional equipment. | |
5. | Equipment that originally cost $30,000 was sold during the year for cash. The equipment had a carrying value of $9,000 at the time of sale. | |
6. | The company issued a note payable for $28,000 and repaid $3,000 by year end. | |
7. | All purchases of inventory are on credit. | |
8. | Accounts Payable is used only to record purchases of inventory. |
Prepare a cash flow statement for the year using the direct
method.
WILDHORSE INC. | ||||
Cash Flow Statement using Direct Method | ||||
S.No. | Particulars | Amount $ | Amount $ | |
A | Cash Flow from Operating Activities | |||
Cash Sales | 624900 | |||
Less: Cash purchases | 4,71,000 | |||
Less: Operating expenses (excluding current year depreciation) | 1,25,000 | |||
Cash Profit | 28,900 | |||
Less: Tax | 14,000 | |||
Cash Profit after Tax | 14,900 | |||
B | Cash Flow from Investing Activities | |||
Purchase of Long Term Investments | -1,01,500 | |||
Sale of Equipment | 6,000 | |||
Purchase of Equipment | -2,06,000 | |||
-1,80,500 | ||||
C | Cash Flow from Financing Activities | |||
Dividend paid | -9,000 | |||
Issue of Long-term notes payable | 25,000 | |||
Issue of Common Shares | 1,05,000 | |||
Interest Expenses | -3,000 | |||
Interest Income | 4,500 | |||
1,22,500 | ||||
Net increase in cash & cash equivalent | -43,100 | |||
Opening Cash | 98000 | |||
Closing cash | 54,900 |