Students are required to select two companies from the top 100 publicly listed companies in Australia. Both the firms will be chosen from the same industry (financials/healthcare/chemical/energy). This assignment applies on the principles of Management Accounting analysis learned in this course, by analyzing the annual report of real companies.
Required:
1. Graphically present and discuss the following variables from the financial statements of your selected companies. (Use Excel Application to do this)
2. Compute the Measures of Central Tendency over the ten-year period for the following variables from the financial statements of your selected companies. (Use Excel Application to do this)
Discuss the descriptive statistics of these variables.
3. Estimate and interpret the correlation coefficients between the following pairs of variables. (Use Excel Application to do this)
4. Estimate and Interpret the Least Square Regression equation of net profits on sales. Use the net profit as the dependent variable and sales as the independent variable. (Use Excel Application to do this)
5. Estimate and interpret the time series equation for the following variables from the financial statements of your selected company. (Use Excel Application do this).
Use each of the above as the dependent variable and year as the independent variable. Estimate the forecasted value for each of the variables over 2 years from the actual figure.