Core maintenance worksheet

Smoothing & Trimming Worksheet

Use a 3-year Core average to determine when growth may safely replenish Liquidity.

Smoothing helps prevent one unusually strong market year from triggering an excessive transfer from Core.

A measured replenishment process

Past Core → Smoothing → Current Core → Liquidity → Trim

01

Enter the previous three Core values

Each value is the Core Market Value before trimming at that year's annual review.

3-Year Smoothed Core Value$960,000$900,000 + $960,000 + $1,020,000 ÷ 3

The smoothing baseline uses the previous three pre-trim Core values so prior trims do not artificially lower the benchmark for future trimming.

02

Enter this year's Core

Enter the Core Market Value before any trim is taken this year.

Core is above its smoothed level$10,000Excess Core Growth

Only this amount above the smoothing baseline is eligible for trimming.

03

Liquidity condition

The more depleted Liquidity becomes, the larger the portion of excess Core growth used to rebuild it.

Liquidity Coverage47.6%$90,000 ÷ $189,000
Selected Trim Rate75%Less than 50% coverage
04

Calculate the trim

Actual Trim is the smaller of the calculated trim and the amount needed to restore Liquidity to its target.

Your Trim

$7,500Core is above its smoothed level
Liquidity After Trim$97,500
Core After Trim$962,500

$970,000 Current Core − $960,000 3-Year Smoothed Core = $10,000 Excess Core Growth

$10,000 × 75% Trim Rate = $7,500 Calculated Trim

$5,000 transferred from Core to Liquidity

Liquidity Shortfall Before Trim
$99,000
Actual Trim
$7,500
Liquidity Shortfall After Trim
$91,500
Calculated Trim
$7,500