90.2K

Verified Solution

Link Copied!

I need help making an excel spreadsheet based off of this information. Thanks

Need help creating an excel spreadsheet off of the given information. Thanks

Tamme started working for a consulting company XYZ. XYZ gives very generous match for retirement 401K contribution. Because Tammi is not salary-based employee, her monthly income is not stable, some of the months might have no income. Here is the rule for XYZ to match Tammie's contribution to her 401k plan: Yearty contribution should follow federal regulation The maximum match from XYZ is half of the federal limits for each year. Each month, XYZ will match dollar-for-dollar for 10% of Tammie's monthly earning or 20% of the federal annual limits, whichever is smaller . Tammie decides that she will contribute 20% of earnings each month XYZ will receive Tammie's income information monthly but not on a fined date. Tammie was a very busy, sometimes she forgot to enter what she contributed for some of the months and had to enter it into the spread sheet sporadically whenever she remembers). She invested in some assets pays her fixed rate Please help Tavle to create a spreadsheet to List the contribution and XY's match chronically Calculate the accumulated value of the account At least 2-war entries (monthly, can easily be expanded to more than 2 years. Inputs: 1. Today's date 2. Investment return 3. Job start date of Tammie's employment 4. Time of the report of Tammie's income randomly entered) 5. Tammie's income Results: 1. Ordered (by time of income reporting from Tammi to XYZ] Sist of a Tammie's income b. Tammie's contribution C.XYZ's match 2. Accumulated value of the assets Document the methodology how you solve the problems (like how much Tammie contributes and XYZ matches, etc.) o

Answer & Explanation Solved by verified expert

See Answer