Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
NPV function based on a series of cash flow and a fixed discount rate of the period, the net present value of an investment return. Refers to the net present value of investment in the future phases of the expenditure (negative) and income (positive) the sum of the current value. Grammatical form: NPV (rate, value1, value2, ...) which, rate for the period of the discount rate is a fixed value; value1, value2, ... T 1-29 on behalf of expenditure and income values, value1 , value2, ..., affiliated to the length of the period must be equal, but the time for payment and income have taken place in the end. It should be noted that: NPV in sequence using the value1, value2, to note the order of cash flow. Therefore, we must ensure that the amount of expenditure and income in accordance with the correct order input. If the parameter is the value, a blank cell, said logic value or numerical expression of the text, then will be taken into account; if the parameter is the error value or values can not be converted into text, are ignored, if the parameter is an array or reference, only one part of the numerical calculation. Ignore the arrays or referenced in the blank cells, logical values, text, and the error value. For example, suppose to open a shop of electrical distribution. гд 200,000 initial investment, and hope that the next five years in revenue each year for гд 20,000, гд 40,000, гд 50,000, гд гд 80,000 and 120,000. Assumed that the annual discount rate is 8% (equivalent to inflation rate or competitive rate of investment), then the investment is the net present value formula: = NPV (A2, A4: A8) + A3 In this example, the beginning of гд 200,000 investment are not included in the v parameter, because the payments took place in the beginning of the first phase. Assuming that the electrical appliances shop in the sixth year of business, it is necessary to re-fitting window, it is estimated that to pay гд 40,000, then after six years of the net present value investment for the bookstore: = NPV (A2, A4: A8, A9) + A3 If the initial investment occurred in the payment period, the net present value of the investment formula is: = NPV (A2, A3: A8)
|
