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

Tag: Investment

  • Home
  • Investment
XL Financial

PV Excel function

Written by Data Empower May 22, 2025

Calculates the present value of an investment.

XL Financial

ODDFYIELD Excel function

Written by Data Empower May 22, 2025

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

XL Financial

FV Excel function

Written by Data Empower May 22, 2025

Calculates the future worth of an investment.

XL Financial

DURATION Excel function

Written by Data Empower May 22, 2025

Calculates the annual duration of a financial instrument with regular interest payments.

Google sheets financial

TBILLEQ Google Sheets function

Written by Data Empower May 18, 2025

Determines the annualized equivalent return of a U.S. Treasury Bill based on its discount rate.

Google sheets financial

PRICEMAT Google Sheets function

Written by Data Empower May 18, 2025

Determines the price of a security that pays interest upon maturity, factoring in the anticipated yield.

Google sheets financial

PRICEDISC Google Sheets function

Written by Data Empower May 18, 2025

Determines the price of a discount (non-interest-bearing) security based on its anticipated yield.

Google sheets financial

NPV Google Sheets function

Written by Data Empower May 18, 2025

Calculates the net present value of an investment using a series of periodic cash inflows and a specified discount rate.

Google sheets financial

MIRR Google Sheets function

Written by Data Empower May 18, 2025

Determines the modified internal rate of return for an investment by analyzing periodic cash flows and the variance between financing interest rates and returns on reinvested revenue.

Google sheets financial

MDURATION Google Sheets function

Written by Data Empower May 18, 2025

Determines the modified Macaulay duration of an investment that pays interest periodically, such as a U.S. Treasury Bond, according to anticipated yield.

Page navigation

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