Accounting Excel

profilenearzl
Spreadsheet_PCU3.xls
Home>Business & Finance homework help>Accounting homework help>Accounting Excel

Title page

www.perdisco.com
spreadsheet version: PCU3e.S1

Worksheet

Moondollars - Worksheet
June 30, 20XX
Acct. No. Account Name Unadjusted Trial Balance Adjustments Adjusted Trial Balance Income Statement Balance Sheet
Debit Credit Debit Credit Debit Credit Debit Credit Debit Credit
100 Cash 103,835
102 Short-term Investments 20,000
110 ARC - Accounts Receivable Control 6,895
112 Interest Receivable
120 Merchandise Inventory 73,322
130 Office Supplies 7,083
140 Prepaid Rent 6,000
141 Prepaid Advertising 9,000
142 Prepaid Insurance 2,950
150 Office Furniture 9,000
151 Accum Depn: Office Furniture 2,031
160 Office Equipment 43,000
161 Accum Depn: Office Equipment 13,532
210 APC - Accounts Payable Control 155
220 Wages Payable
221 Electricity Payable
222 Water Payable
225 Interest Payable
250 Bank Loan Payable 55,000
300 Common Stock 80,000
301 Retained Earnings 100,401
400 Sales Revenue 46,370
401 Sales Returns and Allowances 1,198
402 Sales Discounts 284
403 Interest Revenue 234
500 Purchases 735
501 Purchase Returns and Allowances 1,403
502 Purchase Discounts 66
511 Advertising Expense
516 Wages Expense 10,685
540 Rent Expense
541 Electricity Expense
542 Water Expense
543 Insurance Expense
544 Office Supplies Expense
545 Salary Expense 5,200
560 Depn Expense: Office Furniture 156
561 Depn Expense: Office Equipment
571 Interest Expense
572 Admin. Expense - Bank Charges 5
Totals 299,192 299,192
Net income or loss
Totals 299,192 299,192
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Schedules of accounts

Schedule of accounts receivable
Moondollars Schedule of Accounts Receivable June 30, 20XX
Account No. Name Debit ($) Credit ($)
Total
Schedule of accounts payable
Moondollars Schedule of Accounts Payable June 30, 20XX
Account No. Name Debit ($) Credit ($) Terms
Total
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Income statement

Moondollars Income Statement For the month ended June 30, 20XX
INCOME
Revenue
Net sales revenue
COST OF GOODS SOLD
GROSS PROFIT
OPERATING EXPENSES
Selling expenses
Total selling expenses
General and administrative expenses
Total general and administrative expenses
TOTAL OPERATING EXPENSES
INCOME/(LOSS) FROM OPERATIONS
Other revenue
Other expenses
NET INCOME/(LOSS)
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Stockholders' equity

Moondollars Statement of Stockholders' Equity For the month ended June 30, 20XX
COMMON STOCK
Opening balance May 31, 20XX
Issue of common stock   
Closing balance June 30, 20XX   
RETAINED EARNINGS
Opening balance May 31, 20XX   
Net income/(loss)
Dividend paid
Closing balance June 30, 20XX
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Balance sheet

Moondollars Balance Sheet June 30, 20XX
ASSETS
Current Assets
Total Current Assets
Property, Plant and Equipment
Total Property, Plant and Equipment
TOTAL ASSETS
LIABILITIES
Current Liabilities
Total Current Liabilities
Long-term Liabilities
TOTAL LIABILITIES
STOCKHOLDERS' EQUITY
TOTAL EQUITY
TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)

Post-closing trial balance

Moondollars Post-closing Trial Balance June 30, 20XX
Account No. Name Debit ($) Credit ($)
Total
&LCOFFEE & CAFÉ SUPPLIER - US GAAP EDITION 3 (PCU3e.S1)