top of page
  • BAE

Advantages and disadvantages using Excel spreadsheets for preparing financial reports

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 (worksheet) Adjusting entries Income statement for the year ending June 30,2018 Changes in equity for the year ending June 30,2018 Balance sheet for the year ending June 30,2018.


Part A. Copy Table 1 to the Trial Balance excel sheet and complete the worksheet.


B. Prepare the adjusting entries of AAA Services, below relevant information for the preparation of adjusting entries of AAA at 30 of June 2018 Office supplies having original cost $8640were unused till the end of the period. Office supplies having original cost of $45,600 are shown on unadjusted trial balance.Prepaid rent of $72,000 was paid for the months June, July and August. The equipment costing $160,000 has useful life of 10 years and its estimated salvage value is $28,000. Depreciation is provided using the straight line depreciation method assume that this equipment acquired on 1st of July 2017. The interest rate on $40,000 note payable is 9%. Accrue the interest for one month. $3,000 worth of service has been provided to the customer who paid advance amount of $4,000.


C. Prepare an income statement on the Income statement excel sheet.


D. Prepare a statement of changes in equity on the Changes in equity excel sheet


E. Prepare a balance sheet on the Balance sheet excel sheet.


F. What are the advantages and disadvantages using Excel spreadsheets for preparing financial reports? Give academic references to justify your answers. Type your answers on excel sheet Part F in NOT more than 500 words

Recent Posts

See All

Comments


bottom of page