Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hello i am currently doing an accounting case study forhttps://www.waterco.com.au/ I need to answer part 2,3,4 of the assignment questions Do let me know if

Hello i am currently doing an accounting case study forhttps://www.waterco.com.au/

I need to answer part 2,3,4 of the assignment questions

Do let me know if you need more information regarding this thanks!

https://www.waterco.com.au/waterco/documents/new-and-events/asx-announcements/2019/23.9.2019-annual-report-to-shareholders.pdf (2019 annual report)

https://www.waterco.com.au/waterco/documents/new-and-events/asx-announcements/2018/21.9.2018---annual-report-to-shareholders.pdf (2018-annual report)

https://www.waterco.com.au/waterco/documents/new-and-events/asx-announcements/2017/annual-report-2017.pdf (2017-annual report)

Part 2 - Financial Statements

The purpose of part 2 is to not only introduce students to an actual set of financial statements of a publicly listed company, but to also identify information that may be significant for ratio analysis which will be conducted in Part 3.The financial statements are presented in the financial report section of the company's annual report.For this section you may find it easier to refer to the Excel spreadsheets to obtain the financial data.The Excel spreadsheet will contain the financial information for the past 10 years; however, you will only need to refer the data for the past four years in your spreadsheet, (the past three years and the fourth may be required to create averages for some of the ratios in part 3).This will make it easier to refer to the financial data for several years in one excel worksheet.

Part 2 - Question 1 (Statement of Financial Position):(related content - topic 3)

What is the amount invested by the company in net assets for the current year?(Hint use total assets less total liabilities).How does this amount differ from the value of net assets for each of the previous three years?Can you identify any reason for the changes? (Hint: look at the individual amounts that make up both the total assets and total liabilities, are there any changes to individual items over this three-year period?Alternatively, you could perhaps look at the notes to the financial statements in the annual report to see if there are any changes in the breakdown of individual items in the reports.)Discuss.

Click here to enter text.

Part 2 - Question 2 (Statement of Financial Position):(related content - topic 3)

How much was the total equity for the current year?How does this differ from the total equity in each of the previous three years?Can you identify any reason if there are any changes?Discuss.

Click here to enter text.

Part 2 - Question 3 (Statement of Financial Position):(related content - topic 3)

How much was the total current assets for the current year and what are the components classified under this heading?Is there any difference in the value of total current assets for each of the previous three years?Can you identify any reason if there are any changes?Discuss.(Hint: you may need to refer to the notes to the financial statements in the annual report to review more detailed information.)

Click here to enter text.

Part 2 - Question 4 (Statement of Financial Position): (related content - topic 3)

What are the items listed under non-current liabilities? Are there any new non-current liabilities in the current year that were not there in the previous three years? (Hint: you will need to look in the notes to the accounts to see the breakdown of non-current liabilities).

Click here to enter text.

Part 2 - Question 5 (Statement of Profit or Loss ):(related content - topic 4)

How much was net profit for the current year?How does this compare to the net profit for each of the previous three years?Can you identify any particular revenues or expenses that may have led to changes in the profit figures over the three-year period?Discuss.

Click here to enter text.

Part 2- Question 6 (Statement of Profit or Loss )(related content - topic 4)

Is the total revenue in the current year greater or less than the total annual revenue recorded in each of the previous three years?Discuss.

Click here to enter text.

Part 2 - Question 7 (Statement of Cash Flows):(related content - topic 4)

How much was the cash flows from operating activities for the current year?What was the largest inflow item and the largest outflow item in the operating activities section?Does this differ from the previous three years?Discuss.

Click here to enter text.

Part 2 - Question 8 (Statement of Cash Flows):(related content - topic 4)

How much was the cash flow from investing activities in the current year?Has the company had any new investing cash flows in the current year compared to the previous three years? If they did, list the activities (Hint: it may be necessary to look in the notes to the accounts).

Click here to enter text.

Part 2 - Question 9 (Statement of Cash Flows):(related content - topic 4)

What was the net change in cash flows in the current year?How does this change compare to the previous three years?Discuss.

Click here to enter text.

Part 3 - Financial Statement Analysis Tools

The purpose of part 3 is to introduce students to using financial statement analysis tools.Hopefully your answers to questions in part 2 may have flagged monetary differences that you can now compare based on percentages using ratio analysis.Ensure you include your calculations in your answer and more importantly, try and identify why percentage changes may have occurred.It is this analysis that is most important in this exercise, trying to identify "why" changes have occurred. The group should aim to incorporate the answers and calculations each member has prepared for their assigned company as supporting documentation for the comparative analysis of the companies in the appendix of the final submission.The more analysis provided in the answers to the questions in this workbook, the more information the group will have to draw on when preparing the comparative essay.

From the lecture Powerpoint slides - Performing ratio analysis you should answer the questions on the basis of:

1.Describe the change

2.Explain the change

3.Suggest a cause

Part 3 - Question 1 (Profitability): (related content - topic 5)

Can you identify a trend in the return on equity ratio over the past three years?Comment on the trend.Briefly discuss possible reasons for this trend.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 2 (Profitability):

Has the Return on Assets changed over the past 3 years?What may have caused the change?

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 3 (Profitability):

Has the profit margin and gross profit margin, if applicable, changed over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.(Hint: as mentioned above, refer to your horizontal and vertical analysis of the Statement of Profit or Loss and Statement of Financial Position to assist in your analysis of this ratio.)

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 4 (Asset efficiency): (related content - topic 5)

Identify if the asset turnover ratio increased or decreased over the past three years? Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 5 (Asset efficiency): (related content - topic 5)

The inventory turnover ratio is only applicable to retail businesses.If your assigned company is a retail business, has the Inventory turnover changed over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.Note you might find it useful to also convert to the number of days.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 6 (Asset efficiency): (related content - topic 5)

Has the receivables turnover changed over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.Note you might find it useful to also convert to the number of days.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 7 (Liquidity):(related content - topic 5)

Has the current ratio increased or decreased over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 8 (Liquidity):(related content - topic 5)

Has the quick ratio increased or decreased over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 9 (Liquidity):(related content - topic 5)

Has the cash flow (to current liabilities) ratio increased or decreased over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 10 (Capital structure/Gearing):(related content - topic 5)

Has the debt to equity ratio increased or decreased over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 11 (Capital structure/Gearing):(related content - topic 5)

Has the debt ratio increased or decreased over the past three years?Is this a good result for the company?Briefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 12 (Capital structure/Gearing):(related content - topic 5)

Has the interest coverage ratio improved/declined over the 3 year periodBriefly discuss what the change indicates.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 13 (Capital structure/Gearing):(related content - topic 5)

Has the debt coverage ratio changed over the 3 year period?Is this a positive / negative result for the company?

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 14 (Horizontal Analysis):(related content - topic 6)

Conduct a horizontal analysis of the Statement of Profit or Loss (Income Statement) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 15 (Horizontal Analysis):(related content - topic 6)

Conduct a horizontal analysis of the Statement of Financial Position (Balance Sheet) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 16 (Vertical Analysis):(related content - topic 6)

Conduct a vertical analysis of the Statement of Profit or Loss (Income Statement) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 17 (Vertical Analysis):(related content - topic 6)

Conduct a vertical analysis of the Statement of Financial Position (Balance Sheet) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Note: Horizontal and vertical analysis can be used as a point of reference to assist in identifying percentage changes of individual items that appear in the financial statements.When conducting ratio analysis, over a period of time, you may find it easier to not only identify the change in the numerator and denominator of the formula, but to also use horizontal and vertical analysis to identify the individual components that make up the numerator and denominator of the formula.

Part 3 - Question 18 (Trend Analysis):(related content - topic 6)

Conduct a trend analysis of the Statement of Profit or Loss (Income Statement) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Part 3 - Question 19 (Trend Analysis):(related content - topic 6)

Conduct a trend analysis of the Statement of Financial Position (Balance Sheet) for the past 3 years.Comment on any trends.

Describe the change:

Explain the change:

Suggest a cause:

Part 4 - Group Comparative Essay

Task: You are required to write an essay of no more than 4 pages analysing and comparing the four companies allocated to your group, and then provide a recommendation of the best company to invest in.

To do this, each group member will be required to complete the workbook questions for their assigned company.The comparative essay will be prepared by drawing information for each assigned company from the completed workbooks.

Task Question:

An investor is contemplating a potential investment opportunity in one of four companies. The investor has asked your group to provide a four-page comparative essay discussing the profitability, liquidity, asset efficiency and gearing of the four companies allocated to the group and recommend the company that provides the best investment opportunity.

Structure - Comparative Essay

Pages 1 to 4: Essay should be structured as follows

1. Introduction - approx. 300 - 400 words

Introduce the aim (task) of the paper in one sentence. Next introduce each company in brief. Include a Thesis Statement which begins "This comparative essay will..."

2. Body

In the body you should provide a brief comparative analysis of the key factors of each company in separate paragraphs. This is an overall summary based on your own analysis from the Workbook. You must also identify which company is stronger in each category.

Paragraph 1: Overall Profitability Analysis - approx. 300 - 400 words

Include the overall probability analysis for both companies. In the last sentence of the paragraph identify which company is better from the perspective of profitability.

Paragraph 2: Overall Asset Efficiency Analysis - approx. 300 - 400 words

Include the overall asset efficiency analysis for both companies. In the last sentence of the paragraph identify which company is better from the perspective of overall asset efficiency.

Paragraph 3: Overall Liquidity Analysis - approx. 300 - 400 words

Include the overall liquidity analysis for both companies. In the last sentence of the paragraph identify which company is better from the perspective of overall liquidity analysis.

Paragraph 4: Overall Capital Structure Analysis - approx. 300 - 400 words

Include the overall capital structure analysis for both companies. In the last sentence of the paragraph identify which company is better from the perspective of overall capital structure analysis.

Paragraph 5: Limitations of Analysis - approx. 50 - 100 words

Identify any limitations encountered in conducting the comparative analysis. This may include things like insufficient or old data sources and so on.

3. Conclusion - approx. 50 - 100 words

Repeat the main findings/analysis of your report in summary format. Very clearly explain the status of all companies.

4. Recommendations - approx. 100 words

Make a very clear recommendation for the investor. Explain which company is the best option and use the findings you have presented in the body to support your stance.

Page 4: References

Include the bibliographic details of any references you have used. You must use APA 7th format. Check the Library Guides here for correct usage: https://libguides.jcu.edu.au/apa

You can only use appropriate reputable sources such as journals, textbooks, newspaper articles, or published reports. You cannot use online sources such as Investopedia or Wikipedia.

Page 5 onwards: Appendix

The appendix is not included in the word count or page requirements. This means there is no page restriction here. For each area of analysis, you must put screenshots or copies of the data from your Excel Financial Data Spreadsheet of your assigned company and include your written response from part 3 of the workbook. Do not include the whole workbook in the appendix.You may use the following template to prepare the appendix to support your comparative essay.

Include the following opening statement:

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting for Decision Making and Control

Authors: Jerold Zimmerman

9th edition

125956455X, 978-1259564550

More Books

Students also viewed these Accounting questions

Question

Was the researcher critically reflexive?

Answered: 1 week ago