EXCEL FANATICAL ratio analysis, EXEC coolsprings template

profilemaiezymq12
coolspring_template_-_weeks_2-44.xlsx
Home>Business & Finance homework help>Accounting homework help>EXCEL FANATICAL ratio analysis, EXEC coolsprings template

Coolspring week 2 entries

Coolspring Furniture 101 - Cash
General Journal 103 - Payroll Cash
Week 2 Journal Entries 105 - Petty Cash
Customer/Vendor Info 122 - Accounts Receivable
Date Trans # Description Debit Credit 131 - Merchandise Inventory
20xx 141 - Office Supplies
1-Sep 1 251 - Mortgage Payable correct 1,275.26 correct 142 - Store Supplies
551 - Interest Expense correct 1,724.74 correct 145 - Prepaid Insurance
101 - Cash correct 3,000.00 correct 161 - Land
171 - Building
2-Sep 2 533 - Utilities Expense correct 552.11 correct 171.1 - Accum. Depr. - Building
101 - Cash correct 552.11 correct 181 - Sore Equipment
181.1 - Accum. Depr. - Store Equipment
2-Sep 3 525 - Telephone Expense correct 175.10 correct 182 - Office Equipment
101 - Cash correct 175.10 correct 182.1 - Accum. Depr. - Office Equipment
202 - Accounts Payable
3-Sep 4 101 - Cash correct 2,928.75 correct 211 - Employees Federal Income Tax Payable
122 - Accounts Receivable correct 2,928.75 correct 212 - Social Security Tax Payable
213 - Medicare Tax Payable
3-Sep 5 101 - Cash correct 22,925.86 correct 214 - Employees State Income Tax Payable
513 - Bank Credit Card Expense correct 370.00 correct 215 - Employees City Income Tax Payable
401 - Sales correct 21,977.22 correct 218 - Sales Salaries Payable
231 - Sales Tax Payable correct 1,318.64 correct 219 - Office Salaries Payable
221 - FUTA Tax Payable
5-Sep 6 202 - Accounts Payable correct 4,800.00 correct 222 - SUTA Tax Payable
501.2 - Purchase Discounts correct 96.00 correct 231 - Sales Tax Payable
101 - Cash correct 4,704.00 correct 241 - Unearned Rent Revenue
251 - Mortgage Payable
5-Sep 7 501 - Purchases correct 5,364.00 correct 311 - Oliver Hayden, Capital
202 - Accounts Payable correct 5,364.00 correct 312 - Oliver Hayden, Drawing
313 - Income Summary
401 - Sales
401.1 - Sales Returns & Allowances
412 - Rent Revenue
501 - Purchases
501.1 - Purchases Returns & Allowances
501.2 - Purchase Discounts
502 - Freight-In
511 - Sales Salaries Expense
512 - Advertising Expense
513 - Bank Credit Card Expense
514 - Store Supplies Expense
515 - Travel & Entertainment Expense
516 - Cash Short and Over
519 - Depreciation Exp. - Store Equipment
522 - Office Salaries Expense
523 - Office Supplies Expense
525 - Telephone Expense
530 - Payroll Taxes Expense
533 - Utilities Expense
534 - Charitable Contributions Expense
535 - Insurance Expense
540 - Depreciation Exp. - Building
541 - Depreciation Exp. - Office Equipment
549 - Miscellaneous Expense
551 - Interest Expense

Coolspring week 3 entries

Coolspring Furniture 101 - Cash
General Journal 103 - Payroll Cash
Week 3 Journal Entries 105 - Petty Cash
Customer/Vendor Info 122 - Accounts Receivable
Date Trans # Description Debit Credit 131 - Merchandise Inventory
20xx 141 - Office Supplies
6-Sep 8 101 - Cash correct 6,290.00 correct 142 - Store Supplies
122 - Accounts Receivable correct 6,290.00 correct 145 - Prepaid Insurance
161 - Land
6-Sep 9 101 - Cash correct 653.49 correct 171 - Building
122 - Accounts Receivable correct 653.49 correct 171.1 - Accum. Depr. - Building
181 - Sore Equipment
6-Sep 11 202 - Accounts Payable correct 1,457.40 correct 181.1 - Accum. Depr. - Store Equipment
501.2 - Purchase Discounts correct 43.72 correct 182 - Office Equipment
101 - Cash correct 1,413.68 correct 182.1 - Accum. Depr. - Office Equipment
202 - Accounts Payable
7-Sep 12 122 - Accounts Receivable correct 874.50 correct 211 - Employees Federal Income Tax Payable
401 - Sales correct 825.00 correct 212 - Social Security Tax Payable
231 - Sales Tax Payable correct 49.50 correct 213 - Medicare Tax Payable
214 - Employees State Income Tax Payable
7-Sep 13 202 - Accounts Payable correct 6,900.00 correct 215 - Employees City Income Tax Payable
501.2 - Purchase Discounts correct 207.00 correct 218 - Sales Salaries Payable
101 - Cash correct 6,693.00 correct 219 - Office Salaries Payable
221 - FUTA Tax Payable
7-Sep 14 202 - Accounts Payable correct 5,900.00 correct 222 - SUTA Tax Payable
501.2 - Purchase Discounts correct 118.00 correct 231 - Sales Tax Payable
101 - Cash correct 5,782.00 correct 241 - Unearned Rent Revenue
251 - Mortgage Payable
7-Sep 15 202 - Accounts Payable correct 1,630.00 correct 311 - Oliver Hayden, Capital
501.2 - Purchase Discounts correct 65.20 correct 312 - Oliver Hayden, Drawing
101 - Cash correct 1,564.80 correct 313 - Income Summary
401 - Sales
7-Sep 16 202 - Accounts Payable correct 5,565.00 correct 401.1 - Sales Returns & Allowances
501.2 - Purchase Discounts correct 111.30 correct 412 - Rent Revenue
101 - Cash correct 5,453.70 correct 501 - Purchases
501.1 - Purchase Returns & Allowances
8-Sep 19 502 - Freight-In correct 250.00 correct 501.2 - Purchase Discounts
101 - Cash correct 250.00 correct 502 - Freight-In
511 - Sales Salaries Expense
9-Sep 20 501 - Purchases correct 1,260.00 correct 512 - Advertising Expense
502 - Freight-In correct 75.00 correct 513 - Bank Credit Card Expense
202 - Accounts Payable correct 1,335.00 correct 514 - Store Supplies Expense
515 - Travel & Entertainment Expense
10-Sep 21 101 - Cash correct $20,530.67 correct 516 - Cash Short and Over
516 - Cash Short and Over correct 2.00 correct 519 - Depreciation Exp. - Store Equipment
513 - Bank Credit Card Expense correct 540.95 correct 522 - Office Salaries Expense
401 - Sales correct 19,880.77 correct 523 - Office Supplies Expense
231 - Sales Tax Payable correct 1,192.85 correct 525 - Telephone Expense
530 - Payroll Taxes Expense
10-Sep 22 122 - Accounts Receivable correct 2,681.80 correct 533 - Utilities Expense
401 - Sales correct 2,530.00 correct 534 - Charitable Contributions Expense
231 - Sales Tax Payable correct 151.80 correct 535 - Insurance Expense
540 - Depreciation Exp. - Building
12-Sep 23 101 - Cash correct 2,000.00 correct 541 - Depreciation Exp. - Office Equipment
122 - Accounts Receivable correct 2,000.00 correct 549 - Miscellaneous Expense
551 - Interest Expense
14-Sep 25 202 - Accounts Payable correct 1,465.80 correct
501.2 - Purchase Discounts correct 58.63 correct
101 - Cash correct 1,407.17 correct
14-Sep 26 202 - Accounts Payable correct 1,875.00 correct
501.2 - Purchase Discounts correct 56.25 correct
101 - Cash correct 1,818.75 correct
15-Sep 29 202 - Accounts Payable correct 13,368.00 correct
501.2 - Purchase Discounts correct 267.36 correct
101 - Cash correct 13,100.64 correct
15-Sep 27 501 - Purchases correct 1,200.00 correct
202 - Accounts Payable correct 1,200.00 correct
15-Sep 28 122 - Accounts Receivable correct 1,272.00 correct
401 - Sales correct 1,200.00 correct
231 - Sales Tax Payable correct 72.00 correct
15-Sep 30 103 - Payroll Cash correct 6,709.73 correct
101 - Cash correct 6,709.73 correct
15-Sep 30 522 - Office Salaries Expense correct 2,384.00 correct
511 - Sales Salaries Expense correct 5,850.00 correct
211 - Employees Federal Income Tax Payable correct 565.00 correct
212 - Social Security Tax Payable correct 510.51 correct
213 - Medicare Tax Payable correct 119.40 correct
214 - Employees State Income Tax Payable correct 247.02 correct
215 - Employees City Income Tax Payable correct 82.34 correct
103 - Payroll Cash correct 6,709.73 correct
15-Sep 30 530 - Payroll Taxes Expense correct 755.39 correct
212 - Social Security Tax Payable correct 510.51 correct
213 - Medicare Tax Payable correct 119.39 correct
221 - FUTA Tax Payable correct 16.19 correct
222 - SUTA Tax Payable correct 109.30 correct
15-Sep 31 211 - Employees Federal Income Tax Payable correct 2,475.00 correct
212 - Social Security Tax Payable correct 1,728.74 correct
213 - Medicare Tax Payable correct 423.92 correct
101 - Cash correct 4,627.66 correct
16-Sep 32 512 - Advertising Expense correct 1,450.00 correct
101 - Cash correct 1,450.00 correct
16-Sep 33 101 - Cash correct 1,983.75 correct
122 - Accounts Receivable correct 1,983.75 correct
17-Sep 35 101 - Cash correct 32,511.52 correct
513 - Bank Credit Card Expense correct 972.17 correct
401 - Sales correct 31,588.38 correct
231 - Sales Tax Payable correct 1,895.31 correct
17-Sep 36 501 - Purchases correct 6,790.00 correct
502 - Freight-In correct 300.00 correct
202 - Accounts Payable correct 7,090.00 correct
19-Sep 37 122 - Accounts Receivable correct 996.40 correct
401 - Sales correct 940.00 correct
231 - Sales Tax Payable correct 56.40 correct
20-Sep 38 122 - Accounts Receivable correct 3,810.70 correct
401 - Sales correct 3,595.00 correct
231 - Sales Tax Payable correct 215.70 correct
23-Sep 41 501 - Purchases correct 6,290.00 correct
502 - Freight-In correct 210.00 correct
202 - Accounts Payable correct 6,500.00 correct
23-Sep 42 202 - Accounts Payable correct 3,400.00 correct
501.1 - Purchase Returns & Allowances correct 3,295.00 correct
502 - Freight-In correct 105.00 correct
24-Sep 43 202 - Accounts Payable correct 1,200.00 correct
501.2 - Purchase Discounts correct 36.00 correct
101 - Cash correct 1,164.00 correct
24-Sep 44 202 - Accounts Payable correct 7,090.00 correct
501.2 - Purchase Discounts correct 203.70 correct
101 - Cash correct 6,886.30 correct
24-Sep 45 202 - Accounts Payable correct 3,100.00 correct
501.2 - Purchase Discounts correct 119.80 correct
101 - Cash correct 2,980.20 correct
24-Sep 46 101 - Cash correct 25,652.44 correct
513 - Bank Credit Card Expense correct 633.74 correct
516 - Cash Short and Over correct 4.75 correct
401 - Sales correct 24,793.80 correct
231 - Sales Tax Payable correct 1,487.63 correct
24-Sep 47 501 - Purchases correct 8,750.00 correct
202 - Accounts Payable correct 8,750.00 correct
24-Sep 48 101 - Cash correct 891.00 correct
122 - Accounts Receivable correct 891.00 correct
26-Sep 49 122 - Accounts Receivable correct 1,351.50 correct
401 - Sales correct 1,275.00 correct
231 - Sales Tax Payable correct 76.50 correct
27-Sep 50 501 - Purchases correct 11,150.00 correct
502 - Freight-In correct 600.00 correct
202 - Accounts Payable correct 11,750.00 correct
27-Sep 51 122 - Accounts Receivable correct 715.50 correct
401 - Sales correct 675.00 correct
231 - Sales Tax Payable correct 40.50 correct
28-Sep 52 401.1 - Sales Returns & Allowances correct 270.00 correct
231 - Sales Tax Payable correct 16.20 correct
122 - Accounts Receivable correct 286.20 correct
28-Sep 53 312 - Oliver Hayden, Drawing correct 5,000.00 correct
101 - Cash correct 5,000.00 correct
28-Sep 54 202 - Accounts Payable correct 375.00 correct
101 - Cash correct 375.00 correct
29-Sep 55 101 - Cash correct 1,272.00 correct
122 - Accounts Receivable correct 1,272.00 correct
29-Sep 56 101 - Cash correct 845.50 correct
122 - Accounts Receivable correct 845.50 correct
29-Sep 57 101 - Cash correct 874.50 correct
122 - Accounts Receivable correct 874.50 correct
30-Sep 58 122 - Accounts Receivable correct 4,240.00 correct
401 - Sales correct 4,000.00 correct
231 - Sales Tax Payable correct 240.00 correct
30-Sep 59 401.1 - Sales Returns & Allowances correct 525.00 correct
231 - Sales Tax Payable correct 31.50 correct
101 - Cash correct 556.50 correct
30-Sep 60 101 - Cash correct 25,268.58 correct
513 - Bank Credit Card Expense correct 687.43 correct
401 - Sales correct 24,486.80 correct
231 - Sales Tax Payable correct 1,469.21 correct
30-Sep 61 103 - Payroll Cash correct 6,771.64 correct
101 - Cash correct 6,771.64 correct
30-Sep 61 522 - Office Salaries Expense correct 2,462.00 correct
511 - Sales Salaries Expense correct 5,850.00 correct
211 - Employees Federal Income Tax Payable correct 572.00 correct
212 - Social Security Tax Payable correct 515.35 correct
213 - Medicare Tax Payable correct 120.53 correct
214 - Employees State Income Tax Payable correct 249.36 correct
215 - Employees City Income Tax Payable correct 83.12 correct
103 - Payroll Cash correct 6,771.64 correct
30-Sep 61 530 - Payroll Taxes Expense correct 725.63 correct
212 - Social Security Tax Payable correct 515.34 correct
213 - Medicare Tax Payable correct 120.52 correct
221 - FUTA Tax Payable correct 11.58 correct
222 - SUTA Tax Payable correct 78.19 correct
30-Sep 62 231 - Sales Tax Payable correct 5,840.29 correct
101 - Cash correct 5,840.29 correct
30-Sep 63 312 - Oliver Hayden, Drawing correct 75.00 correct
512 - Advertising Expense correct 45.00 correct
515 - Travel & Entertainment Expense correct 37.50 correct
549 - Miscellaneous Expense correct 59.25 correct
101 - Cash correct 216.75 correct

