Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
CUMPRINC function for the return of a loan in a given period en the st to repay the principal amount of the accumulated amount. The form of its syntax CUMPRINC (rate, nper, pv, start_period, end_period, type) for the interest rate which, nper payment for the total number, pv is the present value, start_period the first phase of the purpose of calculating the payment number from 1 the beginning of counting, end_period for the calculation of the late, type for type of payment. For example, a mortgage-backed transactions as follows: an annual interest rate of 9.00%; a period of 30 years; the current value of гд 125,000. Known from the above conditions can be calculated: r = 9.00% / 12 = 0.0075, np = 30 * 12 = 360.
In the first month of the loan principal amount repaid: = CUMPRINC (A2/12, A3 * 12, A4, 1,1,0) results as follows: -68.27827118. (C) the discount rate demand securities DISC DISC function to return to the discount rate securities. Its grammatical form of DISC (settlement, maturity, pr, redemption, basis) which the settlement date for securities transactions, that is the issue date, the securities sold to the purchaser's date, maturity date for the securities to , the due date is valid until securities at the time of the date, pr for the face value of the "¥ 100" The price of the securities, redemption for the face value of the "¥ 100" of the settlement price of the securities, basis for the benchmark on the type of count . For example: a bond transaction is as follows: 99-year contract on March 18, the due date for 99 years on August 7, priced at гд 48.834, settlement price of гд 52, on the base for counting sjts/ 360. Then the bonds for the discount rate: DISC ( "99/3/18", "99/8/7", 48.834,52,2) calculated as follows: 0.154355363. |
