Question

In: Accounting

Prepare an adjusted trial balance showing adjustments. Show the adjustments and add any new accounts required because of the adjustments.

Case Background

A sole proprietor (the owner) has established a service business specializing in recruitment for businesses needing specialized Tool Industry staff. The trail balance at the end of the first three months of operations is provided below. Part of the service is to train people before they are placed with companies. The owner has asked, you, the accountant for HR, to prepare the answers to the questions below considering the notes provided.

Trial Balance

Accounts

Debits

Credits

Cash

24,500

Accounts Receivable

10,000

Inventories / Supplies

3.500

Equipment

50,000

Accounts Payable

1,500

Notes Payable

50,000

Capital

15,000

Withdrawals

10,000

Sales

50,000

Salaries

15,000

Advertising

2,000

Accountants Fees

1,500

Total

116,500

116,500




Notes

  1. The owner issued a cheque for $2,000 for insurance for the next three month after discovering there was no insurance in place. The cheque has not been recorded as a reduction of cash to-date. There is no insurance expense for the first three months.

  2. The equipment must be depreciated for three months. The equipment has a service life of 5 years and monthly depreciation is estimated to be $833 a month.

  3. Recorded revenue of $5,000 is unearned and was an advance from a client. This revenue will be earned in the next three months.

  4. Salaries of $15,000 were paid in the first three months. However, $1,000 of salaries should be accrued as employees earned these salaries but will not be paid until the 4th month.

  5. The owner provided services of $2,500, which were not invoiced or billed to clients in the 3rd month but were earned in accordance with the Revenue Principle.

  6. Interest expense (Debit) needs to be recorded at the end of three months. The amount is $750 and should be recorded as a liability in Interest Payable (Credit) on the balance sheet. None of the $50,000 note has been paid to lenders yet. This note will be paid back at the end of 5 years.

  7. Supplies of $1,500 must be expensed to Cost of Goods Sold (i.e., moved out of inventory) and a new accrual of Accounts Payable should be established for $2,000 for supplies ordered at the end of the 3rd month, and not booked to-date.


Questions

  1. Prepare an adjusted trial balance showing adjustments. Show the adjustments and add any new accounts required because of the adjustments. Calculate the current ratio, quick ratio and debt to equity (capital) ratio for the owner.

Solutions

Expert Solution



Related Solutions

Please prepare a full trial balance – Trial Balance, Adjustments,Adjusted Trial Balance, Income Statement, Balance...
Please prepare a full trial balance – Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement, Balance Sheet, and Statement of Owner’s Equity, as well the individual Balance Sheet, Income Statement, and Statement of Owners Equity. Include any journal entries necessary for this assignment. Use T accounts if you find them helpful. Attached are the files for your use. Check your formulas. 1. You are reporting for your client for the One Month period September 30, 2020 2. The started the...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement...
Prepare a worksheet that contains the following columns: Trial Balance, Adjustments, Adjusted Trial Balance, Income Statement and Balance Sheet. From the following transactions as well as add't data, please complete the entire accounting cycle for Parker's Plowing (using the chart of accounts below) for 2018. Jan. 1 Parker invested $10,000 cash and $12,000 worth of snow equipment into the plowing company. Jan. 1 Paid rent for six months in advance for garage space, $6000 Jan. 6 Purchased snow supplies for...
The accounts in the Adjusted Trial Balance (after any adjusting entries) at the end of the...
The accounts in the Adjusted Trial Balance (after any adjusting entries) at the end of the accounting period for Lord Fairfax Entertainment Co. are listed BELOW in alphabetical order. All accounts have normal balances. Accounts Payable $1,000 Accounts Receivable   5,000 Capital Stock/Retained Earnings 10,000 Cash                               7,500 Dividends paid 2,500 Fees Earned 5,000 Supplies (asset) 400 Supplies Expense 600 Wages Expense 1,000 Wages Payable 1,000 Based on the ABOVE information and YOUR calculations, recommend preparing the four POST CLOSING journal...
prepare unadjusted trial balance, adjusted trial balance Accounts Receivable: April 30 1,300 Balance, April 30 1,300...
prepare unadjusted trial balance, adjusted trial balance Accounts Receivable: April 30 1,300 Balance, April 30 1,300 Lawn and Garden Supplies: April 2 6,000 April 24 500 Lawn and Garden Supplies Expense 4,650 Balance, April 30 850 Office Supplies: April 6 500 Office Supplies Expense 350 Balance, April 30 150 Prepaid Rent: April 1 4,000 Rent Expense 1,000 Balance, April 30 3,000 Prepaid Insurance: April 8 1,600 Insurance Expense 400 Balance, April 30 1,200 Security Deposit: Rent April 1 1,500 Balance,...
Prepare the Adjusted Trial Balance Accounts Payable – 65,340 Accounts Receivable – 190,300 Accumulated Depreciation (Building)...
Prepare the Adjusted Trial Balance Accounts Payable – 65,340 Accounts Receivable – 190,300 Accumulated Depreciation (Building) – 5,400 Accumulated Depreciation (Equipment – 29,359 Accumulated other comprehensive income – 15,000 Additional Paid in Capital – Treasury Stock – 21,000 Advertising Expense – 8,400 Allowance for Doubtful Accounts – 25,000 Bad Debt Expense – 25,000 Bonds Interest Expense – 43,088 Bonds Payable - $1,600,000 Building – 150,000 Cash – 1,270,676 Common Stock – 101,000 Depreciation Expense – 33,759 Dividends – 41,000 Employee...
The accounts listed below are for Mustafa, Inc.  Use the Adjusted Trial Balance to prepare the income...
The accounts listed below are for Mustafa, Inc.  Use the Adjusted Trial Balance to prepare the income statement, statement of retained earnings, and classified balance sheet at December 31, 2017.   Debit Credit Cash $6,000 Accounts Receivable $3,120 Prepaid Insurance $2,160 Equipment $5,280 Accumulated Depreciation - Equipment $3,120 Accounts Payable $2,640 Unearned Revenue $1,440 Notes Payable (long-term) $3,600 Common Stock $2,400 Retained Earnings, December 31, 2016 $2,160 Dividends $600 Service Revenue $9,840 Cost of Goods Sold $5,160 Salaries Expense $1,200 Utilities Expense...
Prepare an adjusted trial balance. If an amount Ledger Accounts, Adjusting Entries, Financial Statements, and Closing...
Prepare an adjusted trial balance. If an amount Ledger Accounts, Adjusting Entries, Financial Statements, and Closing Entries; Optional Spreadsheet. The unadjusted trial balance of Recessive Interiors at January 31, 2019, the end of the year, follows: Recessive Interiors Unadjusted Trial Balance January 31, 2019 Debit Balances Credit Balances 11 Cash 13,100 13 Supplies 8,000 14 Prepaid Insurance 7,500 16 Equipment 113,000 17 Accumulated Depreciation—Equipment 12,000 18 Trucks 90,000 19 Accumulated Depreciation—Trucks 27,100 21 Accounts Payable 4,500 31 Jeanne McQuay, Capital...
Question 1 REQUIRED: Given the following Adjusted Trial Balance, prepare a report form Classified Balance Sheet....
Question 1 REQUIRED: Given the following Adjusted Trial Balance, prepare a report form Classified Balance Sheet. Hint: Prior to creating the Balance Sheet, calculate the profit/loss and the owner’s (revised) capital balance as of the end of the year. You may assume there were no investments. Erickson Rentals Adjusted Trial Balance March 31, 2010 Debit Credit Cash 4,000 Accounts Receivable 14,100 Trucks 41,000 Accumulated Depreciation, Trucks 16,500 Equipment 24,000 Accumulated Depreciation, Equipment 11,000 Trademark 10,000 Accounts Payable 3,000 Salaries Payable...
Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement...
Prepare each item: Journal Entries T-Accounts Trial Balance Adjusted Trial Balance Income Statement Retained Earnings Statement Balance Sheet Dinah Soars, Biff Wellington and Duane Pipe are the stockholders of Sharpe Incorporated. The charter of the corporation authorized 500,000 shares of $2 par common stock, and 100,000 shares of $30 par, 4%, preferred stock. As of January 1, 2020, there were 24,000 shares of common stock issued and outstanding and 5,000 shares of preferred stock issued and outstanding. Selected transactions completed...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and...
Create a worksheet showing the unadjusted trial balance, adjusting entries, adjusted trial balance, income statement, and balance sheet included with the data below. Also, create a pivot table. Create a general ledger, worksheet, income statement, changes in retained earnings, and balance sheet with the data below. June 1: Hudson Bloom invested $105,273.00 cash and computer equipment with a fair market value of $32,970.00 in his new business, Byte of Accounting. June 1:   Check # 5000 was used to purchased office...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT