Prepare a classified balance sheet as at 31 march 2016

Assignment Help Accounting Basics
Reference no: EM131050871 , Length: word count:2400

Learning Objectives addressed in this assessment:

1. Apply basic accounting principles and concepts in order to understand what accounting information is, what it means and how it is used;

2. Explain the significance of accounting information in the business environment;

3. Read and interpret financial reports and apply knowledge to critically analyse corporate financial and non-financial information.

Graduate Qualities developed by this assessment:

1: You need to operate effectively upon fundamental accounting practical knowledge; GQ2: You are prepared for lifelong learning and professional practice;

2: You are working to be an effective business related problem solver; GQ4 (partial): You can work autonomously and independently;

3 (partial): You are committed to ethical action & social responsibility for business activities.

4 (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 number

Inventories                                  $191,000,000

Prepayments                                $86,490,000 Property,

Plant and Equipment                      $975,050,000

Accounts Payable                         $66,900,000 + your date of birth (ddmm)

Bank Loan                                    $356,800,000

Share Capital                                $915,550,000

Retained Profit                               $       ?

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.

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:

The insurance premium paid on 1 February was for 12 months.

Salary was paid on the 15th of each month. So half of the monthly salary and wages were accrued on 31 March.

It was estimated that the February and March depreciation of Property, Plant and Equipment (PPE) stated on the initial balance was $202,000.

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.

Student Comments: Australian student, 2400 words, need it as per the guidelines

Reference no: EM131050871

Questions Cloud

Case study bumble bee : In an order dated April 14, 1091, the Honorable Billy I. Bob, States Magistrate Judge for the District of Neverland, requested an opinion as to whether Bee Bumble is competent to stand trial under the provisions of Title 18, U.S. Code, Section 4241. ..
Identify some commercial tools that allow users : Identify some commercial tools that allow users to conduct browsing, communication, and collaboration simultaneously. Explain why the topic of group work and its support has gotten increased attention.
Example of pollution : Julia is worried about the rising pollution levels in her city. She doesn't mind paying extra for goods and services that use sustainable processes to help control pollution. This is an example of ________ for pollution.
Write a paper of a risk management plan : Write a paper of no more than 1,750 words following the outline of a risk management plan. Refer to the Risk Management Plan Outline as an example of what the outline must look like. The word count includes tables.
Prepare a classified balance sheet as at 31 march 2016 : Accounting for Management M 5011 - Prepare a worksheet outlining the transactions of HIGH Energy Ltd in February and March 2016. Ignore tax.
Traditional warehousing strategy : Consider a large discount store. Discuss some products and suppliers for which the discount store should use a cross-docking strategy; some products and suppliers better suited to a direct-shipment strategy; and, finally, some products and supplie..
Construct time series plot : a. Construct time series plot. What type of pattern exists in the data? b. Use simple linear regression analysis to find the parameters for the line minimizes MSE for this time series. c. What is the forecast for t=8?
What role did culture play in the negotiation process : Analyze the situation using the concepts of power, emotions, and culture, and write at least a one-page paper describing how these three theories apply to and impact the outcome of the negotiation among the jurors.
Following situations relate to bolivia company : 1. Bolivia provides a warranty with all its products it sells. It estimates that it will sell 1,000,000 units of its product for the year ended December 31, 2014, and that its total revenue for the product will be $100,000,000.

Reviews

Write a Review

Accounting Basics Questions & Answers

  Discuss the characteristics of npv and the role

Examine and discuss the characteristics of NPV and the role that this method plays in capital investment decision making. In addition, discuss the advantages of using this method instead of the other evaluation methods examined this week.

  Potential impact on the family setting due to the intervent

The potential impact of both the human services professional and the client within the school setting. Format your presentation consistent with APA guidelin

  Differences between two sets of economic phenomena

Identify similarities in and differences between two sets of economic phenomena - Having information available to users before it loses its capacity to influence decisions.

  Define provisions that do not have a cash effect

What is the difference between provisions that have a cash effect and those that do not have a cash effect? How would you define provisions that do not have a cash effect?

  Correct amount of sales revenue and the amount

At the end of the first quarter of operations, when it is time to remit the sales taxes to the state taxing agency, the company has $ 420,000 in the Sales account. Determine the correct amount of sales revenue and the amount of sales tax payable.

  Which equipment should axel select

Axel will purchase the equipment that costs the least, as measured by present value. Which equipment should Axel select? Why?

  Direct write-off method to account for uncollectibles

On January 4, 20X8, the company learned that Mattingly had filed for personal bankruptcy. Harrisburg uses the direct write-off method to account for uncollectibles.

  Income statement and comparative balance sheets

Presented below are the 2013 income statement and comparative balance sheets for Santana Industries.

  The company makes all purchases on credit

Use the data for Valley Company in Problem 5-4 to complete the following requirements.

  Phoenix company reported sales of 430000 for year 1 480000

phoenix company reported sales of 430000 for year 1 480000 for year 2 and 530000 for year 3. using year 1 as the base

  Modos company has deposited 4170 in checks received from

modos company has deposited 4170 in checks received from customers. it has written 1520 in checks to its suppliers. the

  Tylers consulting company has purchased a new 15000 copier

tylers consulting company has purchased a new 15000 copier. this overhead cost will be shared by the purchasing

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd