Question

In: Accounting

Prepare financial statements for 2017: Adjusted Trial Balance 2017 Description Debit Credit Cash      154,000.00 Owner's...

Prepare financial statements for 2017:

Adjusted Trial Balance 2017
Description Debit Credit
Cash      154,000.00
Owner's Equity                            250,000.00
Common Stock                            100,000.00
Equipment      150,000.00
Depreciation        15,000.00
Accumulated Depreciation                              15,000.00
Rent Expense        72,000.00
Office Supplies        90,000.00
Accounts Payable                              90,000.00
Supplies Expense        16,700.00
Supplies on Hand                              16,700.00
Utilities        54,000.00
Wages Payable      204,000.00
Federal Taxes Withheld                              54,000.00
State Taxes Withheld                              74,400.00
FICA                              15,606.00
FUTA                                1,632.00
SUTA                                7,650.00
Salary                              50,712.00
Rent Revenue                              80,000.00
COGS      505,944.80
Inventory                            505,944.80
Accounts Receivable      800,000.00
Sales                            800,000.00
Total 2,061,644.80                         2,061,644.80

Solutions

Expert Solution

Income Statement For the year ended 2017
Particulars Amount in $
Revenues:
Sales revenue 800,000.00
Less : Cost of goods Sold                (505,944.80)
Gross Profit (A) 294,055
  
Operating Expenses:     
Depreciation expense 15000
Office Supplies Expense 90000
Supplies Expense 16700
Utillities Expense 54000
Rent expense 72000
Total operating expenses (B) 247,700
Operating Income C =(A-B) 46,355
Other Income:
           Rent revenue 80000
Total Other Income (D) 80,000.00
Net Income (C+D) 126,355.2
Statement of Retained Earnings
For the Year Ended 2017
Particulars Amount in $
Opening Balance                         -  
Net Income of the Year 126,355.2
Closing Balance 126355.2
Balance Sheet as on 31.12.2017
Particulars Amount (in $)
Assets
Current Assets
Cash 154000
Account Receivable 800000
Wages Payable (Prepaid) 204000
Total Current Assets (A) 1158000
Property, Plant & Equipment
Equipment 150000
Less : Accumulated Depreciation -15000
Total Property, Plant & Equipment (B) 135000
Total Assets (A+B) 1293000
Liablities
Current Liablities
Federal Taxes Withheld 54000
State Taxes Withheld 74400
FICA 15606
FUTA 1632
SUTA 7650
Salary 50712
Liablity against Inventories 505,944.80
Accounts Payable 90000
Supplies on Hand 16700
Total Current Liablities (A) 816644.8
Stockholder Equity
Owner Equity 250000
Common Stock 100000
Retained Earnings 126355.2
Total Stockholder Equity (B) 476,355.20
Total Liablities (A+B) 1293000
Statement of Cash Flow using Indirect Method
Particulars Amount in $
Cash Flow From Operating Activities
Net Income 126355.2
Add : Non Cash Expenses
Depreciation 15,000
Less :Increase in Current Assets -1,004,000
Add :Increase in Current Liablites 816,645
-172,355
Net cash Used operating activities (A) -46,000
Cash flows from investing activities
Cash paid for equipment -150000
Net cash used in investing activities (B) -150,000
Cash flows from financing activities
Cash received from sale of common stock 100000
Proceeds from Owner Capital 250000
Net cash used in financing activities ( C) 350,000
Net increase in cash and cash equivalents (A+B+C) 154,000
Cash at the beginning of the Year
Cash at the end of the Year 154000
Assumption

This Entire solution has based on Assumption as follows .

1- Office Supplies and Utilities are treated as expenses and same has been disclosed in Income Statement.

2-Credit balance of inventory of $505944.80 treated as liabilities against for Purchase. So, it has been disclosed in Current liabilities in Balance Sheet.

3- Debit balance of Wages payable treated as prepaid expenses. Thus, it has been disclosed in Current asset.


Related Solutions

Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial...
Account Unadjusted trial balance(debit) Unadjusted trial balance(credit Adjusting entries(debit) adjusting entries(credit) adjusted trial balance(debit) Adjusted trial balance(credit) Cash 32,236.75 32,236.75 baking supplies 18,500 18,500 merchandise inventory(fifo) 175.65 175.65 prepaid rent 1500 1500 prepaid insurance 2400 2400 baking equipment 6000 6000 accumulated depreciation 208.33 208.33 office supplies 600 600 accounts receivable 7700 7700 notes payable 10,000 10,000 wages payable 480 480 common stock 16,000 16,000 dividends 10,000 10,000 bakery sales 55,000 55,000 merchandise sales 221 221 baking supplies expense rent expense...
The adjusted trial balance at April 30, 2017, for Willard Co. follows. Account Debit Credit Cash...
The adjusted trial balance at April 30, 2017, for Willard Co. follows. Account Debit Credit Cash $106,300 Accounts receivable 25,620 Trucks 560,000 Accumulated depreciation, trucks $84,000 Franchise 55,000 Accounts payable 20,540 Salaries payable 10,200 Unearned revenue 35,000 Sid Willard, capital 250,000 Sid Willard, withdrawals 75,000 Plumbing revenue 850,630 Depreciation expense, trucks 84,000 Salaries expense 272,450 Rent expense 60,000 Advertising expense 12,000 Income summary Totals $1,250,370 $1,250,370 Required: 1.      Prepare the four closing entries. 2.      Prepare a post-closing trial balance.
The adjusted trial balance for Chiara Company as of December 31 follows. Debit Credit Cash $...
The adjusted trial balance for Chiara Company as of December 31 follows. Debit Credit Cash $ 265,100 Accounts receivable 51,000 Interest receivable 23,200 Notes receivable (due in 90 days) 173,000 Office supplies 15,500 Automobiles 173,000 Accumulated depreciation—Automobiles $ 55,000 Equipment 140,000 Accumulated depreciation—Equipment 28,000 Land 84,000 Accounts payable 97,000 Interest payable 50,000 Salaries payable 22,000 Unearned fees 34,000 Long-term notes payable 154,000 Common stock 35,580 Retained earnings 320,220 Dividends 53,000 Fees earned 584,000 Interest earned 32,000 Depreciation expense—Automobiles 27,500 Depreciation...
The adjusted trial balance for Chiara Company as of December 31 follows. Debit Credit Cash $...
The adjusted trial balance for Chiara Company as of December 31 follows. Debit Credit Cash $ 157,200 Accounts receivable 51,500 Interest receivable 18,600 Notes receivable (due in 90 days) 171,500 Office supplies 16,000 Automobiles 168,000 Accumulated depreciation—Automobiles $ 55,000 Equipment 140,000 Accumulated depreciation—Equipment 27,000 Land 81,000 Accounts payable 96,000 Interest payable 25,000 Salaries payable 26,000 Unearned fees 36,000 Long-term notes payable 154,000 Common stock 27,580 Retained earnings 248,220 Dividends 53,000 Fees earned 574,000 Interest earned 28,000 Depreciation expense—Automobiles 27,000 Depreciation...
Presented below is the adjusted trial balance of Pharoah Corporation at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Pharoah Corporation at December 31, 2017. Debit Credit Cash $          ? Supplies 1,490 Prepaid Insurance 1,290 Equipment 48,290 Accumulated Depreciation-Equipment $  4,290 Trademarks 1,240 Accounts Payable 10,290 Salaries and Wages Payable 790 Unearned Service Revenue 2,290 Bonds Payable (due 2024) 9,290 Common Stock 10,290 Retained Earnings 25,290 Service Revenue 10,290 Salaries and Wages Expense 9,290 Insurance Expense 1,690 Rent Expense 1,490 Interest Expense 1,190     Total $          ? $          ? Additional information: 1. Net loss for the...
Presented below is the adjusted trial balance of Sunland Corporation at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Sunland Corporation at December 31, 2017. Debit Credit Cash $ ? Supplies 1,560 Prepaid Insurance 1,360 Equipment 48,360 Accumulated Depreciation-Equipment $ 4,360 Trademarks 1,310 Accounts Payable 10,360 Salaries and Wages Payable 860 Unearned Service Revenue 2,360 Bonds Payable (due 2024) 9,360 Common Stock 10,360 Retained Earnings 25,360 Service Revenue 10,360 Salaries and Wages Expense 9,360 Insurance Expense 1,760 Rent Expense 1,560 Interest Expense 1,260 Total $ ? $ ? Additional information: 1....
Presented below is the adjusted trial balance of Martinez Corporation at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Martinez Corporation at December 31, 2017. Debit Credit Cash $          ? Supplies 1,350 Prepaid Insurance 1,150 Equipment 48,150 Accumulated Depreciation-Equipment $  4,150 Trademarks 1,100 Accounts Payable 10,150 Salaries and Wages Payable 650 Unearned Service Revenue 2,150 Bonds Payable (due 2024) 9,150 Common Stock 10,150 Retained Earnings 25,150 Service Revenue 10,150 Salaries and Wages Expense 9,150 Insurance Expense 1,550 Rent Expense 1,350 Interest Expense 1,050     Total $          ? $          ? Additional information: 1. Net loss for the...
Presented below is the adjusted trial balance of Pina Corporation at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Pina Corporation at December 31, 2017. Debit Credit Cash $          ? Supplies 1,310 Prepaid Insurance 1,110 Equipment 48,110 Accumulated Depreciation-Equipment $  4,110 Trademarks 1,060 Accounts Payable 10,110 Salaries and Wages Payable 610 Unearned Service Revenue 2,110 Bonds Payable (due 2024) 9,110 Common Stock 10,110 Retained Earnings 25,110 Service Revenue 10,110 Salaries and Wages Expense 9,110 Insurance Expense 1,510 Rent Expense 1,310 Interest Expense 1,010     Total $          ? $          ? Additional information: 1. Net loss for the...
Presented below is the adjusted trial balance of Metlock, Inc. at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Metlock, Inc. at December 31, 2017. Debit Credit Cash $          ? Supplies 1,390 Accounts Receivable 2,980 Prepaid Insurance 2,060 Equipment 80,000 Accumulated Depreciation—Equipment $20,740 Trademarks 4,020 Accounts Payable 3,200 Salaries and Wages Payable 800 Unearned Service Revenue 1,680 Bonds Payable (due 2024) 31,960 Common Stock 2,580 Additional paid-in capital 15,160 Retained Earnings 14,480 Service Revenue 29,600 Salaries and Wages Expense 14,200 Insurance Expense 2,860 Rent Expense 2,760 Interest Expense 2,960     Total $          ? $          ?...
Presented below is the adjusted trial balance of Windsor, Inc. at December 31, 2017. Debit Credit...
Presented below is the adjusted trial balance of Windsor, Inc. at December 31, 2017. Debit Credit Cash $          ? Supplies 1,410 Accounts Receivable 3,520 Prepaid Insurance 2,380 Equipment 80,220 Accumulated Depreciation—Equipment $20,600 Trademarks 3,760 Accounts Payable 2,820 Salaries and Wages Payable 1,360 Unearned Service Revenue 1,260 Bonds Payable (due 2024) 32,540 Common Stock 2,080 Additional paid-in capital 15,780 Retained Earnings 14,940 Service Revenue 30,180 Salaries and Wages Expense 14,800 Insurance Expense 2,400 Rent Expense 3,180 Interest Expense 2,300     Total $          ? $          ?...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT