Cash Flow Diagram of Inflows and Outflows
October 1st, 2022
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