back to top
Complete the 3 questions given below. A total of 50 marks are allocated to the questions below, which will then be converted to a mark out of 20%.
All workings, where appropriate, must be shown to substantiate your answers.
Question 1 [30 marks]
Preparation of accounting records – using spreadsheets
Flash Cleaning Services commenced operations on 1 July 2018. The company opened a cleaning business – providing cleaning services to local schools, preschools and childcare centres. During its first month of operations, the following transactions occurred:
Additional information as at 31 July 2018:
• Flash Cleaning Services owes wages of $2,200 to employees, for services to 31 July.
• Flash Cleaning Services has invoiced a number of customers for cleanings services provided during July, and needs to accrue service revenue of $12,600.
• Accrued expenses as at 31 July include: fuel ($190) and telephone ($100) for the month of July.
• Supplies on hand at 31 July 2018 amount to $2,100.
• Flash Cleaning Services provided cleaning services to ABC Public School on 28 July 2018, earning $500 of the $5,500 that was paid to Flash Cleaning Services on 25 July 2018.
1. Prepare the journal entries for the twelve transactions listed above that occurred during July 2018. (6 marks)
2. Prepare T-accounts and post all of the above journal entries to the T-accounts. Total all of the T-accounts to determine their balances at the end of the month. (3 marks)
3. Based on the balances in the T-accounts above, prepare the ‘Unadjusted Trial Balance’ in an Excel spreadsheet. (2 marks)
4. Explain what the five types of adjusting entries are. Prepare all of the adjusting entries for Flash Cleaning Services as at 31 July 2018. (6 marks)
5. Using your ‘Unadjusted Trial Balance’ and adjusting entries prepared above, prepare the ten column worksheet in Excel for the month ended 31 July 2018 (refer to page 167 – 171 of the prescribed text for an example of this worksheet). In the spreadsheet, you are required to have a ‘data’ section separated from the ‘worksheet’ section. Use formulas to generate all of the figures in the ‘worksheet’ from the ‘data’ section. Use the IF function for the ‘Profit’ or ‘Loss’ and also to check that the debit and credit columns balance. (5 marks)
6. Using the ten column worksheet prepared above as your ‘data’, prepare the income statement, balance sheet, and statement of changes in equity in Excel. Use formulas to generate all of the figures in the financial statement reports. (6 marks)
7. Calculate and evaluate the business’s current ratio and debt ratio. If Flash Cleaning Services repays the bank loan, how would these ratios change? Do you recommend that the bank loan is repaid? Why or why not. (2 marks)
Please also refer to the 'Requirements' section below for additional submission and spreadsheet requirements.
Question 2 [10 marks]
History of accounting - essay
Prepare an essay discussing the origins of double-entry bookkeeping. Explain why double-entry bookkeeping is so profoundly important in the world of accounting, and how it differs from earlier bookkeeping methods (about 1,000 words in total).
Question 3 [10 marks]
ABC Learning Case Study
Watch the ABC Learning videos (these videos are available on YouTube www.youtube.com/watch and answer the following questions (about 1,000 words in total).
1. Discuss the reasons for ABC Learning’s failure. Were there any warning signs in the company's financial reports that might have indicated that the company was in trouble? (4 marks)
2. Identify and discuss 3 ethical issues from this case study. (6 marks)
back to top
This assessment task will assess the following learning outcome/s:
• be able to apply conceptual and technical aspects of accounting and prepare relevant business financial statements.
• be able to discuss the historical development of accounting.
• be able to appraise the use of information technology including spreadsheet software in accounting problem solving, and evaluate the Internet as a professional resource.
• be able to demonstrate relevant business communication skills including report writing.
• be able to contextualise and evaluate accounting information for decision making purposes.
• be able to explain the importance of ethics in accounting.
In today’s business environment we need verbal skills, writing skills, numeracy skills AND digital literacy skills. All of these skills are assessed throughout this subject. The early questions in this assignment are designed to assess your digital literacy in a business/accounting environment.
This assignment is designed to give you an opportunity to demonstrate knowledge and skills in aspects of accounting and information systems including technical issues as well as concepts such as the accounting equations, cash and accrual accounting, current and non-current assets and liabilities, trial balance, worksheets, income statement, statement of changes in equity, balance sheets and the application of spreadsheet software to the presentation and solution of accounting problems.