Prepare a classified balance sheet

Assignment Help Managerial Accounting
Reference no: EM131252324 , Length: word count:2400

Accounting for Management Problem Solving Assignment

This assignment can be completed individually or in a group of no more than 2 students.

Learning Objectives addressed in this assessment:

  • Apply basic accounting principles and concepts in order to understand what accounting information is, what it means and how it is used;
  • Explain the significance of accounting information in the business environment;
  • Read and interpret financial reports and apply knowledge to critically analyse corporate financial and non-financial information.

Graduate Qualities developed by this assessment:

  • You need to operate effectively upon fundamental accounting practical knowledge; GQ2: You are prepared for lifelong learning and professional practice;
  • You are working to be an effective business related problem solver; GQ4 (partial): You can work autonomously and independently;
  • You are committed to ethical action & social responsibility for business activities.
  • You can communicate effectively in written language.

Assignment context:

You have recently joined Business Smart, a financial and business consultation firm. Your manager Mr. James Brown will take family leave for four weeks. He has asked you to prepare a consultation report for an important client, BEST Resources Ltd, before he returns on October 28, 2016.

BEST Resources Ltd is a mining and metallurgical company based in South Australia. Its  main products cover zinc, lead, copper, gold and other nonferrous metals. The company experienced the fastest growth during the recent mining boom but is struggling with slumping overseas demands in these two years.

The main reason for this consultation for BEST Resources Ltd is the concern about the unsatisfactory quality of transaction recording and reporting addressed by the Chartered Accountants Australia and New Zealand (CAANZ). In early June 2016, CAANZ Adelaide Branch completed a survey of financial reporting by BEST Resources Ltd and found that the company's accounting records were incomplete and the recognition of revenues and expenses was not consistent with accrual accounting. The Managing Director of BEST Resources Ltd,

Mr. Peter Cham, was unhappy about these results and asked Business Smart to review the accounting records up to the end of May 2016 and report any inappropriate transaction recording. Based on this review, financial statements for the 2015-16 financial years can be accurately prepared and any issue regarding business performance can be identified.

In addition, the company has been under public scrutiny recently because of its high environmental pollution and energy consumption. As a response, Peter is thinking about reporting on BEST Resources' environmental challenges and corporate strategy on environmental protection. However, several board members are concerned about the risk associated with such reporting. Given that the company may anticipate a couple of lean years ahead because of the economic downturn and end of the mining boom, they argue that the company should focus on the main business areas and regaining profit. The issue is pending.

You are given the following account information from the balance sheet at May 31, 2016.

Accounts

Cash and cash equivalents                       $3,575,000 + your date of birth (ddmm)

Accounts Receivable2                              $28,740,000

Inventories                                             $9,977,000

Prepayments                                          $15,388,000

Property, Plant and Equipment                 $754,316,000

Accounts Payable                                    $45,875,000 + last 4 digits of your student ID number

Bank Loan                                              $278,099,000

Share Capital                                                  ?

Retained Profit                                        $19,646,000

Also, the following information from the income statement stated from July 1, 2015 to May 31, 2016 is provided.

Accounts

Total revenue    $195,830,000

Net profit6          $18,165,000

Gross profit        $150,366,000

Assume during June 2016, BEST Resources made the following aggregated transactions:

1 June - Paid salary and wages of $940,550.

1 - Purchased new operating equipment at a cost of $2,124,000. Residual value was estimated to be zero and the useful life to be 30 years. Payment would be made in 180 days.

3 - Sold inventories for $253,700, payment to be received in 45 days. The cost of these inventories was $183,700.

8 - Received an outstanding balance of $296,880 from customers for inventories sold on 25 April 2016.

11 - Paid suppliers $332,950 for inventories purchased on 12 May.

16 - Recruited a new accountant commencing work on 1 July.

19 - Sold inventories for $398,450 and received cash payment of $50,000. The balance would be received in 45 days, which is the company's normal credit term. The cost of inventories was $308,450.

23 - Issued 1 million shares at $2.5 per share and received funds on the day.

27 - Paid a television advertisement bill of $12,000. The bill was received on May 28, 2016.

30 - Paid monthly interest of $380,780 on bank loan.

To take CAANZ's advice into account, you have paid attention to transaction analysis and records, in particular, the recognition of income and expenses. You want to make sure they are consistent with accrual accounting. In preparing for the analysis, you have collected additional information for the end of year adjustments (BEST Resources uses straight line method for depreciation):

(1) Salary was paid on the 1st of each month. So the salary and wages for the month of June 2016 must be accrued.

(2) On October 1, 2015, an insurance premium of $806,400 was paid and expensed immediately. It was noted that the insurance policy term was 24 months.

(3) The new plant acquired on August 1, 2015 was not depreciated. The total acquisition cost was $11,129,200. The plant was expected to be used for 50 years with an estimated residual value of $737,200.

(4) A physical stock count revealed that inventories as at June 30, 2016 were $9,434,050. There seemed to be some inventory loss.

(5) The electricity consumption of June 2016 was estimated to be $11,200.

(6) It was noted that repayment of $26,350,000 of bank loan would be due in six months and the remainder of bank loan would be due in five years.

(7) One of the company's commercial properties in Adelaide CBD was rented out on July 1, 2015. The lease agreement was signed for 5 years and included annual payments of $80,000 plus a signing-on fee of $100,000 covering the 5-year agreement term. The $180,000 received on July 1 was recorded as rental income.

(8) By the end of June, further depreciation of total Property, Plant and Equipment (PPE) stated on the balance sheet of May 31, 2016 was estimated to be $333,000.

To better understand the business performance of BEST Resources Ltd, you decide to benchmark its performance against another company with a similar profile in the materials industry and prepare a comparative report.

Required:

1. Work out Share Capital in the initial balances provided to you on May 31, 2016;

2. Prepare a worksheet outlining the transactions of BEST Resources Ltd in June 2016. Ignore tax. (Your worksheet should include the balances at the beginning of June and the adjustments according to the additional information collected at the end of June)

3. Prepare a classified balance sheet as at June 30, 2016;

4. What is the net profit of BEST Resources Ltd for the 2015-16 financial year? Comment on its financial performance and financial position in the year.

