Prepare and Analyze a Statement of Cash Flows with a Worksheet
Satellite 2010 was founded in 2010 to apply a new technology for efficiently transmitting closed-circuit (cable) television signals without the need for an in-ground cable. The company earned a profit of $115,000 in 2010, its first year of operations, even though it was serving only a small test market. In 2011, the company began dramatically expanding its customer base. Management expects both sales and net income to more than triple in each of the next five years.
Comparative balance sheets at the end of 201.0 and 2011, the company’s first two years of operations, follow. (Notice that the balances at the end of the current year appear in the right-hand column.)
The following information regarding the company’s operations in 2011 is available in either the company’s income statement or its accounting records:
1. Net income for the year was $440,000. The company has never paid a dividend.
2. Depreciation for the year amounted to $147,000.
3. During the year the company purchased plant assets costing $2,200,000, for which it paid $1,850,000 in cash and financed $350,000 by issuing a long-term note payable. (Much of the cash used in these purchases was provided by short-term borrowing, as described below.)
4. In 2011, Satellite 2010 borrowed $1,450,000 against a $6 million line of credit with a local bank. In its balance sheet, the resulting obligations are reported as notes payable (short-term).
5. Additional shares of capital stock (no par value) were issued to investors for $500,000 cash.
SATELLITE 2010 COMPARATIVE BALANCE SHEETS | ||
| December 31, | |
| 2010 | 2011 |
|
| |
Cash and cash equivalents | $ 80,000 | $ 37,000 |
Accounts receivable | 100,000 | 850,000 |
Plant and equipment (net of accumulated depreciation) | 600,000 | 2,653,000 |
Totals | $780,000 | $3,540,000 |
|
| |
Notes payable (short-term) | $ -0- | $1,450,000 |
Accounts payable | 30,000 | 63,000 |
Accrued expenses payable | 45,000 | 32,000 |
Notes payable (long-term) | 390,000 | 740,000 |
Capital stock (no par value) | 200,000 | 700,000 |
Retained earnings | 115,000 | 555,000 |
Totals | $780,000 | $3,540,000 |
a. Prepare a worksheet for a statement of cash flows, following the general format illustrated in Exhibit 13-7. (Note: If this problem is completed as a group assignment, each member of the group should be prepared to explain in class all entries in the worksheet, as well as the group’s conclusions in parts c and d.)
b. Prepare a formal statement of cash flows for 2011, including a supplementary schedule of noncash investing and financing activities. (Follow the format illustrated in Exhibit 13–8. Cash provided by operating activities is to be presented by the indirect method.)
c. Briefly explain how operating activities can be a net use of cash when the company is operating so profitably.
d. Because of the expected rapid growth, management forecasts that operating activities will be an even greater use of cash in the year 2012 than in 2011. If this forecast is correct, does Satellite 2010 appear to be heading toward illiquidity? Explain.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.