A firm has a cost of capital of 10% and a capital budget of…

A firm has a cost of capital of 10% and a capital budget of $30 million.  The firm must employ capital rationing; there is no possibility of raising additional capital at this time.  The finance manager estimates the cost and IRR of all projects in this spreadsheet (click me) Which projects should be accepted?  (Note that none of the projects are mutually exclusive).