Scribd
Upload
29 views3 pages

DCF Valuation

The document presents a financial analysis including equity, debt, and cash figures, along with projected EBIT and NOPAT over three years. It calculates Free Cash Flow to Firm (FCFF), present value (PV) of FCFF, and enterprise value, leading to an equity value and price per share. Key metrics such as WACC, EBITDA, and terminal value are also provided for valuation purposes.

Uploaded by

bhaitotal310
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
29 views3 pages

DCF Valuation

The document presents a financial analysis including equity, debt, and cash figures, along with projected EBIT and NOPAT over three years. It calculates Free Cash Flow to Firm (FCFF), present value (PV) of FCFF, and enterprise value, leading to an equity value and price per share. Key metrics such as WACC, EBITDA, and terminal value are also provided for valuation purposes.

Uploaded by

bhaitotal310
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 3

Given

Equity 30,000.00 Tax 30%


debt 75,000.00 Growth 3% add
cash 25,000.00 Interest 10% less
no of sh 250.00 10 yr Bond 7% less
cap ex 5,000.00 Rm 14%
Inc Non cash WC 2,000.00 Beta 2.00
Depn 3,100.00 EV / EBITDA 6
1 2 3
EBIT 10,000.00 11,500.00 13,500.00
NOPAT 7,000.00 8,050.00 9,450.00
Depn 3,100.00 3,100.00 3,100.00
Capex 5,000.00 5,000.00 5,000.00
Inc Non cash WC 2,000.00 2,000.00 2,000.00
FCFF(Foreseeable Future) 3,100.00 4,150.00 5,550.00
AVG TV(Beyond Foreseeable Period)
Total FCFF 3,100.00 4,150.00 5,550.00
Discount Factor 0.90 0.81 0.73
PV of FCFF 2,792.79 3,368.23 4,058.11
Enterprise Value

Equity Value Enterprise Value-Debt+Cash

Price Per Share Equity Value / No Of Shares


4 5
16,500.00 19,000.00 Ke 21.0%
### 13,300.00 Kd 7.0%
3,100.00 3,100.00 WACC 11.0%
5,000.00 5,000.00 EBITDA 22,100.00
2,000.00 2,000.00
7,650.00 9,400.00 TV(Intrinsic Formula) 121,025.00
126,812.50 TV(Multiple Method) 132,600.00
7,650.00 136,212.50 AVG TV 126,812.50
0.66 0.59
5,039.29 80,835.49
96,093.92

Debt+Cash 46,093.92

Of Shares 184.38

You might also like