Adjusting & Closing entries

Coolspring Furniture 101 - Cash
General Journal 103 - Payroll Cash
Week 4 - Adjusting & Closing Entries 105 - Petty Cash
122 - Accounts Receivable
Adjusting Entries: 131 - Merchandise Inventory
Date Trans # Description Debit Credit 141 - Office Supplies
20xx 142 - Store Supplies
30-Sep EOY #1(a) 313 - Income Summary correct 115,750.00 correct 145 - Prepaid Insurance
131 - Merchandise Inventory correct 115,750.00 correct 161 - Land
171 - Building
30-Sep EOY #1(b) 131 - Merchandise Inventory correct 122,500.00 correct 171.1 - Accum. Depr. - Building
313 - Income Summary correct 122,500.00 correct 181 - Sore Equipment
181.1 - Accum. Depr. - Store Equipment
30-Sep EOY #1( c) 523 - Office Supplies Expense correct 691.56 correct 182 - Office Equipment
141 - Office Supplies correct 691.56 correct 182.1 - Accum. Depr. - Office Equipment
202 - Accounts Payable
30-Sep EOY #1(d) 514 - Store Supplies Expense correct 520.24 correct 211 - Employees Federal Income Tax Payable
142 - Store Supplies correct 520.24 correct 212 - Social Security Tax Payable
213 - Medicare Tax Payable
30-Sep EOY #1(e) 535 - Insurance Expense correct 5,400.00 correct 214 - Employees State Income Tax Payable
145 - Prepaid Insurance correct 5,400.00 correct 215 - Employees City Income Tax Payable
218 - Sales Salaries Payable
30-Sep EOY #1(f) 540 - Depreciation Exp. - Building correct 2,515.00 correct 219 - Office Salaries Payable
171.1 - Accum. Depr. - Building correct 2,515.00 correct 221 - FUTA Tax Payable
222 - SUTA Tax Payable
30-Sep EOY #1(g) 519 - Depreciation Exp. - Store Equipment correct 475.00 correct 231 - Sales Tax Payable
181.1 - Accum. Depr. - Store Equipment correct 475.00 correct 241 - Unearned Rent Revenue
251 - Mortgage Payable
30-Sep EOY #1(h) 541 - Depreciation Exp. - Office Equipment correct 285.00 correct 311 - Oliver Hayden, Capital
182.1 - Accum. Depr. - Office Equipment correct 285.00 correct 312 - Oliver Hayden, Drawing
313 - Income Summary
30-Sep EOY #1(i) 241 - Unearned Rent Revenue correct 5,000.00 correct 401 - Sales
412 - Rent Revenue correct 5,000.00 correct 401.1 - Sales Returns & Allowances
412 - Rent Revenue
30-Sep EOY #1(j) 511 - Sales Salaries Expense correct 5,850.00 correct 501 - Purchases
218 - Sales Salaries Payable correct 5,850.00 correct 501.1 - Purchase Returns & Allowances
501.2 - Purchase Discounts
30-Sep EOY #1(k) 522 - Office Salaries Expense correct 2,250.00 correct 502 - Freight-In
219 - Office Salaries Payable correct 2,250.00 correct 511 - Sales Salaries Expense
512 - Advertising Expense
513 - Bank Credit Card Expense
514 - Store Supplies Expense
Closing Entries: 515 - Travel & Entertainment Expense
Date Trans # Description Debit Credit 516 - Cash Short and Over
20xx 519 - Depreciation Exp. - Store Equipment
30-Sep EOY #6
David: Close Income Statement accounts with CREDIT balances to Income Summary. List accounts in numerical order by account #. 		401 - Sales correct 987,327.30 correct 522 - Office Salaries Expense
412 - Rent Revenue correct 5,000.00 correct 523 - Office Supplies Expense
501.1 - Purchase Returns & Allowances correct 6,879.45 correct 525 - Telephone Expense
501.2 - Purchase Discounts correct 7,453.99 correct 530 - Payroll Taxes Expense
313 - Income Summary correct 1,006,660.74 correct 533 - Utilities Expense
534 - Charitable Contributions Expense
30-Sep EOY #6
David: Close Income Statement accounts with DEBIT balances to Income Summary. List accounts in numerical order by account #. 		313 - Income Summary correct 921,100.76 correct 535 - Insurance Expense
401.1 - Sales Returns & Allowances correct 13,470.00 correct 540 - Depreciation Exp. - Building
501 - Purchases correct 575,760.00 correct 541 - Depreciation Exp. - Office Equipment
502 - Freight-In correct 12,256.00 correct 549 - Miscellaneous Expense
511 - Sales Salaries Expense correct 146,250.00 correct 551 - Interest Expense
512 - Advertising Expense correct 9,864.00 correct
513 - Bank Credit Card Expense correct 33,320.26 correct
514 - Store Supplies Expense correct 520.24 correct
515 - Travel & Entertainment Expense correct 22,687.50 correct
516 - Cash Short and Over correct 33.52 correct
519 - Depreciation Exp. - Store Equipment correct 475.00 correct
522 - Office Salaries Expense correct 57,416.00 correct
523 - Office Supplies Expense correct 691.56 correct
525 - Telephone Expense correct 1,925.10 correct
530 - Payroll Taxes Expense correct 16,590.22 correct
533 - Utilities Expense correct 7,530.37 correct
534 - Charitable Contributions Expense correct 850.00 correct
535 - Insurance Expense correct 5,400.00 correct
540 - Depreciation Exp. - Building correct 2,515.00 correct
541 - Depreciation Exp. - Office Equipment correct 285.00 correct
549 - Miscellaneous Expense correct 586.25 correct
551 - Interest Expense correct 12,674.74 correct
30-Sep EOY #6
David: Close Income Summary to the Oliver Hayden, Capital account.
David: Close Income Statement accounts with CREDIT balances to Income Summary. List accounts in numerical order by account #. 		313 - Income Summary correct try again
311 - Oliver Hayden, Capital correct try again
30-Sep EOY #6
David: Close the Oliver Hayden, Drawing account to the Oliver Hayden, Capital account.		 311 - Oliver Hayden, Capital correct try again
312 - Oliver Hayden, Drawing correct try again

