Financial Reconciliation

96-Day Balance Review

Apply six independent day-based values to the cash surrender and outstanding loan calculations.

Calculation period

Day 1 – Day 96

Values used in the formulas

Starting cash surrender

$

Day-one outstanding loan

$

Annual grace-period rate

%

Grace period n

• Cash surrender = starting cash − cumulative six values.
• Loan interest follows: n × ((principal + n) × rate ÷ 365).
• Each adjustment is added to the loan and subtracted from cash on its selected day.
• The gap equals outstanding loan − cash surrender balance.

Enter an amount and the day on which it applies.

Amounts may be positive or negative

01Adjustment

Amount Day

02Adjustment

AmountDay

03Adjustment

AmountDay

04Adjustment

AmountDay

05Adjustment

AmountDay

06Adjustment

AmountDay

Cash surrender

$143,968.04

Balance at day 96

Outstanding loan

$2,544,866.96

Interest plus adjustments

Reconciliation gap

$2,400,898.92

Loan less cash surrender

Only days containing an adjustment are highlighted.

Grace-period interest: $40,835.66

Day	Applied value	Cash balance	Loan balance	Gap

]]>

96-Day Cash Surrender Reconciliation Calculator