SPREADSHEET 21.1 The savings plan excel Please visit us at www.mhhe.com/bkm 1 Retirement Your Income Growth 2 25 07 3 Age Income 4 30 50,000 5 31 53,500 9 35 70,128 19 45 137,952 29 55 271 372 30 65 533 8291 40 Total 7,445,673 D Savings Rate POR 15 .00 Savings Cumulative Savings 7,500 7,500 3,025 15,975 10,519 51,658 20,603 308,859 40.700 943 477 30.074 2.457,510 1.110,851 Retirement Anny Consumption 42,500 45,475 59.000 117.250 220,000 453, 755 192.244 A 1 Retirement Year 2 25 3 Ape 4 30 5 31 39 65 40 Total B Income Growth Savings Rate .07 .15 Income Savings 50000 =B4 SC52 -B4"(14$852) 85'$C$2 B36' 143852) B39'5082 -SUM 84:39SUM CAC39) D ROR 06 Cumulative Savings Consumption 34-04 EDWISD$21405 B5-05 FD360529 B3-c39 Retirement AB EPMTISDS2 SAS2, SDS 30,0,0) SPREADSHEET 21.1 The savings plan excel Please visit us at www.mhhe.com/bkm 1 Retirement Your Income Growth 2 25 07 3 Age Income 4 30 50,000 5 31 53,500 9 35 70,128 19 45 137,952 29 55 271 372 30 65 533 8291 40 Total 7,445,673 D Savings Rate POR 15 .00 Savings Cumulative Savings 7,500 7,500 3,025 15,975 10,519 51,658 20,603 308,859 40.700 943 477 30.074 2.457,510 1.110,851 Retirement Anny Consumption 42,500 45,475 59.000 117.250 220,000 453, 755 192.244 A 1 Retirement Year 2 25 3 Ape 4 30 5 31 39 65 40 Total B Income Growth Savings Rate .07 .15 Income Savings 50000 =B4 SC52 -B4"(14$852) 85'$C$2 B36' 143852) B39'5082 -SUM 84:39SUM CAC39) D ROR 06 Cumulative Savings Consumption 34-04 EDWISD$21405 B5-05 FD360529 B3-c39 Retirement AB EPMTISDS2 SAS2, SDS 30,0,0)