Calculates the amount received at maturity for an investment in fixed-income securities purchased on a given date. Learn more
The RECEIVED function in Google Sheets is a financial function that calculates the amount received at maturity for an investment that has been discounted. The function takes several inputs:
Settlement: The date on which the investment was purchased or settled. Maturity: The date on which the investment matures. Investment: The amount invested. Discount: The discount rate for the investment. Day count convention (optional): The day count convention used to calculate the number of days between settlement and maturity.