Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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.) oStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started