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

  Shri vas dev keeps his books on single entry system from

shri. vas dev keeps his books on single entry system. from the following particulars prepare trading and profit and

  Explain vpn works

Explain ciphertext and describe how you would test a piece of ciphertext to estimate quickly if it was likely the result of transposition?

  Determine appropriate insurance coverage

Explain risk management and its importance and identify types of risk and how you can manage and determine appropriate insurance coverage by investigating options for property and vehicle.

  1 define and compare the following

1. define and compare the following termsnbspnbspnbspnbspnbsp1 corporationnbsp2 proprietorshipcorporation- a

  Identify process goals which comprise key steps to proceed

a deal that will provide your university with many more resources and course offerings, such as more masters-level courses and its first Ph.D.-level courses. This will enhance the institute's accreditation and status.

  Future growth of islamic and conventional banking

Future Growth of Islamic and Conventional Banking - Privatization is Necessary for High Growth

  Flannigans fish flies manufactures fishing lures used in

flannigans fish flies manufactures fishing lures used in the sport of fly-fishing. flannigans uses an automated process

  Would you as a financial manager be interested in doing

would you as a financial manager be interested in doing business in this countrybrunei?as such your research analysis

  Conduct a sensitivity analysis

Assuming that a project has a discount rate of 10 percent, calculate its NPV. Should the project be accepted and conduct a sensitivity analysis. Should the project be accepted now? Why?

  What consolidation journal entry would have been recorded

Journals related to bonds - What consolidation journal entry would have been recorded in connection with these intercompany bonds on December 31, 2007?

  Determination of roi

Compass, corporation purchased a new machine and incurred $9,000 of interest, installation, and overhead expenses that should have been capitalized. Determine the ROI, for 2010, suppose that the $9,000 had been capitalized.

  Find the present value of an income stream

How much would the government have to set aside now (when a child is born), to supplement the average parent's share of a child's college health care cost?  The lump sum the government sets aside will also be invested at 6%, annual compounding.

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