Coolspring EOY worksheet

Coolspring Furniture
End of Year Worksheet
For the Year Ended September 30, 20xx
ACCOUNT TITLES TRIAL BALANCE ADJUSTMENTS INCOME STATEMENT BALANCE SHEET
DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT DEBIT CREDIT
101 Cash 131,410.31
103 Payroll Cash 1,000.00
105 Petty Cash 350.00
122 Accounts Receivable 15,603.65
131 Merchandise Inventory 115,750.00 122,500.00 115,750.00 122,500.00
141 Office Supplies 1,580.00 691.56
142 Store Supplies 1,459.15 520.24
145 Prepaid Insurance 8,100.00 5,400.00
161 Land 75,000.00
171 Building 200,000.00
171.1 Accum. Depr. - Building 20,500.00 2,515.00
181 Store Equipment 10,275.00
181.1 Accum. Depr. - Store Equipment 1,225.00 475.00
182 Office Equipment 13,525.00
182.1 Accum. Depr. - Office Equipment 1,850.00 285.00
202 Accounts Payable 28,801.85
211 Employees Federal Income Tax Payable 1,137.00
212 Social Security Tax Payable 2,051.71
213 Medicare Tax Payable 479.84
214 Employees State Income Tax Payable 1,461.66
215 Employees City Income Tax Payable 463.72
218 Sales Salaries Payable - 0 5,850.00
219 Office Salaries Payable - 0 2,250.00
221 FUTA Tax Payable 56.27
222 SUTA Tax Payable 271.74
231 Sales Tax Payable 8,218.34
241 Unearned Rent Revenue 15,000.00 5,000.00
251 Mortgage Payable 248,724.74
311 Oliver Hayden, Capital 176,914.46
312 Oliver Hayden, Drawing 31,650.00
313 Income Summary 115,750.00 122,500.00 115,750.00 122,500.00
401 Sales 987,327.30 987,327.30
401.1 Sales Returns & Allowances 13,470.00 13,470.00
412 Rent Revenue - 0 5,000.00 5,000.00
501 Purchases 575,760.00 575,760.00
501.1 Purchases Returns & Allowances 6,879.45 6,879.45
501.2 Purchase Discounts 7,453.99 7,453.99
502 Freight-In 12,256.00 12,256.00
511 Sales Salaries Expense 140,400.00 5,850.00 146,250.00
512 Advertising Expense 9,864.00 9,864.00
513 Bank Credit Card Expense 33,320.26 33,320.26
514 Store Supplies Expense - 0 520.24 520.24
515 Travel & Entertainment Expense 22,687.50 22,687.50
516 Cash Short and Over 33.52 33.52
519 Depreciation Exp. - Store Equipment - 0 475.00 475.00
522 Office Salaries Expense 55,166.00 2,250.00 57,416.00
523 Office Supplies Expense - 0 691.56 691.56
525 Telephone Expense 1,925.10 1,925.10
530 Payroll Taxes Expense 16,590.22 16,590.22
533 Utilities Expense 7,530.37 7,530.37
534 Charitable Contributions Expense 850.00 850.00
535 Insurance Expense - 0 5,400.00
540 Depreciation Exp. - Building - 0 2,515.00 2,515.00
541 Depreciation Exp. - Office Equipment - 0 285.00 285.00
549 Miscellaneous Expense 586.25 586.25
551 Interest Expense 12,674.74 12,674.74
Totals 1,508,817.07 1,508,817.07 261,236.80 261,236.80 1,031,450.76 1,129,160.74 122,500.00 - 0
Net Income 97,709.98 97,709.98
1,129,160.74 1,129,160.74 122,500.00 97,709.98
correct correct correct correct correct correct try again try again

