An NPV profile plots a projects NPV at various costs of capital. You are require to create NPV profile of a project and identify the range of cost of capital at which the firm choose to accept the project. Note: For the above question let say the project requires initial investment of x million $ and will generate a cash flow of y million $ for the next three years. The value of x and y is up to the discretion of student.

Note: Solve on Excel and show formulas.