Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1/ 9
3
Semi-Annual Yield 0.0277042424088882
PV of Annuity ₹ 82.14 PV of Face Value 22.8623009225771 Sum ₹ 105.00
a Annual Yield 5.54%
b AfterTax 4.32% c After Tax is more relevant
Annual Yield 4.38%
PV of Face Value 68.0000029229178
Bond 1 25000000 Bond 2 60000000
Total Market Value ₹ 6,704,999,630.90
Total Book Value ₹ 8,500,000,000.00 After Tax Kd 3.68%
Debt 0.319648716689098 Equity 0.680351283310902 Value 1 D/E 0.469828931803496 Ke 0.11 Kd 0.064 WACC 0.09100008028 0.091
a Equity Value 509200000
Bond Value 160660000 Total Value 669860000 Ke 0.106 Kd 0.0575265400557783 0.0442954358429 WACC 0.0912007057034727 11
Debt Equity No of Bonds 17000 No of Shares Par Value 2000 Market Price Coupon Rate 2.95% Years 40 Beta Semi Annual Kd 0.0274259585591423 Risk Premium PV of Annuity ₹ 1,422.35 Rf PV of Face Value 677.654966694921 Total PV ₹ 2,100.00 2100 Total Debt Mkt Value 35700000 Total Equity Mkt Value Annual Kd 5.49% Ke 64175000 Tax Rate 0.21
WACC 6.70%
12
Debt Equity No of Bonds 175000 No of Shares Par Value 1000 Market Price Coupon Rate 3.10% Years 50 Beta Semi Annual Kd 0.0287242424259383 Risk Premium PV of Annuity ₹ 817.31 Rf PV of Face Value 242.689665670101 Total PV ₹ 1,060.00 1060 Total Debt Mkt Value 185500000 Total Equity Mkt Value Annual Kd 5.74% Ke After Tax Kd 0.0448098181844638 524700000 Tax Rate 0.22
WACC 8.64%
16
PV of CFs 25133799.9176616 WACC 10.360606060606100%
D/E 0.65 D/V 0.393939393939394 E/V 0.606060606060606 Ke 11% Kd 4.30%
Ans Accept the project if cost is less than 25133799.92
17
Bond 1 Equity No of Bonds 40000 No of Shares Par Value 1000 Market Price Coupon Rate 2.95% Years 30 Beta Semi Annual Kd 0.278466557027415 Risk Premium PV of Annuity ₹ 105.87 Rf PV of Face Value 0.629968510650051 Total PV ₹ 106.50 106.5 Total Debt Mkt Value 4260000 Total Equity Mkt Value Annual Kd 42.88% Ke 155577000 Tax Rate 0.23
0.011742429798252 WACC 11.96%
18
Debt 4999999.99999999 Equity 25000000
Floatation Cost %age 6.33% 31900000
Absolute Floatation 1900000 1900000
D/E 0.2
19
a Dividend in Y1 0.78375 g 4.50% Current Price 84 Ke 5.43%
9.99905708701048 11.9889 13.18779 Horizon Value 434.793169019953 NPV 348.221668373163 Equity 303.221668373163 No of Shares 1.95
Price per Share ₹ 155.50
Bond 1 Bond 2 No of Bonds 800000 650000 Par Value 100 100 Coupon Rate 3.40% 3.55% Years 18 50 Semi Annual Kd 0.027252 0.030623195857514 PV of Annuity ₹ 47.87 ₹ 90.27 PV of Face Value 61.63302 22.1311694251746 Total PV ₹ 109.50 ₹ 112.40 109.5 112.4
339200000 10.92% Equity Bond 1 Preference Stock 1900000 No of Bonds 40000 No of Shares 73 Par Value 10000 Market Price Coupon Rate 0.00% 1.15 Years 60 Par Value 0.07 Semi Annual Kd 0.1075390366 Dividend 0.036 PV of Annuity ₹ 0.00 PV of Face Value 21.800048224 Total PV ₹ 21.80 21.8 138700000 Total Debt Mkt Value 872000 Total Equity Mkt Value 11.65% Annual Kd 16.56% Ke
