Personal Finance Plan Worksheet

  1. Using the above information, complete the following and fill-in the correct dollar amounts below:

    1. Setup an Emergency NestEgg Fund with a 7% growth rate, and with the fund’s total savings amounting to 6 months of income after 5 years of monthly contributions.
      • Net Monthly Income: $__________

      • Emergency NestEgg Goal: $__________

      • Emergency NestEgg Monthly Contribution: $__________

    2. Setup a Retirement Fund with a 10% growth rate, and a projected retirement age of 70. The fund’s goal should be for a 30-year retirement at the individual’s current net monthly income.
      • Retirement Fund Goal: $__________

      • Retirement Fund Monthly Contribution: $__________

  2. For the above individual, create and print a balanced monthly budget spreadsheet, and pie chart containing the monthly expense dollar amounts for the following categories:

*Note: any excess monthly income should be set-up as a contribution to Personal Savings/Investment.