4
1
5
17
18
1
9Beginning Year 1
20
2
5
26
Rows 5 to 7, and 23, plus cell B8are data.
27 The formula in cell C8 is: =B8*(1+C5). Then copy cell C8 to cells D8, E8, F8, and G8.
28 The formula in cell C9 is: =C6*C8. Then copy cell C9 to cells D9, E9, F9, and G9.
2
9The formula in cell C10 is: =C9*(1-.4). Then copy cell C10 to cells D10, E10, F10, and G10.
3
0The formula in cell B11 is: = B7*B8. Then copy cell B11 to cells C11, D11, E11, F11, and G11.
3
1The formula in cell C12 is: =B11-C11. Then copy cell C12 to cells D12, E12, F12, and G12.
3
2The formula in cell C14 is: =C10+C12. Then copy cell C14to cells D14, E14, F14, and G14.
3
3The formula in cell F16 is: =G14/(B21-G5).
3
4The formula in cell B22 is: =NPV(B21,C14:F14)+F16/(1+B21)^4.
3
5The formula in cell B24 is: =B22-B23.
3
6
b.
To estimate the changes in equity value resulting from the suggested performance improvements,
simply modify the relevant data in the spreadsheet used in part a. To find the estimated amount of
value created, simply deduct $1,873 million, the DCF value of Portal’s equity without
improvements, that is its value “as is.”
Action
Expected Cash Flows from
Assets
($ millions)
New DCF Value Value Created
12-7