INTRATE
Returns the interest rate for a fully invested security.
FinancialFinance & Accounting
What it does
Calculates the interest rate for a fully invested security.
Syntax
INTRATE(settlement, maturity, investment, redemption, [basis])
Arguments
settlement(date) — Settlement date.maturity(date) — Maturity date.investment(number) — Amount invested.redemption(number) — Amount received at maturity.
Examples
Interest Rate
Calculate rate.
FORMULA
=INTRATE(A2, B2, 900, 1000)
RESULT
0.11
SAMPLE DATA
| A | B | |
|---|---|---|
| 1 | Start | End |
| 2 | 2023-01-01 | 2024-01-01 |