mouseovers-for-example table

===============HEADER ROW===============
//cell a01 value = DIV #

The Div # is simply a group identifyer that is used to group how money is allocated in a plan design.
The three groups in this example are (1) the owener, (2) the spouse of the owner, and (3) the employees.

cell a02 value = NAME

A cash balance plan usually includes all full time employees of the company.
Real names have been taken out of this example and replaced with generic names.

cell a03 value = AGE

The age of all people covered in a plan ends up being important as the IRS has different rules for individuals based on their age.

cell a04 value = COMPENSATION

This is the W-2 (or earned income) amount paid to each person.
With good retirment planning, we can prevent individuals from having to pay high tax rates (sometimes 40% or more) on this amount by allocating income to retirement accounts that can be shown as business expenses rather than taxable income.

cell a05 value = 401 (K)

This is the amount of money that will be deposited into a 401(k) account for each person in the plan.
Cash balance plans are very often done in combination with 401(k) plans in order to offer the most tax saving benefits.
401(k) contributions must adhere to non-discrimination testing rules set by the IRS.
The maximum amount that can be contributed to a 401(k) is set by the IRS each year. In 2014, that maximum amount is $23,000 for people over 50 and $17,500 for everyone else.

cell a06 value = SAFE HARBOR

This is the amount of money that will be deposited into a safe harbor account for each person in the plan.
It is often practical to include safe harbor plans as part of a complete retirment plan as they allow 401(k) plans to be managed without some of the complex non-discrimination testing rules that are in place without a safe harbor account.
Safe harbor accounts are not subject to the same complex non-discrimination testing rules set by the IRS like profit sharing and cash balance plans are.
To have a safe harbor account, all non-owner employees must be given at least 3% of pay for their safe harbor account.
One stipulation is that safe harbor contibution amounts must be declared 30 days before a tax year begins. Thus, it is only done if the employer knows it will be easily afforded without interrupting cash flow.
Safe Harbor plans must be 100% vested which means they must be fully funded and that anyone who leaves the company is entitled to 100% of their share of the money regardless of how long they worked at the company.

cell a07 value = PROFIT SHARING
This is the amount of money that is deposited into a profit sharing account for retirement.
Profit sharing accounts are subject to the complex non-discrimination testing rules set by the IRS.
Profit sharing contribution amounts are not determined until the taxes for the year are due, including extensions.
Profit sharing is generally consider an 'expensive way' for employers to allocate money as part of a retirement plan since they are required to share a higher percentage of that money with their employees.
Profit sharing accounts can be vested for up to 6 years meaning that any employee who has worked for the company for less than 6 years forfiets their share.

cell a08 value = CASH BALANCE

This is the amount of money that is deposited into a cash balance account.
Cash balance plan contributions must adhere to non-discrimination testing rules set by the IRS.
Besides a 401(k), cash balance plans are often thought of as the 'least expensive' way for employers to allocate money for retirement since the allocations can usually be heavily weighted towards company owners.
Cash balance contributions can be vested for up to 3 years which means that employees are not entitled to their share of the funds unless they have worked for the company for at least 3 years.
Cash balance investments are managed by the plan sponsor and not by each individual covered in the plan. A rate of return on the investment is then gauranteed by the plan sponsor.

cell a09 value = TOTAL ALLOCATIONS

The total allocations are the sum of the contributions from the 401(k), safe harbor, profit sharing, and cash balance accounts.
This is the money that the business owners can claim as a business expenses rather than income. Thus, the more money that is allocated in this column, the less money that will be taxed as income by the IRS.

cell a10 value = %

The percentage of total retirement plan contributions going to each person.
Generally with income tax rates for high income earners being in the 30%-50% range, any percentage greater than 80% for the owners makes for a good plan design.
With the amount that goes to the employees, they are getting a benefit which should be factored into their total compensation package.

===============HCE ROW===============
//cell b01 value = HIGHLY COMPENSATED EMPLOYEES (HCE'S)

Just like the cash balance plan document, this report has been divided up into groups to explain how money must is being allocated to each group of people within a company.
Highly compensated employees usually include all the owners of the company.
This structure allows for employees to be easily added and removed from the plan and also allows for very customized allocation structures for owners and other highly compensated individuals.

===============OWNER ROW===============
//cell c01 value = 1

The owner has his or her own division in this plan design.
In the lower right area of this report highlighted in green, you can see a summary of the different percentage of funds allocated for tax savings to each group.

cell c02 value = Owner

As this example for a small dental or legal office, this row is could be thought of as the dentist or lawyer who operates the practice and owns the majority of it as well.

cell c03 value = 64

At age 64, our dentist or lawyer may be nearing retirement.
IRS rules allow for a larger 401(k) contribution due to the fact that this person is over 50.

cell c04 value = $245,000.00

This amount would all be taxed as regualr income if there were no retirement planning going on.
It should be noted that in our example, this person may have made more than $245,000. However, the IRS sets a limit on the amount of yearly compensation that is used to determine how much money can be put into a cash balance plan.
The 2013 limit is $245,000. Thus, any amount over that will not be elegible to be put in a cash balance plan and for the purpose of this report, it does not make sense to include any amount over the maximum set by the IRS.

cell c05 value = $22,000.00

In this example from 2013, $22,000 is the maximum 401(k) contribution allowed by the IRS for a person who is 64 years old.
As 401(k) plans offer the most tax incentives, it makes sense to deposit the maximum in this account as long as it can be afforded.

cell c06 value = $0.00

Since safe harbor contribution percentages must be decided upon at least 30 days before a tax year, owners often opt to set their percentage to 0.
The amounts that get allocated to owners within different retirement accounts is often combined when taking into account limits imposed by the IRS, thus the owner would be able to claim less profit sharing or cash balance tax saving benefits if they claimed the benefits in their safe harbor account.
It's the job of our actuaries to give the best plan design which will give the most overall benefits for a company owner.

cell c07 value = $13,475.00

In our example, the owners have elected to include a profit sharing account as part of the overall retirment plan benefits.
The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
In our example, the amount for our primary owner has been calculated to be 5.5% of compensation or $13,475.00.
Having a profit sharing account allows owners to have extra tax savings, however as you can see in the green area of the report in the lower right corner, the percentage of money that must be given to employees as part of that benefit is actually higher than the percentage of money given to this majority owner.

cell c08 value = $220,500.00

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
Within the guidelines of the IRS, the primary owner is allowed to put $220,500.00 into their cash balance plan.

cell c09 value = $255,975.00

The sum of all the retirment account allocations.
This is the amount that is now a business expense that is no longer taxable as income.
If we assume a 40% combined tax rate on the income, this plan example would result in a tax savings of $105,000 for this owner and spouse alone.

cell c10 value = 87.00%

This is the most important cell in the report for business owners who are considering offering a retirement plan that maximizes their savings.
It shows what percentage of the total allocations put towards retirement planning that will be retained by the primary owner.
Thus, of the $294,217.77 of total retirement planning allocations that will be made by the company with this plan, 87.00% of that money will be retained by the primary owner.
If you are a company owner who likes more money in your account, this percentage should excite you! Cash Balance Actuaries offer free plan proposals and would love to design a plan in your best interests today!

===============SPOUSE ROW===============
//cell d01 value = 2

The spouse is a 2nd owner in our example and his or her own division in this plan design.
In the lower right area of this report highlighted in green, you can see a summary of the different percentage of funds allocated for tax savings to each group.

cell d02 value = Spouse

As this example for a small dental or legal office, this row is for the spouse of the primary owner of the business.

cell d03 value = 59

IRS rules allow for a larger 401(k) contribution due to the fact that this person is over 50.

cell d04 value = $24,500.00

This amount would all be taxed as regualr income if there were no retirement planning going on in combination with any other household income which would include the primary owner of the company.

cell d05 value = $22,000.00

In this example from 2013, $22,000 is the maximum 401(k) contribution allowed by the IRS for a person who is 59 years old.
As 401(k) plans offer the most tax incentives, it makes sense to deposit the maximum in this account as long as it can be afforded.

cell d06 value = $0.00

