Create unadjusted trial balance in Trial Balance Worksheet

Assignment Help Accounting Basics
Reference no: EM132696445

Question - Bee-Kind Hives provides residential and commercial hive services. Its balance sheet at the end of July 2019 is shown below, along with its chart of accounts.

Bee-Kind Hives Balance Sheet As at July 31, 2019

Assets Liabilities

Cash $5,580 Accounts Payable $12,800

Accounts Receivable 4,000 Unearned Revenue 6,200

Prepaid Insurance 1,800 Bank Loan 20,000

Equipment 52,000 Total Liabilities 39,000

Owner's Equity

Fred, Capital 24,380

Total Assets $63,380 Total Liabilities and Owner's Equity $63,380

Account Description Account # Account Description Account #

ASSETS REVENUE

Cash 101 Sales 400

Accounts Receivable 105

Prepaid Insurance 110 EXPENSES

Equipment 120 Advertising Expense 500

Accum. Depreciation - Equip 125 Depreciation Expense 510

Insurance Expense 515

LIABILITIES Interest Expense 520

Accounts Payable 200 Salaries Expense 545

Interest Payable 205 Telephone Expense 550

Salary Payable 210

Unearned Revenue 215

Bank Loan 220

OWNER'S EQUITY

Fred, Capital 300

Fred, Withdrawals 310

Income Summary 315

For the month of August 2019, Bee-Kind Hives had the following transactions:

Aug 1 The owner invested $4,000 cash into the business

Aug 2 Received an advertising bill for $500, which will be paid next month

Aug 5 Purchased equipment with $6,200 cash

Aug 7 Received $1,530 cash for work that will be provided in August

Aug 8 Paid the $150 telephone bill with cash

Aug 10 Provided $5,680 worth of honey to customers who will pay later

Aug 20 Received $2,000 in payment from customers paying their accounts

Aug 22 Paid $1,500 toward accounts payable

Aug 24 Paid $1,100 toward principal of the bank loan

Aug 28 Paid salary of $2,000 to an employee

Aug 30 The owner withdrew $1,500 cash for personal use

At the end of August, the following adjustments had to be journalized to properly report the balances of the company's accounts.

Aug 31 One month of prepaid insurance worth $100 has been used

Aug 31 Monthly depreciation on the equipment was $400

Aug 31 Unearned revenue worth $420 has now been earned

Aug 31 Interest of $75 has accrued on the bank loan

Aug 31 Accrued salary expense of $500 for an employee

Note: Of the remaining balance of the bank loan, $5,000 will be paid within the next year.

Required -

a) Enter the opening balances from the July 2019 balance sheet into general ledger accounts.

b) Prepare the journal entries for the month of August and post them to the appropriate general ledger accounts.

c) Create an unadjusted trial balance in a Trial Balance Worksheet and then complete the month end adjustments and the adjusted trial balance columns of the worksheet.

d) Post the month end adjustments to the appropriate general ledger accounts.

e) Prepare the income statement.

f) Prepare the statement of owner's equity.

g) Prepare the classified balance sheet.

h) Prepare the journal entries to close the books for the month of August 2019 (use the income summary account) and post the journal entries to the appropriate general ledger accounts.

i) Create the post-closing trial balance.

j) Calculate Working Capital and the Current Ratio for August and explain what this means for Bee-Kind Hives.

Reference no: EM132696445

Questions Cloud

Prepare necessary entries in general journal form for abc co : Prepare all necessary entries in general journal form for ABC Co. Accounts receivable of €60,000 (gross) are factored with BFO Credit
Identify the managerial function of hr managers : Identify the managerial function' out of the following functions of HR managers? Procurement, Development, Performance appraisal.
Bitcoins as standard form of currency : Search the Internet and explain why some organizations are accepting and other organizations are rejecting the use of Bitcoins as a standard form of currency.
Compute the inventory for the company as of january : Compute the inventory for this company as of January 31, at retail prices. Purchases in January: at retail $1,096,000; at cost $660,000
Create unadjusted trial balance in Trial Balance Worksheet : Create an unadjusted trial balance in a Trial Balance Worksheet and then complete the month end adjustments and the adjusted trial balance
Overall risk posture of the organization : What is the risk posture for each particular system as it contributes to the overall risk posture of the organization?
Find what is the project net present value : The annual operating cash flow is $150,000 and the discount rate is 12 percent. What is the project's net present value if the tax rate is 21 percent?
Find the bond equivalent and effective annual yield : Find the bond equivalent and effective annual yield to maturity of the bond if the bond price is $960.
What would be an appropriate journal entry description : What would be an appropriate journal entry description for this transaction? Cr. Allowance for Doubtful Accounts 2,000. Dr. Cash 2,000

Reviews

Write a Review

Accounting Basics Questions & Answers

  Question 1 the following information is available from the

question 1. the following information is available from the comparative balance sheets and related income statement of

  Information about common stockholders

Common stockholders are most concerned with the spread between the return generated onnew investments and the investors required rate of return

  Determine the purpose of studying financial statements

what is the purpose of studying financial statements?support your statements with evidence from the required studies

  Record all entries need related to the unredeemed coupons

Tiger Corporation sold 1,000,000 boxes of cereal under a new sales promotional program. Record all entries need related to the unredeemed coupons at December 31

  Calculate the number of shares issued

Calculate the number of shares issued and the number of shares outstanding on Jan. 1, Mar. 31, June 30, and Sept. 30

  Compute the net present value and profitability index

Compute the (1) net present value, (2) profitability index, and (3) internal rate of return for each option

  Determining the preferred investment

Assuming that investments A and B are equally risky and using the 4% discount rate, apply the present value technique to assess the acceptability.

  Provide two adjusting entry examples

Why is an adjusting entry important? What accounts are adjusted and what accounts are not adjusted? Why? Provide two adjusting entry examples. What do you find difficult about adjusting entries? What is difficult to understand?

  What are the major types of liabilities

How much total liabilities did the city have before and after the bankruptcy? What are the major types of liabilities?

  Prepare the journal entry to correct the error assuming

Prepare the journal entry to correct the error assuming it is discovered before the books are adjusted or closed in 2011. (Ignore income taxes.)

  The financial statements and notes of the company

Refer to the financial statements and notes of the company

  Make the necessary journal entries to recognise

Make the necessary journal entries to recognise the non-controlling interest as at 30 June 2019. calculate the non-controlling interest as at 30 June 2019.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd