19.2 Impact of Risk
К оглавлению1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 1617 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67
68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84
85 86 87 88 89 90 91 92 93 94 95 96 97
Problem. What impact does the firm's risk have upon the firm's Debt and Equity valuation? Specifically,
if you increased Firm Asset Standard Deviation, then what would happen to the firm’s Equity Value and
Risky Debt Value?
Solution Strategy. Create a Data Table of Equity Value and Risky Debt Value for different input values
for the Firm's Asset Standard Deviation. Then graph the results and interpret it.
FIGURE 19.2 Spreadsheet of the Sensitivity of Equity Value and Risky Debt Value.
How To Build This Spreadsheet Model.
1. Start with the Debt and Equity Valuation - Two Methods Spreadsheet and Change the
Inputs. Open the spreadsheet that you created for Debt and Equity Valuation – Two Methods and
immediately save the spreadsheet under a new name using the File | Save As command.
2. Create A List of Input Values and Add Two More Output Formulas. Create a list of input
values for the Firm Asset Standard Deviation (30.0%, 40.0%, 50.0%, etc.) in the range C35:G35.
Add two more output formulas. One that references the firm’s Equity Value (E) by entering the
formula =C27 in cell B36. Another that references the firm’s Risky Debt Value (D) by entering
the formula =C29 in cell B37.
3. Data Table. Select the range B35:G37 for the Data Table. This range includes both the list of
input values at the top of the data table and the two output formulas on the side of the data table.
Then choose Data | Table from the main menu and a Table dialog box pops up. Enter the Firm
Asset Standard Deviation cell B5 in the Row Input Cell and click on OK.
4. Graph the Sensitivity Analysis. Highlight the range C36:G37 and then choose Insert | Chart
from the main menu. Select an XY(Scatter) chart type and make other selections to complete
the Chart Wizard.
Looking at the chart, we see that increasing the firm's asset standard deviation causes a wealth transfer
from debtholders to equityholders. This may seem surprising, but this is a direct consequence equity
being a call option and debt being V minus a call option. We know that increasing the standard deviation
makes a call more valuable, so equivalently increases the firm's asset standard deviation makes the firm's
Equity Value more valuable and reduces the Risky Debt Value by the same amount.
The intuitive rational for this is that an increase in standard deviation allows equityholders to benefit from
more frequent and bigger increases in V, while not being hurt by more frequent and bigger decreases in
V. In the later case, the equityholders are going to declare bankruptcy anyway so they don’t care how
much V drops. Debtholders are the mirror image. They do not benefit from more frequent and bigger
increases in V since repayment is capped at B, but they are hurt by more frequent and bigger decreases in
V. In the latter case, the size of the repayment default (B – V) increases as V drops more.
The possibility of transferring wealth from debtholders to equityholders (or visa versa) illustrates the
potential for conflict between equityholders and debtholders. Equityholders would like the firm to take on
riskier projects, but debtholders would like the firm to focus on safer projects. Whether the firm
ultimately decides to take on risky or safe projects will determine how wealth is divided between the two
groups.
Problem. What impact does the firm's risk have upon the firm's Debt and Equity valuation? Specifically,
if you increased Firm Asset Standard Deviation, then what would happen to the firm’s Equity Value and
Risky Debt Value?
Solution Strategy. Create a Data Table of Equity Value and Risky Debt Value for different input values
for the Firm's Asset Standard Deviation. Then graph the results and interpret it.
FIGURE 19.2 Spreadsheet of the Sensitivity of Equity Value and Risky Debt Value.
How To Build This Spreadsheet Model.
1. Start with the Debt and Equity Valuation - Two Methods Spreadsheet and Change the
Inputs. Open the spreadsheet that you created for Debt and Equity Valuation – Two Methods and
immediately save the spreadsheet under a new name using the File | Save As command.
2. Create A List of Input Values and Add Two More Output Formulas. Create a list of input
values for the Firm Asset Standard Deviation (30.0%, 40.0%, 50.0%, etc.) in the range C35:G35.
Add two more output formulas. One that references the firm’s Equity Value (E) by entering the
formula =C27 in cell B36. Another that references the firm’s Risky Debt Value (D) by entering
the formula =C29 in cell B37.
3. Data Table. Select the range B35:G37 for the Data Table. This range includes both the list of
input values at the top of the data table and the two output formulas on the side of the data table.
Then choose Data | Table from the main menu and a Table dialog box pops up. Enter the Firm
Asset Standard Deviation cell B5 in the Row Input Cell and click on OK.
4. Graph the Sensitivity Analysis. Highlight the range C36:G37 and then choose Insert | Chart
from the main menu. Select an XY(Scatter) chart type and make other selections to complete
the Chart Wizard.
Looking at the chart, we see that increasing the firm's asset standard deviation causes a wealth transfer
from debtholders to equityholders. This may seem surprising, but this is a direct consequence equity
being a call option and debt being V minus a call option. We know that increasing the standard deviation
makes a call more valuable, so equivalently increases the firm's asset standard deviation makes the firm's
Equity Value more valuable and reduces the Risky Debt Value by the same amount.
The intuitive rational for this is that an increase in standard deviation allows equityholders to benefit from
more frequent and bigger increases in V, while not being hurt by more frequent and bigger decreases in
V. In the later case, the equityholders are going to declare bankruptcy anyway so they don’t care how
much V drops. Debtholders are the mirror image. They do not benefit from more frequent and bigger
increases in V since repayment is capped at B, but they are hurt by more frequent and bigger decreases in
V. In the latter case, the size of the repayment default (B – V) increases as V drops more.
The possibility of transferring wealth from debtholders to equityholders (or visa versa) illustrates the
potential for conflict between equityholders and debtholders. Equityholders would like the firm to take on
riskier projects, but debtholders would like the firm to focus on safer projects. Whether the firm
ultimately decides to take on risky or safe projects will determine how wealth is divided between the two
groups.