Financial Formulas in Excel

Accrued interest for a security that pays interest periodically.

Accrued interest for a security that pays interest at maturity (one time only).

Depreciation of an asset for each accounting period.

Number of days from the beginning of the coupon period until the settlement date.

Number of days in the coupon period that contains the settlement date.

Number of days from the settlement date to the next coupon date.

Next coupon date after the settlement date.

Number of coupons payable between the settlement date and maturity date.

Previous coupon date before the settlement date.

Cumulative interest paid between two specified periods.

Cumulative principal paid on a loan between two specified periods.

Depreciation of asset for a specified period by using the fixed declining balance method.

Depreciation of asset for a specified period by using the double declining balance method or any other specified method.

Discount rate for the security.

Dollar price expressed as a fraction into decimal.

Dollar price expressed as a decimal into fraction.

Macauley duration of the security with periodic interest payments.

Effective annual interest rate from nominal interest rate and number of periods.

Future Value (FV) of the investment based on payments, interest rate and periods.

Future Value of an investment based on a series of compound interest rates.

Interest payment for the investment based on payments and interest rate.

Interest rate for the fully invested security.

Internal Rate of Return (IRR) for the series of cash flows.

Interest paid or recived for the specific period of the investment.

Macauley modified duration for a security with an assumed par value of $100.

Modified Internal Rate of Return (MIRR) for the series of periodic cash flows.

Annual nominal interest rate based on effective rate and number of periods.

Number of periods for the investment based on periods, payments and interest rate.

Net Present Value (NPV) of the investment based on the series of cash flows and discount rate.

Price per $100 face value of a security with an odd first period.

Yield of the security with an odd first period.

Price per $100 face value of the security with an odd last period.

Yield of the security with an odd last period.

Number of periods required by the investment to reach a specified value.

Periodic payment for the loan based on constant payments and interest rate.

Princial payment of an investment for a specific period based on periodic, constant payments and fixed interest rate.

Price per $100 face value of the security that pays periodic interest.

Price per $100 face value of the discounted security.

Price per $100 face value of the security that pays interest at maturity.

Present Value (PV) of the investment based on a constant interest rate.

Interest rate per period of an annuity.

Amount received at maturity for the fully invested security.

Equivalent interest rate for the growth of the investment.

Straight line depreciation of the asset for one period.

Historical data of a financial instrument and loads as an array.

Sum-of-years’ depreciation of the asset for a given period.

Bond-equivalent yield for a treasury bill.

Price per $100 face value for a treasury bill.

Yield for a treasury bill.

Depreciation of the asset for any specified period, using the double declining balance method or other specified method.

Internal Rate of Return (IRR) for a schedule of cash flows that occur at irregular intervals.

Net Present Value (NPV) for a schedule of cash flows that occur at irregular intervals.

Yield on a security that pays periodic interest.

Annual yield for the discounted security.

Annual yield of the security that pays interest at maturity.