Using Microsoft Excel\\\'s Accrued Interest Add-in Functions Business Articles | September 28 Cheap Adidas NHL Shirts , 2012 Making interest rate calculations? Microsoft Excel can help. Excel provides two functions that help you with accrued interest calculations for securities.
Excel provides two functions that help you with accrued interest calculations for securities that pay interest. ACCRINT calculates accrued interest for a security (such as a bond) that pays periodic interest. ACCRINTM calculates accrued interest for a security (such as a zerocoupon bond) that pays interest upon maturity.
Some Background Info on the Accrued Interest Functions
The accrued interest functions use a similar set of arguments, including the issue date, first interest date, settlement date, maturity date, coupon rate, par value, frequency, and basis.
The date arguments are self-explanatory for the most part. The issue date is the date the security is issued. The first interest payment date is the first coupon date. The settlement date is the date you purchased, or settled Cheap Adidas NHL Jerseys , the bond. The maturity date is the date the bond matures, or expires.
You may enter the date arguments either as text strings enclosed in quotation marks (for example, ?7499?) or as serial date values (for example, 37000 for April 19, 2001).
The coupon rate and par value arguments let Excel calculate the interest. The coupon rate is the annual interest rate multiplied by the par value to calculate the annual interest. For example, if a bond pays 8% interest annually and the par value is $1,000, Excel would calculate the annual interest by multiplying the 8% by the $1,000 if the coupon is paid annually.
The frequency argument gives the number of coupon payments made each year: you specify 1 to indicate an annual coupon, 2 to indicate a semiannual coupon Cheap NHL Hats , and 4 to indicate a quarterly coupon.
The basis argument specifies the number of days in the month and in the year assumed for the date calculations. You specify the basis as 0 for the US (or NASD) version of 30 days in a month and 360 days in a year; as 1 for the actual number of days in the month and year; 2 for the actual number of days in the month but 360 days in a year; 3 for the actual number of days in the month and 365 days in a year; and 4 for the European version of 30 days in a month and 360 days in a year.
Common Errors When Using the Accrued Interest Functions
Both the ACCRINT and ACCRINTM functions return an error value in the following situations:
1. If you enter an invalid date argument, Excel returns #VALUE.
2. If the coupon rate or par value argument is less than 0, Excel returns #NUM.
3. If the payment frequency is some number other than 1, 2, or 4, Excel returns #NUM.
4. If the day-count-basis switch isn?t 1, 2, 3, or 4, Excel returns #NUM.
? If issue date follows the settlement date Cheap NHL Hoodies , Excel returns #NUM.
Using the ACCRINT Function
The ACCRINT function calculates the accrued interest for a security that pays periodic interest given the issue date, first interest payment date, settlement date, coupon rate, par value, payment frequency, and a day-count-basis switch. It uses the following syntax:
ACCRINT (issue, first interest, settlement, rate Cheap NHL Shirts , par, frequency, basis)
For example, if you want to calculate the accrued interest on a bond that was issued on February 8, 1999, first paid interest on April 8, 1999, was purchased on May 23, 2000, pays an 8% coupon Cheap NHL Jerseys , shows a $1,000 par value, pays interest four times a year, and uses the US, or NASD, day-count-basis assumption, you use the following formula:
The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity given the issue date, the maturity date, coupon rate, par value, and a day-countbasis switch. It uses the following syntax:
ACCRINTM (issue, maturity, rate, par Cheap Hoodies , basis)
For example, if you want to calculate the accrued interest on a bond that was issued on February 8, 1991, matures on May 23, 2010, accrues an 8% coupon, shows a $1,000 par value, accrues interest two times a year, and uses the US Cheap Shirts , or NASD, day-count-basis assumption, you use the following formula:
=ACCRINTM ("2891","52310",0.08,1000,2)
The function returns the value 1565.33.
4 Vitamin And Nutrient Classes For A Sharp Memory Self Help Articles | July 25, 2011 Are there often times when you lose everyday stuff like your car keys or your spectacles? research has primarily pointed towards the undisputable fact that if the human body is subjected to a poor diet lacking important vitamins, the result is stunted brain growth which in turn negatively impacts your memory as well. Reading through this article will enable you to find out more about what to eat and the list of vitamins that your brain needs.
In essence, vitamins for the memory are an essential requirement for every individual particularly those who profess having a weak memory. Trying to stop your brain from getting smaller in order to negate memory loss is an extremely difficult process and cannot be facilitated by medicine. When talking about memory and vitamins Cheap Jerseys , you should note down four important ones and concentrate on their regular ingestion. Most people use vitamins to promote a healthier diet though you can also have them in pill or supplement form. .
Juwel
Thema drucken
20.01.2020 02:06
Antworten
