Develop excel spread sheet to analyse operations of business

Assignment Help Corporate Finance
Reference no: EM13844406

ASSIGNEMNT DETAIL

Choose an organisation listed on the stock exchange from one of the organisations listed below or another with the approval of the lecturer;

BHP Billiton

Woolworths Ltd

Harvey Norman

Coles Ltd

Research the financial and non-financial information available for the organisation.

Required

1. Develop and excel spread sheet to analyse the operations of the business you have chosen over a three year period, use ratio analysis, trend analysis and other qualitative information to undertake the analysis. Using actual data to the 30 June 2014.

2. Prepare a report in Word to shareholders and management to explain the performance of the organisation.

a. Note the information provided to management may be more in depth than that provided to shareholders, do not just copy the notes in the annual report.

b. Utilise all information that is available

3. Prepare a presentation of the key issues identified in you analysis to be undertaken in week 11 maximum of 5 minutes.

4. Explain the concept of funding mix for an organisation. What are the main sources of funding for the organisation you have chosen, what do you think is the effect of this funding mix on the organisation?

Reference no: EM13844406

Questions Cloud

Suspension of disbelief : When we attend a film, in a way there is not the same kind of "suspension of disbelief" as there is with theater. Rather we demand more "realism" be portrayed in the film. Yet in a way we are suspending disbelief just as much, just changing its fo..
Explain the meaning of polymorphism : Explain the meaning of polymorphism
Store sells a particular brand of monochrome : A small retail store sells a particular brand of monochrome and color television sets. Each monochrome set that is sold earns a profit of $100, while each color set earns $200 profit. The manager of the store estimates that the weekly demands for eac..
Discussion and critical thinking : 1. Which sentence is the better topic sentence, the first or the third? Explain why.
Develop excel spread sheet to analyse operations of business : Develop and excel spread sheet to analyse the operations of the business you have chosen over a three year period, use ratio analysis, trend analysis and other qualitative information to undertake the analysis.
Create one observation for each year : Initialize each of the variables below to their current values, and use a DO LOOP to calculate their estimated values for the next ten years. For example, next year's wage expense will be this year's wage expense plus 6 percent of this year's amount;..
What do you mean by operator overloading : What do you mean by operator overloading
The recommended daily allowance rda : The recommended daily allowance (RDA) of cobalamine (Vitamin B12) for growing teens is 2.4 μg(micrograms). My brother takes it upon himself to make sure that everyone gets the message. It is generally believed that growing teens are getting less than..
Write short notes on nested class : Nested class

Reviews

Write a Review

Corporate Finance Questions & Answers

  Impact of the global economic crisis on business environment

This paper reviews the article of ‘the impact of the global economic crisis on the business environment' that is written by Roman & Sargu (2011).

  Explain the short and the long-run effects on real output

Explain the short and the long-run effects on real output, price, and unemployment

  Examine the requirements for measuring assets

Examine the needs for measuring assets at fair value in accounting standards

  Financial analysis report driven by rigorous ratio analysis

Financial analysis report driven by rigorous ratio analysis

  Calculate the value of the merged company

Calculate the value of the merged company, the gains (losses) to each group of shareholders, NPV of the deal under different payment methods. Synergy remains the same regardless of payment method.

  Stock market project

Select five companies for the purpose of tracking the stock market, preparing research on the companies, and preparing company reports.

  Write paper on financial analysis and business analysis

Write paper on financial analysis and business analysis

  Intermediate finance

Presence of the taxes increase or decrease the value of the firm

  Average price-earnings ratio

What is the value per share of the company's stock

  Determine the financial consequences

Show by calculation the net present value for the three alternatives (no education, network design certification, mba). Also, according to NPV suggest which alternative you advise your friend to choose

  Prepare a spread sheet model

Prepare a spread sheet model for the client that determines NPV/IRR with and without tax.

  Principles and tools for financial decision-making

Principles and tools for financial decision-making. Analyse the concept of corporate capital structure and compute cost of capital.

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd