Worksheet (Spreadsheet) and Statement of Cash Flows – The following information is available for the Bott Company:
|
Account Balances Don't use plagiarized sources. Get Your Custom Essay on
prepare the 2007 statement of cash flows for the bott company show the reconciliatio 610549
Get an essay WRITTEN FOR YOU, Plagiarism free, and by an EXPERT! Just from $10/Page
|
||
|
December 31, 2006 |
December 31,2007 |
|
|
Debits |
||
|
Cash |
$1,800 |
$2,000 |
|
Accounts receivable |
4,600 |
4,720 |
|
Notes receivable (short-term) |
0 |
1,000 |
|
Inventories |
12,000 |
9,700 |
|
Prepaid items |
1,700 |
1,380 |
|
Land |
11,000 |
17,100 |
|
Buildings and equipment |
78,000 |
110,000 |
|
Patent |
4,400 |
4,000 |
|
Treasury stock (common, at cost, $25 per share) |
2,500 |
1,000 |
|
Totals |
$116,000 |
$150,900 |
|
Credits |
||
|
Accumulated depreciation |
$24,000 |
$31,800 |
|
Accounts payable |
6,000 |
8,210 |
|
Salaries payable |
2,600 |
3,500 |
|
Miscellaneous current payables |
1,400 |
1,200 |
|
Interest payable |
0 |
140 |
|
12% bonds payable |
0 |
7,000 |
|
Premium on bonds payable |
0 |
650 |
|
Convertible preferred stock, $50 par |
9,000 |
6,500 |
|
Premium on preferred stock |
3,000 |
2,500 |
|
Common stock, $10 par |
18,000 |
23,500 |
|
Premium on common stock |
28,800 |
41,150 |
|
Retained earnings |
23,200 |
24,750 |
|
Totals |
$116,000 |
$150,900 |
Additional information for the year:
|
(a) Beginning retained earnings, unadjusted |
$23,200 |
|
|
Less: Prior period adjustment—correction of understatement of depreciation |
||
|
(net of income taxes) |
-1,300 |
|
|
Adjusted beginning retained earnings |
$21,900 |
|
|
Add: Net income |
11,500 |
|
|
$33,400 |
||
|
Less: Cash dividends |
($4,000) |
|
|
Stock dividends (150 shares at $31 per share) |
-4,650 |
-8,650 |
|
Ending retained earnings |
$24,750 |
(b) Last year depreciation expense was inadvertently understated in the amount of $1,800. The correction was made this year to Accumulated Depreciation and to Retained Earnings as a prior period adjustment. The company also received a related income tax refund of $500.
(c) Sixty shares of treasury stock (common) were reissued at $30 per share.
(d) Bonds payable with a face amount of $7,000 were issued for $7,750 on April 30, 2007. The bonds mature on April 30, 2012, and pay interest semiannually. The straight-line method is used to amortize the bond premium. Interest expense totaled $460 for 2007.
(e) Fifty shares of preferred stock (originally issued at $60 per share) were converted into 100 shares of common stock.
(f) Land costing $2,900 was sold for $3,800.
(g) Three hundred shares of common stock were sold for $33 per share.
(h) Equipment costing $32,000 was purchased during the year.
(i) Land was acquired at a cost of $9,000 during the year.
(j) Depreciation expense was $6,000.
(k) Patent amortization was $400.
(l) The company loaned money to one of its executives and received a $1,000 short-term note receivable on December 31, 2007. The note matures 90 days from the date of issuance.
Required
1. Prepare a worksheet (spreadsheet) to support a statement of cash flows for 2007.
2. Prepare the 2007 statement of cash flows for the Bott Company. Show the reconciliation of the net income to the net cash provided by operating activities in a separate schedule accompanying the statement.
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.
