Skip to content

Data Empower – The Data Matrix

Search for:
Log in

Menu

Close
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
  • Home
  • Shop
  • Excel
    • All Excel Functions List
  • PowerBI
  • SQL
  • Fabric
  • Google sheets
    • Google Sheets All functions alphabetical
  • About
Search for:
Log in

Category: XL Financial

  • Home
  • XL Financial
  • Page 2
XL Financial

ODDFPRICE Excel function

Written by Data Empower May 22, 2025

Calculates the price per $100 face value of a security with a non-standard first period.

XL Financial

NPV Excel function

Written by Data Empower May 22, 2025

Calculates the present value of an investment by summing a series of cash flows over time, discounted by a specific rate.

XL Financial

NPER Excel function

Written by Data Empower May 22, 2025

Calculates the number of periods needed for an investment.

XL Financial

NOMINAL Excel function

Written by Data Empower May 22, 2025

Provides the yearly nominal interest rate.

XL Financial

MIRR Excel function

Written by Data Empower May 22, 2025

Calculates the internal rate of return when financing positive and negative cash flows at differing rates.

XL Financial

MDURATION Excel function

Written by Data Empower May 22, 2025

Calculates the Macauley modified duration for a security assuming a par value of $100.

XL Financial

ISPMT Excel function

Written by Data Empower May 22, 2025

Determines the interest payments made within a specified time frame of an investment.

XL Financial

IRR Excel function

Written by Data Empower May 22, 2025

Returns the internal rate of return for a series of cash flows.

XL Financial

IPMT Excel function

Written by Data Empower May 22, 2025

Calculates the interest portion of an investment’s payment over a specific period.

XL Financial

INTRATE Excel function

Written by Data Empower May 22, 2025

Calculates the interest rate for a fully invested security

Page navigation

Previous 1 2 3 4 … 6 Next
Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

Copyright © 2025 Data Empower - The Data Matrix | Powered by BuddyX WordPress Theme

We noticed you're visiting from Germany. We've updated our prices to Euro for your shopping convenience. Use United States (US) dollar instead. Dismiss