Risk Adjustment Pro Forma Template for Medicare Advantage Revenue

A risk adjustment pro forma is the single most important financial planning document for any organization managing Medicare Advantage revenue. It translates clinical coding performance, CMS payment mechanics, and contract economics into a unified revenue projection that leadership can act on. Yet many organizations still rely on fragmented spreadsheets, actuarial black boxes, or back-of-the-envelope estimates that fail to capture the full picture. This guide provides a step-by-step framework for building a pro forma that is transparent, auditable, and decision-ready.

What Is a Risk Adjustment Pro Forma?

A risk adjustment pro forma is a structured financial planning document that translates Medicare Advantage contract parameters into projected revenue outcomes. Unlike ad hoc spreadsheet models, a pro forma follows a standardized methodology that documents every input, assumption, formula, and output in a format suitable for board-level presentation, external audit, and regulatory filing. It serves as the single source of financial truth for organizations managing MA risk contracts.

The pro forma integrates five foundational inputs — enrolled membership, CMS benchmark rates, average RAF scores, the normalization factor, and risk share contract terms — into a calculation engine that produces baseline revenue, scenario-based projections, and sensitivity analysis. When properly constructed, it enables finance teams to update revenue projections rapidly when new CMS data arrives, RAF reconciliation results change, or contract terms are renegotiated. A well-built pro forma is the foundation for every Medicare Advantage revenue forecast and the prerequisite for credible board-level financial reporting.

Key Components of a Medicare Revenue Pro Forma

Every pro forma begins with the foundational inputs that define your MA economics. These are the non-negotiable starting points that every subsequent calculation depends on.

• Medicare Advantage lives: Total enrolled members under your contract or delegation arrangement. Segment by community, institutional, and new enrollee categories if your contract spans multiple populations.
• CMS benchmark PMPM: The county-weighted benchmark rate applicable to your plan. This figure is published annually in the CMS Rate Announcement and varies significantly by geography. Use the payment year benchmark, not the performance year rate.
• Baseline average RAF: Your organization's current average Risk Adjustment Factor across the applicable population. Source this from your most recent CMS RAPS or EDPS submission reconciliation, not from internal estimates.
• Risk share percentage: The portion of CMS revenue that flows to your organization under your contract structure. Full-risk arrangements are 100%; shared savings or upside-only arrangements are typically 50-75%.
• CMS normalization factor: The annual adjustment CMS applies to discount aggregate RAF scores. This factor has trended between 1.00 and 0.95 in recent years. See our normalization impact guide for historical trends and forecasting approaches.

Use our RAF revenue calculator to quickly validate your baseline numbers before building the full model.

Step 2: Build the Baseline Revenue Model

With parameters defined, construct the baseline revenue calculation. The core formula is:

Annual Revenue = Benchmark PMPM × Effective RAF × Risk Share % × MA Lives × 12

Where Effective RAF equals your baseline RAF multiplied by the normalization factor and any applicable product adjustment (ESRD, Part D add-on, etc.). This gives you the revenue baseline: the amount your organization would receive if nothing changes in the current year.

The baseline is not a forecast. It is the financial anchor against which all scenario analysis and strategic investments are measured. If your baseline is wrong, every downstream number in the pro forma will be unreliable. Invest the time to validate it against actual CMS reconciliation data.

Pro Forma vs Revenue Forecast

Finance teams frequently use "pro forma" and "revenue forecast" interchangeably, but they serve distinct purposes in Medicare Advantage financial planning. A pro forma is the structured model — the documented framework of inputs, formulas, and assumptions that produces financial projections. It is the "how we calculate" document designed for audit trails, governance, and methodology transparency. A revenue forecast, by contrast, is the output — the forward-looking projection of how much CMS revenue the organization will receive under specific assumption sets.

