Question: A risk-adjusted premium is calculated by multiplying a policy's base premium (BasePremium) with its associated risk multiplier (RiskMultiplier). If a customer pays this risk-adjusted premium

A risk-adjusted premium is calculated by multiplying a policy's base premium (BasePremium) with its associated risk multiplier (RiskMultiplier). If a customer pays this risk-adjusted premium every year, how many years of payments would it take until the customer with CustomerID = C102 exceeds the total amount they have claimed?

A risk-adjusted premium is calculated by
Question 4 of 26 Questions 4-6 refer to the following information: A few years pass, and you are still working for Ensure-u- r-insured. Their product offerings, and therefore databases, have been restructured over the years. They now have the following tables as per the attached image: Policies Table PolicyID CustomerID State PolicyType CoverageLevel Premium Tier BasePremium P100 C100 NSW Auto Basi Gold 800 P101 C100 NSW Auto Premium Silver 1200 P102 C101 VIC Home Basic Bronze 950 P103 C102 OLD Auto Basic Gold 750 P104 C100 NSW Home Premium Gold 1400 Risk Table State Policy Type Premium Tier RiskMultiplier NSW Auto Gold 1.1 NSW Home Gold 1.2 VIC Auto Silver 1.0 OLD Auto Gold 0.9 OLD Auto Bronze 1.5 ClaimsHistoryTable ClaimID PolicyID CustomerID State Policy Type Premium Tier ClaimAmount CL 100 P100 C100 NSW Auto Gold 5000 CL 101 P100 C100 NSW Auto Gold 5500 CL102 P102 C101 VIC Home Bronze 7500 CL103 P103 C102 OLD Auto Gold 3000 CL 104 P104 C100 NSW Home Gold 12000 Click to enlarge A risk-adjusted premium is calculated by multiplying a policy's base premium (BasePremium) with its associated risk multiplier (RiskMultiplier). If a customer pays this risk-adjusted premium every year, how many years of payments would it take until the customer with CustomerID = C102 exceeds the total amount they have claimed

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!