Attached is an excel sheet with problems regarding computation of capital structure. Please show all work so I can understand how you arrived at your conclusion.
a. Compute the NPV of the two investments using the firm's cost of capital.
Identify the preferred investment.
b. Compute the NPV of the two investments using the certainty-equivalent
approach. Identify the preferred investment.
In Excel, the problems are solved together with good narrative for better understanding.