Colorado FIN300 Critical Thinking Irr Calculations Worksheet

FIN 300 Colorado State University Critical Thinking Irr Calculations Worksheet

OPTION #1: CAPITAL RATIONING

Table with Cash Flows for 5 projects.

1. Calculate the IRR for each of the projects presented. Rank the projects based on their IRR.
2. Graph the projects on an Investment Opportunity Schedule (interest rate on the vertical axis and initial investment on the horizontal). Suppose the firm has a capital rationing amount of $170,000 and a required rate of return of 10%.
3. Which projects should the firm implement based on your analysis using the IRR approach above? Write an email to your CFO explaining your rationale proving the choices based on the considerations of shareholder value and the maximum investment budget.

• Submit your 3 to 4 page paper in a Word document, showing all of your calculations (attach Excel File if necessary) with a minimum of four references.
• Use terms, evidence, and concepts from class readings.