There are five independent projects that must be evaluated on the basis of the profitability index. (a) Given an investment limit of $35 million and a MARR of 10% per year, select from the projects. (b) Write the spreadsheet function for a project, specifically for project 5, which will correctly display the PI value used to rank the project.
 FIGURE 1.png)
(a) PI1 = 900,000(P/A,10%,7)/4,000,000
= 900,000(4.8684)/4,000,000
= 1.10
PI2 = 1,900,000(P/A,10%,10)/7,000,000
= 1,900,000(6.1446)/7,000,000
= 1.67
PI3 = 2,900,000(P/A,10%,15)/17,000,000
= 2,900,000(7.6061)/17,000,000
= 1.30
PI4 = 3,600,000(P/A,10%,10)/15,000,000
= 3,600,000(6.1446)/15,000,000
= 1.47
PI5 = 5,000,000(P/A,10%,8)/30,000,000
= 5,000,000(5.3349)/30,000,000
= 0.89 (eliminated since PI < 1.0)
 ANSWER.png)
You might also like to view...
Explain how to regenerate the desiccant dryer.
What will be an ideal response?
Whenever foresters alter natural controls, we say they are using ____ insect controls
A) natural B) biological C) chemical D) standard
Medium temperature refrigeration coil temperatures ranging from 32°F down to 0°F are generally used for what applications?
What will be an ideal response?
The evaporator used in a truck air conditioning system is:
A. Usually located in front of the vehicles radiator B. In some way isolated from the ambient air C. Responsible for heating the air within the vehicle cab D. Not a type of heat exchanger