Explore BrainMass

Cash Flow Diagram of Inflows and Outflows

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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

© BrainMass Inc. brainmass.com December 20, 2018, 12:59 am ad1c9bdddf


Solution Summary

This solution provides a cash flow diagram in Excel and answers various business analysis questions.