This quiz has seven questions once you build the report out, answering them is pretty quick and painless.
So let's get through it.
Question one, how much premium was collected in the third quarter of twenty nineteen for the auto line
of business?
This question simply asks for you to navigate into your date hierarchy and look for the third quarter
and then determine the amount of premium collected.
This required your premium to be properly calibrated as being delayed by three months.
And so the six to one oh five eight answer would show up in Q2 of twenty nineteen based strictly on
effective dates.
Question to what is the first date at which the company has a positive amount of cash on hand?
The first clue here is that it asks for company.
So we need to condense our pivot table policy types down to all.
From there I can use the cash on hand indicator to help guide me as I drill down to dates.
Read is obviously close to or less than zero.
So I'm looking for points where it transitions from red to yellow or green and I can use the cash on
hand total to help with that.
From there, I can eventually narrow it down to the date, July twenty ninth, twenty eighteen.
Question three.
What was the combined ratio for the home business in twenty nineteen, excluding the impact of twenty
eighteen?
This question requires you to drill down to the appropriate policy type and add the non cumulative combined
ratio to the table to find the proper answer.
Once you've done that, you can quickly find that the combined ratio for the home section in twenty
nineteen was one hundred nine point five percent.
Question for what color is the cumulative combined ratio KPI indicator for the auto segment at the end
of October?
Twenty eighteen.
For this simply drill into twenty eighteen and find the month of October, once you're there, look
at the color indicator it should be red since the cumulative combined ratio is one hundred point five
percent at that point in time.
Question five, which statement best describes the trend for profitability between the home and auto
segments?
This question isn't very black and white, I specifically wanted you to do some thinking and look at
how the CPI's transition over time and compare that to the answer choices you had available to you.
The simplest approach is to look at these on a year by year basis and then start with the overall profitability
metric, the combined ratio, the KPI shows home is becoming green, yellow and red, which indicates
that it's less profitable over time.
That same KPI for the auto shows that it's holding stable as they're all yellow, although technically
it is getting worse if you look at the ratios.
If we look at it from the perspective of the cash on hand, auto is either getting better or holding
stable, depending on your opinion of those numbers, while homeowners is clearly getting worse for
that reason.
The best answer here is that homeowners is becoming less profitable while Ottawa is holding stable.
Question six, what is the total amount of expenses paid out for the bottom line of business through
the end of twenty nineteen cumulative with twenty eighteen, we need to add expenses cumulative to our
pivot table to answer this.
And once we do, finding the total expense amount of four million one hundred sixty one thousand four
hundred one is a breeze.
Question seven, what is the total cash on hand for the business at the end of twenty nineteen?
This is another quick and easy one focused on navigating the pivot table report summarized up to all
policies and then find the cash on hand figure for twenty nineteen, which should be one hundred seventy
four thousand six hundred ninety.
That does it for the quiz.
And thanks for joining me.