ExcelFlux

RECEIVED function

the amount received at maturity for a fully invested security.

Financial

Where can you use it?

Budgeting, treasury and finance teams. When reviewing a scenario with cash flows, payment periods and rate assumptions, compare the input and output units in the example.

Scenario in the workbook

Find the maturity proceeds from a discount rate and an initial investment of 100.

A worked example from the workbook

RowAB
6First inputSecond input
74602346388
84602346205
94602346113
Record 1
=RECEIVED(A7,B7,100,0.1,3)

Expected result111.1111111

See the inputs and instructions for all 3 examples

Copyable formulas

English Excel · en-US
=RECEIVED(A7,B7,100,0.1,3)
Turkish Excel · tr-TR
=GETİRİ(A7;B7;100;0,1;3)

Worked examples

Find the maturity proceeds from a discount rate and an initial investment of 100.

Open the English sheet. Inputs begin at A6. F7:F9 show the live results and G7:G9 show the original results for comparison.

Row A B
6 First input Second input
7 46023 46388
8 46023 46205
9 46023 46113
Case Formula Expected result
Record 1 =RECEIVED(A7,B7,100,0.1,3) 111.1111111
Record 2 =RECEIVED(A8,B8,100,0.1,3) 105.2479815
Record 3 =RECEIVED(A9,B9,100,0.1,3) 102.5280899
Microsoft Excel reference