Earnings from Investments: Calculation Worksheets

Changes in Plan Assets Result From Contributions Less Distributions Plus Any Earnings From Investments...

Contributions (employee and employer) increase plan assets. Distributions (of any type) decrease plan assets. Investment earnings increase (if investment gains) or decrease (if investment losses) plan assets. Any change in plan assets can be attributed to these factors.

Year's Change in Plan Assets = Contributions - Distributions + Investment Earnings

In other words...

Investment Earnings = Year's Change in Plan Assets - Contributions + Distributions

We've set up PDF and html worksheets telling you where within your IRS Forms and Schedules to find the figures for this calculation:

Go to...


Earnings From Investments - for Form 5500-SF...

Item 10g on page 4 of Form 5500-SF asks for your plan's earnings from investments for the year. The numbers you need to make the calculation are all contained elsewhere within your Form 5500-SF.

Most users find it easiest to print this page, then fill in the below Worksheet - or you can use  the PDF (either online or downloaded) and type in your numbers, though you'll still have to do the addition and subtraction yourself; the PDF will not perform the calculations for you. (Also, remember that the PDF contains both Form 5500-SF and Schedule I instructions on the same page; ignore whichever set is not relevant to your plan.)

Complete the below to make the  Investment Earnings = Year's Change in Plan Assets - Contributions + Distributions  calculation for your Form 5500-SF. References in the Worksheet (such as to "items") are to your Form 5500-SF.

Earnings From Investments Calculation Worksheet - for Form 5500-SF Users
CHANGE IN ASSETS (subtract b from a, below) $
(a) End of Year Total Plan Assets (item 11a(b)) $
(b) Beginning of Year Total Plan Assets (item 11a(a)) $
less PLAN CONTRIBUTIONS (sum of c thru f, below) - $
(c) item 10b $<>
(d) item 10c $
(e) rollovers in $
(f) trust transfers in $
plus PLAN DISTRIBUTIONS (sum of g thru i, below) + $
(g) item 10d $
(h) item 10e $
(i) item 10f $
plus PLAN EXPENSES, if any (item 10h) + $
equals EARNINGS FROM INVESTMENTS $

Use the final number to figure item 10g on page 4 of Form 5500-SF.


Earnings From Investments - for Schedule I...

tem 2c on page 1 of your Schedule I asks for your plan's earnings from investments for the year. The numbers you need to make the calculation are all contained elsewhere within your Schedule I.

Most users find it easiest to print this page, then fill in the below Worksheet - or you can use  the PDF (either online or downloaded) and type in your numbers, though you'll still have to do the addition and subtraction yourself; the PDF will not perform the calculations for you. (Also, remember that the PDF contains both Form 5500-SF and Schedule I instructions on the same page; ignore whichever set is not relevant to your plan.)

Complete the below to make the  Investment Earnings = Year's Change in Plan Assets - Contributions + Distributions  calculation for your Schedule I. References in the Worksheet (such as to "items") are to your Schedule I.

Earnings From Investments Calculation Worksheet - for Schedule I Users
CHANGE IN ASSETS (subtract b from a, below) $
(a) End of Year Total Plan Assets (item 1a(b)) $
(b) Beginning of Year Total Plan Assets (item 1a(a)) $
less PLAN CONTRIBUTIONS (sum of c thru f, below) - $
(c) item 2a(1) $<>
(d) item 2a(2) $
(e) item 2a(3) $
(f) item 2b $
plus PLAN DISTRIBUTIONS (sum of g and h, below) + $
(g) item 2i $
(h) item 2k $
plus PLAN EXPENSES, if any (item 2h) + $
equals EARNINGS FROM INVESTMENTS $

Enter the final number on page 1 item 2c of Schedule I.


Earnings From Investments - PDF annotated to both Form 5500-SF and Schedule I...

Some of our 401k clients find it most useful to use our  Earnings From Investments Worksheet PDF because they can download the Worksheet or use it online, input their plan's pertinent information, then print the resulting completed Worksheet for their records.

  • Please note that while the PDF will allow you to input your plan's relevant numbers, it will NOT perform the calculations for you; you will have to do that manually.
  • Please also note that the single PDF contains instructions for both Form 5500-SF filers and Schedule I filers. Ignore the category on instructions that isn't relevant to your plan.