|
Subscribe to E-mail Updates
|
|
| DOL > EBSA > Compliance Assistance > VFCP Online Calculator |
|
Voluntary Fiduciary Correction Program Online Calculator With Instructions, Examples & Manual Calculations
How The Online Calculator Works The Online Calculator computes Lost Earnings and interest, if any. If the Principal Amount was used for a specific purpose such that a profit on the use of the Principal Amount is determinable, the Online Calculator also computes interest on the profit. The Online Calculator then compares Lost Earnings to Restoration of Profits and provides the applicant with the greater amount, which must be paid to the plan. The Online Calculator uses IRC Section 6621(a)(2) and (c)(1) underpayment rates in effect during the time period and the corresponding factors from IRS Revenue Procedure 95-17 (IRS Factors), which reflect daily compounding. Under the VFCP special rules for transactions involving large losses or large restorations, the Online Calculator automatically recomputes the amount of Lost Earnings and Restoration of Profits using the applicable IRC Section 6621(c)(1) rates. Correction of most eligible VFCP transactions involves repayment of a Principal Amount. Select the transaction you are correcting from the Index Of Eligible VFCP Transactions for examples of calculations. Consult these examples first to be certain you enter the correct Principal Amount in the Online Calculator for the type of transaction being corrected. Generally, the instructions for using the Online Calculator are:
Index Of Eligible VFCP Transactions Delinquent Remittance Of Participant Funds
Loans
Participant Loans
Purchases, Sales, And Exchanges
Benefits
Plan Expenses
Example 1 Facts:
Using The Online Calculator The applicant enters three sets of data into the Online Calculator: Each entry represents the data for one pay period. First Entry: (For pay period ending March 2, 2001)
Second Entry: (For pay period ending March 16, 2001)
Third Entry: (For pay period ending March 30, 2001)
The Online Calculator provides a combined total of $196.10, which is the Lost Earnings and interest on Lost Earnings to be paid to the plan on January 30, 2004. This same information would be entered for any additional pay period with untimely contributions. The chart under the Online Calculator will maintain a list of all data entered during the session. The Total number at the bottom of the chart shows the total amount of Lost Earnings and interest on Lost Earnings for all pay periods for which data was entered. Note: If any Principal Amount has not been paid to the plan, this Principal Amount also must be paid to the plan and is not included in the total provided by the Online Calculator. Performing The Calculation Manually This example will show the manual calculation for the pay period ending March 2, 2001 only. However, the applicant must calculate Lost Earnings for each pay period and remit the total of all Lost Earnings to the plan. The facts in this example are:
To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor Step 1: Calculate Lost Earnings On The Principal Amount First, the Plan Official must calculate Lost Earnings that should have been paid on the Recovery Date. The first period of time is from March 16, 2001 to March 31, 2001 (15 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 9%. From the IRS Factor Table 23, the IRS Factor for 15 days at 9% is 0.003705021. $10,000 x 0.003705021 = $37.05 The plan is owed $10,037.05 as of March 31, 2001. The second period of time is April 1, 2001 through April 13, 2001 (13 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 8%. From the IRS Factor Table 21, the factor for 13 days at 8% is 0.002853065. $10,037.05 x 0.002853065 = $28.64 Therefore, Lost Earnings of $65.69 ($37.05 + $28.64) must be paid to the plan. Step 2: Calculate Interest On Lost Earnings If Lost Earnings are paid to the plan after the Recovery Date, the Plan Official must also pay interest on the Lost Earnings from the Recovery Date to the Final Payment Date. How to perform this calculation is shown by the following table. The Interest column is the previous time period’s Amt. Due times the Factor. Amt. Due is the previous row’s Amt. Due plus Interest. The first row is based on the $65.69 Lost Earnings. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Note: The last IRS Factor comes from the IRS Factor Tables for leap years. The plan is also owed $11.64. This is the amount of interest on $65.69 (Lost Earnings on the Principal Amount) accrued between April 13, 2001, the Recovery Date, when the Principal Amount $10,000 was paid to the plan, and January 30, 2004, the Final Payment Date. Therefore, the Plan Official must pay $77.33 to the plan on January 30, 2004, as Lost Earnings ($65.69) plus interest on Lost Earnings ($11.64) for the pay period ending March 2, 2001, in addition to the Principal Amount ($10,000) that was paid on April 13, 2001. This same calculation must be done for each pay period with untimely employee contributions or participant loan repayments. Note: If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculation must be redone for each pay period, using the IRC 6621(c)(1) underpayment rates. Example 2 Facts:
Using The Online Calculator The applicant enters the following data into the Online Calculator:
The Online Calculator provides a total of $6.57, which is the Lost Earnings to be paid to the plan on October 5, 2004. The Plan Official must also pay the Principal Amount, which is not included in the total provided by the Online Calculator. Therefore, the amount to be paid is the Principal Amount ($281.83) plus Lost Earnings ($6.57) or $288.40. This same information would be entered for each loan payment made (or lease payment received). The chart under the Online Calculator will maintain a list of all data entered during the session. The Total number at the bottom of the chart shows the total amount of Lost Earnings and interest on Lost Earnings due for all loan payments for which data was entered. The Plan Official must also pay the Principal Amount for each loan or lease payment, which is not included in the total provided by the Online Calculator. In addition, if the loan was to a party in interest, the loan must be paid in full. Performing The Calculation Manually To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from April 1, 2004 to June 30, 2004 (90 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 5%. From the IRS Factor Table 63, the IRS Factor for 90 days at 5% is 0.012370127. $281.83 x 0.012370127 = $3.486273 The plan is owed $285.316273 as of June 30, 2004 ($281.83 + $3.486273). The second period of time is July 1, 2004 through September 30, 2004 (92 days). The IRC 6621(a)(2) underpayment rate for this quarter is 4%. From the IRS Factor Table 61, the IRS Factor for 92 days at 4% is 0.010104808. $285.316273 x 0.010104808 = $2.883066 The plan is owed $288.199339 as of September 30, 2004 ($285.316273 + $2.883066). The last period of time is October 1, 2004 through October 5, 2004 (5 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 5%. From the IRS Factor Table 63, the IRS Factor for 5 days at 5% is 0.000683247. $288.199339 x 0.000683247 = $0.196911 The plan is owed $288.39625 on October 5, 2004 ($288.199339 + $0.196911), which is rounded to $288.40. Each loan payment must be separately calculated, and the amounts totaled. In addition, if the loan was to a party in interest, the loan must be paid in full. Note: If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculations must be redone, using the IRC 6621(c)(1) underpayment rates. Example 3 Facts:
Note: Alternatively, an independent fiduciary may determine that the plan would realize a greater benefit by keeping the asset. Correction would be made pursuant to Section 7.4(a)(2)(ii) of the VFCP. Using The Online Calculator The applicant enters the following data into the Online Calculator:
The Online Calculator provides a total of $4,203.27, which is the Lost Earnings to be paid to the plan on October 5, 2004. Because the Principal Amount plus Lost Earnings ($124,203.27) is greater than the current fair market value ($110,000), the plan must sell the property (either back to the original seller or to a non-party in interest) for $124,203.27. Note: If the current fair market value is $130,000, the plan would sell the property for $130,000. Performing The Calculation Manually To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from December 19, 2003 to December 31, 2003 (12 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 4%. From the IRS Factor Table 13, the IRS Factor for 12 days at 4% is 0.001315861. $120,000 x 0.001315861 = $157.9033 The plan is owed $120,157.9033 as of December 31, 2003 ($120,000 + $157.9033). The second period of time is January 1, 2004 through March 31, 2004 (91 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 4%. From the IRS Factor Table 61, the IRS Factor for 91 days at 4% is 0.009994426. $120,157.9033 x 0.009994426 = $1,200.909 The total owed the plan on March 31, 2004 is $121,358.813. Continue calculating in the same manner. |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
The total amount of Lost Earnings is $4,203.27087 ($157.9033 + $1,200.909 + $2,844.45857), which is rounded to $4,203.27. Current FMV is $110,000. The property must be sold for $124,203.27, the higher of the Principal Amount plus Lost Earnings ($120,000 + $4,203.27) or the current fair market value ($110,000). If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculations must be redone, using the IRS 6621(c)(1) underpayment rates. Example 4 Facts:
Using The Online Calculator The applicant enters the following data into the Online Calculator:
The Online Calculator provides a total of $347.15, which is the Lost Earnings to be paid to the plan on October 6, 2004. The applicant must also pay the Principal Amount, which is not included in the total provided by the Online Calculator. Therefore, the plan must receive $10,347.15. Performing The Calculation Manually To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from December 23, 2003 to December 31, 2003 (8 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 4%. From the IRS Factor Table 13, the IRS Factor for 8 days at 4% is 0.000877049. $10,000 x 0.000877049 = $8.77049 The plan is owed $10,008.77049 as of December 31, 2003 ($10,000 + $8.77049). The second period of time is January 1, 2004 through March 31, 2004 (91 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 4%. From the IRS Factor Table 61, the IRS Factor for 91 days at 4% is 0.009994426. $10,008.77049 x 0.000877049 = $100.0319 The total owed the plan on March 31, 2004 is $10,108.8024. Continue calculating in the same manner.
The total amount of Lost Earnings is $347.1500005 ($8.77049 + $100.0319 +$238.347615), which is rounded to $347.15. The Principal Amount must also be paid to the plan. Therefore, the plan must receive $10,347.15 on October 6, 2004. If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculations must be redone using the IRS 6621(c)(1) underpayment rates. Example 5 Facts:
Using The Online Calculator The applicant enters the following data into the Online Calculator:
The Online Calculator provides a total of $167.85, which is the Lost Earnings to be paid to the plan on October 6, 2004. The applicant must also pay the Principal Amount, which is not included in the total provided by the Online Calculator. Therefore, the plan must receive $2,167.85. Performing The Calculation Manually To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from January 1, 2003 to March 31, 2003 (89 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate table, the rate for this quarter is 5%. From the IRS Factor Table 15, the IRS Factor for 89 days at 5% is 0.012265558. $2,000 x 0.012265558 = $24.53112 The plan is owed $2,024.53112 as of March 31, 2003 ($2,000 + $24.53112). The second period of time is April 1, 2003 through June 30, 2003 (91 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 5%. From the IRS Factor Table 15, the IRS Factor for 91 days at 5% is 0.012542910. $2,024.53122 x 0.012542910 = $25.39351 The total owed the plan on June 30, 2003 is $2,049.92463. Continue the calculations in the same manner.
The total amount of Lost Earnings is $167.850037 ($24.53112 + $25.39351 + $117.925407), which is rounded to $167.85. The Principal Amount must also be paid to the plan. Therefore, the plan must receive $2,167.85 on October 6, 2004. If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculations must be redone using the IRC 6621(c)(1) underpayment rates. Note: Had the property increased in value to $600,000 on December 31, 2002, the participant would have been underpaid by $2,000. The exact same calculation must be done, but the participant would receive $2,167.85 rather than the plan. Example 6 Facts:
Using The Online Calculator The applicant enters the following data into the Online Calculator:
The Online Calculator provides a total of $146.28, which is the Lost Earnings to be paid to the plan on October 6, 2004. The applicant must also pay the Principal Amount, which is not included in the total provided by the Online Calculator. Therefore, the plan must receive $2,146.28. Performing The Calculation Manually To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from March 15, 2003 to March 31, 2003 (16 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 5%. From the IRS Factor Table 15, the IRS Factor for 16 days at 5% is 0.002194034. $2,000 x 0.002194034 = $4.388068 The plan is owed $2,004.388068 as of March 31, 2003 ($2,000 + $4.388068). The second period of time is April 1, 2003 through June 30, 2003 (91 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 5%. From the IRS Factor Table 15, the IRS Factor for 91 days at 5% is 0.012542910. $2,004.388068 x 0.012542910 = $25.14086 The total owed the plan on June 30, 2003 is $2,029.52893. Continue the calculations in the same manner.
The total amount of Lost Earnings is $146.28104 ($4.388068 + $25.14086 + $116.752116), which is rounded to $146.28. The Principal Amount must also be paid to the plan. Therefore, the plan must receive $2,146.28 on October 6, 2004. If the amount of Lost Earnings and interest, if any, to be paid to the plan is greater than $100,000, the calculations must be redone using the IRC 6621(c)(1) underpayment rates.
Example 7 Facts:
Using The Online Calculator The applicant calculates both Lost Earnings and Restoration of Profits to determine the greater of these two amounts, which must then be paid to the plan. The applicant enters the following data into the Online Calculator to determine Lost Earnings:
The Online Calculator provides an amount of $11,440.90, which is Lost Earnings that would be paid to the plan on November 17, 2004. The transaction must also be corrected by the sale of the asset back to the party in interest who originally sold the asset to the plan, or to a person who is not a party in interest. Since the Principal Amount plus Lost Earnings ($111,440.90) is higher than the current fair market value ($100,000), the plan would receive $111,440.90, under the Lost Earnings calculation. Because there are determinable profits, the applicant also selects the Calculate Restoration of Profits button. The applicant enters the following data into the Online Calculator to determine Restoration of Profits:
The Online Calculator provides an amount of $131,800.20, which is Restoration of Profits to be paid to the plan on November 17, 2004. Restoration of Profits is payable to the plan because it exceeds Lost Earnings and interest, if any, which totaled $11,440.90. Performing The Calculation Manually Step 1: Determine Lost Earnings To calculate earnings using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from August 20, 2002 to September 30, 2002 (41 days), the end of the quarter. From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 6%. From the IRS Factor Table 17, the IRS Factor for 41 days at 6% is 0.006761931. $100,000 x 0.006761931 = $676.1931 The plan is owed $676.1931 in Lost Earnings as of September 30, 2002. The second period of time is October 1, 2002 through December 31, 2002 (92 days). From the IRC 6621(a)(2) underpayment rate tables, the rate for this quarter is 6%. From the IRS Factor Table 17, the IRS Factor for 92 days at 6% is 0.015236961. Since Lost Earnings are based on the Principal Amount, the Principal Amount ($100,000) must be added to the Lost Earnings already determined. $100,676.1931 x 0.015236961 = $1,533.999 The plan is owed $2,210.1921 ($676.1931 + $1,533.999) as of December 31, 2002. Continue calculating in the same manner.
The total amount of Lost Earnings is $11,440.9018 ($676.1931 + $1,533.999 + $9,230.7097), rounded to $11,440.90, which would be paid to the plan on November 17, 2004, if Lost Earnings exceeds Restoration of Profits. The transaction must also be corrected by the sale of the asset back to the party in interest who originally sold the asset to the plan or to a person who is not a party in interest. Because the Principal Amount plus Lost Earnings ($111,440.90) is higher than the current fair market value ($100,000), the plan would receive $111,440.90, under the Lost Earnings calculation. Step 2: Determine Restoration Of Profits, (Amount of Profit Plus Amount Of Interest, If Any) The party in interest realized a profit of $125,000 on January 22, 2004, when the stock was sold. Because the correction will take place on November 17, 2004, which is after the date the profit was realized, an interest amount must be calculated. Since the profit already exceeds $100,000, the IRC 6621(c)(1) rate must be used. To calculate interest using applicable IRS Factors, use the basic formula: Dollar Amount x IRS Factor The first period of time is from January 22, 2004 to March 31, 2004 (69 days), the end of the quarter. From the IRC 6621(c)(1) underpayment rate tables, the rate for this quarter is 6%. From the IRS Factor Table 65, the IRS Factor for 69 days at 6% is 0.011374754. $125,000 x 0.011374754 = $1,421.84425 The plan is owed $126,421.84425 in Restoration of Profits as of March 31, 2004. The second period of time is April 1, 2004 through June 30, 2004 (91 days). From the IRC 6621(c)(1) underpayment rate tables, the rate for this quarter is 7%. From the IRS Factor Table 67, the IRS Factor for 91 days at 7% is 0.017555017. $126,421.84425 x 0.017555017 = $2,219.33762 The plan is owed $128,641.1819 in Restoration of Profits as of June 30, 2004. Continue calculating in the same manner.
The total amount of interest on the profit is $6,800.20447 ($1,421.84425 + $2,219.33762 + $3,159.0026), which is rounded to $6,800.20. Therefore, Restoration of Profits is $131,800.20 (the $125,000 profit plus $6,800.20) which would be paid to the plan on November 17, 2004, if Restoration of Profits exceeds Lost Earnings. The transaction must also be corrected by the sale of the asset back to the party in interest who originally sold the asset to the plan or to a person who is not a party in interest. Because the Principal Amount (the original $100,000 sales price) plus Restoration of Profits ($131,800.2045) is higher than the current fair market value ($100,000), the plan would receive $231,800.20 under the Restoration of Profits calculation. Step 3: Determine The Higher Of Lost Earnings Or Restoration Of Profits Under the Lost Earnings calculation, the plan would receive $111,440.90. Under the Restoration of Profits calculation, the plan would receive $231,800.20. Therefore, since Restoration of Profits is greater than Lost Earnings, the plan must be paid $231,800.20 on November 17, 2004.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||