Question: how to solve this on excel Use data table function to calculate various of NPV for Project B. Use the following information to create the
how to solve this on excel
Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 3% 4% 5% 6% 7% 8% 9% 10% 11% 12% Use "data table" function to calculate various of NPV for Project B. Use the following information to create the two variables datatable: WACC: 3%, 4%, 5%, 6%, 7%, 8%, 9%, 10%, 11%, 12%, and The initial investment: 40,000, 50,000, 60,000, 70,000, 80,000, 90,000. (Present your answer at the coresponding space below) Project B -40,000 -50,000 -60,000 -70,000 -80,000 -90,000 3% 4% 5% 6% 7% 8% 9% 10% 11% 12%
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
