INCOME STATEMENT
| Revenues: | ||
| Service fees earned | $62,400 | |
| Expenses: | ||
| Rent expenses | $15,000 | |
| Salaries expenses | 33,400 | |
| Supplies expenses | 4,700 | |
| Insurance expenses | 3,250 | |
| Depreciation expenses | 720 | |
| Interest expenses | 630 | |
| Total expenses | ( 57,700) | |
| Net Income | 4,700 |
STATEMENT OF RETAINED EARNING
| Retained Earning (beginning) | $7,505 |
| Add: Net income | 4,700 |
| Less: Dividend paid | (2,900) |
| Retained Earning (ending) | $9,305 |
BALANCE SHEET
| Assets: | ||
| Current assets: | ||
| Cash | $5,000 | |
| Account receivable | 3,270 | |
| Supplies | 5,060 | |
| Prepaid insurance | 1,500 | |
| Total current assets | 14,830 | |
| Non current assets: | ||
|
Equipment (net): $9,400-$1,080 |
8,320 | |
| Total assets | $23,150 | |
| Liabilities and stockholders' equity | ||
| Liabilities: | ||
| Account payable | 845 | |
| Long term notes payable | 7,000 | |
| Total liabilities | 7,845 | |
| Stockholders' equity: | ||
| Common stock | 6,000 | |
| Retained earning | 9,305 | 15,305 |
| Total liabilities and stockholders' equity | 23,150 |
RATIO
| S.no. | Ratio | Formula | |
| 1 | Profit margin | Net income/Net sales*100 |
4,700/62,400*100 =7.53% |
| 2 | current ratio | Current assets/Current liabilities |
14,830/845 = 17.55:1 |
| 3 | working capital | Current assets/ Current liabilities |
14,830/845 = 17.55:1 |
| 4 | Asset turnover | Net sales/Total assets |
62,400/23,150 = 2.70 times |
| 5 | Debt ratio | Total liabilities/Total assets*100 |
7,845/23,150*100 = 34% |
Note: Net sales = Service revenue earned
Thank you :)
Cash $ 5,000 Accounts receivable 3,270 Supplies 5,060 1,500 9,400 $ 1,080 845 7,000 6,000 Prepaid...
Prepare a Balance Sheet
$ 2,700 3.270 Supplies. Prepaid insurance Accumulated depreciation Equipment Long-term notes payable. 1,500 6,400 . . $ 1,080 845 7,000 3,000 5,205 2,900 Service fees eamed... . 62,400 15,000 33,400 4,700 3,250 720 $79,530 $79,530
P3-8A Financial Statements and Closing Entries The adjusted
trial balance shown below is for Sharpe Consulting Service as of
December 31. Bryan Sharpe made no capital contributions during the
year. Please see attached picture for further details. Need
guidance for answering questions in excel. Thank you.
Cambridge Business Publishers Chapter 3 Accrual Basis of Accounting 1 Cash............. Accounts receivable... Supplies ... Prepaid insurance. ...... Equipment ............ Accumulated depreciation Equipment Accounts payable...... Long-term notes payable .. Common stock .... Retained earnings...
Prepare a detailed Balance Sheet and also calculate the
following ratios:
A) Current Ratio
B) Working Capital
C) Assets Turnover
D) Fixed Assets Turnover
E) A/R Turnover
F) Debt Ratio
$ 2,700 3.270 Supplies. Prepaid insurance Accumulated depreciation Equipment Long-term notes payable. 1,500 6,400 . . $ 1,080 845 7,000 3,000 5,205 2,900 Service fees eamed... . 62,400 15,000 33,400 4,700 3,250 720 $79,530 $79,530
Financial Statements and Closing Entries The adjusted trial balance shown below is for Fine Consulting Service as of December 31. Byran Sharpe made no capital contributions during the year. SHARPE CONSULTING SERVICE Adjusted Trial Balance December 31 Debit Credit Cash $2,900 Accounts Receivable 3,270 Supplies 5,060 Prepaid Insurance 1,500 Equipment 6,400 Accum. Depr. - Equipment $1,080 Accounts Payable 845 Long - Term Notes Payable 7,200 Common Stock 2,800 Retained Earnings 5,205 Dividends 2,900 Service Fees Earned 62,600 Rent Expense 15,500...
Trial balance
Account Titles
Debit
Credit
Cash
$
95,430
Accounts Receivable
$
6,000
Prepaid Rent
$
25,000
Prepaid Insurance
$
2,700
Prepaid Supplies
$
120
Equipment
$ 400,000
Accumulated Depreciation
$
3,250
Accounts Payable
$
970
Accrued Interest
$
1,400
Accrued Salaries
$
550
Unearned Rental Revenue
$
1,950
Notes Payable
$ 350,000
Capital Stock-Mike
$
80,000
Capital Stock-Julie
$
80,000
Dividend
$
4,000
Retained Earnings
$
-
Rental Revenue
$
46,100
Salaries Expense
$
19,950
Rent Expense
$
5,000...
Credit Cash Accounts Receivable Debit $ 6,850 7,000 1,982 3,180 15,000 Supplies Prepaid Insurance Equipment Accounts Payable Unearned Service Revenue Common Stock Service Revenue Salaries and Wages Expense Rent Expense $ 4,245 5,200 21,982 8,300 4,000 1,715 $39,727 $39,727 In addition to those accounts listed on the trial balance, the chart of accounts for Richard also contains the following accounts: Accumulated Depreciation-Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense, and Supplies Expense. Other data: 1. 2. 3....
Problem #3 XYZ Company Adjusted Trial Balance Debit Credit Cash $ 19,800 Accounts receivable 5,250 Supplies 5,300 Prepaid Advertising 3,000 Trucks 30,300 Accumulated depreciation - Trucks Equipment 7,600 Accumulated depreciation - Equipment Accounts payable Unearned service fees S 10,000 2,100 1.200 6,700 20,000 16,050 12,000 90,000 29,800 Common Stock Retained carnings Dividends Service fees earned Wages expense Rent expense Insurance expense Supplies expense Advertising expense Depreciation expense - Trucks Depreciation expense - Equipment 10,200 4,900 5,100 8,000 4,000 800 $146,050...
Credit Cash Debit $6,850 7,000 1,982 3,180 15,000 Accounts Receivable Supplies Prepaid Insurance Equipment Accounts Payable Unearned Service Revenue Common Stock Service Revenue Salaries and Wages Expense Rent Expense $ 4,245 5,200 21,982 8,300 4,000 1,715 $39,727 $39,727 In addition to those accounts listed on the trial balance, the chart of accounts for Richard also contains the following accounts: Accumulated Depreciation Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense, and Supplies Expense. Other data: 1. 2. 3....
Debit Credit Cash $6,850 Accounts Receivable 7,000 Supplies 1,982 Prepaid Insurance 3,180 Equipment 15,000 Accounts Payable $ 4,245 Unearned Service Revenue 5,200 Common Stock 21,982 Service Revenue 8,300 Salaries and Wages Expense 4,000 Rent Expense 1,715 $39,727 $39,727 In addition to those accounts listed on the trial balance, the chart of accounts for Richard also contains the following accounts: Accumulated Depreciation Equipment, Salaries and Wages Payable, Depreciation Expense, Insurance Expense, Utilities Expense, and Supplies Expense. Other data: 1. Supplies on...
Assets Cash $7,000 Accounts Receivable 6,000 Supplies 2,000 Equipment 10,000 Total Assets $25,000 Liabilities & Equity Accounts Payable $3,000 Common Stock 20,000 Retained Earnings 2,000 Total Liabilities & Equity $25,000 Instructions: Open the balances in the general ledger (T-accounts). Post the journal entries from the general journal to the general...