BU IT needs you to analyze the impact of a new project that will cause its cash flows to increase $6,000 over last year’s, and continue to grow at a constant rate of 10% per year for the foreseeable future. The discount rate is 20%. You need to analyze this in three ways.
Calculate the NPV and IRR of this new project based on an initial investment cost of $45,000 and the change in cash flows each year, assuming the growth continues forever.
Find the NPV of this project if the project only generates cash flows for 20 years.
Use an embedded function in Excel to calculate the NPV of the project if the cash flows had zero growth, and the project only generates cash flows for 40 years.