Spreadsheet: 144215d1330794445-lookup-function-aa
Sheet: Allocation

Mutual Funds |  |  |  |  | Percentage Allocation
Name | Symbol |  | Large | Small | Fixed | Bonds | Int'l |  | Chk_pcts
AMERICAN BALANCED FUND | ABALX | 0 | 0.5887 | 0.0178 | 0.0379 | 0.2798 | 0.062 |  | 0.9862000000000002
AMERICAN BOND FUND OF AMERICA | BFAFX | 0 | 0 | 0 | 0.14 | 0.86 | 0 |  | 1
AMERICAN CAPITAL INCOME BUILDER FUND | CAIBX | 0 | 0.33 | 0.0236 | 0.09 | 0.22 | 0.34 |  | 1.0036
AMERICAN CAPITAL WORLD BOND FUND | WBFFX | 0 | 0 | 0 | 0.09 | 0.9 | 0 |  | 0.99
AMERICAN CAPITAL WORLD GROWTH AND INCOME | CWGIX | 0 | 0.3 | 0.02 | 0.06 | 0.02 | 0.59 |  | 0.99
AMERICAN EUROPACIFIC GROWTH FUND | AEGFX | 0 | 0 | 0 | 0.076 | 0 | 0.9134 |  | 0.9894
AMERICAN FUNDAMENTAL INVESTORS FUND | AFIFX | 0 | 0.6646 | 0.0683 | 0.044 | 0.005 | 0.2083 |  | 0.9902000000000001
AMERICAN GROWTH FUND OF AMERICA | GFAFX | 0 | 0.674 | 0.07 | 0.0731 | 0.019 | 0.1577 |  | 0.9938
AMERICAN HIGH INCOME TRUST | AHTFX | 0 | 0.0142 | 0 | 0.0892 | 0.8568 | 0 |  | 0.9602
AMERICAN INCOME FUND OF AMERICA | AMECX | 0 | 0.46 | 0.01 | 0.0481 | 0.2847 | 0.1599 |  | 0.9626999999999999
AMERICAN INVESTMENT COMPANY OF AMERICA | AICFX | 0 | 0.7849 | 0.0255 | 0.0583 | 0.0096 | 0.1018 |  | 0.9801000000000001
AMERICAN NEW PERSPECTIVE FUND | NPFFX | 0 | 0.38 | 0.01 | 0.0562 | 0 | 0.5323 |  | 0.9785
AMERICAN NEW WORLD FUND | NWFFX | 0 | 0.05 | 0.0056 | 0.0493 | 0.1195 | 0.7591 |  | 0.9835
AMERICAN SMALLCAP WORLD FUND | SCWCX | 0 | 0.11 | 0.25 | 0.0827 | 0.0176 | 0.5264 |  | 0.9866999999999999
AMERICAN WASHINGTON MUTUAL INVESTORS | AWSHX | 0 | 0.88 | 0.01 | 0.0089 | 0 | 0.0788 |  | 0.9777
CALAMOS GROWTH FUND | CVGRX | 0 | 0.66 | 0.18 | 0.0235 | 0 | 0.1401 |  | 1.0036
CALAMOS GROWTH & INCOME | CVTRX | 0 | 0.38 | 0.021 | 0.0352 | 0.098 | 0.068 |  | 0.6022000000000001
COLUMBIA ACORN FUND | LACAX | 0 | 0.3036 | 0.57 | 0 | 0 | 0.1216 |  | 0.9952
COLUMBIA ACORN INTERNATIONAL FUND | [NAME] | 0 | 0.02 | 0.02 | 0 | 0 | 0.9357 |  | 0.9757
DODGE & COX BALANCED | DODBX | 0 | 0.57 | 0.04 | 0.0259 | 0.2272 | 0.1281 |  | 0.9912
DODGE & COX INCOME FUND | DODIX | 0 | 0 | 0 | 0.0485 | 0.94 | 0 |  | 0.9884999999999999
DODGE & COX INTERNATIONAL STOCK | DODFX | 0 | 0.0567 | 0.0033 | 0 | 0 | 0.9207 |  | 0.9806999999999999
EATON VANCE TAX MANAGED GROWTH | EXTGX | 0 | 0.91 | 0.0186 | 0.011 | 0 | 0.0447 |  | 0.9843
FIRST EAGLE GOLD FUND | SGGDX | 0 | 0.09 | 0.0219 | 0.0519 | 0.0097 | 0.6663 |  | 0.8398
FIRST EAGLE GLOBAL FUND | SGENX | 0 | 0.29 | 0.0544 | 0.1401 | 0.0112 | 0.4217 |  | 0.9174
FIRST EAGLE OVERSEAS FUND | SGOVX | 0 | 0 | 0 | 0.131 | 0.0144 | 0.7369 |  | 0.8823
FT INCOME FUND | FKINX | 0 | 0.25 | 0.0137 | 0.0222 | 0.5198 | 0.0866 |  | 0.8923000000000001
FT MUTUAL GLOBAL DISCOVERY FUND | TEDIX | 0 | 0.44 | 0.0297 | 0.072 | 0.04 | 0.4078 |  | 0.9895
FT MUTUAL SHARES FUND | TESIX | 0 | 0.57 | 0.09 | 0.0748 | 0.0471 | 0.208 |  | 0.9898999999999999
GOLMAN SACHS MID-CAP VALUE | GCMAX | 0 | 0.53 | 0.43 | 0.03 | 0 | 0 |  | 0.99
JANUS INTERNATIONAL | JNISX | 0 | 0 | 0 | 0.01 | 0 | 0.99 |  | 1
LOOMIS SAYLES STRATEGIC INCOME FUND | NEFZX | 0 | 0.09 | 0 | 0.1 | 0.59 | 0.0644 |  | 0.8444
TRP CAPITAL APPRECIATION FUND | PRWCX | 0 | 0.56 | 0.0486 | 0.1374 | 0.16 | 0.04 |  | 0.9460000000000001
TRP EMERGING MARKETS BOND FUND | PREMX | 0 | 0 | 0 | 0.0416 | 0.959 | 0 |  | 1.0006
TRP EQUITY INCOME FUND | PRFDX | 0 | 0.75 | 0.1128 | 0.0395 | 0.0075 | 0.0452 |  | 0.955
TRP DIVERSIFIED SM CAP GROWTH | PRDSX | 0 | 0.21 | 0.73 | 0.0079 | 0 | 0.0252 |  | 0.9731
TRP SPECTRUM GROWTH FUND | PRSGX | 0 | 0.5673 | 0.0982 | 0.0205 | 0 | 0.29 |  | 0.976
TRP SPECTRUM INCOME | RPSIX | 0 | 0.13 | 0 | 0.0663 | 0.7812 | 0 |  | 0.9775
TRP TAX FREE INCOME FUND | PRTAX | 0 | 0 | 0 | 0.01 | 0.9817 | 0 |  | 0.9917
VG 500 INDEX FUND | VFINX | 0 | 0.9385 | 0.0588 | 0 | 0 | 0 |  | 0.9973
VG DIVIDEND GROWTH | VDIGX | 0 | 0.9018 | 0.01 | 0.053 | 0 | 0.04 |  | 1.0048
VG EQUITY INCOME FUND | VEIPX | 0 | 0.82 | 0.07 | 0.0487 | 0 | 0.0463 |  | 0.9849999999999999
VG HIGH-YIELD CORP INVESTMENT GRADE | [NAME] | 0 | 0 | 0 | 0.021 | 0.9256 | 0 |  | 0.9466
VG INFLATION-PROTECTED SECS | VIPSX | 0 | 0 | 0 | 0 | 0.9995 | 0 |  | 0.9995
VG INTERMEDIATE TERM | VFIDX | 0 | 0 | 0 | 0.03 | 0.9623 | 0 |  | 0.9923000000000001
VG INTERNATIONAL GROWTH FUND | VWIGX | 0 | 0 | 0 | 0.03 | 0 | 0.9153 |  | 0.9453
VG INTERNATIONAL VALUE | VTRIX | 0 | 0 | 0 | 0.0651 | 0 | 0.8758 |  | 0.9409000000000001
VG LIMITED TERM TAX EXEMPT | VMLUX | 0 | 0 | 0 | 0.0915 | 0.92 | 0 |  | 1.0115
VG LONG TERM BOND INDEX FUND | VBLTX | 0 | 0 | 0 | 0 | 0.989 | 0 |  | 0.989
VG MID-CAP INDEX FUND | VMCIX | 0 | 0.5165 | 0.458 | 0.0035 | 0 | 0.01 |  | 0.9879999999999999
VG PRIMECAP CORE FUND | VPCCX | 0 | 0.7356 | 0.064 | 0.03 | 0 | 0.154 |  | 0.9836000000000001
VG SHORT TERM TREASURY FUND | VFIRX | 0 | 0 | 0 | 0.0937 | 0.86 | 0 |  | 0.9537
VG SHORT-TERM BOND INDEX FUND | VBISX | 0 | 0 | 0 | 0.02 | 0.98 | 0 |  | 1
VG SHORT-TERM INVESTMENT GRADE | VFSTX | 0 | 0 | 0 | 0.1144 | 0.88 | 0 |  | 0.9944
VG SHORT TERM TAX EXEMPT FUND | VWSTX | 0 | 0 | 0 | 0.1203 | 0.88 | 0 |  | 1.0003
VG SMALL CAP GROWTH FUND | VISGX | 0 | 0.1274 | 0.85 | 0 | 0 | 0.01 |  | 0.9874
VG SMALL CAP INDEX  FUND | NAESX | 0 | 0.12 | 0.86 | 0.016 | 0 | 0 |  | 0.996
VG SMALL CAP VALUE INDEX FUND | VISVX | 0 | 0.11 | 0.88 | 0.0021 | 0 | 0.0111 |  | 1.0032
VG STRATEGIC EQUITY | VSEQX | 0 | 0.3798 | 0.5957 | 0.0094 | 0 | 0.015 |  | 0.9999
VG STRATEGIC SMALL CAP EQUITY | VSTCX | 0 | 0.107 | 0.87 | 0.01 | 0 | 0.0136 |  | 1.0006
VG TAX MANAGED BALANCED FUND | VTMFX | 0 | 0.39 | 0.0688 | 0.02 | 0.52 | 0.0019 |  | 1.0007
VG TAX MANAGED CAPITAL APPRECIATION FUND | VTCLX | 0 | 0.85 | 0.14 | 0 | 0 | 0 |  | 0.99
VG TAX MANAGED G&I FUND | VTGLX | 0 | 0.94 | 0.0589 | 0 | 0 | 0 |  | 0.9988999999999999
VG TAX MANAGED SMALL CAP FUND | VTMSX | 0 | 0.0476 | 0.9518 | 0 | 0 | 0 |  | 0.9994
VG TOTAL BOND MARKET INDEX FUND | VBTSX | 0 | 0 | 0 | 0.0307 | 0.9484 | 0 |  | 0.9791
VG REIT INDEX FUND | VGSIX | 0 | 0.5919 | 0.4008 | 0 | 0 | 0 |  | 0.9926999999999999
VG WINDSOR II FUND | VWNFX | 0 | 0.8472 | 0.0575 | 0.028 | 0 | 0.0672 |  | 0.9999
VANGUARD BALANCED INDEX FUND | VBINX | 0 | 0.4692 | 0.1081 | 0.0263 | 0.3875 | 0 |  | 0.9911000000000001
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
Annuities |  | 0 | Large | Small | Fixed | Bonds | Int'l |  | Chk_pcts
ING G | IAFSX | 0 | 0.5541 | 0.1294 | 0.0367 | 0.0038 | 0.2204 |  | 0.9444
ING INTL | IFSTX | 0 | 0 | 0 | 0.0536 | 0.0006 | 0.9086 |  | 0.9628
ING BND | ILBAX | 0 | 0 | 0 | 0.1474 | 0.8497 | 0 |  | 0.9971
ING SC | IIRSX | 0 | 0.03 | 0.94 | 0 | 0 | 0.0125 |  | 0.9824999999999999
ING G & I | IIVGX | 0 | 0.8192 | 0.1287 | 0.0265 | 0 | 0.0256 |  | 1
 |  | 0
JH AMERICAN G - JHVIT | JAGHX | 0 | 0.5541 | 0.1294 | 0.0367 | 0.0029 | 0.2204 |  | 0.9435
JH AMERICAN INTL - JHVIT | JAIHX | 0 | 0 | 0 | 0.0178 | 0.0016 | 0.9749 |  | 0.9943
JH BND - JHVIT | JABHX | 0 | 0 | 0 | 0.0978 | 0.8979 | 0 |  | 0.9957
JH SC - JHVIT | JASHX | 0 | 0.0995 | 0.2138 | 0.0966 | 0 | 0.5859 |  | 0.9958
JH G & I - JHVIT | JARHX | 0 | 0.7977 | 0.0522 | 0.0475 | 0 | 0.0969 |  | 0.9943
[NAME] | JELAX | 0 | 0.5062 | 0.1528 | 0.0154 | 0.0029 | 0.3189 |  | 0.9962
[NAME] | JELBX | 0 | 0.2992 | 0.0648 | 0.086 | 0.3975 | 0.1483 |  | 0.9957999999999999
[NAME] | JELCX | 0 | 0.1348 | 0.0262 | 0.1325 | 0.6574 | 0.0532 |  | 1.0041
[NAME] | JELGX | 0 | 0.4039 | 0.089 | 0.056 | 0.2522 | 0.203 |  | 1.0041
[NAME] | JELMX | 0 | 0.246 | 0.0486 | 0.1024 | 0.4932 | 0.1125 |  | 1.0027
 |  | 0
LINCOLN NATL G | WEBSITE | 0 | 0.715 | 0 | 0.044 | 0 | 0.238 |  | 0.997
LINCOLN NATL INTL | WEBSITE | 0 | 0 | 0 | 0.018 | 0 | 0.975 |  | 0.993
LINCOLN NATL BND | WEBSITE | 0 | 0.002 | 0.002 | 0.002 | 0.002 | 0 |  | 0.008
LINCOLN NATL SC | WEBSITE | 0 | 0.002 | 0.002 | 0.002 | 0.002 | 0 |  | 0.008
LINCOLN NATL G & I | WEBSITE | 0 | 0.849 | 0 | 0.051 | 0.002 | 0.098 |  | 1
 |  | 0
AZL - USAllianz |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0
Transamerica |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | 0 | 0 | 0 | 0 | 0 | 0 |  | 0