Description: CMS provides ACOs with monthly claims data for members, including their medical visits and ACO program eligibility. This data can be divided into Membership and Claims tables through the ETL process. However, when calculating PMPY at specific levels of detail using these tables, issues arise due to unrelated dimensions, leading to inaccurate and understated results. This article presents a solution to this problem by utilizing Tableau's data blending capabilities.

Description: This article provides an update, as of September 2019, on the Reinsurance Section’s sponsored research in process and studies recently completed.

Description: According to the Actuarial Standards Board’s Actuarial Standard of Practice No. 49 (ASOP 49), actuarially sound Medicaid managed care capitation rates will include a provision for underwriting gain in order to provide compensation for the risks assumed by an MCO. However, there is no generally accepted method for quantifying underwriting gain in managed Medicaid capitation rates. This article discusses a new model developed to address this void and calculate underwriting gain. The model was developed by researching existing financial literature and performing a statistical analysis of industry data to build out a framework that can be leveraged to estimate underwriting gain.

Description: A DC plan design information that could align with organizational goals allowing for benefits for both higher and lower paid employees. It works amazingly easy for 403(b) plans but can also work well with 401(k) plans. You can model the design to see what works best for your organization to ensure passage of nondiscrimination tests and alignment with budget.

Description: The article discusses the use of the keyword strategy in teaching. The literature with a negative view of keywords is reviewed and responded to by advocating keywords with multiple meanings supplemented with relevant instructional guidance. Numerous examples are presented from the SOA preliminary exams. Additionally, advanced use of keywords to problems not having them are presented.

Description: As an addendum to a July 2022 article, this article restates the formulas then presented for a framework to measure the reinsured portion of a direct loss from capping a net premium ratio or flooring a liability. The article corrects a flaw in one of the original formulas and shows, by example, how the framework can be applied to a specific application of reinsurance accounting.

Description: In *From Distress to Distinction*, Chris Droussiotis explores a novel approach to valuing distressed companies using option pricing theory, drawing parallels to the financial challenges faced by startups. With over 30 years in banking and startup advising, he emphasizes that both distressed firms and early-stage ventures endure periods of negative cash flow but retain potential for recovery. He combines Discounted Cash Flow (DCF) and the Black-Scholes Option Pricing Model to evaluate distressed firms’ recovery prospects and debt sustainability. A case study on Spirit Airlines illustrates this approach: though its current equity value is negative, projected future cash flows suggest significant potential recovery. Droussiotis concludes that strategic valuation, using trend, peer, and expected analysis, can reveal hidden value in distressed companies, guiding effective investment and restructuring decisions.

Description: The article investigates the reasons behind non-zero financial implications for fully reinsured businesses within the regulatory frameworks of US GAAP Long Duration Targeted Improvements (LDTI) and International Financial Reporting Standards (IFRS) 17. It helps companies grasp the nuances of these standards, thereby enhancing their risk management strategies, improving regulatory compliance and optimizing their decision-making processes.

Description: The April/May 2013 edition of The Actuary magazine—the Society of Actuaries’ flagship publication.

Description: The February/March 2014 edition of The Actuary magazine—the Society of Actuaries’ flagship publication.