This was a spreadsheet assignment given to me for the course Financial Management, which I took with Ms. Sana Fatima in Spring 2014. You can refer to the case, its solution at the end and answers to some critical questions in this blog. If you can think of more reasons for the Critical thinking answers, please do share them in the comments.
Spreadsheet Assignment 1
Fatima Fertilizers Company Limited
Sensitivity Analysis in Stock Valuation
Fatima Fertilizer Company Limited, a fully integrated fertilizer complex, was incorporated on 24th December, 2003 as a joint venture between two major business groups of Pakistan: Fatima Group and Arif Habib Group. The Company is listed at all stock exchanges of Pakistan, through a successful initial public offering (IPO) in February 2010 to fund the requirement of the project at the time of the listing.
Fatima Fertilizer currently maintains highest profit margins among its peers due to its diversified product portfolio (urea, CAN and NP) and consistent gas from the dedicated Mari gas field. The companies on the Sui gas network face large unpredictable swings in gas supply leading to detrimental effects on their productivity. These advantages of Fatima will translate into a high sales growth for the next 2-3 years and high operating margins (Exhibit 2).
Arif Habib group has had a history of paying strong dividends in all of their subsidiaries. The management of Fatima will try to reach a payout ratio of 75% as soon as possible; however, it will be difficult to achieve that in near future due to the accelerated debt repayments which they have planning. Fatima plans to achieve a debt free status by 2017 and thus, most of the cash generated from operations will be used to pay off debts in the next five years; hampering their ability to pay high dividends. Once the debt-free status is achieved in CY17, Fatima fertilizer will shift to the desired payout ratio of 75%.
Based on the assumption that in the long run fertilizer demand in Pakistan will be limited by the availability of cultivable land, the terminal growth rate in FCFF is pegged to the GDP growth rate of 3%.
Given the unavailability of gas, Fatima is not expected to expand its production capacity; however, the company will incur maintenance capital expenditure of about PKR500 mn starting from CY14 onwards. The balance sheet and income statement for the year just ended are given in exhibit 1. Market value of company’s long-term debt is same as the book value. Projected financials for the company are given in exhibits 2. The market premium is estimated to be 8% and risk-free rate is 11.5%. Historical beta for Fatima’s stock is 1.15×.
- Using the given information, compute the fair price per share of Fatima stock on Dec 31, 2011. Use FCFF valuation Model.
- Show how the fair price will change if:
i. The terminal growth rate changes (vary the TG rate from 0% to 10% with intervals of 1%).
ii. The risk-free rate changes (vary the RF rate from 5% to 15% with intervals of 1%).
Exhibit 1: Balance Sheet and Income Statement
|Depreciation and Amortization||746.378|
|As of December||2011|
|Other current assets||2,876|
|Total Current Assets||8,126|
|Net Fixed Assets||68,221|
|Creditors & accruals||7,725|
|Current Portion: LT Debt||3,033|
|Total Current Liabilities||10,758|
|Tax rate (%)||35|
|Interest rate on LT Debt (%)||12|
|Market Price per share (PKR)||22.92|
|Number of common shares (million)||2,100|
Exhibit 2: Forecasted Financials
|Operating Margin (EBIT/Sales)||49.39%||50.93%||50.91%||49.92%||48.97%|
|Investment in NWC (% of additional sales amount)||20%||10%||10%||10%||10%|
|Operating Margin (EBIT/Sales)||47.93%||46.81%||37.95%||35.5%|
|Investment in NWC (% of additional sales amount)||10%||5%||5%||5%|
Answers to Critical Thinking Questions:
- Why is the DDM model not appropriate for valuing the stock of Fatima?
The following reasons serve why DDM is inappropriate for Fatima:
- Because company is not a dividend paying firm, hence DDM model is not applicable here.
- The payout ratio is constant at 75%, hence there is no link between the profitability of the company and the dividend payout ratio, hence DDM is inappropriate to apply here.
- Also, since the company is observing a group holding structure which gives it a control perspective hence it serves as another reason why DDM is inappropriate here.
- Why is the FCFE model not appropriate for valuing the stock of Fatima?
- Since Fatima plans to achieve a debt-free status by 2017, thus changing its capital structure hence the FCFE is not appropriate.
- The future cash-flows tend to be negative due to the future high repayments, thus making FCFE negative, not reflecting the company’s actual state.
- What will happen to the beta value of Fatima stock once it achieves the debt-free status in CY17 as planned?
- Since the debt to equity ratio will fall, hence beta will also fall.
- Is using the single WACC figure appropriate for discounting the FCFFs for all years?
- Yes, because initially when the company is deciding on the capital structure it is assumed that this is the optimal capital structure for the company, and hence discounting it for long term is appropriate.
- WACC reflects the cost of the whole company and FCFF reflects the cash to all the capital holders hence it is the appropriate discount rate.
- Is an all-equity financing option good for companies? If not, why is Fatima planning to have a no-debt status?
- Where an all-equity financing option may be less riskier than a loan, may add more credibility to your business, while giving you cash on hand for the expansion of the firm, it also gives you the advantage of not being bound to repay.
- However, at the same time, it poses the threat of a lifelong obligation to the investors as compared to the debt financing when obligations end as soon as the loan is repaid. It also creates the disadvantage of a loss of control and higher regulations.
- Hence, a blend of the both the financing options, is optimal.
Fatima is going for a no-debt status because it plans to channel its profits towards capital expenditure.