Unearned Premium Reserve Workout A
- 02:21
Understand how the unearned premium reserve is calculated and modeled
Transcript
So in this workout, we need to calculate the amount of policies that are earned and the amount of policies that are unearned at year end. We've got some simplifying assumptions. We're assuming that the written policies each month are 100 and that's flat over the course of the year. We're also assuming that the policies are written at the beginning of the month. So the policies that are written in January are written on January 1st. This means we've got a full fiscal year remaining. So this means that the year end we'll take the policies written in that year, and I'm going to multiply it by the months remaining, divided by 12. And you can see here this means we'll earn all the policies. The amount that's unearned of course, is going to be the difference between the written policies and the earned policies. Let me do February manually before I copy it down. So in February, I'll take the written policies at the beginning of February, and I'm going to multiply that by the 11 months left divided by 12 months. And that means I get about 91% that are earned in the year but I will have a chunk that is unearned the year end. So if I copy this down now, you'll see that the amount that gets earned as we progress through the year get smaller and smaller and smaller and the amount that's unearned gets larger and larger and larger. And if I sum this up over the course of the full year, of the 1200 policies that we wrote, we earned 650 and we didn't earn 550. So this is useful because it means that we can take some percentages here, if I take that 650 and I'll divide by the 1,200, it means we'd expect around 54.2% of policies written in the year to be earned. And we'll take the 550 divided by the 1,200, we would expect about 45.8% to be unearned. Now remember, although we're only earning 54.2% of the current year's written policies, we're going to take last year's unearned premium reserve and then earn it in the current year. So the earned policies in a year are partly from written policies in that year and partly from written policies in the prior year too.