RECEIVED()

Syntax. RECEIVED(Settlement,Maturity,Investment,Discount,Basis)

Definition. This function determines the repayment amount of a deposit resulting from a simple anticipative deduction of accrued interest.

Arguments

  • Settlement (required) The day on which the deposit (investment on the buyer side, borrowing on the seller side) is made

  • Maturity (required) The date when the repayment of the deposit takes place

  • Investment (required) The amount of the deposit (the loan)

  • Discount (required) Specifies the percentage of the discount rate

  • Basis (optional) Defines the method you want to use for determining the days in the year according to Table 15-2, shown earlier

All function arguments that concern a date use the date without the time; that is, fractions ...

Get Microsoft® Excel® 2010 Formulas & Functions Inside Out now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial