The world’s Largest Sharp Brain Virtual Experts Marketplace Just a click Away
Levels Tought:
Elementary,Middle School,High School,College,University,PHD
| Teaching Since: | May 2017 |
| Last Sign in: | 408 Weeks Ago, 3 Days Ago |
| Questions Answered: | 66690 |
| Tutorials Posted: | 66688 |
MCS,PHD
Argosy University/ Phoniex University/
Nov-2005 - Oct-2011
Professor
Phoniex University
Oct-2001 - Nov-2016
On the basis of the following data for Teller Co. for 2006 and the preceding year ended December 31, 2005, prepare a statement of cash flows in excel. Use the indirect method of reporting cash flows from operating activities.
Â
Additional Information
Â
1) Assume that equipment costing $125,000 was purchased for cash and equipment costing $85,000 with accumulated depreciation of $65,000 was sold for $15,000;
2) The stock was issued for cash;
3) The only entries in the retained earnings account were net income of $51,000 and cash dividends declared of $13,000.
Â
Â
Balance Sheets
| Â |
Year |
Year |
|
| Â |
2006 |
2005 |
|
|
Cash |
$100,000 |
$ 78,000 |
|
|
Accounts receivable (net) |
78,000 |
85,000 |
|
|
Inventories |
101,500 |
90,000 |
|
|
Equipment |
410,000 |
370,000 |
|
|
Accumulated depreciation |
(150,000) |
(158,000) |
|
| Â |
$539,500 |
$465,000 |
|
| Â |
======== |
======== |
|
| Â | Â | Â | |
|
Accounts payable (merchandise creditors) |
$ 58,500 |
$ 55,000 |
|
|
Cash dividends payable |
5,000 |
4,000 |
|
|
Common stock, $10 par |
200,000 |
170,000 |
|
|
Paid-in capital in excess of par--common stock |
62,000 |
60,000 |
|
|
Retained earnings |
214,000 |
176,000 |
|
| Â |
$539,500 |
$465,000 |
|
| Â |
======== |
======== |
|
| Â | Â | Â | Â |
Hel-----------lo -----------Sir-----------/Ma-----------dam----------- Â----------- -----------Tha-----------nk -----------You----------- fo-----------r u-----------sin-----------g o-----------ur -----------web-----------sit-----------e a-----------nd -----------acq-----------uis-----------iti-----------on -----------of -----------my -----------pos-----------ted----------- so-----------lut-----------ion-----------. P-----------lea-----------se -----------pin-----------g m-----------e o-----------n c-----------hat----------- I -----------am -----------onl-----------ine----------- or----------- in-----------box----------- me----------- a -----------mes-----------sag-----------e I----------- wi-----------ll