Filtering by
- All Subjects: Actuarial
- All Subjects: actuary
- All Subjects: Healthcare Spending
- Creators: Zicarelli, John
- Creators: Gilkey, Gina
- Creators: Swoverland, Robert Bo
- Member of: Barrett, The Honors College Thesis/Creative Project Collection
- Status: Published
The United States spends far more on healthcare than other developed countries, and it is increasing at a rapid pace that places intense financial pressure on the American public. The high levels of spending are not attributable to increased quality of care or a healthier general population. Rather, the culprits are a combination of uniquely American social and cultural factors that increase the prevalence of chronic illness coupled with a large and complex healthcare industry that has a multitude of stakeholders, each with their own motivations and expense margins that inflate prices. Additionally, rampant lack of transparency, overutilization and low-quality care contribute to unnecessarily frequent and expensive payments. Public and private institutions have implemented legislation and programs that provide temporary relief, but powerful lobbying efforts by healthcare-related organizations and a general American aversion to high government involvement have prevented the United States from creating effective, long-lasting reform.
Of the many retirement savings options available, defined benefit pension plans were once a retirement income staple. Due to the highs and lows of the economic cycle, defined benefit pension plans have become severely underfunded. A series of inadequate contributions, enabled by weak funding and risk management policies, poses uncertainty for the retirement of many. The cost of paying pension benefits rises as defined benefit pension plans become increasingly underfunded, burdening the employers who continue to pay them. However, without increasing these already unaffordable pension benefits alongside inflation, they become less valuable to retirees. As pension benefits lose their value and the costs of retirement, such as healthcare and assisted living, increase, defined benefit pension plans may not provide the retirement security that was once promised.
The objective of this study is to build a model using R and RStudio that automates ratemaking procedures for Company XYZ’s actuaries in their commercial general liability pricing department. The purpose and importance of this objective is to allow actuaries to work more efficiently and effectively by using this model that outputs the results they otherwise would have had to code and calculate on their own. Instead of spending time working towards these results, the actuaries can analyze the findings, strategize accordingly, and communicate with business partners. The model was built from R code that was later transformed to Shiny, a package within RStudio that allows for the build-up of interactive web applications. The final result is a Shiny app that first takes in multiple datasets from Company XYZ’s data warehouse and displays different views of the data in order for actuaries to make selections on development and trend methods. The app outputs the re-created ratemaking exhibits showing the resulting developed and trended loss and premium as well as the experience-based indicated rate level change based on prior selections. The ratemaking process and Shiny app functionality will be detailed in this report.
An examination of various reserving methods and their application in commercial auto insurance. Seeks to answer two questions: Which is the best model, out of the Chain Ladder, Mack Chain Ladder, Munich Chain Ladder, Clark's LDF and Clark's Cape Cod methods? Which loss basis, paid or incurred, yields better reserves?