Worksheet (Spreadsheet) and Statement – The following 2007 information is available for the Stewart Company:
|
Condensed Income Statement for 2007 Don't use plagiarized sources. Get Your Custom Essay on
prepare a worksheet spreadsheet to support a statement of cash flows for the stewart 610536
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT! Just from $10/Page
|
|
|
Sales |
$9,000 |
|
Cost of goods sold |
-6,000 |
|
Other expenses |
-2,000 |
|
Loss on sale of equipment |
-260 |
|
Gain on sale of land |
400 |
|
Net income |
$1,140 |
|
Comparative Balance Sheets |
||
|
December 31, |
December 31, |
|
|
Cash |
$700 |
1,130 |
|
Accounts receivable |
450 |
310 |
|
Inventory |
350 |
400 |
|
Land |
300 |
500 |
|
Equipment |
1,600 |
$1,800 |
|
Less: Accumulated depreciation |
-200 |
-150 |
|
Total Assets |
$3,200 |
$3,990 |
|
Accounts payable |
$600 |
$750 |
|
Bonds payable (due 1/1/2012) |
1,000 |
1,000 |
|
Common stock, $10 par |
900 |
1,400 |
|
Retained earnings |
700 |
840 |
|
Total Liabilities and Stockholders’ Equity |
$3,200 |
$3,990 |
Partial additional information:
1. The equipment that was sold for cash had cost $400 and had a book value of $300.
2. Land that was sold brought a cash price of $530.
3. Fifty shares of stock were issued at par.
Required
Making whatever additional assumptions that are necessary,
1. Prepare a worksheet (spreadsheet) to support a statement of cash flows for the Stewart Company for 2007.
2. Prepare the statement of cash flows.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.