Financial Functions

Calculates accrued interest for a security that pays periodic interest.

Calculates accrued interest for a security that pays interest at maturity.

Calculates depreciation for a specific period using the French declining balance method.

Calculates depreciation for a specific period using the French straight-line method.

Calculates the number of days from the beginning of the coupon period to the settlement date.

Calculates the number of days in the coupon period that contains the settlement date.

Calculates the number of days from the settlement date to the next coupon date.

Calculates the next coupon date after the settlement date.

Calculates the number of coupons payable between the settlement date and maturity date.

Calculates the previous coupon date before the settlement date.

Calculates the cumulative interest paid on a loan between two periods.

Calculates the cumulative principal paid on a loan between two periods.

Calculates declining balance depreciation for a specified period.

Calculates double-declining balance depreciation for a specified period.

Calculates the discount rate for a security.

Converts a dollar price expressed as a fraction into a decimal number.

Converts a decimal dollar price into a fractional dollar price.

Calculates the Macaulay duration of a bond.

Calculates the effective annual interest rate from a nominal rate.

Calculates the future value of a series of equal payments and/or a lump sum.

Calculates the future value of a principal after applying a series of compound interest rates.

Calculates the interest rate for a fully invested security.

Finds the interest portion of a loan payment in a given period.

IRR tells you the annual return rate of an investment given its cash flows (initial cost + periodic returns). If IRR exceeds your required return, the investment is worthwhile.

Calculates the interest paid during a specific period of a loan with equal principal payments.

Calculates the modified duration of a bond.

Calculates the modified internal rate of return for a series of cash flows.

Calculates the nominal annual interest rate from an effective rate.

Calculates the number of periods for a loan or investment.

Finds the present value of future cash flows minus the initial investment.

Calculates the price of a security with an odd first coupon period.

Calculates the yield of a security with an odd first coupon period.

Calculates the price of a security with an odd last coupon period.

Calculates the yield of a security with an odd last coupon period.

Calculates the number of periods required for an investment to reach a specified value.

PMT tells you how much each payment will be on a fixed-rate loan. Give it the interest rate, number of payments, and loan amount — it returns the payment per period (monthly, yearly, etc.).

Finds the principal portion of a loan payment in a given period.

Calculates the price of a security that pays periodic interest.

Calculates the price of a discounted security.

Calculates the price of a security that pays interest at maturity.

Calculates the present value of a series of future payments or a future lump sum.

Calculates the interest rate per period of a loan or investment.

Calculates the amount received at maturity for a fully invested security.

Calculates the equivalent compound interest rate for an investment.

Calculates straight-line depreciation of an asset for one period.

Calculates sum-of-years-digits depreciation for a specified period.

Calculates the bond-equivalent yield for a Treasury bill.

Calculates the price of a Treasury bill per $100 face value.

Calculates the yield for a Treasury bill.

Calculates variable declining balance depreciation for any period you specify.

Calculates the internal rate of return for a schedule of cash flows that is not necessarily periodic.

Calculates the net present value for a schedule of cash flows that is not necessarily periodic.

Calculates the yield to maturity of a security that pays periodic interest.

Calculates the annual yield of a discounted security.

Calculates the annual yield of a security that pays interest at maturity.