Subject Code : FNS50215
Country : Australia
Assignment Task:

Case Study:
 
Financial Forecasts:

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 in a project, the company is planning to apply for a loan from the bank. You were 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 below:

20200122070804AM-1987242965-1444727493.JPG

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.

20200122071039AM-616650319-1736130455.JPG

3. Briefly comment on the profitability, liquidity and solvency of the company based on the financial ratios you calculated in 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 a 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.


This Accounting and Finance Assignment has been solved by our Accounting and Finance Experts at UniLearnO. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our experts are well trained to follow all marking rubrics & referencing style.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

  • Uploaded By : Alex Cerry
  • Posted on : January 22nd, 2019
  • Downloads : 296

Whatsapp Tap to ChatGet instant assistance