Since safe harbor contribution percentages must be decided upon at least 30 days before a tax year begins and because they must be fully funded throughout the year, the owners in this example have opted to set their percentage to 0.
The amounts that get allocated to owners within different retirement accounts is often combined when taking into account limits imposed by the IRS, thus the owner would be able to claim less profit sharing or cash balance tax saving benefits if they claimed the benefits in their safe harbor account.
It's the job of our actuaries to give the best plan design which will give the most overall benefits for a company owner.

cell d07 value = $1,506.75

In our example, the owners have elected to include a profit sharing account as part of the overall retirment plan benefits.
The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
In our example, the amount for our spouse owner has been calculated to be 6.15% of compensation or $1,506.75.
Having a profit sharing account allows owners to have extra tax savings, however as you can see in the green area of the report in the lower right corner, the percentage of money that must be given to employees as part of that benefit is actually higher than the percentage of money given to this majority owner.

cell d08 value = $2,450.00

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
Within the guidelines of the IRS, the spouse owner is allowed to put $2,450.00 into their cash balance plan.

cell d09 value = $25,956.75

The sum of all the retirment account allocations.
This is the amount that is now a business expense that is no longer taxable as income.
If we assume a 40% combined tax rate on the income, this plan example would result in a tax savings of $105,000 for this owner and spouse alone.

cell d10 value = 8.82%

This shows what percentage of the total allocations put towards retirement planning that will be retained by this owner.
Thus, of the $294,217.77 of total retirement planning allocations that will be made by the company with this plan, 8.82% of that money will be retained by this owner.

===============NHCE ROW===============
//cell e01 value = NON-HIGHLY COMPENSATED EMPLOYEES (NHCE'S)

Just like the cash balance plan document, this report has been divided up into groups to explain how money must be allocated.
Non-highly compensated employees is usually the group of people at the company whose positions are most likely to turn over.
This structure allows for employees to easily be added and removed from the plan and also allows for customized allocation structures for owners and other highly compensated individuals.

===============EMPLOYEE A ROW===============
//cell f01 value = 3

Division #3 represents all the non-owner, full time employees included in the plan. In the lower right area of this table highlighted in green, you can see a summary of how the divisions are allocating their earnings for tax savings.

cell f02 value = Employee A

As this example for a small dentist or legal office, this row may represent a receptionist for the business.

cell f03 value = 25

At age 25, the contribution amount is very small. Of course, if the plan lasts through their retirement, the total package will become quite valuable.

cell f04 value = $26,605.87

At this salary level, any amount of retirement savings that is offered by an employer will likely be appreciated and very needed when the time for retirement comes.

cell f05 value = $0.00

In our example, the employee has not elected to make a 401(k) contribution nor does the employer offer a contribution on their behalf.
If an employee made their own 401(k) contribution, there would no no tax benefits for the company onwers and so there would be no reason to show it as part of this report.
If the employer had made a 401(k) contribution on behalf of the employee, there would be additional tax savings for the employer only because that amount would count as an expense just like employee compensation.

cell f06 value = $798.18

3% of compensation is the minimum required amount that must be contributed to a safe harbor account for each employee.
3% of compensation is $798.18 for this employee.
It should also be noted that employees can manage their own investments within a safe harbor account.

cell f07 value = $1,024.32

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations that go into determining this number, our actuaries will be happy to explain them to should you be considering a plan for your business.
Within the guidelines of the IRS, this plan design requires 3.85% of compensation or $1,024.32 for this employee's profit sharing account.

cell f08 value = $532.12

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
This employee would recieve 2% of their compensation or $532.12 in their cash balance plan.
As long as this person stays at the company long for 3 years, the employee is entitled to money.

cell f09 value = $2,354.62

The total retirement plan allocations for this employee.

cell f10 value = 0.80%

Of the total $294,217.77 of retirement planning allocations that will be made by the company with this plan, 0.80% of that money will be retained by this employee.

===============EMPLOYEE B ROW===============
//cell g01 value = 3

Division #3 represents all the non-owner, full time employees included in the plan. In the lower right area of this table highlighted in green, you can see a summary of how the divisions are allocating their earnings for tax savings.

cell g02 value = Employee B

As this example for a small dentist or legal office, this row may represent a office manager for the business.

cell g03 value = 47

At age 47, the contribution amount is rather small. Of course, if the plan lasts through their retirement, the total package will become quite valuable.

cell g04 value = $51,616.92

At this salary level, the amount of retirement savings that is offered by an employer will likely be appreciated and needed when the time for retirement comes.

cell g05 value = $0.00

In our example, the employee has not elected to make a 401(k) contribution nor does the employer offer a contribution on their behalf.
If an employee made their own 401(k) contribution, there would no no tax benefits for the company onwers and so there would be no reason to show it as part of this report.
If the employer had made a 401(k) contribution on behalf of the employee, there would be additional tax savings for the employer only because that amount would count as an expense just like employee compensation.

cell g06 value = $1,548.51

3% of compensation is the minimum required amount that must be contributed to a safe harbor account for each employee.
3% of compensation is $1,548.51 for this employee.
It should also be noted that employees can manage their own investments within a safe harbor account.

cell g07 value = $1,987.25

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations that go into determining this number, our actuaries will be happy to explain them to should you be considering a plan for your business.
Within the guidelines of the IRS, this plan design requires 3.85% of compensation or $1,987.25 for this employee's profit sharing account.

cell g08 value = $1,032.34

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
This employee would recieve 2% of their compensation or $1,032.34 in their cash balance plan.
As long as this person stays at the company long for 3 years, the employee is entitled to money.

cell g09 value = $4,568.10

The total retirement plan allocations for this employee.

cell g10 value = 1.55%

Of the total $294,217.77 of retirement planning allocations that will be made by the company with this plan, 1.55% of that money will be retained by this employee.

===============EMPLOYEE C ROW===============
//cell h01 value = 3

Division #3 represents all the non-owner, full time employees included in the plan. In the lower right area of this table highlighted in green, you can see a summary of how the divisions are allocating their earnings for tax savings.

cell h02 value = Employee C

As this example for a small dentist or legal office, this row may represent a receptionist for the business.

cell h03 value = 37

At age 37, the contribution amount is very small. Of course, if the plan lasts through their retirement, the total package will become quite valuable.

cell h04 value = $18,503.93

At this salary level, any amount of retirement savings that is offered by an employer will likely be appreciated and very needed when the time for retirement comes.

cell h05 value = $0.00

In our example, the employee has not elected to make a 401(k) contribution nor does the employer offer a contribution on their behalf.
If an employee made their own 401(k) contribution, there would no no tax benefits for the company onwers and so there would be no reason to show it as part of this report.
If the employer had made a 401(k) contribution on behalf of the employee, there would be additional tax savings for the employer only because that amount would count as an expense just like employee compensation.

cell h06 value = $555.12

3% of compensation is the minimum required amount that must be contributed to a safe harbor account for each employee.
3% of compensation is $555.12 for this employee.
It should also be noted that employees can manage their own investments within a safe harbor account.

cell h07 value = $712.40

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations that go into determining this number, our actuaries will be happy to explain them to should you be considering a plan for your business.
Within the guidelines of the IRS, this plan design requires 3.85% of compensation or $712.40 for this employee's profit sharing account.

cell h08 value = $370.08

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
This employee would recieve 2% of their compensation or $370.08 in their cash balance plan.
As long as this person stays at the company long for 3 years, the employee is entitled to money.

cell h09 value = $1,637.60

The total retirement plan allocations for this employee.

cell h10 value = 0.56%

Of the total $294,217.77 of retirement planning allocations that will be made by the company with this plan, 0.56% of that money will be retained by this employee.

===============EMPLOYEE D ROW===============
//cell h01 value = 3

Division #3 represents all the non-owner, full time employees included in the plan. In the lower right area of this table highlighted in green, you can see a summary of how the divisions are allocating their earnings for tax savings.

cell i02 value = Employee D

As this example for a small dentist or legal office, this row may represent a receptionist for the business.

cell i03 value = 26

At age 26, the contribution amount is very small. Of course, if the plan lasts through their retirement, the total package will become quite valuable.

cell i04 value = $20,433.90

At this salary level, any amount of retirement savings that is offered by an employer will likely be appreciated and very needed when the time for retirement comes.

cell i05 value = $0.00

