accounting cash flow case

profiletin.02
trial_balancenes_renewed_life_center_2013.xls
Home>Business & Finance homework help>Accounting homework help>accounting cash flow case

2011

TRIAL BALANCE
6/30/11
Adjustments
Trial balance Dr Cr Adjusted
1020 Wells Fargo Checking 116,545.71 116,545.71
1550 Building 530,000.00 530,000.00
1570 Software system 20,675.00 20,675.00
1580 Equipment 64,260.54 64,260.54
1590 Leasehold improvements 14,313.25 14,313.25
1700 Employers Insurance Inc stock at cost 28,612.80 28,612.80
1800 Deposits - other 570.52 570.52
1802 Rent deposit 2,662.85 2,662.85
2000 Accounts payable (28,464.69) (28,464.69)
2100 Accrued payroll (8,376.84) (8,376.84)
2103 Federal payroll taxes payable (1,960.41) (1,960.41)
2104 NV Unemployment (1,800.76) (1,800.76)
2410 Building mortgage - second (50,000.00) (50,000.00)
2400 Building mortgage - primary (480,000.00) (480,000.00)
3000 Common stock $1 par (50,000.00) (50,000.00)
3001 Additional paid in capital (90,000.00) (90,000.00)
3010 Retained earnings (196,351.12) (196,351.12)
- 0
4100 Dividends earned (1,076.78) (1,076.78)
4200 Fees for treatment- other (720,127.63) (720,127.63)
4201 Methadone fees - Medicaid (56,970.76) (56,970.76)
4202 Methadone fees - Medicare (58,474.57) (58,474.57)
4203 Evaluation fees (183.00) (183.00)
4204 Methadone fees - private pay (446.00) (446.00)
4205 Fee refunds 1,452.00 1,452.00
5100 Medical supplies 40,037.66 40,037.66
5101 Other inventory items 4,370.00 4,370.00
5102 Patient treats 747.95 747.95
5103 Methadone liquid 37,404.00 37,404.00
5104 Methadone tablet 12,254.40 12,254.40
5106 Laboratory fees 29,650.82 29,650.82
5107 Physicians fees 23,882.38 23,882.38
5108 Contract labor 1,600.00 1,600.00
6100 Salaries and wages 442,719.67 442,719.67
6101 Holiday pay 36,849.50 36,849.50
6102 Social security company 29,941.63 29,941.63
6103 Medicare company 7,002.49 7,002.49
6104 Fed and state unemployment 4,559.67 4,559.67
6105 Payroll expenses - other 7,264.09 7,264.09
7100 Utilities 8,255.58 8,255.58
7101 Rent - premises 28,450.00 28,450.00
7102 Security 1,751.50 1,751.50
7103 Cleaning 3,900.00 3,900.00
7105 Reference materials 789.11 789.11
7106 Office supplies 9,876.44 9,876.44
7108 Computer network maintenance 893.76 893.76
7109 Computer tech support 3,375.00 3,375.00
7110 Software costs 806.95 806.95
7111 Equipment rental 2,166.60 2,166.60
7112 Property taxes 4,185.00 4,185.00
7113 Liability insurance 13,491.92 13,491.92
7114 Advertising 1,829.42 1,829.42
7115 Licenses and permits 10,029.13 10,029.13
7116 Dues and subscriptions 412.91 412.91
7117 Postage and delivery 561.39 561.39
7119 Professional fees - other 8,803.43 8,803.43
7120 Legal fees 5,181.63 5,181.63
7121 Telephone 2,507.77 2,507.77
7122 Professional development 2,601.68 2,601.68
7123 Travel 2,964.49 2,964.49
7124 Meals 3,153.08 3,153.08
7125 Gifts - employees 2,324.76 2,324.76
7128 Loss on disposal of investments 16,825.00 16,825.00
7130 Construction costs new building 93,931.89 93,931.89
7131 Mortgage payments - second 10,000.00 10,000.00
7132 Mortgage payments - primary 42,000.00 42,000.00
7134 Donations 400.00 400.00
7135 Bank charges 1,138.60 1,138.60
7136 Cash (over) short (17.08) (17.08)
7137 Income taxes paid 4,265.67 4,265.67
TOTAL 0.00 - 0 - 0 0.00

2010

6/30/10
Post closing Adjustments
Trial balance dr cr Adjusted
1020 Wells Fargo Checking 67,326.25 67,326.25
1025 Wells Fargo - Money market/investment 25,914.28 25,914.28
1570 Software system 20,675.00 20,675.00
1580 Equipment 38,535.01 38,535.01
1590 Leasehold improvements 14,153.07 14,153.07
1700 Employers Insurance Inc stock at cost 145,437.95 145,437.95
1802 Rent deposit 2,662.85 2,662.85
2000 Accounts payable (16,768.42) (16,768.42)
2100 Accrued payroll (4,872.30) (4,872.30)
2103 Federal payroll taxes payable (223.43) (223.43)
2104 NV Unemployment (489.14) (489.14)
3000 Common stock $1 par (40,000.00) (40,000.00)
3001 Additional paid in capital (56,000.00) (56,000.00)
3010 Retained earnings (196,351.12) (196,351.12)
- 0
- 0 - 0 - 0 0.00

Fixed assets

Per books Depreciation ACC Depn 2010 Acc depn 2011
Equipment Cost 2007 2008 2009 2010 2011
2007 22,000.01 2,200.00 4,400.00 4,400.00 4,400.00 15,400.01 15,400.01
2008 3,500.00 350.00 700.00 700.00 1,750.00 1,750.00
2009 4,000.00 400.00 800.00 1,200.00 1,200.00
2010 9,035.00 903.50 903.50 903.50
2011 25,725.53 - 0 - 0
64,260.54 2,200.00 4,750.00 5,500.00 6,803.50 19,253.51 - 0 19,253.51
Software system
2008 20,675.00 2,067.50 4,135.00 4,135.00 10,337.50 10,337.50
Total accumulated depreciation 84,935.54 2,200.00 6,817.50 9,635.00 10,938.50 29,591.01
Leasehold improvements Acc Amort
?? 14,153.07 11,322.46 11,322.46
Buildings
Total 99,088.61 2,200.00 6,817.50 9,635.00 10,938.50 40,913.46