Question

In: Accounting

Balance Sheet:   The following is the ending balances of accounts at June 30, 2017 for WorkBee...

Balance Sheet:  

The following is the ending balances of accounts at June 30, 2017 for WorkBee Company.

Account Title

Debits

Credits

Cash

148,000

Accounts receivable

280,000

Prepaid expenses

35,000

Land

72,000

Buildings

320,000

Accumulated depreciation—buildings

160,000

Investments

265,000

Salaries Payable

120,000

Accounts payable

173,000

Deferred Revenue

45,000

Notes payable

100,000

Mortgage payable

250,000

Common stock

100,000

Retained earnings

172,000

Totals

1,120,000

1,120,000

Additional Information:

1. The accounts receivable account consists of the following:

a. Amounts owed by customers

$225,000

b. Allowance for uncollectible accounts—trade customers

(15,000)

c. Nontrade note receivable (due in three years)

65,000

d. Interest receivable on note (due in four months)

5,000

??Total

$280,000

2. The notes payable account consists of two notes of $50,000 each. One note is due on September 30, 2017, and the other is due on November 30, 2018.

3. The mortgage payable is payable in semiannual installments of $5,000 each plus interest. The next payment is due on October 31, 2017. Interest has been properly accrued and is included in accrued expenses.

4. Five hundred thousand shares of no par common stock are authorized, of which 200,000 shares have been issued and are outstanding.

5.The land account includes $50,000 representing the cost of the land on which the company's office building resides. The remaining $25,000 is the cost of land that the company is holding for investment purposes.

6.Deferred revenue will be recognized as revenue equally over the next two fiscal years.

7.The note payable is due in annual installments of $1,000 each.

8.Investments include $65,000 in Treasury bills purchased on November 30, 2016. The bills mature on January 30, 2018. The remaining $200,000 includes investments in marketable equity securities that the company intends to sell in the next year.

9.Prepaid expenses include $12,000 paid on December 31, 2016, for a two-year insurance plan on the assets.

10.Cash includes a $20,000 amount for compensating balance at the bank, and $50,000 cash put aside for sinking fund in support of a planned future bond issuance.

Required:

Prepare a well classified balance sheet for the WorkBee Company at June 30, 2017.

Solutions

Expert Solution

Classified Balance sheet of Work bee Company at june 30, 2017 is under

WorkBee Company
As of June 30, 2017
Assets Amount ($)  
Current Assets
Cash
Cash in hand           78,000
Cash at bank           20,000
Sinking Fund investment           50,000
Accounts Receivable- Net of bad debt        2,10,000
Inventory
Investments        2,00,000
Prepaid Expenses           23,000
Land- Current Investment           25,000
Interest Receivable             5,000
Total Current Assets       6,11,000
Fixed Assets
Building        3,20,000
Land           47,000
Leasehold Improvements
Accumulated Depreciation       -1,60,000
Total Fixed Assets       2,07,000
Investment           65,000
Non Current Assets
Prepaid Insurance           12,000
Notes Receivable - Non current           65,000
Total Non Current Assets       1,42,000
Total Assets:       9,60,000
Liabilities Amount
Current Liabilities
Account s Payable        1,73,000
Salary Payable        1,20,000
Deferred Revenue           45,000
Notes Payable -Current Portion           62,000
Mortgages payable -Current Portion           10,000
Total Current Liabilities       4,10,000
Long-term Liabilities
Mortgages payable        2,40,000
Notes payable           38,000
Total Long-term Liabilities       2,78,000
Total Liabilities       6,88,000
Owner's Equity
Common Stock        1,00,000
Additional Paid-in Capital
Owner's Equity       1,00,000
Retained Earnings        1,72,000
Total Owner's Equity       2,72,000
Total Liabilities and Owner's Equity       9,60,000

Related Solutions

