Problem Set 6 Hints and Spreadsheet

In question 1, part C of Problem Set 6, I ask you to “Find the maximum price which the insurer can charge for the coinsurance contract such that profit can still be earned while at the same time providing the typical Florida homeowner with higher expected utility from insuring and retrofitting. How much profit will the insurer earn on a per policy basis?” Here are some hints which you’ll hopefully find helpful.

For starters, keep in mind that in part A, insurance is compulsory (i.e., required by law), whereas, in parts B and C, insurance is not compulsory. In part B of question 1, you are asked to show that the homeowner retrofits while choosing not to purchase insurance. However, in part C, the homeowner might retrofit and purchase coverage if the coinsurance contract is priced more affordably. Therefore, the insurer’s problem is to figure out how much it must reduce the price of the coinsurance contract so that the typical Florida homeowner will have higher expected utility from insuring and retrofitting compared with the part B’s alternative of retrofitting only. It turns out that this is a fairly easy problem to solve using Solver. If you download the spreadsheet located at, you can find the price at which the consumer would be indifferent between buying coinsurance and retrofitting compared with self-insurance and retrofitting. You can determine this “breakeven” price by having Solver set the D28 target cell (which is expected utility for coinsurance with retrofitting) equal to a value of 703.8730 (which is the expected utility of self-insurance and retrofitting) by changing cell D12, which is the premium charged for the coinsurance. Once you have the “breakeven” price, all you have to do to get the homeowner to buy the coinsurance contract is cut its price slightly below that level so that the alternative of coinsurance plus retrofitting is greater than the expected utility of retrofitting only. The insurer’s profit then is simply the difference between the price that motivates the purchase of insurance less the expected claims cost to the insurer (which is $1,250).

Print Friendly, PDF & Email

Leave a Reply

Your email address will not be published. Required fields are marked *