Yahoo Answers is shutting down on May 4th, 2021 (Eastern Time) and beginning April 20th, 2021 (Eastern Time) the Yahoo Answers website will be in read-only mode. There will be no changes to other Yahoo properties or services, or your Yahoo account. You can find more information about the Yahoo Answers shutdown and how to download your data on this help page.

Siena H asked in 商業與財經投資 · 2 decades ago


懇請各位大大幫忙解答,公式該怎麼套? 今天要考試了幫個忙吧!謝謝唷^^




1 Answer

  • 2 decades ago
    Favorite Answer

    EXCEL函數運算DURATION(settlement,maturity,coupon yld,frequency,basis)Settlement   債券的結算日。債券結算日是債券交易給買方後的次日。Maturity   為債券的到期日。到期日為債券過期的日期。Coupon   為債券的年利率。Yld   為債券的年利潤。Frequency   為每年給付利息的次數。Basis   為所採用的日計利基的類型。Basis        日計利基 0 或省略        US (NASD) 30/3601      Actual/actual2      Actual/3603      Actual/3654      European 30/360

Still have questions? Get your answers by asking now.