spreadsheet). For example, you can calculate the future value of your 401(k) in 20 years based on a 5% interest rate, annual contribution of $3,000, and amount that you have amassed in the account. If the account value is $12,000 now, then the formula is @FV (5%,20,-3000,-12000,0) = $131,037.

How do I calculate my 401k match?

For example, your employer may pay $0.50 for every $1 you contribute up to 6% of your salary. So if you make $50,000 per year, 6% of your salary is $3,000. If you contribute that much to your 401(k), your employer contributes half the amount — $1,500 of free money — as a match.

What is the maximum safe harbor match formula?

A basic safe harbor matching formula requires a match rate of 100% of employee deferrals up to 3% of compensation plus 50% of employee deferrals between 3% – 5% of compensation, for a maximum match of 4% of eligible compensation.

What is the maximum safe harbor match?

With a safe harbor 401(k), everyone can contribute up to the $19,500 maximum in 2020, and those age 50 and older can make an additional $6,500 in catch-up contributions. The trade-off is the company has to make mandatory contributions to employee 401(k) accounts, and that money becomes vested immediately.

How is a 401k match calculated in Excel?

In this example, the match has two tiers. In tier 1 the company matches 100% up to 4% of the an employee’s compensation. In tier 2, the company matches 50% on deferrals between 4% and 6%. So, if an employee contributes 10%, the company matches 100% up to 4%, and 50% from 4 to 6%.

How to calculate 401k match for Tier 2?

In tier 2, the company matches 50% on deferrals between 4% and 6%. So, if an employee contributes 10%, the company matches 100% up to 4%, and 50% from 4 to 6%. After that, there’s no match. Let’s look at how we can calculate the match for these two Tiers with IF statements. Then in the next video, we’ll look at how we can simply the formulas.

How to find value based on multiple criteria in Excel?

To look up a value based on multiple criteria in separate columns, use this generic formula: {=INDEX (return_range, MATCH (1, (criteria1 = range1) * (criteria2 = range2) * (…), 0))}

When does a company match your 401k deferral?

In tier 2, the company matches 50% on deferrals between 4% and 6%. So, if an employee contributes 10%, the company matches 100% up to 4%, and 50% from 4 to 6%. After that, there’s no match.