In practice, the revenue forecast is a use of the pro forma model. The pro forma provides the calculation engine; the forecast applies scenario-specific assumptions (RAF projections, benchmark rate changes, membership growth) to generate projected outcomes. Organizations that invest in building a rigorous pro forma can produce updated Medicare Advantage revenue forecasts in hours rather than weeks when CMS publishes rate changes or when RAF reconciliation data arrives. Those without a structured pro forma must rebuild their analysis from scratch each cycle, introducing delay and error risk. Build the pro forma first as your modeling infrastructure, then use it to generate forecasts for different scenarios and time horizons.

Incorporating RAF and HCC Assumptions

The pro forma becomes strategic when you model how revenue changes under different RAF outcomes. Build at minimum three scenarios:

• Pessimistic (-0.03 to -0.05 RAF): What happens if coding completeness declines, provider turnover disrupts documentation, or CMS audit activity reduces reported HCCs? This scenario defines your downside exposure and informs reserve planning. Use our Medicare downside risk calculator to quantify maximum financial exposure under adverse scenarios.
• Base case (flat to +0.01 RAF): Assumes current coding operations continue with marginal improvement. This is typically the scenario used for budget planning and contract renewal negotiations.
• Optimistic (+0.03 to +0.05 RAF): Assumes successful execution of coding improvement initiatives, chart review programs, or prospective HCC capture tools. Tie this scenario directly to funded clinical programs.

For each scenario, calculate the incremental revenue impact using the per-RAF dollar value methodology described in our How Much Is 0.1 RAF Worth analysis. Present results as both absolute dollar changes and percentage changes to the baseline.

Step 4: Incorporate Coding Program Economics

If your organization invests in chart review, prospective coding, or clinical documentation improvement programs, the pro forma must account for both the cost and the expected revenue lift of those programs. This is where the pro forma becomes a true decision-support tool rather than a passive projection.

For each coding initiative, capture the following:

• Program cost: Include vendor fees, internal FTE costs, technology licensing, and chart procurement expenses.
• Expected RAF lift: Based on historical capture rates, chart review yield data, or vendor performance guarantees. Be conservative; most programs underperform initial projections by 15-25%.
• Revenue impact: Apply the per-RAF dollar value to the expected lift. Our HCC revenue impact calculator guide provides a detailed framework for this calculation.
• ROI and payback period: Express the net financial return as both a multiple (revenue divided by cost) and a time-to-breakeven in months.

Modeling Multi-Year MA Contract Performance

CMS normalization is the variable that most frequently undermines otherwise sound pro forma models. The normalization factor adjusts annually based on aggregate industry RAF trends, and it has consistently reduced effective payment rates over the past decade. Failing to account for normalization can overstate projected revenue by 2-5%.

Beyond normalization, consider modeling the impact of CMS model version changes (such as the transition from V24 to V28), county benchmark rebasing, and any announced payment policy changes that may affect your specific plan or geography. These are low-probability but high-impact variables that belong in your sensitivity analysis.

Multi-year pro forma projections extend these single-year considerations across contract periods of three to five years. Each projection year must account for compounding normalization trends, anticipated benchmark rate trajectories based on CMS historical patterns, membership growth or attrition assumptions, and the cumulative impact of coding program maturation. Year-over-year RAF improvement typically follows a diminishing-returns curve as initial coding gaps are closed, so multi-year models should taper projected RAF lifts accordingly rather than assuming linear improvement indefinitely.

Step 6: Build the Sensitivity Table

The most valuable page in any risk adjustment pro forma is the sensitivity table: a matrix showing annual revenue across a range of RAF values and member counts. Typically this table spans RAF changes from -0.10 to +0.10 in 0.01 increments on one axis, and membership changes of plus or minus 10-20% on the other.

This table gives leadership the ability to answer ad hoc questions instantly. What if we lose 5% of our membership and RAF drops by 0.02? What if a new coding vendor delivers the promised 0.04 lift? The sensitivity table turns strategic conversations into quantified discussions rather than qualitative debates.

Using a Pro Forma for Board-Level Forecasting

When presenting your risk adjustment pro forma to a board or executive audience, structure the narrative in three layers. First, present the baseline: where revenue stands today. Second, present the range: the pessimistic-to-optimistic corridor that bounds the likely financial outcomes. Third, present the investment thesis: which funded initiatives are expected to move RAF and by how much, at what cost, and with what expected return.

