Bus120A Excel module

Bus120A Excel module - CHATEAU AMERICANA YEAR-END WORKSHEET...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CHATEAU AMERICANA YEAR-END WORKSHEET 31-Dec-03 12-31-20XX Dec 31, 2003 ACCT ACCOUNT POST CLOSING UNADJUSTED ADJUSTMENTS ADJUSTED INCOME BALA NO. TITLE TRIAL BALANCE TRIAL BALANCE TRIAL BALANCE STATEMENT SHE DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT ASSETS 111000 General checking account 2,138,784.99 2,150,317.00 2,150,317.00 2,150,317.00 112000 Payroll checking account 28,726.39 1,000.00 1,000.00 1,000.00 113000 Money market account 775,549.73 782,546.49 782,546.49 782,546.49 114000 Savings account 48,576.82 51,745.56 51,745.56 51,745.56 119000 Petty cash 500.00 500.00 500.00 500.00 121000 Accounts receivable 4,913,697.13 5,366,569.32 5,366,569.32 5,366,569.32 129000 Allowance for bad debts 97,459.89 95,401.58 10,973.45 106,375.03 141000 Inventory - production 10,407,164.74 11,578,434.36 11,578,434.36 11,578,434.36 145000 Inventory - finished goods 3,902,457.04 4,012,626.83 4,012,626.83 4,012,626.83 150000 Prepaid expenses 84,636.54 142,465.96 142,465.96 142,465.96 160000 Land and buildings 15,350,295.73 16,358,487.34 16,358,487.34 16,358,487.34 170000 Equipment 12,829,549.56 13,875,131.10 13,875,131.10 13,875,131.10 180000 Accumulated depreciation 14,140,830.31 15,342,029.47 15,342,029.47 191000 Investments 2,080,764.31 3,095,227.56 3,095,227.56 3,095,227.56 LIABILITIES 210000 Accounts payable 3,682,954.12 4,987,975.79 4,987,975.79 222100 Federal income tax withheld 64,442.36 67,294.17 67,294.17 222200 FICA withheld 12,107.35 12,681.48 12,681.48 222300 Medicare withheld 2,831.56 2,965.82 2,965.82 223100 FICA payable - employer 12,107.35 12,681.48 12,681.48 223200 Medicare payable - employer 2,831.56 2,965.82 2,965.82 223300 Unemployment taxes payable 846.39 943.57 943.57 230000 Other accrued expenses 568,998.06 599,411.86 599,411.86 235000 Federal income taxes payable 157,448.31 148,925.04 148,925.04 236000 Property taxes payable 0.00 0.00 240000 Mortgages payable 7,442,445.94 7,639,067.73 7,639,067.73 261000 Notes payable 654,000.00 816,500.00 816,500.00 STOCKHOLDERS' EQUITY 310000 Common stock 90,000.00 90,000.00 90,000.00 311000 Paid-in capital in excess of par - common 3,567,265.00 3,567,265.00 3,567,265.00 312000 Dividends - common 0.00 0.00 0.00 390000 Retained earnings 22,064,134.78 22,064,134.78 22,064,134.78 REVENUE 410000 Sales 22,310,170.95 22,310,170.95 22,310,170.95 420000 Sales discounts 347,614.00 347,614.00 347,614.00 430000 Sales returns and allowances 15,651.33 15,651.33 15,651.33 491000 Dividend income 4,000.00 4,000.00 4,000.00 492000 Interest income 24,332.56 24,332.56 24,332.56 COST OF GOODS SOLD 510000 Cost of goods sold 11,545,511.59 11,545,511.59 11,545,511.59 EXPENSES 601000 Wages and salaries expense 1,972,322.74 1,972,322.74 1,972,322.74 601500 Sales commissions expense 771,665.60 771,665.60 771,665.60 602100 FICA tax expense 244,568.36 244,568.36 244,568.36 602200 Medicare tax expense 57,197.43 57,197.43 57,197.43 602300 FUTA expense 7,392.00 7,392.00 7,392.00 602400 SUTA expense 22,176.00 22,176....
View Full Document

This note was uploaded on 05/14/2011 for the course ACC 440 taught by Professor Mr.perks during the Fall '11 term at San Jose State.

Page1 / 32

Bus120A Excel module - CHATEAU AMERICANA YEAR-END WORKSHEET...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online