Question: 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
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.
Step by Step Solution
3.31 Rating (160 Votes )
There are 3 Steps involved in it
Project 1 Initial Invest 490000 Cash inflows of 100000 for years 15 and 50000 for years 610 Year Cash Flows PVF 45 Present Value Cumulative Cash Flows 0 49000000 49000000 1 10000000 0957 9569378 39000... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (1 attachment)
68-B-E-M-E (2079).xlsx
300 KBs Excel File