Income Statement

Coolsprings Furniture
Income Statement
For the Fiscal Year Ended September 30, 20xx
Revenue from Sales:
Sales
Less: Sales Returns & Allowances
Net Sales $ - 0 try again
Cost of Goods Sold:
Merchandise Inventory, Sept. 1, 20xx $ 115,750.00
Purchases
Less: Purchase Returns & Allowances
Purchase Discounts - 0
Net Purchases $ - 0
Add: Freight-In
Cost of Goods Purchased - 0
Goods Available for Sale $ 115,750.00
Less: Merchandise Inventory, Sept. 30,20xx 122,500.00
Cost of Goods Sold (6,750.00) try again
Gross Profit $ 6,750.00
Operating Expenses:
Sales Salaries Expense
Advertising Expense
Bank Credit Card Expense
Store Supplies Expense
Travel & Entertainment Expense
Depreciation Exp. - Store Equipment
Office Salaries Expense
Office Supplies Expense
Telephone Expense
Payroll Taxes Expense
Utilities Expense
Charitable Contributions Expense
Insurance Expense
Depreciation Exp. - Building
Depreciation Exp. - Office Equipment
Miscellaneous Expense
Total Operating Expenses - 0 try again
Income from Operations $ 6,750.00
Other Revenue:
Rent Revenue
Other Expenses:
Interest Expense
Cash Short and Over
Total Other Expenses - 0 $ - 0 try again
Net Income $ 6,750.00 try again

