In: Accounting
The comparative balance sheets for Pronghorn Corporation show
the following information.
December 31 |
||||
2020 |
2019 |
|||
Cash |
$33,400 |
$12,900 |
||
Accounts receivable |
12,200 |
10,000 |
||
Inventory |
11,800 |
9,100 |
||
Available-for-sale debt investments |
–0– |
2,900 |
||
Buildings |
–0– |
29,800 |
||
Equipment |
45,200 |
20,200 |
||
Patents |
5,000 |
6,300 |
||
$107,600 |
$91,200 |
|||
Allowance for doubtful accounts |
$3,000 |
$4,600 |
||
Accumulated depreciation—equipment |
2,000 |
4,500 |
||
Accumulated depreciation—building |
–0– |
5,900 |
||
Accounts payable |
5,000 |
2,900 |
||
Dividends payable |
–0– |
4,900 |
||
Notes payable, short-term (nontrade) |
3,000 |
4,000 |
||
Long-term notes payable |
31,000 |
25,000 |
||
Common stock |
43,000 |
33,000 |
||
Retained earnings |
20,600 |
6,400 |
||
$107,600 |
$91,200 |
Additional data related to 2020 are as follows.
1. | Equipment that had cost $11,000 and was 40% depreciated at time of disposal was sold for $2,500. | |
2. | $10,000 of the long-term note payable was paid by issuing common stock. | |
3. | Cash dividends paid were $4,900. | |
4. | On January 1, 2020, the building was completely destroyed by a flood. Insurance proceeds on the building were $30,000 (net of $2,100 taxes). | |
5. | Debt investments (available-for-sale) were sold at $1,700 above their cost. The company has made similar sales and investments in the past. | |
6. | Cash was paid for the acquisition of equipment. | |
7. | A long-term note for $16,000 was issued for the acquisition of equipment. | |
8. | Interest of $2,000 and income taxes of $6,400 were paid in cash. |
Prepare a statement of cash flows using the indirect method.
(Show amounts that decrease cash flow with either a -
sign e.g. -15,000 or in parenthesis e.g.
(15,000).)
Statement of Cashflow | ||||
Net Income | $ 14,200.00 | |||
Add | ||||
Depreciation** | $ 1,900.00 | |||
Loss on sale of Equipment* | $ 4,100.00 | |||
Amortisation of Patent (6300-5000) | $ 1,300.00 | |||
Less Gain on Insurance proceed*** | $ -8,200.00 | |||
Less Gain on sale of available for sale | Given | $ -1,700.00 | ||
Adjustment to reconcile Net income to net cash provided by operating Activities | $ 11,600.00 | |||
Increase in Account Receivable | $ -3,800.00 | |||
Increase in Inventory | $ -2,700.00 | |||
Increase in Account Payable | $ 2,100.00 | |||
Decrease in Note payable-Short Term | $ -1,000.00 | $ -5,400.00 | ||
Net Cash flow from operating Activities | $ 6,200.00 | A | ||
Cashflows from Investing Activities | ||||
Collection from sale of Equipment* | $ 2,500.00 | |||
Collection from Insurance Proceed*** | $ 32,100.00 | |||
Collection from sale of Available for sale (2900+1700) | $ 4,600.00 | |||
Payment toward purchase of Equipment** | $ -36,000.00 | $ 3,200.00 | ||
Net Cashflows from Investing Activities | $ 3,200.00 | B | ||
Cashflows from Financing Activities | ||||
Payment of Long Term Note given | $ -10,000.00 | |||
Issuance of common Stock (Given) | $ 10,000.00 | |||
Payment of Dividend (Given) | $ -4,900.00 | |||
Receipt from issuance of Long term Note (Given) | $ 16,000.00 | $ 11,100.00 | ||
Net Cashflows from Financing Activities | $ 11,100.00 | C | ||
Net Increase/(Decrease) in Cash | $ 20,500.00 | A+B+C | ||
Beginning Cash in Hand | $ 12,900.00 | |||
Ending Cash in Hand | $ 33,400.00 | $ 20,500.00 | ||
Net Increase/(Decrease) in Cash | ||||
Sale of Equipment* | |
Equipment Value | $ 11,000.00 |
Accu Depn | $ 4,400.00 |
Net Book Value | $ 6,600.00 |
Less proceed | $ -2,500.00 |
Loss of sale of Equip. | $ 4,100.00 |
Calculation of Equipment** | |||||
Beg Bal | Sold during year | After sales | Ending Bal | Current Month Addition | |
Equipment Value | $ 20,200.00 | -$11,000.00 | $9,200.00 | $45,200.00 | $ 36,000.00 |
Accu Depn | -$4,500.00 | -$4,400.00 | -$100.00 | -$2,000.00 | -$1,900.00 |
Calculation of Building*** | |
Building | $ 29,800.00 |
Acc. Depn | $ -5,900.00 |
Net Book Value | $ 23,900.00 |
Collection | $ 32,100.00 |
Gain on sales | $ 8,200.00 |