case#254918913-Finance.xlsx

case#254918913-Finance.xlsx - Assuming that presently my...

Info icon This preview shows pages 1–4. Sign up to view the full content.

Stage 1: Age 25-40 Inflation Rate 2% Return 10% Year Investment(Including inflation) Valuation Factor 1 50000 1.1000 55000 2 51,000.00 1.2100 61710 3 52,020.00 1.3310 69238.62 4 53,060.40 1.4641 77685.73164 5 54,121.61 1.6105 87163.39090008 6 55,204.04 1.7716 97797.32458989 7 56,308.12 1.9487 109728.59818986 8 57,434.28 2.1436 123115.48716902 9 58,582.97 2.3579 138135.57660364 10 59,754.63 2.5937 154988.11694928 11 60,949.72 2.8531 173896.6672171 12 62,168.72 3.1384 195112.06061758 13 63,412.09 3.4523 218915.73201293 14 64,680.33 3.7975 245623.4513185 15 65,973.94 4.1772 275589.51237936 Amount accumulated upto Age 40 $ 2,083,700.27 Stage 2: Age 40-60 Inflation Rate 2% Return 10% Year 16 36,319.48 4.595 166887.02379485 17 37,045.87 5.054 187247.24069782 18 37,786.79 5.560 210091.40406296 19 38,542.52 6.116 235722.55535864 20 39,313.37 6.727 264480.70711239 21 40,099.64 7.400 296747.3533801 22 40,901.63 8.140 332950.53049247 23 41,719.66 8.954 373570.49521255 24 42,554.06 9.850 419146.09562849 25 43,405.14 10.835 470281.91929516 26 44,273.24 11.918 527656.31344917 Assuming that presently my age is 25 years and i am willing to retire 35 years later. I expect to receiv
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 2
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

{[ 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