Analyse questions 1 until 6 and write a report. Take note that this report is meant Mr Ramli who is not well verse in finance.
Analyse questions 1 until 6 and write a report. Take note that this report is meant Mr Ramli who is not well verse in finance. Hence, you need to explain the intuition behind your calculations. For example, tell Mr Ramli why different discount rates (RWACC, RE and RO) are used to discount the cash flows in different NPV methods. And why it makes sense to use peers? cost of equity to estimate Mr Ramli?s new venture, etc.
The Case
Mr Ramli was a founder of business that specializes in the plastic moulding industries. His business has been established in the market since mid-1990s as a privately owned company. The company has been grown steadily over the years with all the profits being reinvested in the business.
Recently, he intended to expand his company by launching a new plastic moulding line. Thus, he needed to calculate the net present value (NPV) of the projected cash flows to determine the attractiveness of the new expansion. His key concern was determining a reasonable discount rate to apply to cash flows in order to calculate the project's net present value (NPV). Mr Ramli approached a consultant friend to look into the comparable businesses in the same industry's cost of capital. In this case, the basic idea is that businesses in the same sector often have similar clients, activities, and properties, thus they face similar business risks and should have similar capital costs.
The first step to value the project, Mr Ramli prepared projected earnings for the coming five years. He also prepares projected balance sheet and estimated cash flow. Although the growth rate over the 5-years forecast period was high, he felt that the growth rate will be stabilised at 5 percent per year after the initial high growth of 5 percent at the initial high growth phase. His main concern was to find a suitable discount rate to be applied to cash flows to ascertain the NPV of project.
Expansion Plan
The demand for plastic products was growing in the country and thus there are a lot of potential demand from other countries. However, the company could not realize its hidden potential as investment in capital expenses over the last few years. Mr Ramli felt the new investment needed to be installed on a priority basis and capital expenditures had to be continued to sustain the growth the firm.
The new manufacturing line for plastic products would involve the usage of eco-friendly plastic ingredients and production technologies such that the final plastic products are recyclable. This is in line with Mr Ramli?s wish to become an Environmental, Social and Governance (ESG) plastic moulding company. Mr Ramli aims to make his company to be the first plastic moulding company to be included in Bloomberg?s ESG rating. Research has shown that ESG rated companies received a higher valuation and have greater access to financing, thus, lower cost of capital.
Financial assessment
Mr Ramli wanted to maintain separate accounts for the new projects so that performance of the new expansion could be monitored independently. Through the debt component for the parent company was negligible, the new projects were proposed to be financed with the debt to asset of 30.6%[1] with debt value of $8 million. Accordingly, projected balance sheet for the next 5 years were prepared and can be found in Exhibit 2.
To estimate profitability of the new project, Mr Ramli could easily estimate free cash flow to the firm for the next 5 years from the projected financial statement. Although the operations were expected to grow at a high rate during the next 5 years, Mr Ramli debt that the growth may not be sustainable in the long run and considered a perpetual growth rate of 5 percent per year in cash for beyond the initial five years. The main problem was to find a suitable discounting rate for the company. As the company was not listed in any stock exchange, project beta and cash flow cannot be determined.
According to the consultant?s suggestion, Mr Ramli should evaluate the riskiness of similar plastic moulding company listed in the market and estimate the cost of capital of the company using publicly available information. As it was difficult to identify a single company whose risk profile would exactly match the plastic moulding project, he decided to review the cost of capital of the major plastic moulding companies operating in Malaysia. Since there was limited plastic moulding companies managed privately, the comparison was limited to companies listed in the Bursa Malaysia stock exchange. Mr Ramli decided to use the business risk of these companies as his reference point.
Refer to Exhibit 2 for the details of competing firms. These companies were operating in the same business domain and should have broadly similar business risk and thus similar cost of capital. To arrive the cost of equity of these companies using CAPM (Capital asset Pricing Model). Mr Ramli requires measures of equity beta, risk free rate and expected market rate of return. The Beta (?) of a stock measures the correlated volatility of an equity stock in relation to the volatility of benchmarked asset. A stock market index is generally used as a benchmark. The formula for estimating equity beta of a firm is:
?equity=
r equity= rate of return on equity
r market index= rate of return of market portfolio
= Covariance from two rates of return
Beta can also be estimated using regressing the return series of the stock against stock market index. The equity betas of the companies were calculated using the daily stock prices of these companies and the value of KLCI stock marke index. Historically, the 10 year government bond yielded on an average 3% return. In the country, interest rate decision are taken by the central bank. Considering these factors, Mr Ramli use risk free rate 3% per year. This rate also closely matched the discount rate of long term maturity trasury bills. Mr. Ramli carried out a survey where market risk premium of several countries were compiled. As a result, Mr Ramli decides to apply a market risk premium of 8%. He was confident these inputs were adequate to ascertain cost of capital of the firm. To keep the analysis simple, he assumed a uniform tax rate of these companies at 30%. Further, debts of the companies including his companies were considered risk free and an identical cost of debt of 3% and 5% respectively were taken for the valuation plan.
Exhibit 1: Selected Projected Cash Flow Items (million dollar) | ||||||
Year |
1 |
2 |
3 |
4 |
5 |
|
Cash inflows |
4,400 |
4,900 |
5,400 |
5,900 |
6,400 |
|
Cash costs |
2,400 |
2,700 |
3,000 |
3,300 |
3,600 |
Exhibit 2: Plastic Moulding companies | |||||||||
Company |
Year Ending |
Face value |
Book Value |
Market Cap (Million Dollar) |
Net Income (Million Dollar) |
Equity (Million Dollar) |
Debt (Million Dollar) |
Equity Beta |
|
Eng Huat Plastic |
Dec 2019 |
10 |
222.1 |
8704 |
142.2 |
3,774.2 |
1740.8 |
0.5472 |
|
Jaki Plastic |
Mar 2020 |
2 |
43.5 |
58,237.8 |
1,678.7 |
5,200.4 |
17471.1 |
0.2638 |
|
Avery Plastic |
Dec 2019 |
10 |
272 |
121,160.1 |
3,552 |
11,441.82 |
24232 |
0.2 |
|
Bolder Plastic |
Mar 2020 |
10 |
46 |
74,938.8 |
1073.4 |
2,995.5 |
11240.7 |
0.9856 |
|
Fitness Plastic |
Mar 2020 |
1 |
8.9 |
6,116.3 |
909.9 |
910.5 |
1223.2 |
0.6357 |
|
George Plastic |
Mar 2020 |
1 |
26.6 |
8996.9 |
2,347.4 |
23,611.8 |
2241.5 |
0.5393 |
|
National Plastic |
Mar 2020 |
10 |
336.3 |
4669.2 |
351.6 |
3,157.9 |
933.8 |
0.669 |
|
Eastern plastic |
Mar 2020 |
10 |
47.8 |
15,336.9 |
676.5 |
1,868.6 |
766.8 |
0.5372 |
|
- Calculate the levered and unlevered cash flows for the proposed moulding project for the next five years.
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Cash inflows |
4,400.00 |
4,900.00 |
5,400.00 |
5,900.00 |
6,400.00 |
Cash costs |
2,400.00 |
2,700.00 |
3,000.00 |
3,300.00 |
3,600.00 |
Operating income |
2,000.00 |
2,200.00 |
2,400.00 |
2,600.00 |
2,800.00 |
Corporate tax (30%) |
600.00 |
660.00 |
720.00 |
780.00 |
840.00 |
Unlevered cash flow (UCF) |
1,400.00 |
1,540.00 |
1,680.00 |
1,820.00 |
1,960.00 |
Terminal value at year 5 |
55,621.62 |
||||
UCF + TV |
1,400.00 |
1,540.00 |
1,680.00 |
1,820.00 |
57,581.62 |
Cash inflows |
4,400.00 |
4,900.00 |
5,400.00 |
5,900.00 |
6,400.00 |
Cash costs |
2,400.00 |
2,700.00 |
3,000.00 |
3,300.00 |
3,600.00 |
Operating income |
2,000.00 |
2,200.00 |
2,400.00 |
2,600.00 |
2,800.00 |
Interest Payment (3%) |
60.00 |
66.00 |
72.00 |
78.00 |
84.00 |
Income after interest |
1,940.00 |
2,134.00 |
2,328.00 |
2,522.00 |
2,716.00 |
Corporate tax (30%) |
582.00 |
640.20 |
698.40 |
756.60 |
814.80 |
Levered cash flow (LCF) |
1,358.00 |
1,493.80 |
1,629.60 |
1,765.40 |
1,901.20 |
Terminal value at year 5 |
53,952.97 |
||||
LCF + TV |
1,358.00 |
1,493.80 |
1,629.60 |
1,765.40 |
55,854.17 |
- Risk free rate: 3%
- Market risk premium: 8%
- Industry total beta: 4.4
CAPM = 3% + 4.4 (8% - 3%)
= 3% + 22%
= 25%
- Debt to asset financing: 30.6%
- Cost of debt: 5%
- Corporate tax: 30%
WACC = 0.306 (0.25) + 0.306 (0.05) (1 ? 0.30)
= 0.0765 + 0.01071
= 0.08721 @ 8.7% (Required return)
- Growth rate: 5%
Terminal value = Year 5 cash flow * (1 + g) / (r ? g)
UCF = RM1,960*(1 + 0.05)/ (0.087 ? 0.05) = RM55,621.62
LCF = RM1,901.2*(1 + 0.05)/ (0.087 ? 0.05) = RM53,952.97
- Estimate the average cost of unlevered equity for plastic moulding companies in Exhibit 3 (Hint: Use CAPM & MM II RS formula).
- Industry Beta (average): 0.55
- Industry total debt: RM59,849.90
- Industry total Equity: RM52,960.72
- Debt-Equity ratio: RM59,849.90/RM52,960.72 = 1.13
CAPM: = + ( - ) ?
= 3% + 8% (0.55)
= 3% + 4.4%
= 7.4%
MMII: = + [() ? (1 - ) ? ( - )
7.4% = + [(1.13) ? (1 ? 0.30) ? ( ? 0.05)
7.4% = + ( ? 0.05) ? 0.791
7.4% = + 0.791 ? 0.03955
7.4% + 3.955 = 1.791
1.791 = 11.355%
= 11.355% / 1.791
= 6.34% @ 0.634
- Estimate the cost of levered equity (RS) for Ramli?s proposed plastic moulding project (Hint: MMII RE formula, use R0=from (2) above).
MMII : = + [() ? (1 - ) ? ( - )
= 6.34% + [(1.13) ? (1 ? 0.30) ? (6.34% - 5%)
= 6.34% + 1.05994
= 7.39994 @ 7.4%
- Estimate the WACC for Ramli?s proposed plastic moulding project
Debt/Equity, which is =1.13
Debt to value of firm = Debt / Value of firm
=
= /
= /
= 0.5305 @ 0.531
Equity to firm value = 1 ? Debt to value of firm
= 1 ? 0.531
= 0.469
= [() ? (1 - ) ? ] + [) ? ]
= [0.531 ? (1 ? 0.30) ? 5%) + [0.469 ? 7.40%]
= 1.8585 + 3.4706
= 5.3291 @ 5.33%
- Calculate net present value of the project assuming that initial investment is equal to $11 million using WACC, APV and FTE methods. What would be your recommendation?
WACC method = (Unlevered cash flow / RWACC) ? Initial investment
= (RM8,400,000 / 5.3291) ? RM11,000,000
= -RM9,423,748.85
APV method = NPVunlevered+ tc*B
= UCF/R0 ? Initial investment + tC*B
= (RM8,400,000/6.34 - RM11,000,000) + 0.3* RM8,000,000
= -RM7,275,078.86
FTE method = LCF/RS - (Investment-Amount borrowed)
= RM8,148,000/7.4 ? (RM11,000,000 ? RM8,000,000)
= -RM1,898,918.92
Our recommendation for the net present value of the project that suitable is FTE method because the loss of the company is lesser compared to the other method. Negative net present value meaning that the project is expected to result in a net loss for the company.
[1] As in Ross et al.?s textbook Chapter 18, the 30.6% debt ratio is determined from Debt/Initial investment+ APV.
6. Repeat the NPV calculations using perpetuity method (use first year UCF or LCF as the cash flow variable). Explain why perpetuity cash flows yields lower NPV values than the supernormal growth cash flows in (5).
Rs Rs Rs Rs Rs
Step by Step Solution
3.40 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
6 Calculation of NPV in perpetuity method NPV ar Cash outflow Cash inflow 814800074 110000008000000 ...See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Document Format ( 1 attachment)
61b03806d72ce_85888.docx
120 KBs Word File
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started