annual-rate: A number value representing the annual coupon rate or stated annual interest rate of the security used to determine periodic interest payments. annual-rate must be greater than 0, and is entered as a decimal (for example, 0.08) or with a percent sign (for example, 8%).
days-basis: An optional European method for dates falling on the 31st of a month.
The currency shown in this function result depends on your Language & Region settings (in System Preferences in macOS 12 and earlier, System Settings in macOS 13 and later, and Settings in iOS and iPadOS).
Example
Suppose you own a hypothetical security. The security, which pays interest only at maturity, was originally issued at $1000 (invest-amount) on December 14, 2008 (settle), matures on June 30, 2015 (maturity), and has a nominal interest or discount rate (annual-rate) of 6.5%, calculated on a 30/360 days basis.
=RECEIVED("12/14/2008", "06/30/2015", 1000, 0.065, 0) returns approximately 1,740.30745431693, the amount to be received at maturity, including both principal and interest.