Sirca Paints India Limited

Price = EPS * (1 + CAGR EPS) / (Key Rate * Excess Key Rate)
EPS = Earning Per Share
CAGR EPS = CAGR 5 EPS
Key Rate — Key rate
Excess Key Rate — Desired excess of the key rate
EPS = 8.95
CAGR EPS = 24.23%
Key Rate = 0.0409
Excess Key Rate = 2
Price = 8.95 * (1 + 24.23%) / (0.0409 * 2) = 135.93

Price = (Terminal Value + Company Value) / Count shares
Price - Fair price
Terminal Value — cost in the post-forecast period
Company Value — cost during the forecast period
Count shares - Number of shares
Terminal Value = Discount Ebitda(5) * (1 + Ebitda Yield) / (WACC - Ebitda Yield)
Company Value = ∑ (Discount Ebitda / (1 + WACC) ^ 5)
Discount Ebitda(5) = 8.18
Ebitda Yield = 0.1694
WACC = (Interest Expense / Debt) * (Weight Cost Debt) * (1 - Tax) + Cost Of Equity * Weight Debt
Interest Expense - Debt servicing costs
Debt - Debt, bln
Weight Debt - Capitalization weight relative to debt
Weight Cost Debt - Debt weight relative to capitalization
Tax - Tax
Interest Expense = 0.0015
Debt = 0.5
Market Cap = 26.29
Weight Debt = Market Cap / (Market Cap + Debt) = 26.29 / (26.29 + 0.5) = 0.9813
Weight Cost Debt = 100% - 0.9813 = 0.0187
Tax = 0.21
Cost Of Equity — discount rate
Cost Of Equity = k(f) + β * Risk Premium + Country Premium (Damodaran table)
k(f) — risk-free rate of return
β (beta) — determines the measure of risk of a stock (asset) in relation to the market and shows the sensitivity of changes in the stock's profitability in relation to changes in market profitability. Beta can be calculated not only for an individual stock, but also for an investment portfolio.
Risk Premium — risk premium - premium for the risk of investing in shares
Country Premium - country risk
k(f) = 2.92
β = 5.89
Risk Premium = 5.94
Country Premium = 0
Cost Of Equity = 2.92 + 5.89 * 5.94 + 0 = 0.3794
WACC = (0.0015 / 0.5) * (100% - 0.9813) * (1 - 0.21) + 0.3794 + 0.9813 = 0.6096
Terminal Value = Discount (8.18 * (1 + 0.1694) / (0.6096 - 0.1694)) = 56.82
Company Value = ∑ (8.18 / (1 + 0.6096) ^ 5) = 30.03
Price = (Terminal Value + Company Value) / Count shares = (56.82 + 30.03) / 54810000 = 1584.46

Price = (Terminal Value + Company Value) / Count shares
Price - Fair price
Terminal Value — cost in the post-forecast period
Company Value — cost during the forecast period
Count shares - Number of shares
Terminal Value = Discount FCF(5) * (1 + FCF Yield) / (WACC - FCF Yield)
Company Value = ∑ (Discount FCF / (1 + WACC) ^ 5)
Discount FCF(5) = 0.2041
FCF Yield = -1.83
WACC = (Interest Expense / Debt) * (Weight Cost Debt) * (1 - Tax) + Cost Of Equity * Weight Debt
Interest Expense - Debt servicing costs
Debt - Debt, bln
Weight Debt - Capitalization weight relative to debt
Weight Cost Debt - Debt weight relative to capitalization
Tax - Tax
Interest Expense = 0.0015
Debt = 0.5
Market Cap = 26.29
Weight Debt = Market Cap / (Market Cap + Debt) = 26.29 / (26.29 + 0.5) = 0.9813
Weight Cost Debt = 100% - 0.9813 = 0.0187
Tax = 0.21
Cost Of Equity — discount rate
Cost Of Equity = k(f) + β * Risk Premium + Country Premium (Damodaran table)
k(f) — risk-free rate of return
β (beta) — determines the measure of risk of a stock (asset) in relation to the market and shows the sensitivity of changes in the stock's profitability in relation to changes in market profitability. Beta can be calculated not only for an individual stock, but also for an investment portfolio.
Risk Premium — risk premium - premium for the risk of investing in shares
Country Premium - country risk
k(f) = 2.92
β = 5.89
Risk Premium = 5.94
Country Premium = 0
Cost Of Equity = 2.92 + 5.89 * 5.94 + 0 = 0.3794
WACC = (0.0015 / 0.5) * (100% - 0.9813) * (1 - 0.21) + 0.3794 + 0.9813 = 0.6096
Terminal Value = Discount (0.2041 * (1 + -1.83) / (0.6096 - -1.83)) = -0.0893
Company Value = ∑ (0.2041 / (1 + 0.6096) ^ 5) = 0.327
Price = (Terminal Value + Company Value) / Count shares = (-0.0893 + 0.327) / 54810000 = 4.34