Problem 5-4A
Adjusting entries and multi-step income statement—perpetual
CHECK FIGURES: 1. Income statement columns = $529,310;
2. Profit = $5,025
Information from the unadjusted trial balance of Jumbo's on December 31, 2017, the end of the annual accounting period, is as follows:
|
Debit |
Credit |
||
|
Cash |
8,100 |
||
|
Accounts receivable |
22,665 |
||
|
Merchandise inventory |
34,600 |
||
|
Store supplies |
2,415 |
||
|
Office supplies |
775 |
||
|
Prepaid insurance |
3,255 |
||
|
Equipment |
74,490 |
||
|
Accumulated depreciation, equipment |
13,655 |
||
|
Accounts payable |
8,000 |
||
|
Salaries payable |
0.0 |
||
|
Sally Fowler, capital |
168,965 |
||
|
Sally Fowler, withdrawals |
62,000 |
||
|
Interest income |
310 |
||
|
Sales |
529,000 |
||
|
Sales returns and allowances |
5,670 |
||
|
Cost of goods sold |
381,160 |
||
|
Salaries Expense |
96,300 |
||
|
Rent expense |
29,100 |
||
|
Supplies Expense |
0.0 |
||
|
Depreciation expense, equipment |
0.0 |
||
|
Insurance expense |
0.0 |
||
|
Totals |
719,930 |
719,930 |
|
Required
1. Record adjusting entries for the following in format.
a. A review of the store supplies on December 31, 2017, revealed a balance on hand of $2,000; a similar examination of the office supplies showed that $640 had been used.
b. The balance in the Prepaid Insurance account was reviewed and it was determined that $255 was unused at December 31, 2017.
c. The records show that the equipment was estimated to have a total estimated useful life of 10 years with a resale value at the end of its life of $14,490.
d. Accrued salaries payable, $1,800.
e. A count of the merchandise inventory revealed a balance on hand
December 31, 2017, of $33,800.
2. Using adjusted trial balance numbers, prepare multiple-step income statement showing the expenses in detail.
Analysis Component:
Explain why Interest income is shown under Other revenues and expenses on the multiple-step income statement.
| Unadjusted Trial Balance | Adjustments | Adjusted Trial Balance | ||||
| Debit | Credit | Debit | Credit | Debit | Credit | |
| Cash | 8,100 | 8,100 | ||||
| Accounts receivable | 22,665 | 22,665 | ||||
| Merchandise inventory | 34,600 | 800 | 33,800 | |||
| Store supplies | 2,415 | 415 | 2000 | |||
| Office supplies | 775 | 640 | 135 | |||
| Prepaid insurance | 3,255 | 3000 | 255 | |||
| Equipment | 74,490 | 74,490 | ||||
| Accumulated depreciation, equipment | 13,655 | 6000 | 19655 | |||
| Accounts payable | 8,000 | 8,000 | ||||
| Salaries payable | 0 | 1800 | 1800 | |||
| Sally Fowler, capital | 1,68,965 | 1,68,965 | ||||
| Sally Fowler, withdrawals | 62,000 | 62,000 | ||||
| Interest income | 310 | 310 | ||||
| Sales | 5,29,000 | 5,29,000 | ||||
| Sales returns and allowances | 5,670 | 5,670 | ||||
| Cost of goods sold | 3,81,160 | 800 | 3,81,960 | |||
| Salaries Expense | 96,300 | 1800 | 98,100 | |||
| Rent expense | 29,100 | 29,100 | ||||
| Supplies Expense | 0 | 1055 | 1055 | |||
| Depreciation expense, equipment | 0 | 6000 | 6000 | |||
| Insurance expense | 0 | 3000 | 3000 | |||
| Totals | 7,19,930 | 7,19,930 | 12655 | 12655 | 7,28,330 | 727730 |
| 7,20,530 | 7,19,930 | |||||
| Difference | 600 | 600 | ||||
|
NOTE: THERE IS A DIFFERENCE OF $600 IN THE UN-ADJUSTED TRIAL BALANCE. |
||||||
| INCOME STATEMENT | ||||||
| Revenues: | ||||||
| Sales | 5,29,000 | |||||
| Sales returns and allowances | 5,670 | |||||
| Net sales | 5,23,330 | |||||
| Cost of goods sold | 3,81,960 | |||||
| Gross profit | 1,41,370 | |||||
| Operating expenses | ||||||
| Salaries Expense | 98,100 | |||||
| Rent expense | 29,100 | |||||
| Supplies Expense | 1055 | |||||
| Depreciation expense, equipment | 6000 | |||||
| Insurance expense | 3000 | |||||
| Total operating expenses | 1,37,255 | |||||
| Operating income | 4,115 | |||||
| Other income/(expenses) | ||||||
| Interest income | 310 | |||||
| Net income | 4,425 | |||||
Problem 5-4A Adjusting entries and multi-step income statement—perpetual CHECK FIGURES: 1. Income statement columns = $529,310;...
6. Post adjusting entries and prepare an adjusted trial balance 7. Prepare a multi-step income statement and statement of owner's equity for the year ended December 31, 2018 Prepare a classified balance sheet as of Dscember 31, 2018 Assume Interest Receivable is a current asset and Interest Payable is a current liability 8. Evaluate the company's success for the first year of operations by calculating the following ratios Round to two decimal places Comment on the results a. Liquidity i....
219 H D Auto Zoom : P4-10A. Multi-step Income Statement and Adjusting Entries The New England Trading Company, whose LO2 accounting year ends on December 31, had the following normal balances in its general ledger at De cember 31: $17,000 56,600 74.000 3,000 4,200 21,000 Cash. Accounts receivable Inventory.......... Prepaid insurance... Office supplies Furniture and fixtures... Accumulated depreciation furniture and fixtures....... Delivery equipment............ Accumulated depreciation delivery equipment ... Accounts payable.... Long-term notes payable ......... Common stock..... Retained earnings ................. Sales...
Use the following adjusting entries to complete the
worksheet, prepare an income statement, statement of retained
earnings, closing entries, and balance sheet.
Broomfield Company
Adjusting Journal Entries
For the Year Ended December 31, 2019
Account Titles
DR
CR
a.
Interest
Expense
15,920
Interest
Payable
15,920
b.
Insurance Expense
19,152
Prepaid
Insurance
19,152
c.
Rent
Expense
23,940
Prepaid
Rent
23,940
d.
Unearned
Revenue
12,000
Consulting Revenue
12,000
e.
Supplies
Expense
116,622
Supplies...
Problem 4-5A Preparing adjusting entries and income statements; computing gross margin, acid-test, and current ratios LO A1, A2, P3, P4 [The following information applies to the questions displayed below.] The following unadjusted trial balance is prepared at fiscal year-end for Nelson Company. NELSON COMPANY Unadjusted Trial Balance January 31, 2017 Debit Credit Cash $ 1,000 Merchandise inventory 12,500 Store supplies 5,800 Prepaid insurance 2,400 Store equipment 42,900 Accumulated depreciation—Store equipment $ 15,250 Accounts payable 10,000 Common stock 5,000...
Prepare a Trial Balance, Multi Step Income
Statement, Retained Earnings Statement, and Classified Balance
Sheet
the
values needed are all the way on the left in the photo. i started
the trial balance (the green chart) but could not get both sides to
equal.
ACCT 251 EXCEL ASSIGNMENT - PREPARING FINANCIAL STATEMENTS IN EXCEL (see instructions tab for detailed instructions) Prepare a multi-step income statement: Prepare a retained earnings statement: Prepare a classified balance sheet: 1,001,360 101,360 591,680 Service Revenue...
3.25 Journalining adjusting entries and posting to account The unadjusted trial balance for Pit Class Maldo Company, the dining service, is as follows: FIRST CLASS MAIDS COMPANY Unad usted Trial Balance December 31, 2014 3.000 Account Title Cath Office Supplies Prepaid instance Equipment Accumuland Depreciation opment Accounts Payable Salaries Payable Unnamed Revenue Molly Capital Moly Withdrawal Service Revenue Salaries Expense Supplies Expense Depreciation Expense Equipment Insurance pense Total $ 4.500 During the 12 months ended December 31, 2014. First Class...
Preparation of Financial Statements Use the following information to prepare a multi-step Statement of Comprehensive Income, a Statement of Changes in Shareholders Equity, and a classified Statement of Financial Position. Charles Corporation Adjusted Trial Balance December 31, 2017 Debit Credit $ 33,400 87,400 Cash 90,000 7,000 170,000 Merchandise Inventory.. Store Supplies Store Equipment. Accumulated Depreciation-Store Equipment Delivery Equipment Accumulated Depreciation-Delivery Equipment Notes Payable Accounts Payable Common Shares.... Retained Earnings. Sales Sales Return and Allowances Cost of Goods Sold. 54,000 96,000...
Complete the worksheet using the excel file. Add your adjusting journal entries and complete the adjusted trial balance. Do not do the financial statements, closing entries, or post-close trial balance. The information for the adjusting journal entries are at the bottom of the tab- "adjusting entries" Adjusting Journal Entries Info. Insurance that expired during December was $275.00 A physical count of the supplies indicated that $715.00 were on hand. Depreciation on office equipment for the period was $330.00 Salaries worked...
The income statement of Gopitkumar Co. for the month of July shows net income of $1,400 based on Service Revenue $5,500, Salaries and Wages Expense $2,300, Supplies Expense $1,200, and Utities Expense $600. In reviewing the statement, you discover the following. 1. 2. 3. 4. 5. Insurance expered during July of $400 was omitted Supplies expense includes $250 of supplies that are still on hand at July 31. Depreciation on equipment of $150 was omitted. Accrued but unpaid salaries and...
Required: 1. Prepare the adjusting entries on the Trial
Balance tab, and complete the worksheet on the Trial Balance
tab
2. On the Financial Statements tab, prepare the income
Statement, Retained Earnings Statement, and Balance Sheet for the
2020 year
3. On the Tab complete T-Accounts for all accounts. The
ending balances in every should agree to the balances on the
Balance Sheet as of December 31, 2020
Prepaid Insurance 1,000 89,020 Accounts Receivable 103,100 103 100 Equipment 100,000 Allowance...