Accounting Information Systems Excel Practical assessment
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 attached.
Table 1. Adjusted Trial Balance of John Brown Home Services
Based on information provided above, please complete the following tasks:
Create an excel file and name it as Your_Student_No.xlsx, e.g. S004123456.xlsx. Name each of the excel sheets as:
- Trial Balance,
- Income statement,
- Changes in equity,
- Balance sheet, and
- Part E.
A. Copy Table 1 to the Trial Balance excel sheet and complete the worksheet.
B. Prepare an income statement on the Income statement excel sheet.
C. Prepare a statement of changes in equity on the Changes in equity excel sheet
D. Prepare a balance sheet on the Balance sheet excel sheet.
E. Do you recommend Excel spreadsheets or accounting software for preparing financial reports?
Give 5 reasons to justify your answers. Type your answers on excel sheet Part E in NOT more than 600 words.
Attachment:- Assignment File.rar