Excel formula to determine basic safe harbor match

[Guest Bear]

Hello,

A while back someone had posted an excel file for calculating a basic safe harbor match, but unfortunately the file is no longer available for download here.

Does anyone have a file or formula to calculate? Any and all help is greatly appreciated!!!

[ERISAnut]

Column A = Compensation

Column B = Deferrals for the Year

Column C = B/A This will Express Deferrals as a percentage of compensation

Column D = =IF(C6>=0.05,0.04*A6,IF(C6<=0.03,B6,(A6*0.03)+((B6-(A6*0.03))/2)))

Be sure the Compensation entered in Column A has already been limited to the 401(a)(17) limit.

Hope this helps.

[Guest Bear]

Thank you very much Erisanut!