You are talking about hurdle rate. This 'target discount rate' should equal AT LEAST the cost of capital to the company, PLUS a return for the risk involved in making the investment. You calculate the internal rate of return using the IRR function in your spreadsheet, compare it to the hurdle...