Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
The main functions include the calculation of depreciation AMORDEGRC, AMORLINC, DB, DDB, SLN, SYD, VDB. These functions are used to calculate the depreciation of its assets, but used different methods of calculation. Here, the formula for calculating the specific will not repeat them, the specific choice of depreciation methods, the units shall be as the case may be. Third, reimbursement rates for function Reimbursement rates for the main function used to calculate the internal rate of return, including the IRR, MIRR, RATE and several function XIRR. (A) internal rate of return to return to the function - IRR IRR function to return to the values represented by a group of cash flow internal rate of return. These cash flow does not necessarily must be balanced, but as an annuity, they must occur at a fixed interval, such as monthly or year-on-year. Internal rate of return for the investment recovery rate, which includes periodic payments (negative values) and income (positive). Its grammatical form of IRR (values, guess) in which values for the array or cell reference, including the internal rate of return used to calculate the figures, values must contain at least one positive and one negative, to calculate the internal rate of return, IRR function Based on the numerical order to explain the order of cash flow should be determined by the need to enter the order of payment and income values, or if the array reference that contains text, logical values or blank cells, these values will be ignored; guess as to the function IRR calculation of the estimated value, excel using the iterative method to calculate IRR function to start from the guess function and constantly modify the rate of return IRR, until the results of the accuracy of 0.00001%, if the IRR function after 20 iterations, is still unable to find results, return error value # NUM! In most cases, the IRR function does not need to guess the value of the calculation, if the omitted guess, assuming it was 0.1 (10%). If the IRR function to return an error value # NUM! , Or was not close to expectations, can give a value-for-guess what to try. For example, if you want to start a clothing store, is expected to гд 110,000 investment and is expected to net income for the next five years as follows: гд 15,000, гд 21,000, гд 28,000, гд гд 36,000 and 45,000. Investment, respectively, obtained two years, four years and five years after the internal rate of return.
work table B1: B6 input data "function. xls" as shown in the calculation of the investment after a four-year internal rate of return IRR (B1: B5) was -3.27%; the calculation of the investment after five years Internal Rate of Return IRR (B1: B6) for 8.35%; calculated after two years of internal rate of return must be included in the function guess, that the IRR (B1: B3, -10%) to -48.96%. |