5. Select a benchmarking company for further analysis. You need to choose a company from a list of Selected ASX Listed Mining 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 name (or your fellow student's name should you do the assignment in pair), e.g. if your name is Allen Moore, you can use either Aspire Mining Limited or Mintails Limited. If you cannot find an appropriate company to analyse, you may randomly select a company from the list but you need to clearly justify the reason.

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 2016 (if a 2016 report is not available, you can use the 2015 report). Based on available data, analyse and compare the financial results of this benchmarking company and BEST Resources Ltd (if no average data is available for  some accounts, you may use year-end data to work out ratios. Ignore tax). 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?

6. 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?

7. Does the benchmarking company produce any report or information about environmental issues such as environmental pollution and energy consumption? Do you think BEST Resources Ltd should follow what the benchmarking company is doing? Do you agree with Peter's view about reporting on environmental challenges or with board members that the company should focus on business growth and regaining profit because of current financial stress and economic downturn? Explain why.

Reference no: EM131252324

Questions Cloud

Difference between an object and an attribute : 1. Why is a Ford automobile a specialisation of a car and an engine is not? 2. What is the difference between an object and an attribute? 3. What is the goal of domain analysis?
How firm operates relative to the characteristics of market : Examine a perfectly competitive firm that you have recently purchased a product from, focusing specifically on how the firm operates relative to the characteristics of the market.
Date of any employee hired after employee davies : The HR department wants to determine the names of all the employees who were hired after Davies. Create a query to display the name and hire date of any employee hired after employee Davies.
Develop a thesis pertaining to the assigned film text : Develop three (3) topic sentences that articulate the major ideas that will comprise the body of your essay. Remember that your topic sentences should clearly state the argument or point to be made in the respective paragraphs.
Prepare a classified balance sheet : Accounting for Management Problem Solving Assignment. Prepare a worksheet outlining the transactions of BEST Resources Ltd in June 2016. Ignore tax. (Your worksheet should include the balances at the beginning of June and the adjustments according ..
Execute all of the possible inputs : 1. If a program has two integer inputs and each can be 32-bit integer, how many possible inputs does this program have? 2. If a program has 264 possible inputs and one test can be run every millisecond, how long would it take to execute all of the ..
Find and report the nash equilibrium of the game : Calculate each player's best-response function as a function of the opposing player's pure strategy. -  Find and report the Nash equilibrium of the game.
Why did the roman empire fall : Discuss the medieval struggle between the monarchies and the Catholic church - what were the issues? On what ideas did each base its claim to rule the people of Europe?
What gdp does and does not measure : What GDP Does and Does Not Measure? The expenditure approach of GDP measures out through calculations of consumption, investment, govt. spending, and net exports.

Reviews

len1252324

10/22/2016 5:05:14 AM

You are required to use the Harvard Referencing style. The minimum number of references for this assignment is five (including textbook). If you are not sure about the referencing style, please read the Referencing guide on the course Learn online website. Marks are allocated for correct answers, but ‘consequential’ errors are not penalized. 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 or groups, nor should you compare your final answers with other students or groups. It is NOT acceptable to share files, templates, or electronic versions of assignment questions with other students or groups.

len1252324

10/22/2016 5:05:05 AM

The length of this assignment should not exceed 2,400 words (excluding title page, table of contents, executive summary/abstract, endnote/footnote, and 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.

len1252324

10/22/2016 5:04:55 AM

Total 2400 words, need it completely as per the guidelines and my date of birth is 12/05/1993 and last digits of my id card is 9026 Its required in assignment. 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 Learn online website before submission. All assignments must be submitted online. Hard copies of assignment are NOT accepted. If the assignment is completed by two students, only one student needs to make the submission. Please submit one single Word Document only. Please do not attach the assignment cover sheet. Instead, clearly indicate your name and student ID (if applicable, your fellow student’s name and ID) on the first page of the submission.

Write a Review

 

Managerial Accounting Questions & Answers

  Prepare the direct material usage budget

Prepare the direct material usage budget for the first quarter of next year and prepare the direct manufacturing labour usage budget for the first quarter of next year.

  How can sprint use a job order costing system

Assume Sprint will install and service a server to link all of a customer's employee's smartphones to a centralized company server, for an upfront flat price.

  Which costs would you expect to remain relatively constant

Given that production was greater than planned, should Cyril expect that all actual costs will be greater than budgeted? Which costs would you expect to increase, and which costs would you expect to remain relatively constant?

  Simid sports-production budget

Near end of 2011, the management of Simid Sports Co., merchandising company, prepared the following estimated balance sheet for December 31, 2011: Simid Sports' single product is bought for $30 per unit and resold for $60 per unit.

  Prepare the operating activities section

The following accounts and corresponding balances were drawn from Osprey Company's 2014 and 2013 year-end balance sheets:

  What are cost drivers

A few questions though could be asked to make it easier for me to understand. Some of these are: What would you consider as an individual product? What are cost drivers?

  Problem on packer manufacturing company

Production and cost data for the month of February for Process A of the Packer manufacturing Company follow.

  What measures will you use to determine

How will the best strategy be determined? What measures will you use to determine if the team is operating successfully

  Prepare a horizontal analysis of deltas property

Briefly outline Delta Airlines company's history, products, and services, and identify the costs reported in the balance sheet for property, plant, and equipment.

  Prepare jersey boy contribution margin income statement

Use the shortcut unit contribution margin approach to compute the number of shows needed annually to earn a profit of $3,078,000. Is this goal realistic? Give your reason.

  Functions of the financial and managerial accountants

Illustrate out the functions of the financial and managerial accountants and describe how their reports are employed by companies.

  How much would projected cash inflow for end of year five

How much would the projected cash inflow for the end of Year 5 have to increase for the project to be acceptable? How much would the projected cash inflow for the end of Year 5?

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