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: Google sheets financial

  • Home
  • Google sheets financial
Google sheets financial

YIELDMAT Google Sheets function

Written by Data Empower May 18, 2025

Calculates the yearly yield for a security that pays interest upon maturity, based on its purchase price.

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

XNPV Google Sheets function

Written by Data Empower May 18, 2025

Evaluates the net present value of an investment using a defined sequence of potentially uneven cash flows and a specified discount rate.

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

VDB Google Sheets function

Written by Data Empower May 18, 2025

Calculates the depreciation of an asset for a specific time frame, including fractional periods.

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

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

SYD Google Sheets function

Written by Data Empower May 18, 2025

Determines the devaluation of an asset over a given timeframe utilizing the sum of years digits approach.

Page navigation

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