In our example, the employee has not elected to make a 401(k) contribution nor does the employer offer a contribution on their behalf.
If an employee made their own 401(k) contribution, there would no no tax benefits for the company onwers and so there would be no reason to show it as part of this report.
If the employer had made a 401(k) contribution on behalf of the employee, there would be additional tax savings for the employer only because that amount would count as an expense just like employee compensation.

cell i06 value = $613.02

3% of compensation is the minimum required amount that must be contributed to a safe harbor account for each employee.
3% of compensation is $613.02 for this employee.
It should also be noted that employees can manage their own investments within a safe harbor account.

cell i07 value = $786.70

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations that go into determining this number, our actuaries will be happy to explain them to should you be considering a plan for your business.
Within the guidelines of the IRS, this plan design requires 3.85% of compensation or $786.70 for this employee's profit sharing account.

cell i08 value = $408.68

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
This employee would recieve 2% of their compensation or $408.68 in their cash balance plan.
As long as this person stays at the company long for 3 years, the employee is entitled to money.

cell i09 value = >$1,808.40

The total retirement plan allocations for this employee.

cell i10 value = 0.61%

Of the total $294,217.77 of retirement planning allocations that will be made by the company with this plan, 0.61% of that money will be retained by this employee.

===============EMPLOYEE E ROW===============
//cell h01 value = 3

Division #3 represents all the non-owner, full time employees included in the plan. In the lower right area of this table highlighted in green, you can see a summary of how the divisions are allocating their earnings for tax savings.

cell j02 value = Employee E

As this example for a small dentist or legal office, this row may represent a receptionist for the business.

cell j03 value = 42

At age 42, the contribution amount is very small. Of course, if the plan lasts through their retirement, the total package will become quite valuable.

cell j04 value = $21,664.32

At this salary level, any amount of retirement savings that is offered by an employer will likely be appreciated and very needed when the time for retirement comes.

cell j05 value = $0.00

In our example, the employee has not elected to make a 401(k) contribution nor does the employer offer a contribution on their behalf.
If an employee made their own 401(k) contribution, there would no no tax benefits for the company onwers and so there would be no reason to show it as part of this report.
If the employer had made a 401(k) contribution on behalf of the employee, there would be additional tax savings for the employer only because that amount would count as an expense just like employee compensation.

cell j06 value = $649.93*

3% of compensation is the minimum required amount that must be contributed to a safe harbor account for each employee.
3% of compensation is $649.93 for this employee.
It should also be noted that employees can manage their own investments within a safe harbor account.

cell j07 value = $834.08

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations that go into determining this number, our actuaries will be happy to explain them to should you be considering a plan for your business.
Within the guidelines of the IRS, this plan design requires 3.85% of compensation or $834.08 for this employee's profit sharing account.

cell j08 value = $433.29

The amount here is determined by the complex non-discrimination testing rules as well as other limits and rules as by the IRS.
If you want to understand the rules, limits and calculations, that go into determining this number, please search reirement plans on Wikipedia or should you be considering a plan for your business, our actuaries can help you understand the rules.
This employee would recieve 2% of their compensation or $433.29 in their cash balance plan.
As long as this person stays at the company long for 3 years, the employee is entitled to money.

cell j09 value = $1,917.30

The total retirement plan allocations for this employee.

cell j10 value = 0.65%

Of the total $294,217.77 of retirement planning allocations that will be made by the company with this plan, 0.65% of that money will be retained by this employee.

===============TOTAL ROW===============
//cell k01 value = TOTALS

Totals for each group.

===============OWNER HCE TOTALS ROW===============
//cell l01 value = OWNER HCE'S=

