The financial statements must be complete and in good form using Excel (or similar spreadsheet). The adjusted?

Answers:0   |   LastUpdateAt:2012-07-28 19:08:59  

Question
harvey
Asked at 2012-07-28 19:08:59
The financial statements must be complete and in good shape to use Excel (spreadsheet or similar).

The adjusted trial balance of Myra Co. at December 31, 2009, is as follows
Myra Company
Adjusted trial balance
December 31, 2009

Account # Title Credit Debit
101 in cash $ 7,500
104 Short-term investments $ 23,500
Sources
126 $ 8,100
128 Prepaid Insurance $ 8,600 167 Equipment $ 40,000
168 Accumulated Depreciation-Equipment
$ 20,000 $ 177,000 173 Building
174 Accumulated Depreciation-Building
$ 59,000 183 Land $ 68,120
201 Accounts payable $ 17,000
203 $ 3,000 Interest payable
208 $ 3,500 Income payable
210 Salaries
pay $ 2,500 Property Taxes 213
pay $ 1,300 233 professional fees of $ 7,900 Unearned

251 long-term notes payable $ 64,500 301 S. Look,
Capital $ 132,600 302 S. Look, $ 10,300 retirement
401 Professional fees $ 104,000 accrued
406 Rental
won $ 18,000 407 $ 2,500 Dividends received
409 Interest $ 2,300
606-Building Depreciation expense $ 12,980
612 Depreciation of equipment costs $ 6,000
623 Salaries expense $ 27,500
633 Interest expense $ 3,800
637 Insurance expense $ 7700
640 Rental expense
$ 11,300 652 Supplies expense
$ 6100 682 postage of $ 2,800
683 property tax expense $ 3,400
684 Repairs
expense $ 6,900 Phone 688
expense $ 3200 690 Utilities $ 3300 expense
Amounts to $ 438,100 $ 438,100

Myra S. invested $ 7,500 cash in the company during the year 2009 (December 31, 2008, balance in favor of Myra S., capital account $ 125,100). Myra Company is required to make a payment of $ 6,000 in their long-term notes payable during 2010.

Total assets (12/31/2009), $ 253,820, net income, $ 31,820

Required
1) Prepare the income statement and statement of owner
Answers

This Question:"The financial statements must be complete and in good form using Excel (or similar spreadsheet). The adjusted?" No answers yet. Be the first!
Related Questions
1
  • Answer This Question:The financial statements must be complete and in good form using Excel (or similar spreadsheet). The adjusted?