You are analyzing an investment in Project X. The project requires an initial investment of $5,300. It will generate cash flows of $3,000 in year 1, $2,000 in year 2, and 900 in year 3. In year 4 the project will require an additional investment of $2,000. The project will then generate cash flows of $1,500 per year in years 5, 6, and 7.

1	Construct a tool to calculate the NPV of the project at discount rates of 15% and 20%.
	Highlight the cells with the answer in yellow.
	The tool should be able to calculate the NPV correctly if you change the cash flows.
	The tool should be able to calculate the NPV correctly if you change the discount rates.
	Use absolute references wherever you can.
2	Calculate the IRR of the project.
	Use the Excel IRR function.
	Highlightb the cell with the answer in yellow.