John Brown is the owner of John Brown Home Services. This Company provides service such as cleaning, car details, lawn and gardening to customers in Melbourne. The adjusted trial balance columns of the worksheet for John Brown Home Services are as shown in Table 1 below.

 

Table 1. Adjusted Trial Balance of John Brown Home Services

John Brown Home Services

Worksheet

for the month ended 31 August 2019
Account Adjusted trial balance Income statement Balance Sheet
Debit Credit       Debit   Credit   Debit   Credit  
Cash at Bank $45,000          
Accounts Receivable      19,500          
Prepaid Rent        7,500          
Equipment   37,500          
Accumulated Depreciation     $8,000        
Loan Payable (due Sep 2019)       15,600        
Accounts Payable         9,000        
J. Brown, Capital       80,000        
J. Brown, Drawings            5,500          
Service Revenue      34,000        
Salaries Expense     27,500          
Rent Expense        2,500          
Depreciation Expense   1,600          
Interest Expense         59          
Interest Payable 59
      146,659    146,659        
Profit for this month          
         

 

Based on information provided on page 1, complete the following tasks:

Create an excel file. Name each of the excel sheets as:

  • Trial Balance,
  • Income statement,
  • Changes in equity,
  • Balance sheet, and
  1. Copy Table 1 on page 1 to the Trial Balance excel sheet and complete the worksheet.
  2. Prepare an income statement on the Income statement excel sheet.
  3. Prepare a statement of changes in equity on the Changes in equity excel sheet
  4. Prepare a balance sheet on the Balance sheet excel sheet.
$12.00 – Buy Solution

Click on Buy Solution and make payment. All prices shown above are in USD. Payment supported in all currencies. Price shown above includes the solution of all questions mentioned on this page. Please note that our prices are fixed (do not bargain).

After making payment, solution is available instantly.Solution is available either in Word or Excel format unless otherwise specified.

If your question is slightly different from the above question, please contact us at info@myassignmentguru.com with your version of question.