Conduct and present a ratio analysis of rio tinto

Reference no: EM131488587

Task Overview

Create a Microsoft Excel spreadsheet to conduct and present a ratio analysis of Rio Tinto (RIO). Follow the embedded example of Ratio Analysis completed on Caltex vs Shell

The analysis is to include the calculation and presentation of ratios for liquidity, activity, debt, profitability, market value and competitor (BHP Billiton). The ratio analysis is to show:

Values for each ratio for three years
Trend analysis graphs
Peer group analysis graphs

Requirements -

Create a single MS Excel file to perform a ratio analysis using the latest three years of complete financial statement data.

a. Include company name and address

b. List the financial statements and other information that were used in the calculation of the ratios

c. Do not type the answers in the cell.

d. Each number used in the ratio calculation should be able to be traced back to the financial statements present in the same worksheet using 'Trace Precedents' button.

Perform a ratio analysis (showing all calculations) on all groups of ratios as attached in the embedded material below:

a. Liquidity ratios

b. Activity ratios

c. Debt ratios

d. Profitability ratios

e. Market value ratios

Show the following:

a. The values for each ratio for three years.

b. The trend analysis graphs: For each ratio, provide a graph showing the three year performance of your company.

c. Peer group analysis graphs: For each ratio, provide a graph showing the three year performance of Rio Tinto's ratio against the major competitor - BHP Billiton.

Attachment:- Assignment Files.rar

Reference no: EM131488587

Questions Cloud

How does the globalization of business affect : How does the globalization of business affect how you would analyze the ethical issues surrounding the use of child labor around the world?

Review the current literature on brand switching : Review the current literature on Brand Switching and write a literature review which could be suitable for publication in an academic marketing journal

Discuss the marginal tax rate : (Calculating free cash flows) Racin' Scooters is introducing a new product and has an expected change in EBIT of $475,000. Racin' Scooters has a 34 percent.

Brief back ground of the business operations : Brief back ground of the business operations. Motivations for the firm to expand their operations in the Asian markets.

Conduct and present a ratio analysis of rio tinto : Create a Microsoft Excel spreadsheet to conduct and present a ratio analysis of Rio Tinto (RIO). Follow the embedded example of Ratio Analysis

Which type of life insurance accrues a cash value over time : Which type of life insurance accrues a cash value over time? Which of the following is not an example of a rating error in performance management?

Communication skills in the workplace : Communication Skills in the Workplace - Information processing, consistency of interpretation and extrapolation of meaning are the main constrains.

Calculate the percentage of antibiotic users : Do the example data in Table 35-2 meet the assumptions for the Pearson ?2 test? Compute the ?2 test. What is the ?2 value?

What is the projects free cash flow in year one : (Calculating free cash flows) Spartan Stores is expanding operations with the introduction of a new distribution center. Not only will sales increase.

Reviews

len1488587

5/8/2017 6:48:35 AM

The Word doc has instructions clearly detailed and all reference material. Job should be reasonably simple for anyone with a Finance degree. Course materials on Ratio Analysis. Everything needed to complete the work is in the attached embedded file. Data files of annual financials on Rio Tinto and competitor - BHP Billiton. The analysis is to include the calculation and presentation of ratios for liquidity, activity, debt, profitability, market value and competitor (BHP Billiton).

Write a Review

Required(*) Message

User Account

All Pages