8. (You will need a computer for this problem.) The following informa- tion is available about an investment opportunity. Investment will occur at time 0 and sales will commence at time 1.

a. Prepare a spreadsheet to estimate the project's annual after-tax cash flows.

b. Calculate the investment's internal rate of return and its NPV.

c. How do your answers to questions

(a) and

(b) change when you assume a uniform inflation rate of 8 percent a year over the next 10 years? (Use the following equation to calculate the nominal dis- count rate: in = (1+i)(1 + p) 1, where in is the nominal dis- count rate, i, is the real discount rate, and p is expected inflation.)

d. How do you explain the fact that inflation causes the internal rate of return to increase and the net present value to decrease?

e. Does inflation make this investment more attractive or less attrac- tive? Why?

Transcribed Image Text:

Initial cost Unit sales Selling price per unit, this year Variable cost per unit, this year Life expectancy Salvage value Depreciation Tax rate Nominal discount rate Real discount rate Inflation rate $10 million 100,000 $50.00 $20.00 10 years SO Straight-line 34% 10.0% 10.0% 0.0%