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
XL Financial

PV Excel function

Written by Data Empower May 22, 2025

Calculates the present value of an investment.

XL Financial

PRICEMAT Excel function

Written by Data Empower May 22, 2025

Calculates the price per $100 face value of a security that accrues interest until maturity.

XL Financial

PRICEDISC Excel function

Written by Data Empower May 22, 2025

Calculates the price for each $100 face value of a discounted financial instrument.

XL Financial

PRICE Excel function

Written by Data Empower May 22, 2025

Calculates the price for a $100 face value of a security that offers periodic interest payments.

XL Financial

PPMT Excel function

Written by Data Empower May 22, 2025

Calculates the principal portion of a payment for an investment over a specified period.

XL Financial

PMT Excel function

Written by Data Empower May 22, 2025

Calculates the regular payment for an annuity.

XL Financial

PDURATION Excel function

Written by Data Empower May 22, 2025

Calculates the number of periods an investment needs to attain a specified target value.

XL Financial

ODDLYIELD Excel function

Written by Data Empower May 22, 2025

Calculates the yield of a security with an unconventional last period.

XL Financial

ODDLPRICE Excel function

Written by Data Empower May 22, 2025

Calculates the price per $100 face value of a security that has a non-standard last period.

XL Financial

ODDFYIELD Excel function

Written by Data Empower May 22, 2025

Calculates the yield of a security with a non-standard first period.

Page navigation

1 2 3 … 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