Financial Formulas in Excel

Financial formulas in Excel are used to organize and analyze the financial data. These financial formulas in Excel can calculate interest rate, duration, price, days, depreciation, yield and much more.

How to use Financial Formulas in Excel

The article in this webpage describes how to use the Financial functions in Excel with the syntax, arguments, detailed explanation, and examples step by step.

Click on any of the below Financial formulas in Excel to get the detailed information about it.

Function

Description

ACCRINT Function

Accrued interest for a security that pays interest periodically.

ACCRINTM Function

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

AMORLINC Function

Depreciation of an asset for each accounting period.

COUPDAYBS Function

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

COUPDAYS Function

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

COUPDAYSNC Function

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

COUPNCD Function

Next coupon date after the settlement date.

COUPNUM Function

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

COUPPCD Function

Previous coupon date before the settlement date.

CUMIPMT Function

Cumulative interest paid between two specified periods.

CUMPRINC Function

Cumulative principal paid on a loan between two specified periods.

DB Function

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

DDB Function

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

DISC Function

Discount rate for the security.

DOLLARDE Function

Dollar price expressed as a fraction into decimal.

DOLLARFR Function

Dollar price expressed as a decimal into fraction.

DURATION Function

Macauley duration of the security with periodic interest payments.

EFFECT Function

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

FV Function

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

FVSCHEDULE Function

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

INTRATE Function

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

IPMT Function

Interest rate for the fully invested security.

IRR Function

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

IPSPMT Function

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

MDURATION Function

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

MIRR Function

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

NOMINAL Function

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

NPER Function

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

NPV Function

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

ODDFPRICE Function

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

ODDFYIELD Function

Yield of the security with an odd first period.

ODDLPRICE Function

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

ODDLYIELD Function

Yield of the security with an odd last period.

PDURATION Function

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

PMT Function

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

PPMT Function

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

PRICE Function

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

PRICEDISC Function

Price per $100 face value of the discounted security.

PRICEMAT Function

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

PV Function

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

RATE Function

Interest rate per period of an annuity.

RECEIVED Function

Amount received at maturity for the fully invested security.

RRI Function

Equivalent interest rate for the growth of the investment.

SLN Function

Straight line depreciation of the asset for one period.

STOCKHISTORY Function

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

SYD Function

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

TBILLEQ Function

Bond-equivalent yield for a treasury bill.

TBILLPRICE Function

Price per $100 face value for a treasury bill.

PBILLYIELD Function

Yield for a treasury bill.

VDB Function

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

XIRR Function

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

XNPV Function

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

YIELD Function

Yield on a security that pays periodic interest.

YIELDDISC Function

Annual yield for the discounted security.

YIELDMAT Function

Annual yield of the security that pays interest at maturity.

Learn More

Function

Description

XLOOKUP Function

Search for a specified value from a table or range of cells.

DATEDIF Function

Number of days, months or years between two dates.

0 Comments

Excel Formulas (Category)

» Financial Formulas in Excel

» Logical Formulas in Excel

» Text Formulas in Excel

» Date and Time Formulas in Excel

» Lookup and Reference Formulas in Excel

» Math and Trig Formulas in Excel

» Statistical Formulas in Excel

» Engineering Formulas in Excel

» Cube Formulas in Excel

» Information Formulas in Excel

» Compatibility Formulas in Excel

» Web Formulas in Excel

Excel Tutorial Part 1 (Basic)

» Excel Basics

» Excel Home

» Excel Workbook

» Excel Template

» Excel Cell

» Excel Password

Excel Tutorial Part 2 (Format)

» Excel Clipboard

» Excel Format Font

» Excel Format Alignment

» Excel Format Number

» Excel Border

» Excel Conditional Formatting

Excel Tutorial Part 3 (Data)

» Excel Sort Data

» Excel Filter Data

» Excel Text to Columns

» Excel Data Validation

» Excel Flash Fill

» Excel Remove Duplicates

» Excel Relationships

» Excel Consolidate

» Excel What-If Analysis

» Excel Group

» Excel Charts

» Excel Table

» Excel PivotTable

Excel Tutorial Part 4 (Find)

» Excel Find and Replace

» Excel Go To

» Excel Select Objects

» Excel Selection Pane

Excel Tutorial Part 5 (Review)

» Excel Spell Check

» Excel Smart Lookup

» Excel Translate

» Excel Comments & Notes

» Excel Protect

» Excel Hide Ink

Excel Tutorial Part 6 (View)

» Excel Workbook Views

» Excel Formula Bar

» Excel Zoom

» Excel Window

» Excel Macros

Excel Tutorial Part 7 (Fx)

» Excel Formulas (Category)

» Excel Formulas (Alphabetical Order)

» Excel Errors

» Excel Name Manager

» Excel Formula Auditing

» Excel Watch Window

» Excel Calculation Options

Excel Tutorial Part 8 (Other)

» Excel Add-ins

» Excel Shortcuts