RECEIVED
Returns the amount received at maturity for a fully invested security.
FinancialFinance & Accounting
What it does
Calculates payout at maturity for a security.
Syntax
RECEIVED(settlement, maturity, investment, discount, [basis])
Arguments
settlement(date) — Date.maturity(date) — Date.investment(number) — Amount invested.discount(number) — Discount rate.
Examples
Received Amount
Calculate payout.
FORMULA
=RECEIVED(A2, B2, 900, 0.05)
RESULT
1000
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Set | Mat |
| 2 | 2023-01-01 | 2024-01-01 |