Question

Wonderful Snacks has requested the following two sensitivity analyses of the proposed projects: npv= -379,147.91 and volume growth rate=10% and price growth rate= 3%

a. Create a one-way data table to calculate the net present value of the project at discount rates ranging between 5% and 25%. Use increments of 1%.

b. Create a two-way data table that calculates the net present value of the project at volume growth rates of 8%, 10%, and 12% and price per unit growth rates of 2%, 3%, and 4%.

Answer 1

Explanation:

two-way data table that calculates the net present value of the project at volume growth rates of 8%, 10%, and 12% and price per unit growth rates of 2%, 3%, and 4%.