Equity
This document was uploaded by user and they confirmed that they have the permission to share it. If you are author or own the copyright of this book, please report to us by using this DMCA report form. Report DMCA
Overview
Download & View Equity as PDF for free.
More details
- Words: 482
- Pages: 8
OPTION WORKSHEET: EQUITY AS AN OPTION
VALUING EQUITY AS AN OPTION This program calculates the value of equity as a call option on the value of the underlying firm.
Assumptions 1. All the assumptions underlying the Black-Scholes model apply 2. The value of the firm is known.
The user has to input the following variables 1. Current value of the underlying firm (or its assets). 2. Variance in the ln(value) of the underlying firm. 3. Face Value of the outstanding debt. 4. Riskless interest rate that corresponds to average duration of debt. 5. Face-value weighted duration of the debt outstanding of the firm. 6. Expected dividend yield on the stock of the firm.
OPTION WORKSHEET: EQUITY AS AN OPTION
Inputs relating the underlying asset Enter the value of the firm =
$1,200.00
(in currency)
There are two ways of estimating standard deviation. One is to use the firm's own stock and bond prices to estimate it. The other is to use th Which approach would you like to use to estimate variance?
F
Stock & Bond Price Variance Are the stocks and bonds of this firm traded?
Yes
Enter the standard deviation in the firm's stock price (ln) =
25%
Enter the standard deviation in the firm's bond price (ln) =
10%
Enter the correlation between the stock and bond prices =
0.3
Enter the average D/(D+E) ratio during the variance estimation period90% = Based upon these inputs, the standard deviation is=10.04% Industry average variance in firm value If yes, enter the annualized standard deviation in ln(value) of asset 15.00%
Enter the current annualized dividends on the stock (total) This will result in a dividend yield of
$0.00
(in currency)
No
(Yes or No)
0.00%
Do you want to change this dividend yield for the life of the option? If yes, enter the new dividend yield for the life of the option =
(in %)
Inputs relating to the option Enter the cumulated face value of outstanding debt $1,844.50 = Enter the average duration of outstanding debt =
3.94
(in currency) [Add coupons to the face value of debt] (in years)
OPTION WORKSHEET: EQUITY AS AN OPTION
(Weighted by the face value of the debt) General Inputs Enter the riskless rate that corresponds to the option lifetime =
8.00%
(in %)
OPTION WORKSHEET: EQUITY AS AN OPTION
Output Stock Price=
$1,200.00
T.Bond rate=
Strike Price=
$1,844.50
Variance=
Expiration (in years) =
3.94
d1 =
-0.48
N(d1) =
0.32
d2 =
-0.67
N(d2) =
0.25
Value of equity as a call = Value of outstanding debt =
Annualized dividend yield=
$44.37 $1,155.63
Appropriate interest rate for debt = 12.59%
8.00% 0.010075 0.00%
OPTION WORKSHEET: EQUITY AS AN OPTION
OPTION WORKSHEET: EQUITY AS AN OPTION
e it. The other is to use the variance of the industry to which your firm belongs.
OPTION WORKSHEET: EQUITY AS AN OPTION
OPTION WORKSHEET: EQUITY AS AN OPTION
VALUING EQUITY AS AN OPTION This program calculates the value of equity as a call option on the value of the underlying firm.
Assumptions 1. All the assumptions underlying the Black-Scholes model apply 2. The value of the firm is known.
The user has to input the following variables 1. Current value of the underlying firm (or its assets). 2. Variance in the ln(value) of the underlying firm. 3. Face Value of the outstanding debt. 4. Riskless interest rate that corresponds to average duration of debt. 5. Face-value weighted duration of the debt outstanding of the firm. 6. Expected dividend yield on the stock of the firm.
OPTION WORKSHEET: EQUITY AS AN OPTION
Inputs relating the underlying asset Enter the value of the firm =
$1,200.00
(in currency)
There are two ways of estimating standard deviation. One is to use the firm's own stock and bond prices to estimate it. The other is to use th Which approach would you like to use to estimate variance?
F
Stock & Bond Price Variance Are the stocks and bonds of this firm traded?
Yes
Enter the standard deviation in the firm's stock price (ln) =
25%
Enter the standard deviation in the firm's bond price (ln) =
10%
Enter the correlation between the stock and bond prices =
0.3
Enter the average D/(D+E) ratio during the variance estimation period90% = Based upon these inputs, the standard deviation is=10.04% Industry average variance in firm value If yes, enter the annualized standard deviation in ln(value) of asset 15.00%
Enter the current annualized dividends on the stock (total) This will result in a dividend yield of
$0.00
(in currency)
No
(Yes or No)
0.00%
Do you want to change this dividend yield for the life of the option? If yes, enter the new dividend yield for the life of the option =
(in %)
Inputs relating to the option Enter the cumulated face value of outstanding debt $1,844.50 = Enter the average duration of outstanding debt =
3.94
(in currency) [Add coupons to the face value of debt] (in years)
OPTION WORKSHEET: EQUITY AS AN OPTION
(Weighted by the face value of the debt) General Inputs Enter the riskless rate that corresponds to the option lifetime =
8.00%
(in %)
OPTION WORKSHEET: EQUITY AS AN OPTION
Output Stock Price=
$1,200.00
T.Bond rate=
Strike Price=
$1,844.50
Variance=
Expiration (in years) =
3.94
d1 =
-0.48
N(d1) =
0.32
d2 =
-0.67
N(d2) =
0.25
Value of equity as a call = Value of outstanding debt =
Annualized dividend yield=
$44.37 $1,155.63
Appropriate interest rate for debt = 12.59%
8.00% 0.010075 0.00%
OPTION WORKSHEET: EQUITY AS AN OPTION
OPTION WORKSHEET: EQUITY AS AN OPTION
e it. The other is to use the variance of the industry to which your firm belongs.
OPTION WORKSHEET: EQUITY AS AN OPTION
OPTION WORKSHEET: EQUITY AS AN OPTION
Related Documents
Equity
July 2020 42
Equity
November 2019 67
Equity Theory
June 2020 51
Brand Equity
June 2020 23
Equity Analysis
June 2020 27