Question

In: Accounting

1. Record the account information listed on the trial balance (page 7 of the instructions) onto...

1. Record the account information listed on the trial balance (page 7 of the instructions) onto the general ledger sheets provided (pages WP-3 through WP-10). [Note: Cash, Accounts Receivable, and Prepaid Rent have already been done for you.] The balances of all of the accounts should be dated as of December 31, 20XX. (Make sure that you also write-in the account number for each of these general ledger accounts—found on the chart of accounts, page 5 of these instructions).

2. Prepare the worksheet (WP-2) for year-end procedures

Suggested steps are as follows:

a. Complete the chart of accounts that is provided for Veggies-R-Us. (page 5 of these instructions), i.e., state whether each account is an asset, liability, shareholders’ equity, revenue, or expense account.

b. Transfer the account names from the chart of accounts, (page 5 of these instructions) to the worksheet that is provided (WP-2). Make sure that you list all of these accounts on the worksheet (even if they don’t currently have balances) and make sure that you list them in the order that they are listed on the chart of accounts.

c. Transfer the balances that you have from your general ledger (completed in step #1) to the worksheet started in step 2.a. [Check figures are debit/credit = $438,290]

3. Prepare the required adjusting journal entries for the month-end based upon the information provided on page 6 of these instructions (Information for AJE’s #1 through #10).

Suggested steps are as follows:

a. Based on the information provided in a. on page 6 (of these instructions), determine the required adjusting journal entry. Write up this adjusting journal entry on the General Journal sheets provided (WP-11 to WP-14). Make sure to properly date and label your adjusting journal entry (i.e., 1, 2, 3, etc). Start with the account to be debited first, then the account to be credited is written in next. Provide a description for each of your adjusting journal entries. NOTE: These adjusting journal entries are within the group of journal entries that you were required to do throughout the semester.

b. Post this adjusting journal entry from the General Journal to the proper accounts on your worksheet (WP-2). Indicate that you have posted the adjusted journal entry by making a ‘squiggly line’ in the POST. REF. Column of the General Journal. (Remember, put this ‘squiggly’ line on the far right side of this column because later we will need to enter the account number in this column when we post this adjusting journal entry to the general ledger. Don’t do this yet, we have to complete the worksheet first!)

c. Now go back to page 6 (of these instructions), and perform the same steps from above (3.a. & 3.b.) for the information provided in b. through j.

d. After you have completed all of the required adjusting journal entries, make sure that your worksheet balances. To do this, add up all of the debits and all of the credits that you have made in the “ADJUSTMENTS’ column of the worksheet. Your debits should equal your credits. [Check number = $37,097]

4. If your worksheet balances, it is now time to calculate the adjusted trail balance amounts on the worksheet. Once you have completed this step you need to once again make sure that your worksheet balances. Add up the debits and credits in the “ADJUSTED TRIAL BALANCE’ column of the worksheets. Your debits should equal your credits. [Check number = $448,232 for debits and credits, Cash = $26,750; Accum Depr-Building = $30,580; Premium on bonds payable = $5,700; Revenue = $154,775]

5. Complete the “INCOME STATEMENT” and “BALANCE SHEET” columns of the worksheet. The debits and credits will not be equal, the difference for both of these sections should = $55,693 (Net Income for the period).

6. Post the adjusting journal entries from your general journal (WP-11 through WP-14) to the proper General Ledger accounts (WP-3 through WP-10). When you have completed posting an amount from the General Journal to the General Ledger, enter the account number that you posted this AJE to in the POST. REF. Column of the General Journal.

Make sure that the balances in your General Ledger accounts EQUAL the balances on your Worksheet (WP-2) after your have posted the Adjusting Journal Entries to the General Ledger. (All of these account amounts must equal, or a mistake has been made!)

7. With the aid of your worksheet, prepare formal financial statements for Veggies-R-Us., for the year ended December 31, 20XX. (Use your text book if necessary to prepare these statements: Income Statement, Statement of Shareholders’ Equity, and a classified Balance Sheet. Sample financial statements can also be found at the end of the excel file called “Layout of worksheets”)

[check figures, net income = $55,693; Total Assets = $295,478; Retained Earnings 12/31/20XX = $105,363.]

8. Use General Journal sheet WP-11 through WP-14 to prepare closing entries. Post these closing entries to the General Ledger. (After this step is completed, all of your revenue accounts, expense accounts, and the dividend account should have a balance of –0-.)

The trial balance of Veggies-R-Us., at December 31, 20XX, and the data needed for the year-end adjustments follow. (Round all results to the nearest whole dollar amount.)

  1. The dollar value of supplies on hand at year end = $5,250; this was determined after taking a physical inventory.

  2. Prepaid rent still in force at December 31, $900.

  3. Depreciation on furniture for the year, $210.

  4. Depreciation on building for the year, $1,980.

  5. Depreciation on equipment for the year, $1,125.

  6. At the end of the year, Veggies-R-Us. owed P-Tato $480 and $820 to other employees of the company for work performed during the year just ended.

  7. Unearned revenue, customer deposits still unearned at December 31 was $3,125.

  8. Veggies-R-Us. uses the allowance method to determine their bad debt expense. The allowance for bad debts is based upon the balance in accounts receivable. Based upon past experience Veggies-R-Us. uses the rate of 0.75% (.0075) of accounts receivable to determine the appropriate balance in the Allowance for Doubtful accounts. Round the balance in this allowance account (your calculated year end balance) to the nearest whole dollar.

  9. Bonds payable info: The principal amount (a.k.a. face value, par value, stated value) of these bonds = $150,000. These bonds have a 10 year term. The stated rate (a.k.a. contract rate, nominal rate, contract rate) of interest on these bonds = 5%. Theses bonds are dated July 1, 20XX (current year) and were sold on July 1, 20XX (current year) for the sum of $156,000.

Interest on these bonds is to be paid semi-annually on January 1 and July 1 of each year. An entry needs to be made for December 31’s accrued interest due and for the appropriate amount relating to the amortization of the premium (use straight-line amortization for this premium). A check will be written and issued for the appropriate amount of interest due on January 1. (Check out your textbook pages 594 – 597)

  1. The investments that A. Duck Ponds currently has in their investment account (current asset) represents investments that were purchased recently. Based upon stock market quotes obtained for December 31, the market value of these investments = $112,000. (Consider these to be trading securities – pg 632-633 of your textbook)

Account Title

Debit

Credit

Cash

$26,750

Accounts receivable

47,630

Allowance for doubtful accounts

250

Prepaid rent

1,680

Supplies

8,700

Investments

113,520

Furniture

15,350

Accumulated depreciation-furniture

12,800

Equipment

44,600

Accumulated depreciation-equipment

1,830

Building

89,900

Accumulated depreciation-building

28,600

Accounts payable

6,240

Salary payable

Unearned revenue, customer deposits

25,500

Bonds payable

150,000

Premium of bonds payable

6,000

Common stock

20,000

Retained earnings

54,920

Dividends

5,250

Revenue

132,400

Salary expense

51,600

Rent expense

5,000

Utilities expense

10,410

Depreciation expense-furniture

0

Depreciation expense-equipment

0

Depreciation expense-building

0

Advertising expense

5,650

Supplies expense

12,000

Bad debts expense

0

Interest expense

0

Total

$438,290

$438,290

Solutions

Expert Solution

INCOME STATEMENT
Amount Amount
Revenue $           154,775
Salary Expense $         52,420 Bond Premium $                   300
Rent Expense $            5,780
Utilities expense $         10,410
Depreciation Exp-Furniture $               210
Depreciation Exp-Equipment $            1,125
Depreciation Exp-Building $            1,980
Advertising Expense $            5,650
Supplies Expense $         12,000
Bad Debts Expense $               107
Interest Expense $            3,750
Loss on Supplies $            3,450
Loss on Investment $            1,520
P-Tato Service $               480
$               500
Net profit $         55,693
$       155,075 $           155,075
BALANCE SHEET
Amount Amount
Cash $              26,750 Accounts Payable $                 6,720
Accounts Receivable $              47,630 Salary Payable $                    820
Allowence for B/Debts $                 (357) Unearned Revenue $                 3,125
Prepaid Rent $                    900 Bonds Payable $            150,000
Supplies $                5,250 Premium of Bond $                 5,700
Investments $           112,000 Common Stock $              20,000
Furniture $              15,350 Interest Payable $                 3,750
Acc.Depreciation $           (13,010)
Equipment $              44,600 Retained Earnings $            105,363
Acc.Depreciation $              (2,955)
Building $              89,900
Acc.Depreciation $           (30,580)
$           295,478 $            295,478

This is just a simple solution by drawing the Income Statement and Balance Sheet for the question. This would take to a lot of time to explain each one of them and their journal entries.


Related Solutions

The Revenue account balance of $42 000 was listed on the trial balance as a debit....
The Revenue account balance of $42 000 was listed on the trial balance as a debit. How much is the balance sheet off by, and is the debits more than the credits?
GENERAL INSTRUCTIONS FOR JANUARY 1) Journalize the transactions listed below and on the next page and...
GENERAL INSTRUCTIONS FOR JANUARY 1) Journalize the transactions listed below and on the next page and post to the ledger accounts. Omit explanations. 2) Prepare an unadjusted trial balance. 3) Journalize the adjusting entries and post to the general ledger. Adjustment data are provided on the next page. 4) Prepare an adjusted trial balance. 5) Prepare a schedule of accounts receivable. List the balance of each customer account with a balance and total the balances. Compare the total to the...
The trial balance of Winsor Corporation is reproduced on the following page. The information below is...
The trial balance of Winsor Corporation is reproduced on the following page. The information below is relevant to the preparation of adjusting entries needed to both properly match revenues and expenses for the period and reflect the proper balances in the real and nominal accounts. As the accountant for Winsor Corporation, you are to prepare adjusting entries based on the following data, entering the adjustments on the work sheet and completing the additional columns with respect to the income statement...
The trial balance for K and J Nursery, Inc., listed the following account balances at December...
The trial balance for K and J Nursery, Inc., listed the following account balances at December 31, 2018, the end of its fiscal year: cash, $24,000; accounts receivable, $19,000; inventories, $33,000; equipment (net), $88,000; accounts payable, $22,000; wages payable, $9,000; interest payable, $5,000; note payable (due in 18 months), $38,000; common stock, $66,000. Prepare a classified balance sheet for K and J Nursery, Inc. The equipment originally cost $155,000.
Ppt 4 acct 1 P247 Using the account information in the following adjusted trial balance for...
Ppt 4 acct 1 P247 Using the account information in the following adjusted trial balance for Melodies piano school: Prepare the closing entries for December 31, 2017 Post the closing entries Prepare the post closing trial balance at December 31, 2017 Melodies Piano School Adjusted Trial Balance December 31, 2017 Debit Credit Cash $7,000 Accounts receivable 3000 piano 31000 Accumulated depreciation, piano $27,000 Salaries payable 700 Melodie Martin , capital 17200 Melodie Martin, withdrawals 2300 Teaching revenue 38000 Salaries expense...
Q. From the following information in Trial balance   prepare Trading, Profit and Loss Account and Balance...
Q. From the following information in Trial balance   prepare Trading, Profit and Loss Account and Balance Sheet of the company as on 31st December 2020. Particulars Dr. Amount (Dhs) Cr. Amount (Dhs) Capital Purchases Purchase Returns Sales Sales Returns Opening Stock Cash in Hand Salaries Rent Commission received Drawings Wages General Expenses Creditors Debtors Machinery Furniture Land and Building Bank Loan 200,000 50,000 90,000 65,000 35,000 30,000 20,000 50,000 15,000 100,000 65,000 50,000             170,000 300,000 10,000 310,000 20,000 145,000...
Panther Marine Instructions: Using the "June 30, 2017 adjusted trial balance" information AND statement of retained...
Panther Marine Instructions: Using the "June 30, 2017 adjusted trial balance" information AND statement of retained earnings complete a classified balance sheet. Round all amounts to the nearest cent. The rest of the formatting is up to the student. Note that grades are based on organization and clarity of this financial statement. The only other requirements are the following items: a. ONLY use accounts that have adjusted balances b. Proper report title c. Classified asset categories: current assets; Property, Plant,...
1. The trial balance will include a.the ending balance of each account. b.only the debits of...
1. The trial balance will include a.the ending balance of each account. b.only the debits of each account. c.only the credits of each account. 2. The unadjusted trial balance is prepared a.prior to determining the account balance in the ledger. b.after the journal entries are posted. c.prior to posting the journal entries. d.only if errors are suspected. d.only balance sheet accounts.
Question 1 Follow the instructions on page 7, using your Pie Plate Demonstrator to answer the...
Question 1 Follow the instructions on page 7, using your Pie Plate Demonstrator to answer the following questions. In this experiment, we assume the foam plate has a positive charge when rubbed with paper towels. Lift the pan away from the charged plate using the styrofoam cup. Briefly touch the rim of the pan to neutralize it. Place the neutralized pan on the plate and observe the tape rise. When the pan is on the plate, the rim of the...
Lasko Trial Balance as of 12/31/17 each account has a normal balance. Use this financial information...
Lasko Trial Balance as of 12/31/17 each account has a normal balance. Use this financial information to answer the questions below. Unearned Revenue $25,000 Supplies $15,500 Sales $140,000 Salaries Expense $22,000 Retained Earnings $29,000 Rent Expense $18,600 Additional Paid in Capital $76,000 Insurance Expense $4,500 Prepaid Insurance $6,000 Office Equipment $50,000 Notes Payable (Due 06/30/2018) $12,000 Dividends $5,000 Cost of Goods Sold $72,400 Cash $80,000 Capital Stock $1 par $4,000 Accumulated Depreciation $15,000 Accounts Receivable $72,000 Depreciation Expense $5,000 Accounts...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT