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 Excel NPER function calculates the number of periods required to pay off a loan, for a constant periodic payment and a constant interest rate. The syntax of the function is: NPER(rate, pmt, pv, [fv] , [type]). Where the arguments are as follows:n the following spreadsheet, the Excel Nper function is used to calculate the number of months required to pay off in full, a loan of $50,000 at a rate of $1,000 per month. Interest is charged at a rate of 4% per year, and the payment to the loan is to be made at the end of each month. Formula: Result: