Question: (Part 1) Using a 4.5% discount rate, calculate the Net Present Value , Payback, Profitability Index, and IRR for each of the investment projects below

(Part 1)

Using a 4.5% discount rate, calculate the Net Present Value, Payback, Profitability Index, and IRR for each of the investment projects below (note, the inflows are for each year). Based on your calculations rank the projects and support you answer.

Project 1

Initial Invest= $490,000, Cash inflows of $100,000 for years 1-5 and $50,000 for years 6-10.

Project 2

Initial Invest= $970,000, Cash inflows of $400,000 for years 1-3, $0 for years 4-7 and $250,000 for years 8-10.

Project 3

Initial Invest= $820,000, Cash inflows of $300,000 for years 1-5, $0 for years 6-9 and $100,000 for year 10.

(Part 2)

Assuming a budget of $1,100,000 what are your recommendations for the three projects in the above problem. Explain. Assuming a budget of $2,200,000 what are your recommendations for the above problem? Explain.

Step by Step Solution

3.35 Rating (164 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Part 1 Year Project 1 Project 2 Project 3 Cumulative Cash Flows Project 1 Project 2 Project 3 0 49000000 97000000 82000000 49000000 97000000 82000000 ... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Document Format (1 attachment)

Excel file Icon

68-B-C-F-C-B (1323).xlsx

300 KBs Excel File

Students Have Also Explored These Related Corporate Finance Questions!