Researching Kwame's employer

$-$

sponsored retirement plan has already got us started on that path. In this assignment, we will broaden the exercise and summarize all retirement accounts Kwame and Laticia already have in place or can open and contribute to

$,$

$$today$.$

The template for the retirement account summary I want you to create is here. Download a copy and start filling it out. Please keep the following in mind:

$1$

$.$

$$There are income limits for Roth IRA contributions, and deductibility limits for Traditional IRA contributions. Those rules are outside the scope of this class. For our purposes, let's assume that Laticia and Kwame can each have an IRA

$($

Individual Retirement Account

$)$

$$and contribute the maximum allowed to it

$.$

$$We will not consider whether it should be Traditional or Roth IRA in this assignment.

$2$

$.$

$$With his employer

$-$

sponsored plan, Kwame can contribute the maximum to both a

$4$

$5$

$7$

$$account and a

$4$

$0$

$1$

$($

k

$)$

$$account$.$

$3$

$.$

$$List employee contributions and employer match, if any, on separate rows.

$4$

$.$

$$Whatever the number of empty rows is in the middle of the table, it doesn't mean that that's the number of rows you will need to

fill out. If you need more rows, insert more, and if there are extras, then leave them blank or delete them.

$5$

$.$

$$Once you fill out all the numbers for each of the accounts Kwame and Laticia already have in place, or can establish and contribute

to

$,$

$$use Excel formulas to calculate all the totals in the frame at the bottom of the table.

$6$

$.$

$$Format the table in a presentable reader

$-$

friendly way: column widths for good visibility, consistent formatting of all the dollar

amounts etc.

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

PLS LIST OUT THE STEPS AND USE THE TEMPLATE BLEOW

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$!$

$1$

THANK YOU