Open calculator ↗

Rotating savings association cash-flow yield by draw order · Calculation guide

Members contribute monthly, including in their draw month, and receive the pool less a one-time fee.

Calculation guide

Report modified annualized cash-flow return using the entered annual finance and reinvestment rates, from first to last contribution. This avoids ambiguous ordinary IRRs for intermediate draws.

MIRR annual = (FV of positive net flows / PV of negative net flows)^(12/(n−1)) − 1

Inputs

Members and monthly rounds

Example entry 4. Allowed range 2.0 to 120.0. Use whole numbers.

Member draw round (first = 1)

Example entry 2. Allowed range 1.0 to 120.0. Use whole numbers.

Monthly contribution per member

Example entry 100 (in the selected currency). Minimum 1e-06.

Fee deducted from draw

Example entry 0 (in the selected currency).

Annual effective financing rate (%)

Example entry 0 %. Allowed range 0.0 to 100.0.

Annual effective reinvestment rate (%)

Example entry 0 %. Allowed range 0.0 to 100.0.

Worked example

InputValue
Members and monthly rounds4
Member draw round (first = 1)2
Monthly contribution per member100
Fee deducted from draw0
Annual effective financing rate (%)0%
Annual effective reinvestment rate (%)0%
ResultValue
Modified annual cash-flow yield0%
Undiscounted net cash0

Interpreting the result

A zero total net cash flow means nominal payments and receipts balance over the cycle. Draw timing can still affect the annualized return when finance or reinvestment rates are positive.

How each input affects this example

Each row starts from the worked example and changes one input.

InputOriginal inputNew inputAffected resultOriginal resultNew result
Fee deducted from draw01Modified annual cash-flow yield0%-1.326681%
Annual effective financing rate (%)0%1%Modified annual cash-flow yield0%0.554112%
Annual effective reinvestment rate (%)0%1%Modified annual cash-flow yield0%0.66556%
Rotating savings association cash-flow yield by draw order →

Sources