{"id":3182,"date":"2019-04-11T22:09:22","date_gmt":"2019-04-12T03:09:22","guid":{"rendered":"https:\/\/www.rixtrema.com\/blog\/?p=3182"},"modified":"2019-11-13T11:52:44","modified_gmt":"2019-11-13T16:52:44","slug":"case-study-working-with-non-audited-plans-in-401kfiduciaryoptimizer","status":"publish","type":"post","link":"https:\/\/rixtrema.com\/blog\/case-study-working-with-non-audited-plans-in-401kfiduciaryoptimizer\/","title":{"rendered":"Case Study: Working with Non-Audited Plans in 401kFiduciaryOptimizer"},"content":{"rendered":"

The Ask<\/b><\/span><\/h3>\n

The 401kFiduciaryOptimizer<\/a> <\/span>is a great tool to analyze 401(k) plans, but it works mostly with audited plans with a Schedule H (Schedule of Assets) attached to their most recent form 5500. But does it really mean that there is no way we can analyze non-audited plans considered for less than 100 participan<\/span>ts?<\/span><\/span><\/p>\n

The Problem<\/b><\/span><\/h3>\n

Well, technically speaking, the system will not show any smaller plans on the Plan Screener<\/a><\/span> page if they\u2019re not audited. Simply because it can\u2019t operate with data, which is not made publicly available. But if you\u2019re in good relations with a plan sponsor, or if you could get hold of their plan assets for any other reason, it\u2019s very easy to make a custom analysis report out of it. Of course, you can send the spreadsheet to our Support Team, and they\u2019ll be glad to assist you, otherwise it can be done on your end.<\/span><\/p>\n

The Solution<\/b><\/span><\/h3>\n

After you\u2019ve received the list of holdings and weights from your client, you\u2019ll need to create an excel file in the following format: Column A for the tickers; Column B for the weights:<\/span><\/p>\n

\"\"<\/a><\/span><\/p>\n

After you save it, you can utilize this file by uploading it to your 401kFiduciaryOptimizer account. In order to do that, you should go to the Edit Plan section:<\/span><\/p>\n

\"\"<\/a><\/span><\/p>\n

On the Load Plan page you can either upload the whole plan from the spreadsheet or add funds one by one.<\/span><\/p>\n

To upload the whole line-up from the file, you should:<\/span><\/p>\n

    \n
  1. Enter the name of the plan you\u2019re uploading<\/span><\/li>\n
  2. Click on the Browse button and locate excel file on your computer to upload it<\/span><\/li>\n
  3. Hit Next to double-check and finish the loading process:<\/span><\/li>\n<\/ol>\n

    \"\"<\/a><\/span><\/p>\n

    After the plan is loaded, the system will automatically provide you with a thorough analysis on potential savings, diversification and performance that you can print out immediately, the same way you can print out a report for any publicly available plan.<\/span><\/p>\n

    But what if you don\u2019t know the tickers or would like to upload a custom plan without creating an excel file? You can easily do that by adding funds one by one. To do that you need to:<\/span><\/p>\n

      \n
    1. Give a custom name to the plan<\/span><\/li>\n
    2. Start typing some words or the whole name of the fund you\u2019d like to be added<\/span><\/li>\n
    3. Pick the one you were looking for from the drop-down list. Do the same thing for all the other funds you want to be added<\/span><\/li>\n
    4. Click Next and specify the weight for each fund you\u2019ve added (if you\u2019re not sure about the value, the system will automatically set them equal 100,000 by default) and save it:<\/span><\/li>\n<\/ol>\n

      \"\"<\/a><\/span><\/p>\n

      Watch more on\u00a0401kFiduciaryOptimizer below and be sure to request your free personalized demo to explore the full potential of this unique online tool in order help you grow your 401k Business:<\/span><\/span><\/p>\n