copy of ca excel .problem.set a.b
DESCRIPTION
Copy of CA Excel .Problem.set a.BTRANSCRIPT
CHATEAU AMERICANAYEAR-END WORKSHEET
12/31/201212-31-2011 12-31-2012
ACCT ACCOUNT POST CLOSING UNADJUSTED ADJUSTMENTS ADJUSTED INCOME BALANCENO. TITLE TRIAL BALANCE TRIAL BALANCE TRIAL BALANCE STATEMENT SHEET
DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDITASSETS
111000 General checking account 2,138,784.99 2,171,441.24 2,171,441.24 2,171,441.24 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,983.73 106,385.31 106,385.31 141000 Inventory - production 10,407,164.74 11,577,948.87 11,577,948.87 11,577,948.87 145000 Inventory - finished goods 3,902,457.04 3,992,237.27 3,992,237.27 3,992,237.27 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,871,631.10 13,871,631.10 13,871,631.10 180000 Accumulated depreciation 14,140,830.31 15,341,679.47 15,341,679.47 15,341,679.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 4,987,975.79 222100 Federal income tax withheld 64,442.36 67,385.78 67,385.78 67,385.78 222200 FICA withheld 12,107.35 12,681.48 12,681.48 12,681.48 222300 Medicare withheld 2,831.56 2,965.82 2,965.82 2,965.82 223100 FICA payable - employer 12,107.35 12,681.48 12,681.48 12,681.48 223200 Medicare payable - employer 2,831.56 2,965.82 2,965.82 2,965.82 223300 Unemployment taxes payable 846.39 943.57 943.57 943.57 230000 Other accrued expenses 568,998.06 599,403.23 599,403.23 599,403.23 235000 Federal income taxes payable 157,448.31 149,097.05 149,097.05 149,097.05 236000 Property taxes payable 0.00 0.00 0.00 239000 Dividends payable 50,000.00 50,000.00 50,000.00 240000 Mortgages payable 7,442,445.94 7,639,067.73 7,639,067.73 7,639,067.73 261000 Notes payable 654,000.00 813,000.00 813,000.00 813,000.00
STOCKHOLDERS' EQUITY310000 Common stock 90,000.00 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 3,567,265.00 312000 Dividends - common 0.00 50,000.00 50,000.00 50,000.00 390000 Retained earnings 22,064,134.78 22,064,134.78 22,064,134.78 22,064,134.78
REVENUE410000 Sales 22,331,154.75 22,331,154.75 22,331,154.75 420000 Sales discounts 348,017.49 348,017.49 348,017.49 430000 Sales returns and allowances 15,684.50 15,684.50 15,684.50 451000 Gain/Loss - Fixed Assets 0.00 491000 Dividend income 4,000.00 4,000.00 4,000.00 492000 Interest income 23,482.56 23,482.56 23,482.56
COST OF GOODS SOLD510000 Cost of goods sold 11,565,901.15 11,565,901.15 11,565,901.15
EXPENSES601000 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.00 22,176.00 611000 Utilities expense 325,954.67 325,954.67 325,954.67 611300 Irrigation & waste disposal expense 230,910.91 230,910.91 230,910.91 612000 Landscaping expense 142,475.69 142,475.69 142,475.69 621000 Advertising expense 295,944.33 295,944.33 295,944.33 623000 Marketing expense 192,865.67 192,865.67 192,865.67 624000 Festivals & competitions expense 238,654.75 238,654.75 238,654.75 631000 Telephone expense 37,584.73 37,584.73 37,584.73 632000 Internet & computer expense 14,475.00 14,475.00 14,475.00 633000 Postage & shipping expense 35,117.66 35,117.66 35,117.66 641000 Legal & accounting fees 88,425.50 88,425.50 88,425.50 643000 Other consulting fees 12,500.00 12,500.00 12,500.00 651000 Office supplies expense 58,689.68 58,689.68 58,689.68 660000 Data processing expense 9,743.89 9,743.89 9,743.89 670000 Depreciation expense 1,200,849.16 1,200,849.16 1,200,849.16 680000 Travel and entertainment expense 169,405.86 169,405.86 169,405.86 691000 Other insurance expense 115,058.55 115,058.55 115,058.55 692000 Medical insurance 192,154.80 192,154.80 192,154.80 693000 Workmen's compensation insurance 139,750.00 139,750.00 139,750.00 699000 Other employee benefits expense 175,643.90 175,643.90 175,643.90 700000 Dues & subscriptions expense 32,076.00 32,076.00 32,076.00 711000 Federal income tax expense 857,595.76 149,097.05 1,006,692.81 1,006,692.81 712000 Property tax expense 19,875.00 19,875.00 19,875.00 721000 Repairs and maintenance 71,974.93 71,974.93 71,974.93 731000 Automobile expense 81,493.45 81,493.45 81,493.45 740000 Lease expense 113,607.56 113,607.56 113,607.56 791000 Bad debt expense 10,983.73 10,983.73 10,983.73 792000 Miscellaneous expense 26,665.63 26,665.63 26,665.63 793000 Interest expense 359,969.78 359,969.78 359,969.78
Sub-totals 20,404,468.91 22,358,637.31 57,461,800.71 55,507,632.31
Chateau AmericanaFor the year ended December 31, 2012
Bottles sold in thousand of units
AL GA NCWhite wines
Sauvignon Blanc 2645 4358 4658Chardonnay 2478 4251 4257Riesling 3014 4875 4658Chenin Blanc 3557 4701 4089Pinot Gris 3783 4117 4558
15477 22302 22220Red wines
Cabernet Sauvignon 5689 5887 4875Merlot 5440 5696 4904Pinto Noir 5899 5024 5612Syrah 5336 5147 5120
22364 21754 20511Sparkling wines
Brut 2214 3254 2564Blanc de blanc 2356 3022 2457
4570 6276 5021Total bottles sold 42411 50332 47752
CommissionsSauvignon Blanc 7935.00 13074.00 13974.00Chardonnay 10531.50 18066.75 18092.25Riesling 6781.50 10968.75 10480.50Chenin Blanc 11560.25 15278.25 13289.25Pinot Gris 13240.50 14409.50 15953.00Cabernet Sauvignon 17920.35 18544.05 15356.25Merlot 20400.00 21360.00 18390.00Pinto Noir 25070.75 21352.00 23851.00Syrah 24012.00 23161.50 23040.00Brut 11070.00 16270.00 12820.00Blanc de blanc 11191.00 14354.50 11670.75Total Commissions 159712.85 186839.30 176917.00
Average commission per bottle sold
Requirement Responses to Formula Auditing Questions#2 G30#4 value used in the4 formula is of the wrong data type and examine the value of the underlined ref
#5 a word is being used to multiply a number
#7 needs a formula#8 total commisions is based on all the values in the colum
#9 the cell was trying to multlply merlot by the number
SC VA
2568 22142355 22772388 24562014 25572211 2080
11536 11584 83119
3254 48793254 45453897 46553999 4050
14404 18129 97162
2654 20142548 22145202 4228 25297
31142 33941 205578
7704.00 6642.0010008.75 9677.25
5373.00 5526.006545.50 8310.257738.50 7280.00
10250.10 15368.8512202.50 17043.7516562.25 19783.7517995.50 18225.0013270.00 10070.0012103.00 10516.50
119753.10 128443.35 771665.60
3.75
value used in the4 formula is of the wrong data type and examine the value of the underlined ref
a word is being used to multiply a number
needs a formula
the cell was trying to multlply merlot by the number
Corporate Income Taxes
Bracket Range Bracket Amount Plus< = 0 0%< = $50,000 50,000 15%> $50,000, < = $75,000 75,000 25% 7,500> $75,000 < = $100,000 100,000 34% 13,750> $100,000, < = $335,000 335,000 39% 22,250> $335,000, < = $10,000,000 10,000,000 34% 113,900
Rates1
1 Of the amount over the previous bracket amount
CASH FLOWS FROM OPERATING ACTIVITIESNet incomeAdjustments from operating activities
Depreciation(Increase) decrease in assets:
Accounts receivableInventoryPrepaid expensesInvestments - trading securities
Increase (decrease) in liabilities:Accounts payableAccrued expensesPayroll Taxes Withheld and PayableFederal Income Tax Payable
Net cash provided by operating activities
CASH FLOWS FROM INVESTING ACTIVITIESPurchase of fixed assets
Net cash used in investing activities
CASH FLOWS FROM FINANCING ACTIVITIESCash proceeds from mortgages payableCash proceeds from notes payable
Net cash provided by financing activities
NET INCREASE IN CASH
CASH - Beginning of year
CASH - End of year
CHATEAU AMERICANAStatement of Cash Flows
For the Year Ending 12-31-12
REVENUESalesLess: Sales Discount Sales Returns and AllowancesNET SALES
COST OF GOODS SOLD
GROSS MARGIN
OPERATING EXPENSES
Chateau AmericanaIncome Statement December 31, 2012
TOTAL OPERATING EXPENSE
INCOME FROM OPERATIONS
OTHER INCOME AND EXPENSES
INCOME (LOSS) BEFORE TAXES
FEDERAL INCOME TAX
NET INCOME (LOSS)
RETAINED EARNINGS - 12/31/2011
RETAINED EARNINGS - 12/31/2012
EARNINGS PER SHARE
Chateau AmericanaIncome Statement December 31, 2012
0.00
2011
ASSETS
CURRENT ASSETSCash & Cash EquivalentsAccounts Receivable 4,913,697.13 Less: Allowance for bad debts (97,459.89)InventoryPrepaid Expenses 84,636.54 Investments - Available for Sale 2,080,764.31 Total Current Assets $6,981,638.09
PROPERTY, PLANT & EQUIPMENTLess: Accumulated Depreciation (14,140,830.31)
($14,140,830.31)
TOTAL ASSETS
LIABILITIES AND STOCKHOLDER'S EQUITY
CURRENT LIABILITIESAccounts Payable $3,682,954.12 Accrued Expenses 568,998.06 Payroll Taxes Withheld and PayableFederal Income Tax PayableDividends Payable 0.00 Total Current Liabilities $4,251,952.18
LONG-TERM LIABILITIESMortgage Payable $7,442,445.94 Note payable 654,000.00 Total Long-Term Liabilities $8,096,445.94
Total Liabilities $12,348,398.12
STOCKHOLDERS' EQUITYCommon Stock $90,000.00 Additional Paid-In Capital in Excess of Par $3,567,265.00 Retained Earnings 22,064,134.78 Total Stockholder's Equity $25,721,399.78
TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $38,069,797.90
CHATEAU AMERICANABalance Sheet
For the Year Ending 12-31-2012
2012
Current Ratio
Inventory Turnover
Asset Turnover
Return on Equity
Debt-Equity Ratio
Times Interest Earned
CHATEAU AMERICANAFinancial Statement Analysis
For the Year Ended 12/31/2012
The Future Value of an Annuity
Interest RatePeriodAnnual DepositInitial DepositDeposit Type
4.5% 5.0% 5.5% 6.0% 6.5%-70000-80000-90000
-100000-110000-120000-130000
7.0%
Chateau AmericanaExpenses In Excess of $200,000For the Year Ending 12/31/2012
DATE EMPLOYEE NAME
EARNINGS
296-49-3438124-11-7755014-39-4215349-43-6417
EMPLOYEEID
PAYTYPE
REGULAR HOURS
PAYRATE
REGULAR PAY
EARNINGS DEDUCTIONS PAYMENT
OVERTIME HOURS
OVERTIME PAY
GROSS PAYG/L 40500
FICA & MEDICAREG/L 20600
FED. INC. TAXG/L 20300
NET PAYG/L 10100
PAYMENT
CK. NO.7111
SUBSPOSTREF
ID EMPLOYEE NAME FIT W/H296-49-3438 Anna C. Johnson S 1750.00 85.71124-11-7755 Jose G. Rodriquez S 2550.00 182.90014-39-4215 Thomas P. Bryan H 15.00 153.88349-43-6417 Robert T. Hissom H 14.25 158.30
PAYTYPE
REGULARPAY RATE
ACCT_TYPE ACCT_CODE ACCT_TITLE DEPT COST_CENTER601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG TAYLOR601 - SALARIES 601000 Wages and Salaries MKTG DANIEL601 - SALARIES 601000 Wages and Salaries MKTG DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries ADMIN DANIEL601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries MKTG CAMERON601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS JACQUES601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM
601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries OPS SAM601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN ROB601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD601 - SALARIES 601000 Wages and Salaries ADMIN EDWARD
602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense ADMIN602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense MKTG602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS
602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS602 - PAYROLL TAXES 602100 FICA Tax Expense OPS
610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 611000 Utilities ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN610 - OCCUPANCY 612000 Landscaping ADMIN620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 621000 Advertising MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG620 - MARKETING 624000 Festivals & Competitions MKTG
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN
630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 631000 Telephone Expense ADMIN630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 632000 Internet and Computer Expense MKTG630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN630 - COMMUNICATIONS 633000 Postage Expense ADMIN
650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN650 - SUPPLIES 651000 Office Supplies ADMIN
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN
670 - DEPRECIATION 671000 Depreciation - Buildings ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN690 - INSURANCE 691000 Insurance ADMIN
710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN710 - TAXES 711000 Federal Income Tax ADMIN
720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN720 - MAINTENANCE 721000 Repairs & Maintenance ADMIN
790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 791000 Bad Debt Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN
790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 792000 Miscellaneous Expense ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN790 - OTHER OPERATING 793000 Interest ADMIN
YR MON BUDGETREV_BUDGET EXPLANATIONS08 Jan 18000 1800008 Feb 18000 1800008 Mar 18000 1800008 Apr 18000 1800008 May 18000 1800008 Jun 18000 1800008 Jul 18000 1800008 Aug 18000 1800008 Sep 18000 1800008 Oct 18000 1800008 Nov 18000 1800008 Dec 18000 1800008 Jan 14000 1400008 Feb 14000 1400008 Mar 14000 1500008 Apr 14000 1500008 May 14000 1500008 Jun 14000 1500008 Jul 14000 1500008 Aug 14000 1500008 Sep 14000 1500008 Oct 14000 1500008 Nov 14000 1500008 Dec 14000 1500008 Jan 14000 1400008 Feb 14000 1400008 Mar 14000 1400008 Apr 14000 1400008 May 14000 1400008 Jun 14000 1500008 Jul 14000 1500008 Aug 14000 1500008 Sep 14000 1500008 Oct 14000 1500008 Nov 14000 1500008 Dec 14000 1500008 Jan 17000 1700008 Feb 17000 1700008 Mar 17000 1700008 Apr 17000 1700008 May 17000 1700008 Jun 17000 1700008 Jul 17000 1700008 Aug 17000 1700008 Sep 17000 1700008 Oct 17000 1700008 Nov 17000 1700008 Dec 17000 1700008 Jan 9000 900008 Feb 9000 900008 Mar 9000 900008 Apr 9000 900008 May 9000 900008 Jun 9000 900008 Jul 9000 900008 Aug 9000 9000
08 Sep 9000 900008 Oct 9000 900008 Nov 9000 900008 Dec 9000 900008 Jan 20000 2000008 Feb 20000 2000008 Mar 20000 2000008 Apr 20000 2000008 May 20000 2000008 Jun 20000 2000008 Jul 20000 2000008 Aug 20000 2000008 Sep 20000 2000008 Oct 20000 2000008 Nov 20000 2000008 Dec 20000 2000008 Jan 25000 2500008 Feb 25000 2500008 Mar 25000 2500008 Apr 25000 2500008 May 25000 2500008 Jun 25000 2500008 Jul 25000 2500008 Aug 25000 2500008 Sep 25000 2500008 Oct 25000 2500008 Nov 25000 2500008 Dec 25000 2500008 Jan 3443 344308 Feb 3443 344308 Mar 3443 344308 Apr 3251 325108 May 1339 133908 Jun 0 008 Jul 0 008 Aug 0 008 Sep 0 008 Oct 0 008 Nov 0 008 Dec 0 008 Jan 3519 351908 Feb 3519 351908 Mar 3519 351908 Apr 3519 351908 May 3519 351908 Jun 2716 271608 Jul 2066 206608 Aug 0 008 Sep 0 008 Oct 0 008 Nov 0 008 Dec 0 008 Jan 1989 198908 Feb 1989 198908 Mar 1989 198908 Apr 1989 198908 May 1989 1989
08 Jun 1645 164508 Jul 689 68908 Aug 689 68908 Sep 689 68908 Oct 689 68908 Nov 574 57408 Dec 0 008 Jan 29980 2998008 Feb 29980 2998008 Mar 29980 2998008 Apr 29980 2998008 May 29980 2998008 Jun 29980 2998008 Jul 29980 2998008 Aug 29980 2998008 Sep 29980 2998008 Oct 29980 2998008 Nov 29980 2998008 Dec 29980 2998008 Jan 13540 1354008 Feb 13540 1354008 Mar 13540 1354008 Apr 13540 1354008 May 13540 1354008 Jun 13540 1354008 Jul 13540 1354008 Aug 13540 1354008 Sep 13540 1354008 Oct 13540 1354008 Nov 13540 1354008 Dec 13540 1354008 Jan 20731 2073108 Feb 20731 2073108 Mar 20731 2073108 Apr 20731 2073108 May 20731 2073108 Jun 20731 2073108 Jul 20731 2073108 Aug 20731 2073108 Sep 20731 2073108 Oct 20731 2073108 Nov 20731 2073108 Dec 20731 2073108 Jan 12750 12750 San Francisco Chronicle Wine Competition08 Feb 15450 15450 Grand Harvest Awards08 Mar 57500 57500 Monterey International Wine Competition; Pacific Rim International Wine Competition08 Apr 18750 18750 Best of Bay Wine Competition and Zin Challenge08 May 75500 75500 San Francisco International Wine Competition; Critics Challenge International Wine Competition08 Jun 15600 15600 California Zinfandel Championship Competition08 Jul 13850 13850 Long Beach Grand Cru Wine Competition08 Aug 0 008 Sep 0 008 Oct 0 008 Nov 0 008 Dec 0 008 Jan 3125 312508 Feb 3125 3125
08 Mar 3125 312508 Apr 3125 312508 May 3125 312508 Jun 3125 312508 Jul 3125 312508 Aug 3125 312508 Sep 3125 312508 Oct 3125 312508 Nov 3125 312508 Dec 3125 312508 Jan 1750 175008 Feb 1750 175008 Mar 1750 175008 Apr 1750 175008 May 1750 175008 Jun 11500 11500 Set up b2b site08 Jul 1750 175008 Aug 1750 175008 Sep 1750 175008 Oct 1750 175008 Nov 1750 175008 Dec 1750 175008 Jan 650 65008 Feb 650 65008 Mar 650 65008 Apr 650 65008 May 650 65008 Jun 650 65008 Jul 650 65008 Aug 650 65008 Sep 650 65008 Oct 650 65008 Nov 650 65008 Dec 650 65008 Jan 1800 180008 Feb 1800 180008 Mar 1800 180008 Apr 1800 180008 May 1800 180008 Jun 1800 180008 Jul 1800 180008 Aug 1800 180008 Sep 1800 180008 Oct 1800 180008 Nov 1800 180008 Dec 1800 180008 Jan 48350 4835008 Feb 48350 4835008 Mar 48350 4835008 Apr 48350 4835008 May 48350 4835008 Jun 48350 4835008 Jul 48350 4835008 Aug 48350 4835008 Sep 48350 4835008 Oct 48350 4835008 Nov 48350 48350
08 Dec 48350 4835008 Jan 38460 3846008 Feb 38460 3846008 Mar 38460 3846008 Apr 38460 3846008 May 38460 3846008 Jun 38460 3846008 Jul 38460 3846008 Aug 38460 3846008 Sep 38460 3846008 Oct 38460 3846008 Nov 38460 3846008 Dec 38460 3846008 Jan 23120 2312008 Feb 23120 2312008 Mar 23120 2312008 Apr 23120 2312008 May 23120 2312008 Jun 23120 2312008 Jul 23120 2312008 Aug 23120 2312008 Sep 23120 2312008 Oct 23120 2312008 Nov 23120 2312008 Dec 23120 2312008 Jan 4995 499508 Feb 4995 499508 Mar 4995 499508 Apr 4995 499508 May 4995 499508 Jun 4995 499508 Jul 4995 499508 Aug 4995 499508 Sep 4995 499508 Oct 4995 499508 Nov 4995 499508 Dec 4995 499508 Jan 920 92008 Feb 920 92008 Mar 920 92008 Apr 920 92008 May 920 92008 Jun 920 92008 Jul 920 92008 Aug 920 92008 Sep 920 92008 Oct 920 92008 Nov 920 92008 Dec 920 92008 Jan 3050 305008 Feb 3050 305008 Mar 3050 305008 Apr 3050 305008 May 3050 305008 Jun 3050 305008 Jul 3050 305008 Aug 3050 3050
08 Sep 3050 305008 Oct 3050 305008 Nov 3050 305008 Dec 3050 305008 Jan 30000 3000008 Feb 30000 3000008 Mar 30000 3000008 Apr 30000 3000008 May 30000 3000008 Jun 30000 3000008 Jul 30000 3000008 Aug 30000 3000008 Sep 30000 3000008 Oct 30000 3000008 Nov 30000 3000008 Dec 30000 30000
San Francisco International Wine Competition; Critics Challenge International Wine Competition
CHATEAU AMERICANAYEAR-END WORKSHEET
12/31/201212-31-2011
ACCT ACCOUNT POST CLOSINGNO. TITLE TRIAL BALANCE
DEBIT CREDITASSETS
111000 General checking account 2,138,784.99 112000 Payroll checking account 28,726.39 113000 Money market account 775,549.73 114000 Savings account 48,576.82 119000 Petty cash 500.00 121000 Accounts receivable 4,913,697.13 129000 Allowance for bad debts 97,459.89 141000 Inventory - production 10,407,164.74 145000 Inventory - finished goods 3,902,457.04 150000 Prepaid expenses 84,636.54 160000 Land and buildings 15,350,295.73 170000 Equipment 12,829,549.56 180000 Accumulated depreciation 14,140,830.31 191000 Investments 2,080,764.31
LIABILITIES
210000 Accounts payable 3,682,954.12 222100 Federal income tax withheld 64,442.36 222200 FICA withheld 12,107.35 222300 Medicare withheld 2,831.56 223100 FICA payable - employer 12,107.35 223200 Medicare payable - employer 2,831.56 223300 Unemployment taxes payable 846.39 230000 Other accrued expenses 568,998.06 235000 Federal income taxes payable 157,448.31 236000 Property taxes payable 0.00 239000 Dividends payable240000 Mortgages payable 7,442,445.94 261000 Notes payable 654,000.00
STOCKHOLDERS' EQUITY310000 Common stock 90,000.00 311000 Paid-in capital in excess of par - common 3,567,265.00 312000 Dividends - common 0.00 390000 Retained earnings 22,064,134.78
REVENUE410000 Sales420000 Sales discounts430000 Sales returns and allowances491000 Dividend income492000 Interest income
COST OF GOODS SOLD510000 Cost of goods sold
EXPENSES601000 Wages and salaries expense601500 Sales commissions expense602100 FICA tax expense602200 Medicare tax expense602300 FUTA expense602400 SUTA expense611000 Utilities expense611300 Irrigation & waste disposal expense612000 Landscaping expense621000 Advertising expense623000 Marketing expense624000 Festivals & competitions expense631000 Telephone expense632000 Internet & computer expense633000 Postage & shipping expense641000 Legal & accounting fees643000 Other consulting fees651000 Office supplies expense660000 Data processing expense670000 Depreciation expense680000 Travel and entertainment expense691000 Other insurance expense692000 Medical insurance693000 Workmen's compensation insurance699000 Other employee benefits expense700000 Dues & subscriptions expense711000 Federal income tax expense712000 Property tax expense721000 Repairs and maintenance731000 Automobile expense740000 Lease expense791000 Bad debt expense792000 Miscellaneous expense793000 Interest expense
Sub-totals Net Income (Loss) TOTALS 52,560,702.98 52,560,702.98
12-31-2012UNADJUSTED ADJUSTMENTS ADJUSTED
TRIAL BALANCE TRIAL BALANCEDEBIT CREDIT DEBIT CREDIT DEBIT
ADJUSTED INCOME BALANCETRIAL BALANCE STATEMENT SHEET
CREDIT DEBIT CREDIT DEBIT CREDIT
0.00 0.00 0.00 0.00
0.00 0.00 0.00
NET SALES
TOTAL OPERATING EXPENSE
0.00
2011
ASSETS
CURRENT ASSETSCash & Cash EquivalentsAccounts Receivable 4,913,697.13 Less: Allowance for bad debts (97,459.89)InventoryPrepaid Expenses 84,636.54 Investments - Available for Sale 2,080,764.31 Total Current Assets $6,981,638.09
PROPERTY, PLANT & EQUIPMENTLess: Accumulated Depreciation (14,140,830.31)
($14,140,830.31)
TOTAL ASSETS
LIABILITIES AND STOCKHOLDER'S EQUITY
CURRENT LIABILITIESAccounts Payable $3,682,954.12 Accrued ExpensesPayroll Taxes Withheld and Payable 95,166.57 Federal Income Tax Payable 157,448.31 Total Current Liabilities $3,935,569.00
LONG-TERM LIABILITIESMortgage Payable $7,442,445.94 Note payable 654,000.00 Total Long-Term Liabilities $8,096,445.94
Total Liabilities $12,032,014.94
STOCKHOLDERS' EQUITYCommon Stock $90,000.00 Additional Paid-In Capital in Excess of Par $3,567,265.00 Retained Earnings 22,064,134.78 Total Stockholder's Equity $25,721,399.78
TOTAL LIABILITIES AND STOCKHOLDER'S EQUITY $37,753,414.72
CHATEAU AMERICANABalance Sheet
For the Year Ending 12-31-12
2012
CASH FLOWS FROM OPERATING ACTIVITIESNet incomeAdjustments from operating activities
Depreciation(Increase) decrease in assets:
Accounts receivableInventoryPrepaid expensesInvestments - trading securities
Increase (decrease) in liabilities:Accounts payableAccrued expensesPayroll Taxes Withheld and PayableFederal Income Tax Payable
Net cash provided by operating activities
CASH FLOWS FROM INVESTING ACTIVITIESPurchase of fixed assets
Net cash used in investing activities
CASH FLOWS FROM FINANCING ACTIVITIESCash dividend paidCash proceeds from mortgages payableCash proceeds from notes payable
Net cash provided by financing activities
NET INCREASE IN CASH
CASH - Beginning of year
CASH - End of year
CHATEAU AMERICANAStatement of Cash Flows
For the Year Ending 12-31-12
Current Ratio
Inventory Turnover
Asset Turnover
Return on Equity
Debt-Equity Ratio
Times Interest Earned
CHATEAU AMERICANAFinancial Statement Analysis
For the Year Ended 12/31/2012