Financial Functions

Ø  Faccrint()

Calculate the accrued interest for a security that pays periodic interest

Ø  Faccrintm()

Calculate the accrued interest for a security that pays interest at maturity

Ø  Fcoupcd()

Calculate the coupon date

Ø  Fcoups()

Calculate the number of coupons payable between a security’s settlement date and maturity date/ the number of days in a coupon period that contains the settlement date/ the number of days from the beginning of a coupon's period to the settlement date / the number of days from the settlement date to the next coupon date

Ø  Fdb()

Calculate the depreciation of an asset for a specified period

Ø  Fddb()

Calculate the depreciation of an asset for a specified period

Ø  Fdisc()

Calculate the discount rate for a security

Ø  Fduration()

Return the modified duration of a security that pays periodic interest with an assumed par value

Ø  Fintrate()

Calculate the interest rate for a security that pays interest at maturity

Ø  Firr()

Calculate the internal rate of return for a series of cash flows represented by numeric values

Ø  Fmirr()

Calculate the modified internal rate of return for a series of periodic cash flows

Ø  Fnper()

Calculate the number of periods required to pay off a loan according to a specified periodic payment

Ø  Fnpv()

Calculate the net present value of an investment

Ø  Fpmt()

Calculate each period’s amount required to pay off an investment loan

Ø  Fprice()

Calculate the price of a security

Ø  Frate()

Calculate the interest rate required to pay an investment

Ø  Freceived()

Calculate the amount received at maturity for a security

Ø  Fsln()

Calculate the straight-line depreciation of an asset for each period

Ø  Fsyd()

Calculate depreciation of an asset for a specified period, using the sum-of-years’ digits method

Ø  Fv()

Calculate the future value of an investment

Ø  Fvdb()

Calculate the depreciation of an asset for a specfied period

Ø  Fyield()

Calculate the yield rate