finance (equity valuation and analysis) - Finance Assignment Help

Internal Code: MAS 4357

Finance Assignment Help

Question: 1. Provide an overview of both industry sectors. This should include a discussion of the type of goods and services that are produced, recent performance and the key challenges faced by each sector. 2. Present a table (see below) consisting of the following financial performance indicators that will assist in the valuation of each firm for the last 6 years using data from DatAnalysis (Financial data). Make sure that the last financial year is the same for all companies.

• Total operating revenues
• Net profit
• EPS
• D/E ratio
• ROC
• ROE

3. Provide an overview (discussion) of each company’s performance by industry sector. Use diagrams, graphs, charts etc produced on excel by yourself to illustrate key points you wish to make (do not download diagrams, graphs, charts etc from other sources). 4. Produce a diagram developed in excel depicting the share price performance for each company over the last 2 years and provide an overview the performance. 5. Determine whether each firm is under or overvalued using trailing ratios and an appropriate benchmark for each industry. Show all calculations and provide relevant explanations. 6. Provide a ranking (1 being the best, 4 worst) between all 4 companies. Show all calculations and provide relevant explanations.