Avoid presenting a single-point revenue forecast. Boards that see only one number inevitably ask "but what if that's wrong?" By leading with a range and a sensitivity table, you demonstrate analytical rigor and give leadership the context they need to make capital allocation decisions with confidence.

Common Pro Forma Pitfalls

• Using stale RAF data: Your average RAF from 18 months ago is not your current RAF. Ensure you are using the most recent CMS reconciliation data available.
• Ignoring the timing lag: Coding improvements made in the performance year affect revenue in the following payment year. Your pro forma timeline must reflect this 12-18 month delay.
• Overstating coding program impact: Vendor promises are not financial projections. Apply a haircut of 20-30% to any externally sourced RAF lift estimate.
• Treating the pro forma as static: A pro forma should be updated quarterly as new CMS data, coding results, and membership changes become available. A model that is only built once per year loses its strategic value within weeks.

For a comprehensive treatment of every variable in this framework, see our Medicare risk adjustment revenue model guide. A well-built pro forma is the foundation for any Medicare Advantage revenue forecast and risk share revenue modeling effort. See our MA contract profitability model guide for integrating pro forma results into contract-level profitability analysis. For organizations managing multi-contract portfolios, our enterprise MRRI platform automates pro forma generation, scenario comparison, and board-ready reporting across all contracts.

Risk Adjustment Pro Forma Model Structure Checklist

Use this outline as your starting template when building a board-ready risk adjustment pro forma. Each section should contain documented assumptions, data sources, and sensitivity ranges.

1. Membership Inputs: Monthly MA enrollment by county and product type (HMO, PPO, DSNP). Include growth/attrition assumptions and seasonal enrollment patterns.
2. CMS Benchmark Rates: County-level benchmark PMPM rates weighted by enrollment distribution. Document the source (Rate Announcement year) and any projected rate change assumptions.
3. RAF Score Projections: Population average RAF split by demographic and diagnosis components. Include baseline (actual), projected coding improvement, and V28 transition adjustments.
4. Normalization Factor: Current CMS normalization factor and projected trajectory. Model at least three scenarios (favorable, expected, adverse).
5. Product and Star Rating Adjustments: Product-type factors (HMO vs. PPO) and Star Rating rebate percentages based on current and projected quality scores.
6. Risk Share Terms: Risk share percentage, surplus/deficit corridors, quality withholds, and retrospective true-up provisions. Document the specific contract language driving each assumption.
7. Revenue Calculation: Benchmark × RAF × (1/Normalization) × Product Factor × Risk Share % × Member Months. Build at member-county level and aggregate upward.
8. Sensitivity Analysis: RAF variance (±0.05–0.10), benchmark rate changes (±1–3%), normalization movement, and membership growth scenarios.
9. Scenario Summary: Conservative, base, and optimistic cases with revenue ranges and key assumption differences documented for each.
10. Governance and Audit Trail: Version control, assumption sign-off dates, data source documentation, and variance-to-actual tracking schedule.

Frequently Asked Questions

What is a risk adjustment pro forma?

A risk adjustment pro forma is a structured financial model that documents the inputs, assumptions, formulas, and projected revenue outcomes for Medicare Advantage risk contracts. It serves as the foundation for budget planning, board reporting, and audit-ready financial documentation.

What makes a pro forma board-ready?

A board-ready pro forma includes documented data sources for every assumption, sensitivity analysis showing revenue ranges under different scenarios, clear methodology that can withstand external audit, and version control that tracks assumption changes over time. The model should be built at the member-county level to eliminate aggregation bias.

How often should a risk adjustment pro forma be updated?

At minimum, update the pro forma quarterly to incorporate actual CMS payment data, RAF reconciliation results, and membership changes. Major updates should occur after each CMS Rate Announcement (typically February–April) and after mid-year RAF true-ups. Monthly variance-to-actual tracking between updates provides early warning signals.