Problem 3 Inputs discount rate Consider an investment project decision with the following inputs annual net...

Transcribed Image Text:

Problem 3 Inputs discount rate Consider an investment project decision with the following inputs annual net revenue growth rate Initial investment 15.00% 12.00% Show excel formulas for NPV and IRR below: -> (c) Would you invest in this project? Explain your answer (3 pts) (d) Given net revenue in years 1 through 6 that you have calculated in part a, what is the maximum initial investment you would be willing to make and still invest in the project? (7 pts) Answer: (e) Explain how to answer this question using Solver (10 pts) In Solver (fill in or leave empty appropriate cells below) Set objective: To: By Changing variable cells: Subject to the constraints: Problem 3 Inputs discount rate Consider an investment project decision with the following inputs annual net revenue growth rate Initial investment 15.00% 12.00% Show excel formulas for NPV and IRR below: -> (c) Would you invest in this project? Explain your answer (3 pts) (d) Given net revenue in years 1 through 6 that you have calculated in part a, what is the maximum initial investment you would be willing to make and still invest in the project? (7 pts) Answer: (e) Explain how to answer this question using Solver (10 pts) In Solver (fill in or leave empty appropriate cells below) Set objective: To: By Changing variable cells: Subject to the constraints: