7111AFE Accounting and Governance Assignment

Reference no: EM132506821

7111AFE Accounting and Governance - Griffith University

Financial Report Analysis and Decision to lend to a Company

Aims of this assignment

This assignment aims to develop:

a) a highly proficient digital literacy through digitising financial statements into an excel spreadsheet and use these digitised financial statements to calculate and compare ratios to do the analysis showing the comparison in a graph.
b) an ability to understand and analyse financial reports,
c) skills to compare financial information of two listed companies, and
d) capacity to evaluate financial information and synthesise financial and non-financial information tomake business decisions.

Assignment overview

You work as the investment manager of Capital Investments Ltd. The CEO of the company, Mr Barings, asked you for advice to invest $10,000,000 in shares of either Michael Hill International Ltd, Lovisa Holdings Ltd or in none of these companies.

Both Michael Hill and Lovisa have offered Capital Investments Ltd, a private placement of ordinary shares. The purpose of an increase in equity for each company is to raise funds to finance an expansion of operating capacity.The CEO of Capital Investments has to make a recommendation to the Board of Directorswhether to acceptMichael Hill's offer to sell to Capital Investments a new issue of ordinary shares and reject Lovisa's offer, or acceptLovisa's offer to sell to Capital Investments a new issue of ordinary shares and reject Michael Hill's offer or alternatively reject both offers.

Obtain each of the company's annual reports for the 2016 and 2019 financial years from the companies' website and Lovisa: The annual report contains the Chairman's report, the CEO's report, the Directors report and the Financial Statements (Balance Sheet, Income Statement, Statement of Changes in Equity, Statement of Cash Flows and Notes to Financial Statements). The financial statements include comparative figures from the prior year; therefore, you will have data for five financial years: 2019, 2018, and 2017.

Assignment tasks

Before commencing work on the tasks below refer to the Individual Assignment Rubric for the criteria and standards that will be applied in the assessment of your assignment.
You have to upload your Excel Worksheet and a Word Document report. They must include the following tasks:
1. Excel Worksheet (Rubric 1)
- Allocation of marks for each part according to the rubric.
1.1 Digitise the 4-years comparative income statement, balance sheet and statement of cash flows in an excel worksheet.Use a different worksheet for the two companies, worksheet 1one for Michael Hill and worksheet 2 for Lovisa. The first column for each financial statement is the column of the accounts, sub-totals and totals of the statement.The second column is the year 2019, the third column the year 2018, then the year 2017 and finally the year 2016. Always use the year reported in the most current financial statement (e.g. the year 2018 that is reported in the comparative financial statements 2019) because sometimes companies make adjustments to the financial statements in the following Annual Report.
1.2 Use the formulas provided for the assignment to calculate the following ratios for each company for the years 2019, 2018 and 2017: current ratio, quick ratio, current cash debt coverage, receivables turnover, inventory turnover, debt to assets ratio, times interest earned, ROE, ROA, profit margin, asset turnover, gross profit rate and price-to-earnings ratio. These ratios should be calculated using the Excel formulas with the integer plus 2 digits, or if it is a percentage, in decimals with four digits. The ratios must be listed comparatively in 3 columns for the years 2019, 2018, and 2017. (See format in the Appendix)
1.3 Select thefive most relevant ratios to do the analysis to recommend the investment (or no investment) of the $10,000,000. Choose the ratios based on:
a) the relevance of the ratio for the decision to be made (investment of $10,000,000 in shares of one of these companies).
b) the significance of the difference between the ratios of the two companies (i.e. the differences between the ratios is significant enough to make a difference in the decision to be made).
c) From the 5 ratios, 3 ratios should evaluate profitability and the other 2 ratios should evaluate liquidity and/or solvency.
1.4 Prepare five graphs (one per each ratio chosen)in a different worksheet (worksheet 3) comparing both companies in the period from 2017 to 2019.
2. Word Document (Rubric 2)
The Word document is the report of your analysis. In this report you have to include the following headings:
2.1 Company background research
Review Michael Hill's and Lovisa's annual reports and any other sources of information. Write a short response to each item below to build background knowledge of each company and their industry(max: 150 words; min: 100 words).
a) Describe the operating activities and businesses of each company noting similarities and differences between Michael Hill and Lovisa.
b) Describe the composition of the Board of Directors and the Board Committees. Identify significant changes in the BOD and in the management of these companies in the last three years. Identify any concern raised in the Chairman, CEO and/or Directors' report.
2.2Comparative analysis
From the ratios calculated in the Excel worksheet, provide a comparative analysis ofthe five ratios chosen to evaluate a) profitability and b) liquidity and/or solvency(max: 200 words; min: 100 words per ratio - you can use dot points for ratio analysis discussion).
For the analysis, obtain additional data from the financial statements and notes to the financial statements. The analysis should include an interpretation of changes in the ratios over the three years and how they affected a) profitability of these companies, and b) liquidity, solvency and risk of each company. At the end of the comparative analysis of each ratio add a copy of the graph you prepared in the Excel worksheet.

2.3 Conclusion and Recommendation
a) A recommendation on whether Capital Investments should invest $10,000,000 in shares of Michael Hill or in shares ofLovisa or to do not invest in any of them must be stated. The recommendation must be supported by an explanation based on the conclusion of the analysis that justifies the decision made(max: 850 words; min: 150 words).
b) You have to explicitly and clearly provide your recommendation to Mr Barings, so he can in turn provide a recommendation to the Board of Directors.

Attachment:- Accounting and Governance.zip

Reference no: EM132506821

Questions Cloud

Amount of money the banking system creates : Why don't banks hold 100 percent reserves? How is the amount of reserves banks hold related to the amount of money the banking system creates?

What was the balance in the securities fair value adjustment : What was the balance in the Securities Fair Value Adjustment account at December 31, 2019? What was the net dollar impact of the adjustment to the SFVA

Monetary policy during the great recession : Why a 0 (nominal) interest rate didn't help the economy during the 2008 great recession? Write down the relevant equation and explain it clearly.

Find the company inventory days for year averaged days : In the recent year, Rs. 500,000; and its cost of goods sold was Rs. 400,000. The company's inventory days for that year averaged days.

7111AFE Accounting and Governance Assignment : 7111AFE Accounting and Governance Assignment Help and Solution, Griffith University - Assessment Writing Service - calculate and compare ratios

Equilibrium gdp in keynesian income expenditure model : Carefully explain the effect of a $100 decrease in government transfers (subsidies for education, pensions etc.) on the equilibrium GDP in the Keynesian income

Find how much must be deposited at beginning of each : Find How much must be deposited at the beginning of each of the next eighteen years to fund the education?(Rounded your answer to nearest €).

What is the effect of the decrease in business confidence : What is the effect of the decrease in business confidence on the IS and MP curves?

Explain the effects of a reduction in the saving rate : Graphically illustrate and explain the effects of a reduction in the saving rate on the Solow growth model.

User Account

All Pages