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

  How much control does fed have over this longer real rate

Hubbard argues that the Fed can control the Fed funds rate, but the interest rate that is important for the economy is a longer-term real rate of interest.   How much control does the Fed have over this longer real rate?

  Coures:- fundamental accounting principles

Coures:- Fundamental Accounting Principles: - Explain the goals and uses of special journals.

  Accounting problems

Accounting problems,  Draw a detailed timeline incorporating the dividends, calculate    the exact Payback Period  b)   the discounted Payback Period. the IRR,  the NPV, the Profitability Index.

  Write a report on internal controls

Write a report on Internal Controls

  Prepare the bank reconciliation for company

Prepare the bank reconciliation for company.

  Cost-benefit analysis

Create a cost-benefit analysis to evaluate the project

  Theory of interest

Theory of Interest: NPV, IRR, Nominal and Real, Amortization, Sinking Fund, TWRR, DWRR

  Liquidity and profitability

Distinguish between liquidity and profitability.

  What is the expected risk premium on the portfolio

Your Corp, Inc. has a corporate tax rate of 35%. Please calculate their after tax cost of debt expressed as a percentage. Your Corp, Inc. has several outstanding bond issues all of which require semiannual interest payments.

  Simple interest and compound interest

Simple Interest, Compound interest, discount rate, force of interest, AV, PV

  Capm and venture capital

CAPM and Venture Capital

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