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
for the month ended 31 August 2019
|Account||Adjusted trial balance||Income statement||Balance Sheet|
|Cash at Bank||$45,000|
|Loan Payable (due Sep 2019)||15,600|
|J. Brown, Capital||80,000|
|J. Brown, Drawings||5,500|
|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
- Copy Table 1 on page 1 to the Trial Balance excel sheet and complete the worksheet.
- Prepare an income statement on the Income statement excel sheet.
- Prepare a statement of changes in equity on the Changes in equity excel sheet
- Prepare a balance sheet on the Balance sheet excel sheet.
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 firstname.lastname@example.org with your version of question.