Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

image text in transcribed

image text in transcribed

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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Modern Management Control Systems Text And Cases

Authors: Kenneth A. Merchant

1st Edition

0135541557, 978-0135541555

More Books

Students also viewed these Accounting questions