National Gas Financial Statement Analysis

Anonymous
timer Asked: Mar 29th, 2019
account_balance_wallet $40

Question Description

Q1. Assume that you are a Financial Analyst working of a leading Auditing Firm. Evaluate the financial performance of a company listed in the Muscat Securities Market (MSM)/GCC Market by taking into consideration the following

instructions.

 Select a company listed in Muscat Securities Market Market ,You may refer to http://www.msm.gov.om/]the company name is :NATIONAL GAS

 Collect annual financial reports of the chosen company for three consecutive years.

 Use ONLY annual financial statements for analysis. Avoid using quarterly statements.

 Provide references for the data collected (use Coventry Harvard style of referencing). Company websites can also be used for data collection.

 From the financial statements and additional information collected by you complete the below mentioned tasks.

A. Prepare comparative income statements and balance sheet for 3 years using Horizontal and Vertical Analysis

techniques for the both income statements and balance sheet. (10 marks)

B. On the basis of literature review and from the above computations analyses; Profitability position and Financial position of the chosen company. Provide meaningful recommendations for the company to improve the Profitability position and financial position based on the analysis.

(Literature Review about the techniques used for analysis and recommendations

(profitability position- & financial position

Q2. City Cinemas is planning to expand and open new Cinemas in Sultanate of Oman. Currently they are considering two options, one is to start a new cinema in Sohar and other is to take over an existing cinema in Nizwa. But due to recent developments they will be able to fund only one project of the two as the overall revenue trends are subdued. Details of cash inflows for 5 years of the two projects along with additional information is given in the table below

Details

New cinema at Sohar

Take-over existing cinema at Nizwa

Consumer trends

Growth expected at 10%

Stagnated

Population growth

12%

5%

Competition

Strong

Moderate

Initial cost

500,000

500,000

Cash flows

YEAR 1

150,000

200,000

YEAR 2

160,000

185,000

YEAR 3

190,000

160,000

YEAR 4

175,000

175,000

YEAR 5

200,000

150,000

,

A. Evaluate the projects using Internal Rate of Return method.

B. Based on the above analysis and on the basis of the relevant literature review, which project would you recommend and why. The students have to consider the non-financial factors provided in the above scenario and other relevant non-financial factors while recommending a project.

C. Based on appropriate literature review, analyse the non-financial factors provided in the above

scenario and other relevant non-financial factors.

Q3. Your company, a leading fertilizer manufacturer has asked you to submit a cost-volume-profit analysis report for the two products being produced in your company

Particulars

Product A Price per unit (RO)

Product B Price per unit (RO)

Sales price

20

15

Material

10

9

Direct wages

3

2

Variable expenses

100% of direct wages

100% of direct wages

Fixed expenses

RO 800

The following scenarios are predicted by the Management:

Scenario 1: 100 units of product A and 200 units of product B

Scenario 2: 150 units of product A and 150 units of product B

Scenario 3: 200 units of product A and 100 units of product B

You are required to:

  • Compute the contribution per unit of both Product A and Product Find out total contribution and profits for each of the scenario.
  • In your opinion which is the most profitable scenario and justify your recommendation

C. Evaluate the role of CVP analysis in taking business decisions with appropriate literature review.

Unformatted Attachment Preview

Q1. Assume that you are a Financial Analyst working of a leading Auditing Firm. Evaluate the financial performance of a company listed in the Muscat Securities Market (MSM)/GCC Market by taking into consideration the following instructions. Select a company listed in Muscat Securities Market Market ,You may refer to http://www.msm.gov.om/] the company name is : NATIONAL GAS Collect annual financial reports of the chosen company for three consecutive years. Use ONLY annual financial statements for analysis. Avoid using quarterly statements. Provide references for the data collected (use Coventry Harvard style of referencing). Company websites can also be used for data collection. From the financial statements and additional information collected by you complete the below mentioned tasks. A. Prepare comparative income statements and balance sheet for 3 years using Horizontal and Vertical Analysis techniques for the both income statements and balance sheet. (10 marks) B. On the basis of literature review and from the above computations analyses; Profitability position and Financial position of the chosen company. Provide meaningful recommendations for the company to improve the Profitability position and financial position based on the analysis. (Literature Review about the techniques used for analysis and recommendations (profitability position- & financial position Q2. City Cinemas is planning to expand and open new Cinemas in Sultanate of Oman. Currently they are considering two options, one is to start a new cinema in Sohar and other is to take over an existing cinema in Nizwa. But due to recent developments they will be able to fund only one project of the two as the overall revenue trends are subdued. Details of cash inflows for 5 years of the two projects along with additional information is given in the table below Details Consumer trends Population growth Competition Initial cost YEAR 1 YEAR 2 YEAR 3 YEAR 4 YEAR 5 New cinema at Sohar Growth expected at 10% 12% Strong 500,000 150,000 160,000 190,000 175,000 200,000 Take-over existing cinema at Nizwa Stagnated 5% Moderate 500,000 Cash flows 200,000 185,000 160,000 175,000 150,000 , A. Evaluate the projects using Internal Rate of Return method. B. Based on the above analysis and on the basis of the relevant literature review, which project would you recommend and why. The students have to consider the non-financial factors provided in the above scenario and other relevant non-financial factors while recommending a project. C. Based on appropriate literature review, analyse the non-financial factors provided in the above scenario and other relevant non-financial factors. Q3. Your company, a leading fertilizer manufacturer has asked you to submit a cost-volumeprofit analysis report for the two products being produced in your company Particulars Sales price Material Direct wages Variable expenses Fixed expenses Product A Price Product B Price per unit (RO) per unit (RO) 20 15 10 9 3 2 100% of direct 100% of direct wages wages RO 800 The following scenarios are predicted by the Management: Scenario 1: 100 units of product A and 200 units of product B Scenario 2: 150 units of product A and 150 units of product B Scenario 3: 200 units of product A and 100 units of product B You are required to: A. Compute the contribution per unit of both Product A and Product Find out total contribution and profits for each of the scenario. B. In your opinion which is the most profitable scenario and justify your recommendation C. Evaluate the role of CVP analysis in taking business decisions with appropriate literature review. Instruction Cover page Table of contents: Introduction: Overall introduction about the assignment. A short paragraph capturing all the points to be covered in the assignment. Question 1: (40 marks) Introduction: A short paragraph covering the tasks involved in question no. 1 A short profile about the selected company (short paragraph) Task A: calculations (10 marks) Prepare comparative income statements and balance sheet for 3 years using Horizontal and Vertical Analysis techniques for the both income statements and balance sheet. Income Statement – Profitability position Vertical Analysis of Income Statement for three years: Vertical analysis table to be presented here. Horizontal Analysis of Income Statement for three years: horizontal analysis table to be presented here Example: if you have selected the financial data of 2018, 2017 and 2016 then two tables to be presented. Table one – horizontal analysis of 2016 and 2017 and table two – horizontal analysis of 2017 and 2018 Balance sheet – financial position Vertical Analysis of Balance sheet for three years: Vertical analysis table to be presented here. Horizontal Analysis of Balance sheet for three years: Horizontal analysis table to be presented here Example: if you have selected the financial data of 2018, 2017 and 2016 then two tables to be presented. Table one – horizontal analysis of 2016 and 2017 and table two – horizontal analysis of 2017 and 2018 Task B: Analysis and LR – 30 marks On the basis of literature review and from the above computations analyse; Profitability position and Financial position of the chosen company. Provide meaningful recommendations for the company to improve the Profitability position and financial position based on the analysis. Literature Review about the technique used (vertical and horizontal analysis) for calculations. – 10 marks Profitability position: Analysis and recommendations based on calculations and with LR (LR could be used for benchmarking/ comparison of similar industry across the globe/GCC etc) – 10 marks Financial position: Analysis and recommendations based on calculations and with LR (LR could be used for benchmarking/ comparison of similar industry across the globe/GCC etc) – 10 marks Conclusion: a short paragraph about the overall position of the company. Question 2: (25 marks) Task A: Calculations (10 marks) Evaluate the projects using Internal Rate of Return method. IRR calculations to be provided here (including all steps involved in the calculations) Task B: Recommendation with LR (10 marks) Based on the above analysis and on the basis of the relevant literature review, which project would you recommend and why. The students have to consider the non-financial factors provided in the above scenario and other relevant non-financial factors while recommending a project. Literature review of the technique used Recommendations based on calculations, LR and Non- financial factors including factors mentioned in the scenario and other relevant non-financial factors. Task C: Analysis with LR (5 marks) Based on appropriate literature review, analyse the non-financial factors provided in the above scenario and other relevant non-financial factors. Analysis based on literature review of the non-financial factors provided in scenario Analysis based on literature review of other relevant non-financial factors. Question 3: (20 marks) Task A: calculations (10 marks) Compute the contribution per unit of both Product A and Product B. Find out total contribution and profits for each of the scenario. Provide the detailed calculations/ tables of the following, Contribution of Product A Contribution of product B Total contribution and profits for Scenario A Total contribution and profits for Scenario B Total contribution and profits for Scenario C Task B: Discuss the most profitable scenario with justification (5 marks) In your opinion which is the most profitable scenario and justify your recommendation. Task C: role of CVP analysis with LR (5 marks) Evaluate the role of CVP analysis in taking business decisions with appropriate literature review. Reflection report on Industry Guest Lecture: (5 marks) Your reflection report may cover the following, Introduction – brief profile of the Industry Guest Speaker Reflection/ Your understanding of all points mentioned/ covered by the Industry Guest Speaker. Reflection/ Your understanding of the Question & Answers session Any other relevant point covered in the speech. Conclusion List of references: Include all references (text book, Journals/ Research articles, websites etc) and style prescribed in CU Harvard Style referencing for both in-text citations and references. Pls ensure that you have provided the reference for all your in-text citations used in your assignment. Appendix: 1. Student declaration form - mandatory 2. Financial statements downloaded from the MSM website. Pls insert the financial statements as files (both word format and PDF acceptable) - mandatory 3. Any working notes or calculations which are part of the assignment - mandatory 4. Any other relevant documents if necessary ...
Purchase answer to see full attachment

Tutor Answer

Richardweir
School: New York University

At...

flag Report DMCA
Review

Anonymous
Good stuff. Would use again.

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors