The Excel spreadsheet template provided below contains detailed directions and figures regarding Blue Mesa's new project. Use the template to create a cash flow diagram of the project's inflows and outflows, as follows:
Input the yearly project inflows
Compute the discount factor for each year
Compute the NPV of the project
Using the cash flows in the template, use the IRR formula to calculate the IRR of the project
This solution provides a cash flow diagram in Excel and answers various business analysis questions.