1
00:00:00,630 --> 00:00:06,150
This quiz has seven questions once you build the report out, answering them is pretty quick and painless.

2
00:00:06,310 --> 00:00:07,440
So let's get through it.

3
00:00:08,220 --> 00:00:13,710
Question one, how much premium was collected in the third quarter of twenty nineteen for the auto line

4
00:00:13,710 --> 00:00:14,300
of business?

5
00:00:14,850 --> 00:00:19,950
This question simply asks for you to navigate into your date hierarchy and look for the third quarter

6
00:00:19,950 --> 00:00:22,140
and then determine the amount of premium collected.

7
00:00:22,650 --> 00:00:27,330
This required your premium to be properly calibrated as being delayed by three months.

8
00:00:27,570 --> 00:00:33,930
And so the six to one oh five eight answer would show up in Q2 of twenty nineteen based strictly on

9
00:00:33,930 --> 00:00:34,800
effective dates.

10
00:00:35,880 --> 00:00:41,480
Question to what is the first date at which the company has a positive amount of cash on hand?

11
00:00:42,270 --> 00:00:44,790
The first clue here is that it asks for company.

12
00:00:44,970 --> 00:00:48,090
So we need to condense our pivot table policy types down to all.

13
00:00:48,600 --> 00:00:53,880
From there I can use the cash on hand indicator to help guide me as I drill down to dates.

14
00:00:54,570 --> 00:00:56,760
Read is obviously close to or less than zero.

15
00:00:56,910 --> 00:01:02,130
So I'm looking for points where it transitions from red to yellow or green and I can use the cash on

16
00:01:02,130 --> 00:01:03,690
hand total to help with that.

17
00:01:04,770 --> 00:01:09,810
From there, I can eventually narrow it down to the date, July twenty ninth, twenty eighteen.

18
00:01:10,810 --> 00:01:11,770
Question three.

19
00:01:12,040 --> 00:01:17,230
What was the combined ratio for the home business in twenty nineteen, excluding the impact of twenty

20
00:01:17,230 --> 00:01:17,770
eighteen?

21
00:01:18,730 --> 00:01:24,310
This question requires you to drill down to the appropriate policy type and add the non cumulative combined

22
00:01:24,310 --> 00:01:26,830
ratio to the table to find the proper answer.

23
00:01:27,670 --> 00:01:32,470
Once you've done that, you can quickly find that the combined ratio for the home section in twenty

24
00:01:32,470 --> 00:01:35,620
nineteen was one hundred nine point five percent.

25
00:01:36,520 --> 00:01:43,330
Question for what color is the cumulative combined ratio KPI indicator for the auto segment at the end

26
00:01:43,330 --> 00:01:43,980
of October?

27
00:01:43,990 --> 00:01:44,890
Twenty eighteen.

28
00:01:46,090 --> 00:01:50,740
For this simply drill into twenty eighteen and find the month of October, once you're there, look

29
00:01:50,740 --> 00:01:56,500
at the color indicator it should be red since the cumulative combined ratio is one hundred point five

30
00:01:56,500 --> 00:01:57,970
percent at that point in time.

31
00:01:59,190 --> 00:02:05,130
Question five, which statement best describes the trend for profitability between the home and auto

32
00:02:05,130 --> 00:02:05,760
segments?

33
00:02:06,730 --> 00:02:11,710
This question isn't very black and white, I specifically wanted you to do some thinking and look at

34
00:02:11,710 --> 00:02:16,770
how the CPI's transition over time and compare that to the answer choices you had available to you.

35
00:02:17,650 --> 00:02:24,550
The simplest approach is to look at these on a year by year basis and then start with the overall profitability

36
00:02:24,550 --> 00:02:33,460
metric, the combined ratio, the KPI shows home is becoming green, yellow and red, which indicates

37
00:02:33,460 --> 00:02:35,170
that it's less profitable over time.

38
00:02:35,740 --> 00:02:41,320
That same KPI for the auto shows that it's holding stable as they're all yellow, although technically

39
00:02:41,320 --> 00:02:43,510
it is getting worse if you look at the ratios.

40
00:02:44,480 --> 00:02:49,190
If we look at it from the perspective of the cash on hand, auto is either getting better or holding

41
00:02:49,190 --> 00:02:54,920
stable, depending on your opinion of those numbers, while homeowners is clearly getting worse for

42
00:02:54,920 --> 00:02:55,530
that reason.

43
00:02:55,880 --> 00:03:01,580
The best answer here is that homeowners is becoming less profitable while Ottawa is holding stable.

44
00:03:02,690 --> 00:03:07,850
Question six, what is the total amount of expenses paid out for the bottom line of business through

45
00:03:07,850 --> 00:03:13,550
the end of twenty nineteen cumulative with twenty eighteen, we need to add expenses cumulative to our

46
00:03:13,550 --> 00:03:14,900
pivot table to answer this.

47
00:03:15,020 --> 00:03:20,540
And once we do, finding the total expense amount of four million one hundred sixty one thousand four

48
00:03:20,540 --> 00:03:22,070
hundred one is a breeze.

49
00:03:23,180 --> 00:03:28,520
Question seven, what is the total cash on hand for the business at the end of twenty nineteen?

50
00:03:29,450 --> 00:03:34,970
This is another quick and easy one focused on navigating the pivot table report summarized up to all

51
00:03:34,970 --> 00:03:40,610
policies and then find the cash on hand figure for twenty nineteen, which should be one hundred seventy

52
00:03:40,610 --> 00:03:42,320
four thousand six hundred ninety.

53
00:03:43,010 --> 00:03:44,360
That does it for the quiz.

54
00:03:44,360 --> 00:03:45,500
And thanks for joining me.
