RECEIVED Function in Google Sheets

Calculate the amount received from a discounted security at maturity.

RECEIVED Function

The RECEIVED function in Google Sheets calculates the amount received from a discounted security at maturity based on its investment and discount rate.

Syntax

RECEIVED(settlement, maturity, investment, discount, [day_count_convention])
  • settlement: The security’s settlement date.
  • maturity: The security’s maturity date.
  • investment: The amount invested in the security.
  • discount: The discount rate of the security.
  • day_count_convention: (Optional) The day count basis to use. Defaults to 0 (US (NASD) 30/360).

Examples

  1. Basic Amount Received Calculation

Calculate the amount received from a treasury bill:

=RECEIVED(DATE(2023, 1, 1), DATE(2023, 12, 31), 1000, 0.05)

This will output 952.38.

Notes

  • The function helps in evaluating the return on discounted securities.
  • The result is the amount received at maturity.
  • PRICEDISC: Calculate the price of a discounted security.
  • YIELD: Calculate the yield of a security that pays periodic interest.