=DB 

Calculates depreciation based on the fixed-declining balance method

=DDB  

Calculates depreciation based on the double-declining balance method

=FV

Calculates the future value of an investment with constant periodic payments and a constant interest rate

=INTRATE

– the interest rate on a fully invested security

=IPMT

This formula returns the interest payments on a debt security

=IRR

This formula calculates the internal rate of return (discount rate that sets the NPV to zero)

=NPV

calculates the net present value of cash flows based on a discount rate

PV = Present Value

F = Future payment (cash flow)

i = Discount rate (or interest rate)

n = the number of periods in the future the cash flow is

=PMT

This function returns the total payment (debt and interest) on a debt security

=PRICE

Calculates the price per $100 face value of a periodic coupon bond

=PV

Calculates the present value of an investment

=SLN 

Calculates depreciation based on the straight-line method

=XIRR

Calculates the internal rate of return (discount rate that sets the NPV to zero) with specified dates

=XNPV

Calculates the NPV of cash flows based on a discount rate and specific dates

=YIELD

Returns the yield of a security based on maturity, face value, and interest rate