By intervening early, SBIRT saves lives and money and is consistent with overall support for patient wellness. Late-stage intervention and substance abuse treatment is expensive, and the patient has often developed comorbid health conditions.
Example 1: Even Cash Inflows: Calculate the net present value of a project which requires an initial investment of $243,000 and it is expected to generate a cash inflow of $50,000 each month for 12 months. Assume that the salvage value of the project is zero. The target rate of return is 12% per annum. Solution.
The Net Present Value (NPV) function in Excel 2013 calculates the net present value based on a series of cash flows. where value1, value2, and so on are between 1 and 13 value arguments representing a series of payments (negative values) and income (positive values), each of which is equally spaced in time and occurs at the end of the period.