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

Use this Excel spreadsheet (click me) to answer question 6-8…

Use this Excel spreadsheet (click me) to answer question 6-8.  The equipment for this project uses the 5-year MACRS depreciation schedule, highlighted in bold; when the project concludes after 6 years, the equipment will expire worthless. What is the cash flow in year 1?