Get premium membership and access questions with answers, video lessons as well as revision papers.
- RATIO ANALYSIS CASE STUDY
The financial statements below were extracted from the books of E. A. Portland Cement Company ltd. The excerpts below were also extracted...(Solved)
RATIO ANALYSIS CASE STUDY
The financial statements below were extracted from the books of E. A. Portland Cement Company ltd. The excerpts below were also extracted from the key managers reports;
The business environment in the year continued to present challenges such as competition, high energy costs and importation of cheap cement into the market which reduced sales in the local and regional markets.
The Group’s performance in the year was affected by these factors resulting to a loss of Kshs 385 million. Earnings per share reduced to a loss of Kshs (4.30) from Kshs 19.73 in the year 2013. Clinker production increased in the year reducing the quantity of purchased clinker by 39%.
Major improvements in production efficiencies however resulted in 3% savings in cost of production. However, the cost of energy increased marginally in the year averaging Kshs.13.36 per kwh compared to kshs 12.70 per kwh in 2013. Power consumption averaged 69.1 million kwh in the current year compared to 67.7 million kwh in the previous year resulting in additional costs of Kshs. 70 million during the year in focus due to the higher production of clinker. As a result of the cost savings, Gross Margin returned an impressive 26% despite a 3% slump in cement prices.
Administrative and Selling Costs increased by Kshs 700m (or 34%) attributed to higher staff and administration expenses incurred in the year. There was an increase in staff costs driven by restructuring management levels and staff compensation.
For the year under review, the Company returned an operating loss of Kshs. 92 million compared to prior year operating profit of Kshs. 340 million while the loss before tax was Kshs. 374 million compared to a profit before tax of Kshs. 1,419 million the previous year.
The previous year’s results included Fair Value Gain on revaluation of the investment property amounting to Kshs. 730 million. Cash flows generated from operations remained relatively stable at above Kshs 700 million similar to the previous year. Investments in long term capital projects used up Kshs. 597 million while servicing of loan obligations used up another Kshs. 541 million during the year.
Required
a. Calculate the key ratios under each of the categories below to evaluate the financial performance of the company
1. Liquidity ratios.
- Current ratio
- Cash ratio
2. Gearing/leverage/capital structure ratios.
- Debt ratio
- Capital gearing ratio
- Interest cover ratio
3. Profitability ratios.
- Gross profit margin
- Net profit margin
- Return on capital employed
- Return on equity
4. Growth and valuation ratios.
- Earnings per share
- Price-earnings ratio given average share price for 2014 to be sh 53
- Earning yield
b. Provide a detailed analysis of the company performance, indicating whether you concur with the report provided by the management on the financial performance of the company.
Date posted: November 8, 2021.
- State and explain the limitations of ratio analysis.(Solved)
State and explain the limitations of ratio analysis.
Date posted: November 8, 2021.
- State and explain the advantages of ratio analysis.(Solved)
State and explain the advantages of ratio analysis.
Date posted: November 8, 2021.
- What are the bases used in ratio analysis?(Solved)
What are the bases used in ratio analysis?
Date posted: November 8, 2021.
- Name five broad categories of ratio analysis.(Solved)
Name five broad categories of ratio analysis.
Date posted: November 8, 2021.
- A company expects to earn a rate of return of 10% on its investment of sh 11,000 after one year. How much does it need...(Solved)
A company expects to earn a rate of return of 10% on its investment of sh 11,000 after one year. How much does it need to invest now to attain the above returns?
Date posted: November 8, 2021.
- Find the compound amount, which would be obtained from a principal of sh 2000 at 8% compounded quarterly for 5 years.(Solved)
Find the compound amount, which would be obtained from a principal of sh 2000 at 8% compounded quarterly for 5 years.
Date posted: November 8, 2021.
- If you borrowed sh 10,000 for 3 years at 5% simple annual interest, how much will you have paid by the end of three years?(Solved)
If you borrowed sh 10,000 for 3 years at 5% simple annual interest, how much will you have paid by the end of three years?
Date posted: November 8, 2021.
- An investor is considering investing in the stock market. One of the stocks he has identified has the following characteristics;
Required
Compute;
1. Expected rate of return for the...(Solved)
An investor is considering investing in the stock market. One of the stocks he has identified has the following characteristics;
Required
Compute;
1. Expected rate of return for the investment
2. The variance of the return
3. The standard deviation of the return
4. COV
Date posted: November 8, 2021.
- Discuss the various measures of risk.(Solved)
Discuss the various measures of risk.
Date posted: November 8, 2021.
- State and explain the factors influencing the required rate of return.(Solved)
State and explain the factors influencing the required rate of return.
Date posted: November 8, 2021.
- An investor is planning to invest in the following conditions;
Required
Calculate the expected rate of return
(Solved)
An investor is planning to invest in the following conditions;
Required
Calculate the expected rate of return
Date posted: November 8, 2021.
- A portfolio of investments consists of the following individual investments and their market values;
Required
Calculate the weighted HPY of the portfolio of investment(Solved)
A portfolio of investments consists of the following individual investments and their market values;
Required
Calculate the weighted HPY of the portfolio of investment
Date posted: November 8, 2021.
- The data below relates to an investment;
Required
Calculate
1. Arithmetic mean (AM)
2. Geometric mean(GM)
(Solved)
The data below relates to an investment;
Required
Calculate
1. Arithmetic mean (AM)
2. Geometric mean(GM)
Date posted: November 8, 2021.
- An investment costs sh 250,000 and its worth sh 350,000 after being held for two years. Calculate;
1. HPR
2. HPY
3. Annual HPR
4. Annual HPY
(Solved)
An investment costs sh 250,000 and its worth sh 350,000 after being held for two years. Calculate;
1. HPR
2. HPY
3. Annual HPR
4. Annual HPY
Date posted: November 8, 2021.
- Briefly describe the historical rate of return as a type of return by an investor.(Solved)
Briefly describe the historical rate of return as a type of return by an investor.
Date posted: November 8, 2021.
- Name the three types of returns can be evaluated by an investor.(Solved)
Name the three types of returns can be evaluated by an investor.
Date posted: November 8, 2021.
- State and explain the different types of micro level risks.(Solved)
State and explain the different types of micro level risks.
Date posted: November 8, 2021.
- State and explain the two main different types of macro level risks.(Solved)
State and explain the two main different types of macro level risks.
Date posted: November 8, 2021.
- Outline the methods used in carrying out risk analysis.(Solved)
Outline the methods used in carrying out risk analysis.
Date posted: November 8, 2021.
- State and explain the different types of long term financing.(Solved)
State and explain the different types of long term financing.
Date posted: November 8, 2021.
- State the disadvantages of using preference share capital.(Solved)
State the disadvantages of using preference share capital.
Date posted: November 8, 2021.
- State the advantages of using preference share capital.(Solved)
State the advantages of using preference share capital.
Date posted: November 8, 2021.
- What are the characteristics of ordinary shareholders of a business?(Solved)
What are the characteristics of ordinary shareholders of a business?
Date posted: November 8, 2021.
- Outline the classification of preference shares.(Solved)
Outline the classification of preference shares.
Date posted: November 8, 2021.
- Outline the factors influencing choice of finance.(Solved)
Outline the factors influencing choice of finance.
Date posted: November 8, 2021.
- State the disadvantages of share capital as a type long term financing.(Solved)
State the disadvantages of share capital as a type long term financing.
Date posted: November 8, 2021.
- State the advantages of share capital as a type long term financing.(Solved)
State the advantages of share capital as a type long term financing.
Date posted: November 8, 2021.
- State the advantages of venture capital as a type long term financing.(Solved)
State the advantages of venture capital as a type long term financing.
Date posted: November 8, 2021.
- State the disadvantages of venture capital as a type long term financing.(Solved)
State the disadvantages of venture capital as a type long term financing.
Date posted: November 8, 2021.