Stmt Of Owner's Equity

Coolspring Furniture
Statement of Owner's Equity
For the Fiscal Year Ended September 30, 20xx
Oliver Hayden, Capital, September 1, 20xx
Net Income for fiscal year $ 6,750.00
Less: Withdrawals for fiscal year
Increase in Capital 6,750.00
Oliver Hayden, Capital, September 30, 20xx $ 6,750.00 try again

Balance Sheet

Coolspring Furniture
Balance Sheet
As of September 30, 20xx
Assets
Current Assets:
Cash
Payroll Cash
Petty Cash
Accounts Receivable
Merchandise Inventory 122,500.00
Office Supplies
Store Supplies
Prepaid Insurance
Total Current Assets $ 122,500.00 try again
Property, Plant & Equipment
Land
Building
Less: Accumulated Depreciation - 0
Store Equipment
Less: Accumulated Depreciation - 0
Office Equipment
Less: Accumulated Depreciation - 0
Total Property, Plant & Equipment - 0 try again
Total Assets $ 122,500.00 try again
Liabilities
Current Liabilities:
Accounts Payable
Employees Federal Income Tax Payable
Social Security Tax Payable
Medicare Tax Payable
Employees State Income Tax Payable
Employees City Income Tax Payable
Sales Salaries Payable
Office Salaries Payable
FUTA Tax Payable
SUTA Tax Payable
Sales Tax Payable
Unearned Rent Revenue
Mortgage Payable (current portion) 20,356.28
Total Current Liabilities $ 20,356.28
Long-term Liabilities
Mortgage Payable
Less: Current Portion 20,356.28 (20,356.28)
Total Liabilities $ - 0 try again
Owner's Equity
Oliver Hayden, Capital 6,750.00
Total Liabilities & Owner's Equity $ 6,750.00 try again

Post Closing Trial Balance

Coolspring Furniture
Post-Closing Trial Balance
As of September 30, 20xx
ACCOUNT TITLES BALANCE
DEBIT CREDIT
101 Cash
103 Payroll Cash
105 Petty Cash
122 Accounts Receivable
131 Merchandise Inventory 122,500.00
141 Office Supplies
142 Store Supplies
145 Prepaid Insurance
161 Land
171 Building
171.1 Accum. Depr. - Building
181 Store Equipment
181.1 Accum. Depr. - Store Equipment
182 Office Equipment
182.1 Accum. Depr. - Office Equipment
202 Accounts Payable
211 Employees Federal Income Tax Payable
212 Social Security Tax Payable
213 Medicare Tax Payable
214 Employees State Income Tax Payable
215 Employees City Income Tax Payable
218 Sales Salaries Payable
219 Office Salaries Payable
221 FUTA Tax Payable
222 SUTA Tax Payable
231 Sales Tax Payable
241 Unearned Rent Revenue
251 Mortgage Payable
311 Oliver Hayden, Capital
Totals 122,500.00 - 0
try again try again