Scribd
Upload
64 views2 pages

Financial Valuation Analysis

This document contains calculations to value a company using discounted cash flow analysis. It lists the company's projected free cash flows over 4 years and calculates the present value of those cash flows using a 5.3588% cost of capital discount rate. It then adds the present value of the cash flows to the calculated terminal value to derive an enterprise value of $26317.926555037 for the company.

Uploaded by

mzbabar319
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
64 views2 pages

Financial Valuation Analysis

This document contains calculations to value a company using discounted cash flow analysis. It lists the company's projected free cash flows over 4 years and calculates the present value of those cash flows using a 5.3588% cost of capital discount rate. It then adds the present value of the cash flows to the calculated terminal value to derive an enterprise value of $26317.926555037 for the company.

Uploaded by

mzbabar319
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

TV 23645.

8333333333

1 2 3 4
Free Cash Flow 1034 1045 1056 1075
PV 981.4082924255 941.4010089 902.9245713 872.4191745
26317.926555037
enterprise value
COC Cost of Capital
Rf+B(Rm -Rf)

Rf= 0.98 5 YEAR TREASURY RATE


B 0.89 RISK
Rm 5.9 MARKET RETURN (S&P 500 RETURN)

4.92
4.3788
COC 5.3588 %
TV=FCF/(r-g)

5 TV
1345 28020.83333
1036.0201606674 21583.75335

YEAR TREASURY RATE

ARKET RETURN (S&P 500 RETURN)

FV = PV(1+R)^N
PV=FV/(1+COC)^N

You might also like