Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
(B) RATE function with the actual profitability of an investment In economic life, often to assess the current operation of an investment, or the status of a new enterprise. For example, a contractor, he suggest you 30,000 loans for the construction of public works funds, and agreed to pay you 9,000 a year, pay a total of five years as the minimum return on the loan. So how do you go to the investment decision-making? How do I know if the investment rate of return? For such a periodic payment or reimbursement after the investment, the RATE function can quickly calculate the actual profit. The form of its syntax RATE (nper, pmt, pv, fv, type, guess). specific steps are as follows: 1, select the data storage cell in accordance with the above-mentioned method is similar to the cell designated as a "percentage" of the format. 2, insert the function RATE, open the "Paste Function" dialog box. 3, in the "Paste Function" dialog box, in the "Nper" Enter the reimbursement cycle 5 (years), in the "Pmt" enter 7000 (the amount of annual return), in "Pv" type -30000 (the amount of investment) . That the formula is = RATE (5,9000, -30000) 4, calculated to determine the results of 15.24%. This is the actual investment earnings each year, you can determine this value based on whether it is satisfied with the profit, or decision to invest in other projects, or re-negotiation of the return each year. four, bonds and other financial functions Bonds and other financial calculation function can be divided into principal and interest of the function, with the interest payments on a function of time, yield and interest rate-related function, and correction of the function of the period, with the function of the portfolio and the securities that the function of the price. 1, calculating the principal, interest function - CUMPRINC, ACCRINT, ACCRINTM, CUMIPMT, COUPNUM 2, with the interest payments on a function of time - COUPDAYBS, COUPDAYS, COUPDAYSNC, COUPNCD, COUPPCD 3, yield and interest rate-related function - INTRATE, ODDFYIELD, ODDLYIELD, TBILLEQ, TBILLPRICE, TBILLYIELD, YIELD, YIELDDISC, YIELDMAT 4, with the amendments to the function of the period - DURATION, MDURATION 5, and the function of the portfolio - DISC, ODDFPRICE, ODDLPRICE, PRICE, PRICEDISC, PRICEMAT, RECEIVED 6, with the Securities that the function of the price - DOLLARDE, DOLLARFR In bonds and other financial functions, I will focus on the function ACCRINT, CUMPRINC, DISC. (A) for the regular payment of accrued interest securities function ACCRINT ACCRINT function can return to regular payment of accrued interest securities. The form of its syntax ACCRINT (issue, first_interest, settlement, rate, par, frequency, basis) One issue for the securities of the issue date, first_interest effect for income on securities, settlement of securities transactions for the day, that is the issue date, the securities sold to the purchaser's date, rate for the portfolio votes of the per annum interest rate, par for the nominal value of securities, if the omitted par, it will automatically ACCRINT function par is set to ¥ 1000, frequency is the number of years interest, basis for the benchmark on the type of count. For example, a Treasury bond trading as follows: the issue date for the March 1, 2008; date of date of August 31, 2008; closing date of May 1, 2008, coupon interest rate of 10.0%; face value for the гд 1000; according to the semi-annual interest; 30/360 day count for the benchmark, then the accrued interest as follows:
|