Totals for all owners and highly compensated individuals (HCE'S)

cell l02 value = $269,500.00

Total amount of compensation for all owners and highly compensated individuals (HCE'S)

cell l03 value = $44,000.00

Total amount of 401(k) contributions for all owners and highly compensated individuals (HCE'S)

cell l04 value = $0.00

Total amount of safe harbor contributions for all owners and highly compensated individuals (HCE'S)

cell l05 value = $14,981.75

Total amount of profit sharing contributions for all owners and highly compensated individuals (HCE'S)

cell l06 value = $222,950.00

Total amount of cash balance contributions for all owners and highly compensated individuals (HCE'S)

cell l07 value = $281,931.75

Total amount of retirement planning allocations for all owners and highly compensated individuals (HCE'S)

cell l08 value = 95.82%

Percentage of allocations that are given to the owners and highly compensated individuals (HCE'S).
The higher this number, the more benifical it is for the owners to have these plans. Good plan design is generally cosidered anything over 80%.

===============NHCE TOTALS ROW===============
//cell m01 value = NHCE'S=

Totals for all non-highly compensated individuals (NHCE'S)

cell m02 value = $138,824.94

Total amount of compensation for all non-highly compensated individuals (NHCE'S)

cell m03 value = $0.00

Total amount of 401(k) contributions for all non-highly compensated individuals (NHCE'S)

cell m04 value = $4,164.76

Total amount of safe harbor contributions for all non-highly compensated individuals (NHCE'S)

cell m05 value = $5,344.75

Total amount of profit sharing contributions for all non-highly compensated individuals (NHCE'S)

cell m06 value = $2,776.51

Total amount of cash balance contributions for all non-highly compensated individuals (NHCE'S)

cell m07 value = $12,286.02

Total amount of retirement planning allocations for all non-highly compensated individuals (NHCE'S)

cell m08 value = 4.18%

Percentage of allocations that are given to all non-highly compensated individuals (NHCE'S)

===============TOTALS ROW===============
//cell n01 value = TOTAL=

Company Totals

cell n02 value = $408,324.94

Total amount of compensation for the entire company

cell n03 value = $44,000.00

Total amount of 401(k) contributions for the entire company

cell n04 value = $4,164.76

Total amount of safe harbor contributions for the entire company

cell n05 value = $20,326.50

Total amount of profit sharing contributions for the entire company

cell n06 value = $225,726.51

Total amount of cash balance contributions for the entire company

cell n07 value = $294,217.77

Total amount of retirement planning allocations for the entire company

cell n08 value = 100.00%

This value will always be 100% as it represents the percentage of allocations given to everyone in the company combined.

===============GREEN TABLE HEADER ROW===============
//cell o03 value = Allocations As a Percentage of Compensation=

This table compares allocations put towards retirement as a percentage of compensation for each group.

cell o05 value = Profit Sharing

Percentage of compensation going towards a profit sharing plan.

cell o06 value = Cash Balance

Percentage of compensation going towards a cash balance plan.

===============GREEN TABLE DIV #1 ROW===============
//cell p03 value = Div #1

Div #1 is for the primary owner.

cell p04 value = Primary Owner

Div #1 is for the primary owner.

cell p05 value = 5.50%

5.5% of total compensation will be put into a profit sharing account for this owner.
This means that 5.5% of income taxes for this owner will be avoided during the year because of the profit sharing retirement plan in place.

cell p06 value = 90.00%

90% of total compensation will be put into a cash balance plan for this owner.
This means that 90% of income taxes for this owner will be avoided during the year because of the cash balance plan in place.

===============GREEN TABLE DIV #2 ROW===============
//cell q03 value = Div #2

Div #2 is for the spouse of the primary owner who is also an owner.

cell q04 value = Spouse/Owner

Div #2 is for the spouse of the primary owner who is also an owner.

cell q05 value = 6.15%

6.15% of compensation will be put into a profit sharing account for this owner.
This means that 6.15% of income taxes for this owner will be avoided during the year because of the profit sharing retirement plan in place.

cell q06 value = 10.00%

10% of total compensation will be put into a cash balance plan for this owner
This means that 10% of income taxes for this owner will be avoided during the year because of the cash balance plan in place.

===============GREEN TABLE DIV #3 ROW===============
//cell p03 value = Div #3

Div #3 is for all the non-owner employees of the company.

cell r04 value = Employees

Div #3 is for all the non-owner employees of the company.

cell r05 value = 6.85%

Employees will earn an extra 6.85% as part of their total compensation with this profit sharing plan.
This amount should be factored into their total compensation package.

cell r06 value = 2.00%

Employees will earn an extra 2.00% as part of their total compensation with this cash balance plan.
This amount should be factored into their total compensation package.