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: Investing

  • Home
  • Investing
Google sheets financial

YIELDDISC Google Sheets function

Written by Data Empower May 18, 2025

Determines the annual yield of a discount security, based on its purchase price.

Google sheets financial

YIELD Google Sheets function

Written by Data Empower May 18, 2025

Determines the annual yield of a security that pays interest periodically, such as a US Treasury Bond, based on its market price.

Google sheets financial

XIRR Google Sheets function

Written by Data Empower May 18, 2025

Determines the internal rate of return for an investment derived from a series of cash flows that may occur at irregular intervals.

Google sheets financial

TBILLYIELD Google Sheets function

Written by Data Empower May 18, 2025

Determines the yield on a U.S. Treasury Bill based on its purchase price.

Google sheets financial

TBILLPRICE Google Sheets function

Written by Data Empower May 18, 2025

Determines the price of a U.S. Treasury Bill based on its discount rate.

Google sheets financial

RRI Google Sheets function

Written by Data Empower May 18, 2025

Calculates the interest rate necessary for an investment to achieve a designated value over a specified number of periods.

Google sheets financial

RECEIVED Google Sheets function

Written by Data Empower May 18, 2025

Determines the total amount paid at maturity for investments in fixed-income securities bought on a specific date.

Google sheets financial

NPER Google Sheets function

Written by Data Empower May 18, 2025

Determines the number of payment periods required for an investment given consistent periodic payments and a fixed interest rate.

Follow me on Ganjing World!

Get the SQLBits T-Shirt now!

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