Develop a spreadsheet model for a listed australian company

Assignment Help Financial Management

Reference no: EM13858796

1. BACKGROUND

This assignment requires students to develop a spreadsheet model for a listed Australian company using advanced MS Excel functions as part of its construction with a written explanation of your financial model and how the output from it can be used.

The marking rubric will be available on the Unit's Blackboard site early in the semester and the assignment is to be submitted online as you did for the earlier Folio assessment.

Finding an appropriate company for analysis

Before commencing you must choose a listed Australian company. When you select the company, it is strongly suggested that you choose a GICS code of: 1) Pharmaceuticals, Biotechnology & Life Sciences; 2) Food Beverage & Tobacco; 3) Health Care Equipment & Services; 4) Technology, Hardware and Equipment; and, 4) Retailing.

Important: Do one more check before you start analysing the company data. Access the financial statement data using DatAnalysis Premium (MorningStar) as you did for the ‘Folio' assessment and download the spreadsheet as demonstrated in this YouTube Clip. Do a check that the company has financial data indicating real operations over the past five years, for example, changing balances for revenues, cash at bank, inventories, debt and shareholders' funds.

2. REQUIREMENTS

a. Requirements for your financial model

The assignment is a challenging assessment that requires you to develop a small financial model from knowledge gained during your study in this unit. Students should know that the financial model using MS Excel spread sheet developed for this section does not have to be large but it should have the features identified in the section below.

b. Features of MS Excel financial model

• Begin the financial model worksheets in MS Excel with a worksheet containing the raw data you have downloaded for your company from DatAnalysis.

• The second worksheet in your workbook should contain edited financial data that formats the raw financial data into financial statements which will be more useful to a client or manager reviewing the model.

• The third worksheet must be a common-size analysis of the company's comparative balance sheets for at least the past five years and also an index number trend analysis of the income statements over the same period.

• Application of concepts and advanced MS Excel functions (for example, Scenario Manager, What- if Analysis, Regression Analysis, Monte Carlo simulation or MS Excel Solver).

• The worksheet or worksheets should be organised so that they have a data entry section, calculation section and output section. It is important to create comments and text guidance to a user of your financial model.

• The output section should employ visually useful output like graphs and charts to display results and should be organised to print neatly on one A4 page.

• Demonstrate a clear understanding of academic integrity through correctly referencing the original work of others used in the assignment.

c. Explanation of Financial Model

A written explanation of how your financial model works. That is, you are to write about how your financial model can be used to examine the company financial statements and how the output of your financial model will be useful to a financial manager of the firm? (12pt, Ariel font, 1.5 line spacing; no more than 300 words).

This explanation is to be submitted as an MS Word or PDF file that has been separately labelled.

Reference no: EM13858796

Questions Cloud

What is a hypothesis test? : What is a hypothesis test? Why do we need to use them to make decisions about relating sample results to the population

Explain how using the ashford university library has improve : Explain how using the Ashford University Library has improved your experience in conducting research

What determinant of demand changed : How did samsung's unveiling of the galaxy S5 affect the demand for the S4? what determinant(s) of demand changed? How did walmart's price cut compensate?

Eassy about a fill named tokyo story : Eassy about a fill named tokyo story

Develop a spreadsheet model for a listed australian company : The Assignment for Accounting Modelling ACCT3003. Develop a spreadsheet model for a listed Australian company using advanced MS Excel functions as part of its construction with a written explanation of your financial model and how the output from ..

What are raw materials price & quantity variances for march : What are the raw materials price & quantity variances for March? What are the journal entries associated with these variances?

The wheat is milled into flour that sells : We grow wheat that sells for $40,000. The wheat is milled into flour that sells for $55,000. The flour is used to bake bread that sells to consumers for $90,000. If nGDP is $9000 billion while rGDP is $12,000 then the GDP deflator is...

What is this attribute and how does it describe god : Please select one of the attributes above to discuss. In your initial posting, address the following questions: What is this attribute? How does it describe God? Are there any problems associated with this attribute

Full employment-GDP deflator : Country X has an $8000 billion GDP and a population of 200 million. Country Y has a $6000 billion GDP and a population of 150 million. Which of the following is true? Full employment is: If the GDP deflator is now 125, we may conclude that since the ..

User Account

All Pages