The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 91,000 Short-term investments 73,000 Accounts receivable (net) 288,000 Prepaid expenses (for the next 12 months) 40,000 Land 83,000 Buildings 328,000 Accumulated depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 124,000 Accounts payable 177,000 Accrued liabilities 49,000 Notes payable 108,000 Mortgage payable 210,000 Common stock 140,000 Retained earnings 200,000 Totals $ 1,172,000 $ 1,172,000 Additional information: The short-term investments account includes...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2021, for Excell Company. Account Title Debits Credits Cash $ 91,000 Short-term investments 73,000 Accounts receivable (net) 288,000 Prepaid expenses (for the next 12 months) 40,000 Land 83,000 Buildings 328,000 Accumulated depreciation—buildings $ 164,000 Equipment 269,000 Accumulated depreciation—equipment 124,000 Accounts payable 177,000 Accrued liabilities 49,000 Notes payable 108,000 Mortgage payable 210,000 Common stock 140,000 Retained earnings 200,000 Totals $ 1,172,000 $ 1,172,000 Additional information: The short-term investments account includes...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account...
The following is the ending balances of accounts at June 30, 2018 for Excell Company. Account Title Debits Credits Cash $ 121,000 Short-term investments 103,000 Accounts receivable 318,000 Prepaid expenses 70,000 Land 113,000 Buildings 358,000 Accumulated depreciation—buildings $ 179,000 Equipment 284,000 Accumulated depreciation—equipment 139,000 Accounts payable 192,000 Accrued expenses 64,000 Notes payable 138,000 Mortgage payable 320,000 Common stock 290,000 Retained earnings 45,000 Totals $ 1,367,000 $ 1,367,000 Additional information: The short-term investments account includes $37,000 in U.S. treasury bills purchased...
The draft accounts for the year ended 30 June 2019 and a balance sheet as at...
The draft accounts for the year ended 30 June 2019 and a balance sheet as at that date for W. Willow are submitted to you. Towards the end of the financial year, her accountant resigned and she had completed the records herself. She thinks that errors have occurred and asks for your help. An examination of the accounting records reveals the following. W. Willow is registered for GST. Required: (a) Show the journal entries required to make the necessary adjustments....
The draft accounts for the year ended 30 June 2015 and a balance sheet as at...
The draft accounts for the year ended 30 June 2015 and a balance sheet as at that date for Thomson are submitted to you. Towards the end of the financial year, her accountant resigned, and she had completed the records herself. He thinks that errors have occurred and asks for your help. An examination of the accounting records reveals the following Thomson is registered for GST. Required; Show the journal entries required to make the necessary adjustments. Interest of $1920...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 30th June 2020 ‘000 30th June 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 2020 ‘000 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft 24 22.80 Accounts Payable...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020...
The balances in the accounts of Maybe Ltd at 30 June 2019 and 30 June 2020 are: 30th JUNE 2020 ‘000 30th JUNE 2019 ‘000 Sales (all on credit) 300 420 Cost of Goods Sold 156 132 Doubtful Debts expense 30 36 Interest Expense 24 36 Salaries 36 30 Depreciation 12 18 Cash 172.80 166.80 Inventory 216 192 Accounts Receivable 324 300 Allowance for Doubtful Debts 36 42 Land 180 180 Plant 120 108 Accumulated Depreciation 24 36 Bank Overdraft...
Create Journal entries for the following: Account Balances June 30, 2016 June 30, 2017 Debits Cash...
Create Journal entries for the following: Account Balances June 30, 2016 June 30, 2017 Debits Cash $       361,700 $       880,550 Accounts Receivable           100,000           125,000 Marketable Securities (at cost)              11,700              13,000 Allowance for Change in Value                1,500                1,800 Construction in Process           168,750           405,000 Prepaid Expenses              45,000              10,000 Investments (long-term)                        -                13,500 Leased Equipment                        -                20,000 Building              30,000                        -   Deferred tax asset                5,375                2,200...
The following is a list of balance sheet accounts and balances (in random order) for the...
The following is a list of balance sheet accounts and balances (in random order) for the Nathan Supply Company as of December 31, 2017. Prepare a classified balance sheet for Nathan Supply Company. Equipment $32000 Land 20,000 Retained Earnings 40,000 Note Payable (Due in 5 years) 17,000 Inventory 60,000 Allowance for Doubtful Accounts 1,000 Accounts Payable 36,000 Common Stock 30,000 Salaries Payable 10,000 Accumulated Depreciation 14,000 Cash 10,000 Accounts Receivable 26,000      Nathan Supply Company Balance sheet As of December...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT