ABCDEFGHIJKLMNOP
1
NCUSIF Equity/Retained Earnings "Yield Calculator "
2
Instructions: Replace all blue values with your own numbers to determine your required yield. The blue values are the current assumptions based on historical data and industry trends. When you change the blue values, the green values will update.
** DO NOT CHANGE GREEN FORMULA VALUES
3
4
5
ABC DEFGHIJ= ([G + (F*M) + (D*M - A)]/H) K = J-IL = K *HM = B * (E+1)N=L/M
6
Year End $ Billions EquityPrior Year End Insured Shares $ TrillionsPrior Year End Equity RatioTargeted Year End Equity RatioEstimated Annual Share Growth Rate (%)Projected Insured Loss (BPS) Budgeted Overhead NCUSIF Expense $ millionsEstimated NCUSIF Investment Balances $ BillionsYield on Investment Portfolio (H)Required Portfolio Yield to Meet Equity Ratio Goal (D)Required + or - Yield on Portfolio to Meet Equity Goal (D)Additional $ from Premium to meet Equity in D or - (surplus) for Dividend Estimated Year End Insured SharesAdditional Premium or - Dividend (in BPS) to meet (D)
7
$5,439,105,503$1,782,000,000,0000.30440.30%5.00%0.0005%$240,000,000$23,500,000,0002.70%1.80%-0.90%-$210,950,003$1,871,100,000,000-1.13
8
9
10
ASSUMPTIONS: Blue values can be changed by user. Green boxes are calculated
NEGATIVE YIELDS MEANS $ CAN BE DIVIDENDED BACK TO CREDIT UNIONS AND STILL MEET TARGET YEAR END EQUITY RATIO IN D
11
Columns A, B, and C are from year end audit. Total fund balance in A of $5.132 bn has been reduced by $467 million in unrealized gains on investments
 audit.
12
Col D desired currrent year end equity ratio
13
Col E Estimated insured share growth: Historical CAGR is 6.91% (2008-2020)
7.63% (2008-2021)
*Type % # change with % symbol in column E to have correct calculations in green columns
14
Col F Projected cash insurance losses: 1.51 basis points (2008-2020)
1.35 basis points (2008-2021)
15
Col G From NCUA budget and actual prior year of $181 million
ior year $208.2 million
16
Col H From Year end audit plus estmated growth from insured shares, col E/2
https://docs.google.com/spreadsheets/d/1eAZN2CjyNkgu9bfuUXIF1xmFPBwLvAio/edit#gid=2118513014
17
Col I Yield on NCUSIF portfolio from last fund update
18
Col N is columns L/M
19
Last update by CWF with October 2025 actual data. Posted Dec 16, 2025
025 October actual data on Dec 16, 2025
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100