enow.com Web Search

Search results

  1. Results from the WOW.Com Content Network
  2. Effective interest rate - Wikipedia

    en.wikipedia.org/wiki/Effective_interest_rate

    The effective interest rate (EIR), effective annual interest rate, annual equivalent rate (AER) or simply effective rate is the percentage of interest on a loan or financial product if compound interest accumulates in periods different than a year. [1] It is the compound interest payable annually in arrears, based on the nominal interest rate ...

  3. Fixed-income attribution - Wikipedia

    en.wikipedia.org/wiki/Fixed-income_attribution

    While compact, effective duration only measures the effect of a parallel shift in the yield curve across all maturities. It does not take into effect other risk factors, such as non-parallel yield curve shifts, convexity, option-adjusted spreads, and others. However, effective duration may suffice for many managers as a basic risk measure.

  4. Duration (finance) - Wikipedia

    en.wikipedia.org/wiki/Duration_(finance)

    The dual use of the word "duration", as both the weighted average time until repayment and as the percentage change in price, often causes confusion. Strictly speaking, Macaulay duration is the name given to the weighted average time until cash flows are received and is measured in years. Modified duration is the name given to the price ...

  5. Bond convexity - Wikipedia

    en.wikipedia.org/wiki/Bond_convexity

    The more curved the price function of the bond is, the more inaccurate duration is as a measure of the interest rate sensitivity. [ 2 ] Convexity is a measure of the curvature or 2nd derivative of how the price of a bond varies with interest rate, i.e. how the duration of a bond changes as the interest rate changes. [ 3 ]

  6. Net present value - Wikipedia

    en.wikipedia.org/wiki/Net_present_value

    When using Microsoft's Excel, the "=NPV(...)" formula makes two assumptions that result in an incorrect solution. The first is that the amount of time between each item in the input array is constant and equidistant (e.g., 30 days of time between item 1 and item 2) which may not always be correct based on the cash flow that is being discounted.

  7. Microsoft Excel - Wikipedia

    en.wikipedia.org/wiki/Microsoft_Excel

    It can edit and format text in cells, calculate formulas, search within the spreadsheet, sort rows and columns, freeze panes, filter the columns, add comments, and create charts. It cannot add columns or rows except at the edge of the document, rearrange columns or rows, delete rows or columns, or add spreadsheet tabs.

  8. Little's law - Wikipedia

    en.wikipedia.org/wiki/Little's_law

    In mathematical queueing theory, Little's law (also result, theorem, lemma, or formula [1] [2]) is a theorem by John Little which states that the long-term average number L of customers in a stationary system is equal to the long-term average effective arrival rate λ multiplied by the average time W that a customer spends in the system.

  9. Compound interest - Wikipedia

    en.wikipedia.org/wiki/Compound_interest

    The force of interest is less than the annual effective interest rate, but more than the annual effective discount rate. It is the reciprocal of the e -folding time. A way of modeling the force of inflation is with Stoodley's formula: δ t = p + s 1 + r s e s t {\displaystyle \delta _{t}=p+{s \over {1+rse^{st}}}} where p , r and s are estimated.

  1. Related searches calculate effective duration in excel formula based on tab name

    calculate effective duration in excel formula based on tab name function