Choose OMAN CABLES INDUSTRY (OCAI)
Financial Analysis for Managers Individual Assignment-
Intended learning outcomes:
1. Evaluate the performance of a company using various financial analytical tools.
2. Analyse different patterns of cost behaviour and apply cost-volume-profit analysis to business decisions.
3. Select and apply investment appraisal techniques appropriately.
4. Evaluate the performance of business units using both financial and non-financial measures.
Answer all questions -
Q1. Assume that you are a Financial Analyst working for Middle East Venture Capital L.L.C. Evaluate the financial performance of a company listed in the Muscat Securities Market (MSM)/GCC Market by taking into consideration the following instructions.
Instructions:
- Select a company listed in Muscat Securities Market/GCC Market (preferably other than banking and investment companies or Holding companies).
- Collect financial reports of the chosen company for three consecutive years.
- Use 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.
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.
b. On the basis of literature review and from the above computations analyse; Profitability position and Financial position of the chosen company.
c. Compare and contrast Vertical analysis and Horizontal analysis techniques.
Q2. Mars Hypermarket LLC is planning to expand and open new stores in Sultanate of Oman. Currently they are considering two options, one is to start a new store in Barka and other is to take over an existing store in Ibra. But due to recent developments they will be able to fund only one store as the overall revenue trends are subdued. The required rate of return is 10%. Details of cash inflows of 5 years of the two projects along with additional information is given in the table below,
|
Details
|
New Store at Barka
|
Take-over existing at lbra
|
|
Suppliers availability
|
Not available. To be initiated
|
Already existing
|
|
Consumer trends
|
Growth expected at 10%
|
Stagnated
|
|
Population growth
|
12%
|
5%
|
|
Competition
|
Strong
|
Moderate
|
|
Initial cost
|
200,000
|
200,000
|
|
Cash flows
|
|
Year 1
|
60,000
|
20,000
|
|
Year 2
|
80,000
|
60,000
|
|
Year 3
|
100,000
|
80,000
|
|
Year 4
|
60,000
|
120,000
|
|
Year 5
|
40,000
|
80,000
|
a. Evaluate the projects using, Net Present value Method and 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 information provided in the case and other relevant non-financial factors while recommending a project.
Q3. Your company, a leading cement manufacturer has asked you to submit a cost-volume-profit analysis report for the two products being produced in your company.
|
Product A
|
Product B
|
|
|
RO
|
RO
|
|
RO
|
RO
|
|
Sales
|
|
300,000
|
Sales
|
|
300000
|
|
Less: Variable Cost
|
240000
|
|
Less: Variable Cost
|
200000
|
|
|
Fixed Cost
|
30000
|
270000
|
Fixed Cost
|
70000
|
270000
|
|
Budgeted Profit
|
|
30000
|
Budgeted Profit
|
|
30000
|
You are required to:
a. Calculate break - even point of each product.
b. The company prefers to maintain a desired profit of RO 10,000. Identify the sales volume to maintain the desired profit.
c. Compute margin of safety for both products.
d. The business is expected to go through ups and downs in the demand hence you need to state which product is likely to earn greater profit in conditions of heavy demand for the product and low demand for the product.
e. Evaluate the importance of the role of CVP analysis in taking business decisions with appropriate literature review.