Accounting for Management M 5011
SP3 2016
Problem Solving Assessment
Learning Objectives addressed in this assessment:
CO1: Apply basic accounting principles and concepts in order to understand what accounting information is, what it means and how it is used;
CO2: Explain the significance of accounting information in the business environment;
CO3: Read and interpret financial reports and apply knowledge to critically analyse corporate financial and non-financial information.
Graduate Qualities developed by this assessment:
GQ1: You need to operate effectively upon fundamental accounting practical knowledge;
GQ2: You are prepared for lifelong learning and professional practice;
GQ3: You are working to be an effective business related problem solver;
GQ4 (partial): You can work autonomously and independently;
GQ5 (partial): You are committed to ethical action & social responsibility for business activities.
GQ6 (partial): You can communicate effectively in written language.
Assignment context:
You have recently joined Business Smart, a financial and business consultation firm. Your manager James Brown will take family leave for four weeks. He has asked you to prepare a consultation report for an important client, HIGH Energy Ltd, before he returns on 19 May.
HIGH Energy Ltd is a fast growing company utilising national and global resources to provide a variety of energy solutions to South Australian businesses. Despite rapid business expansion and integration of energy sales and services, the company’s accounting and reporting quality is of concern. The Chartered Accountants Australia and New Zealand (CAANZ) Adelaide Branch has recently completed a survey of financial reporting by HIGH Energy Ltd and found that the company’s accounting records were incomplete and in particular the recognition of revenues and expenses was not consistent with accrual accounting.
The Managing Director of HIGH Energy, Matthew Rice, was unhappy about these results and asked Business Wealth to reorganise the accounting records and financial statements for February and March 2016, and report any issue of concern about the business performance. In addition, the company has been under public scrutiny recently because of its high carbon emissions and the associated financial risk. As a response, Matthew is thinking about reporting on HIGH Energy’s environmental protection activities including recent investment in renewable energy such as solar, wind and biomass.
You are given the following account information from the Balance Sheet of 31 January 2016.
Accounts
Cash and cash equivalents $72,300,000
Accounts Receivable1 $88,050,000 + the last 4 digits of your student ID number2
Inventories3 $191,000,000
Prepayments $86,490,000
Property, Plant and Equipment4 $975,050,000
Accounts Payable5 $66,900,000 + your date of birth (ddmm)6
Bank Loan $356,800,000 Share Capital $915,550,000 Retained Profit $ ?
Notes to the above information:
1 Trade and other receivables are all included in Accounts Receivable.
2 For example, if your student ID number is 110101234, then this figure should be $88,051,234. If the last digit of your student number is a letter, then the 4 digits before the letter should be used. For example, if your student number is 00034321N, then Accounts Receivable should be $88,054,321.
3 Inventories include all raw materials, work-in-progress and finished goods.
4 Property, Plant and Equipment (PPE) is a net amount. The original cost of PPE is $1,324,507,500 and accumulated depreciation is $349,457,500.
5 Trade and other payables such as expenses payable are all included in Accounts Payable.
6 For example, if your date of birth is June 5, then this figure should be $66,900,506; if your date of birth is November 29, then this should be $66,902,911.
During February and March, HIGH Energy has made the aggregated transactions as follows:
1 February A premium of $960,000 was paid in cash for business insurance.
3 Raised share capital of $18,375,500 cash to the business account.
9 Invoiced customers for services completed and received cash payment of $260,600. The balance of $760,600 would be received in 30 days.
12 Received $42,510,325 payment from customers who were billed
previously.
15 Paid salary and wages totalling $1,755,000.
22 Paid suppliers $789,620 for inventories purchased last month.
25 An environmental director was hired to commence work on 1 April.
26 Received a $330,000 bill from a local radio for advertising.
1 March Purchased new operation equipment for $8,017,200 on credit, payment to be made in 90 days.
4 Sold energy products for $509,200 on credit, payment to be received in
60 days. The cost of these inventories was $460,800.
9 Received the outstanding balance for services provided on 9 February.
15 Paid salary and wages totalling $1,755,000.
16 Applied for an “Energy Excellence” grant of $800,000 from the South
Australian Government and the result was expected to be announced at the “Award Night” on 1 May.
19 Invoiced customers for energy supply $9,345,600, payment to be
received in 30 days.
22 Paid the bill received on 26 February.
31 Paid interest of $450,500 on bank loan. It was noted that repayment of $105,500,000 of bank loan would be due in three months and the remainder would be due in five years.
To take CAANZ’s advice into account, you have paid specific attention to income and expenses recognition. You want to make sure they are consistent with accrual accounting. In preparing the analysis and adjustments, you have collected additional information as follows:
(1) The insurance premium paid on 1 February was for 12 months.
(2) Salary was paid on the 15th of each month. So half of the monthly salary and wages were accrued on 31 March.
(3) It was estimated that the February and March depreciation of Property, Plant and Equipment (PPE) stated on the initial balance was $202,000.
(4) The new equipment purchased on 1 March was expected to have a useful life of 20 years with an estimated residual value of $817,200. Straight line method was applied for depreciation.
To better understand the business performance of HIGH Energy Ltd, you decide to benchmark its performance against another company with a similar profile in the energy industry and prepare a comparative report.
Required:
1. Work out Retained Profit on 31 January 2016;
2. Prepare a worksheet outlining the transactions of HIGH Energy Ltd in February and March 2016. Ignore tax. (Your worksheet should include the initial balances and the adjustments where necessary according to the additional information collected)
3. Prepare an income statement for the period from 1 February to 31 March 2016;
4. Prepare a classified balance sheet as at 31 March 2016;
5. Prepare a classified cash flow statement for the period from 1 February to 31 March 2016;
6. Explain what the above financial statements indicate about the financial position and performance of HIGH Energy Ltd.
7. Select a benchmarking company for further analysis. You need to choose a company from a list of Selected ASX Listed Companies provided as a separate file under Assignment on the course website. Assume the company selected represents the industry average and can be used as a benchmarking company. The name of the company selected should begin with the same letter of the alphabet as your own name, e.g. if your name is Allen Moore, you can use either ADX Energy Limited or Mission Newenergy Limited. If you cannot find an appropriate company match for your name, you may randomly select a company from the list but you need to clearly explain in your assignment why the companies that follow the same letter in your name are not used.
Then go to the company information database DatAnalysis Premium via the UniSA Library website. Under Company Reports, search the company according to its ASX Code or part of the company name. Go to Financial Data to review the company’s financial statements in 2015 (if a 2015 report is not available, you can use the 2014 report). Analyse and compare the financial results of this benchmarking company and HIGH Energy Ltd. Your focus should cover the following points:
1) Which company is more profitable and generates healthier returns?
2) How well are the two companies managing their resources? Do you think they are efficient in managing their assets?
3) Can they meet their short term and long term debts?
8. Go to Annual Reports to review the most recent reports (preferably the past three years) of the selected benchmarking company. Are there any additional issues of concern related to this benchmarking company’s financial position and performance? Discuss how these additional issues and evidence disclosed in the annual reports may influence your interpretation and comparative results?
9. Does the benchmarking company produce any report or information about environmental issues such as carbon emissions or renewable energy? Do you think HIGH Energy Ltd should follow what the benchmarking company is doing? Do you agree with Matthew’s view about reporting on environmental activities and investment in energy solutions? Explain.
Submission Notes:
• Your assignment must be presented in a clear report format, including introduction and conclusion, and with correct grammar, expression and in-text referencing. Read Writing Reports Guide on the course Learnonline website before submission.
• All assignments must be submitted online. Hard copies of assignment are NOT accepted.
• Please submit one single Word Document only. Please do not attach the assignment cover sheet. Instead, clearly indicate your name and student ID on the first page of the submission. This is to avoid high similarity of the assignment cover sheets reported in Turnitin.
• The length of this assignment should not exceed 2,400 words (excluding title page, table of contents, executive summary/abstract, endnote/footnote, appendix and reference list). However, the 2,400 word limit does NOT apply to calculation questions (i.e. Requirements 1 – 5). Generally, these calculation questions are treated as being equivalent to 400 words in total. Therefore, the word limit for the theory questions (i.e. Requirements 6 – 9) is 2,000 words.
• You are required to use the Harvard Referencing style. The minimum number of references for this assignment is five (including the textbook). If you are not sure about the referencing style, please read the Referencing guide on the course Learnonline website.
• Marks are allocated for correct answers, but ‘consequential’ errors are not penalised (for example, if you make an error in an entry, which flows through to the financial statements, you do not lose marks again).
• Marks are also allocated for correct presentation and formatting of financial statements. Marks are deducted for poor presentation of the assignment as a whole.
• You may ask your lecturer/tutor for help when studying this assignment, but they will only answer general questions and will not ‘check’ student answers to the assignment. You may only discuss the assignment with other students at a general or conceptual level, that is, you may talk about the issues, not the details.
• You should not prepare your assignment together with other students, nor should you compare your final answers with other students. It is NOT acceptable to share files, templates, or electronic versions of assignment questions with other students. To ensure Academic Integrity, all submissions will be checked through Turnitin databases which include online publications, internet resources and past student submissions.
• Remember, this is an individual assignment and must be all your own work. If you present material that is not all your own work you have engaged in academic dishonesty which is taken very seriously and dealt with very severely. Refer to the Academic Integrity section of the Learnonline course website.
• Due date: Wednesday, 18 May 2016, 10pm