Undertake your own research to obtain an organisation’s LATEST THREE- YEAR annua

Question

Undertake your own research to obtain an organisation’s LATEST THREE- YEAR annual reports. You can use one from an organisation with which you are familiar or one which is freely available on the internet (company’s website) or from ASIC or ASX.

You are the Financial Planning and Analysis manager of the company you are choosing. In order to invest a project, the company is planning to apply for a loan from the bank. You was assigned by the CEO the task of advising the Board of Directors about the financial forecasts and the company’s ability to meet the long-term obligations. The proposed loan details are shown as below:
Proposed Loan Details
Loan amount: $5,000,000
Loan term: 4 years
Interest rate 6.50%
Payment frequency: Monthly
Required:
1. You are required to undertake your own research from the company’s website, and read all the relevant information from the annual reports to understand and identify the organisational policy and procedures in regards to (not limited to) sales, inventory management, collection policy, credit, purchasing and payment policy and cost structures.

2. Calculate the financial ratios for the actual three years by using the following template. You can calculate the relevant ratios based on a year-end balance instead of the average beginning and ending year balance.

3. Briefly comment the profitability, liquidity and solvency of the company based on the financial ratios you calculated in the Part 2.

4. You are required to identify timeframes and parameters to be used for the financial forecasts.

5. You are required to use the EXCEL to include all the parameters or assumptions (i.e. key forecast drivers) used, and prepare proforma income statement and balance sheet.

6. You are required to forecast the free cash flow for the company.

7. You are required to write a REPORT (refer to Notes to the Students for more information) to include all the information and workings used in the preparation of proforma income statement and balance sheet, and free cash
flow forecast.Financial Forecasts (80 marks total)

Ref : JB HiFi annual report ( https://www.jbhifi.com.au/Documents/2017%20Annual%20Report.pdf)

Actual year 2 - 20XX Actual year 3 - 20XX Financial ratios Actual year 1 20XX Return on Equity Return on Assets Debt to Equity Ratio Time Interest Earned Days in Receivables Days in Inventory Days in Payables Current Ratio Quick Ratio

Explanation / Answer

1. Following relevant details are available on company's report regarding their policy. A quick analysis of their working capital has been done to understand their business cash conversion cycle.

15

1. Cash cycle is positive and 15 days.

2. Invetory is more and outstanding days is 56.

2. Relevant ratios in addition to above analysis are as follows:

3. Profitability of company has been decreasing i.e. ROE has reduced from 0.38 in 2016 to 0.20 in 2017. Liquidity of company is decreasing due to decreasing current ratio and quick ratio. Further Solvency of company has been increasing due to increment in D/E ratios.

4. For the financial forecasts four years should be taken into consideration as debt is being issued for 4 years. i.e. 2018, 2019, 2020 and 2021. Ratio analysis already highlights that this company is in trouble. Higher leverage would further ruin its situation if topline doesn't grow rapidly.

2017 Sales ($ Mn) 5628 Trade Receivables($ Mn) 196.6 Trade Payables($ Mn) 647.8 Inventory($ Mn) 859.9 COGS 4397.5 Days in Inventory 56 Days in Receivables 13 Days in Payables 54 Cash Conversion Cycle

15

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.