SheetFX
≡
<< Go back to all functions

RECEIVED

The RECEIVED function in Google Sheets is used to calculate the amount received at maturity for an investment in fixed-income securities purchased on a given date. This function is particularly useful for financial analysis and investment planning.

Function Syntax and Parameters

Syntax: RECEIVED(settlement, maturity, investment, discount, [day_count_convention])

Parameters:

  • settlement: The settlement date of the security (date when the security is exchanged for cash).
  • maturity: The maturity date of the security (date when the principal amount is repaid).
  • investment: The amount invested in the security.
  • discount: The discount rate (yield) of the security.
  • [day_count_convention]: [Optional] The day count convention to use for calculating the time period between settlement and maturity.

Step-by-Step Tutorial

  1. Using RECEIVED to calculate the amount received at maturity:
    • Example: =RECEIVED("10/01/2023", "01/01/2025", 10000, 0.05, "ACT/365")
    • Result: The function will calculate and return the amount received at maturity for the investment.

Use Cases and Scenarios

  1. Bond Investments: Calculate the amount received at maturity for a bond investment.
  2. Fixed-Income Securities: Evaluate the returns on fixed-income securities.
  3. Financial Analysis: Understand the payout structure of different investments.

Related Functions

  • PRESENT VALUE: Calculate the present value of an investment or cash flow.
  • FV: Calculate the future value of an investment.

Related Articles