RECEIVED

Amount received at maturity for fixed-income security investment

Description

For a fixed-income security investment, given the purchase date, calculates the amount received at maturity.

Function signature

RECEIVED(settlement: String, maturity: String, investment: Number, discount: Number, basis: String = us_nasd) => Number

Parameter

Description

Settlement

The security's settlement date.

Maturity

The security's maturity or end date.

Investment

The amount invested (irrespective of face value of each security).

Discount

The discount rate of the security invested in.

Basis

Method to use for counting days per month/year:

  • `us_nasd` (default): 30-day month, 360-day year, i.e. US (NASD).

  • `actual`: Actual number of days per month/year.

  • `actual_360`: 360 day year, actual number of days per month.

  • `actual_365`: 365 day year, actual number of days per month. This means leap years are not taken into account.

  • `european`: Like `us_nasd`, but for months that are not 30 days long, European standards are used.

Examples

date1 = "2010-01-02T13:06:15+03:00"
date2 = "2039-12-31T13:06:15+03:00"
date3 = "2009-01-31T13:06:15+03:00"
date4 = "2023-10-31T13:06:15+03:00"
date5 = "2009-01-30T13:06:15+03:00"
date6 = "2023-10-30T13:06:15+03:00"
date7 = "2009-01-31T13:06:15+03:00"
date8 = "2023-10-30T13:06:15+03:00"

Formula

Return value

RECEIVED(date1, date2, 100, 0.05, "us_nasd")

-200.05557099

RECEIVED(date1, date2, 100, 0.05)

-200.05557099

RECEIVED(date3, date4, 2400, 0.03, "us_nasd")

4304.93273543

RECEIVED(date5, date6, 2800, 0.03, "actual_360")

5080.1330511

RECEIVED(date7, date8, 2500, 0.03, "actual")

4483.18192978