I have someone questioning the maths behind some figures that are provided in a report.
I never wrote the report but I can work out how the previous creator came to the figures that they have.
We are calculating Renewal Retention on a policy/subscription whatever you want to call it.
This done on a month to month basis. The report states the current forecasted retention is $46.27 \%$ and the current total retention is $45.86 \%$, these figures seem close together considering theirs still 10 days left of the month.
In my mind I can get the forecasted retention thus:
Over the entire month:
$881$ Available to Renew
$404$ Renewed
However I calculate by taking the total available to renew in the current period so from the beginning of the month until present day
$616$ Cases Available To Renew in that period
I then do the same and take the Total Number Renewed in the current period
$285$ Cases.
I then divide $\frac{285}{616 \times 100}$ to provide $46.27 \%$ forecasted retention.
Am I wrong here? I don't claim to be any good at maths, in fact I did terrible in my school exams.