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 dis­play the PI value used to rank the project.


(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)

Trades & Technology

You might also like to view...

Explain how to regenerate the desiccant dryer.

What will be an ideal response?

Trades & Technology

Whenever foresters alter natural controls, we say they are using ____ insect controls

A) natural B) biological C) chemical D) standard

Trades & Technology

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?

Trades & Technology

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

Trades & Technology