I saw your Youtube video on Demand for Insurance and it led me to here. With that said, there are many articles written about health coverage choice e.g.National Institute of Health: http://economics.mit.edu/files/7870
Beginning on page 5 and,
Urban institute: http://www.urban.org/UploadedPDF/412471-Health-Insurance-Policy-Simulation-Model-Methodology-Documentation.pdf
Beginning on page 12.
RAND Compare has an overly complex model, but for discussion purposes, will use NIH's example.
NIH is taking into consideration (i) Risk aversion utility maximization (ii) expected healthcare needs (iii) variance in OOP cost from a set of health plans with consideration of variance in premiums for the health plans.
Is there a model or someone who can help me create a supplemental excel model that reflects the NIH's Model? In this model, they are using limited data such as Age, Income, and gender to impute a cost (lognorm function?)
There is so much written about this subject, however, I am having a very hard time modeling what is being discussed. If you could point me in a direction to someone who can help or may be interested in taking this on as a project, I would appreciate your feedback.
The video of mine that you mention just considers risk aversion and then only in the two-state case: loss or no-loss. So it is done very simply in that model. I have another video on adverse selection, that looks at the problem graphically in a simple model and one on moral hazard that does it algebraically. (It is really a model of the principal and agent, but that is essentially the same as an insurance model with moral hazard.)
The MIT paper that you mention puts all these factors together in one model by considering two periods, where in the second period there is moral hazard, given the insurance policy choice in the first period. Then, understanding the second period solution, they fold it back and look at the selection problem in the first period. And the do this noting that demographic characteristics of the insurance purchaser will impact both the moral hazard and the selection problems. This is substantially more complex then any of my videos. It is also more realistic.
Whether you can build an Excel model that imitates the MIT paper, I'm not sure. But why would you want to do that? To understand the MIT paper because it is too hard to work through the equations that are presented there? Please not that papers published in the AER are meant for an audience of professional economists and assume the reader has crossed a prior threshold of understanding - both on the issues and the math modeling. I would not teach this paper to an undergraduate class.