Eliminate the (stage two) infinite horizon cash flows and recompute the value of the firm and the value added by the firm using the same five methods. Then, switch to evaluating a project while maintaining no infinite horizon cash flows. Compute the value of future cash flows and the NPV of the project using the same five methods. Finally, restore the infinite horizon cash flows and compute the value of future cash flows and the NPV of the project using the same five methods.

Start by considering firm valuation with no infinite. Just click on “No” option button in cell B10 (see below).

Transcribed Image Text:

1 2 A B FIRM AND PROJECT VALUATION 3 Inputs 4 Valuation Object Valuation Object C Firm Project 1 5 Date 0 Proj Investment or Firm Cap $800.00 6 Tax Rate 7 Unlevered Cost of Equity Capital 40.0% 10.0% 8 Riskfree Rate-Cost of Riskfree Debt 3.0% 9 Infinte Horizon Growth Rate 5.0% Infinite Horizon 10 Include Infinite Horizon? O Yes No 2 11