Feb 5 Chapter 5 Example.xlsx

Feb 5 Chapter 5 Example.xlsx - Starting Salary employee...

This preview shows 1 out of 2 pages.

Starting Salary $ 55,000.00 Summ employee contribution 8.0% employer contribution 5.0% total of em rate of return 6.0% Tot salary increase 2.0% Year Salary 1 $ 55,000.00 $ 4,400.00 $ 2,750.00 $ 7,150.00 2 $ 56,100.00 $ 4,488.00 $ 2,805.00 $ 14,872.00 3 $ 57,222.00 $ 4,577.76 $ 2,861.10 $ 23,203.18 4 $ 58,366.44 $ 4,669.32 $ 2,918.32 $ 32,183.01 5 $ 59,533.77 $ 4,762.70 $ 2,976.69 $ 41,853.38 6 $ 60,724.44 $ 4,857.96 $ 3,036.22 $ 52,258.76 7 $ 61,938.93 $ 4,955.11 $ 3,096.95 $ 63,446.35 8 $ 63,177.71 $ 5,054.22 $ 3,158.89 $ 75,466.23 9 $ 64,441.27 $ 5,155.30 $ 3,222.06 $ 88,371.57 10 $ 65,730.09 $ 5,258.41 $ 3,286.50 $ 102,218.77 11 $ 67,044.69 $ 5,363.58 $ 3,352.23 $ 117,067.71 12 $ 68,385.59 $ 5,470.85 $ 3,419.28 $ 132,981.90 13 $ 69,753.30 $ 5,580.26 $ 3,487.66 $ 150,028.74 14 $ 71,148.36 $ 5,691.87 $ 3,557.42 $ 168,279.75 15 $ 72,571.33 $ 5,805.71 $ 3,628.57 $ 187,810.81 16 $ 74,022.76 $ 5,921.82 $ 3,701.14 $ 208,702.42 17 $ 75,503.21 $ 6,040.26 $ 3,775.16 $ 231,039.98 18 $ 77,013.28 $ 6,161.06 $ 3,850.66 $ 254,914.11 19 $ 78,553.54 $ 6,284.28 $ 3,927.68 $ 280,420.91 20 $ 80,124.61 $ 6,409.97 $ 4,006.23 $ 307,662.37 21 $ 81,727.11 $ 6,538.17 $ 4,086.36 $ 336,746.63 22 $ 83,361.65 $ 6,668.93 $ 4,168.08 $ 367,788.45 23 $ 85,028.88 $ 6,802.31 $ 4,251.44 $ 400,909.51 24 $ 86,729.46 $ 6,938.36 $ 4,336.47 $ 436,238.91 25 $ 88,464.05 $ 7,077.12 $ 4,423.20 $ 473,913.57 26 $ 90,233.33 $ 7,218.67 $ 4,511.67 $ 514,078.72 27 $ 92,038.00 $ 7,363.04 $ 4,601.90 $ 556,888.38 28 $ 93,878.76 $ 7,510.30 $ 4,693.94 $ 602,505.92 29 $ 95,756.33 $ 7,660.51 $ 4,787.82 $ 651,104.60 30 $ 97,671.46 $ 7,813.72 $ 4,883.57 $ 702,868.16 31 $ 99,624.89 $ 7,969.99 $ 4,981.24 $
Image of page 1

Subscribe to view the full document.

Image of page 2
You've reached the end of this preview.
  • Spring '10
  • IrinaKadyrova
  • Salary, total of employer contributions

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern