© 2020 Cengage Learning®. May not be scanned, copied or duplicated, or posted to a publicly accessible website, in whole
or in part, except for use as permitted in a license distributed with a certain product or service or otherwise on a
password-protected website or school-approved learning management system for classroom use.
Fund earn 10%: Isaac will only be able to invest for 30 years. Using the Appendix B, the
annuity factor for 10% for 30 years is 164.494. Thus, investing $3,000 per year will amount to
$493,487 [$3,000 * 164.494= $493,487]. Using a financial calculator, the key strokes are:
3,000 +/- PMT Using the FV Excel function,
30 N =FV(.10,30,3000) = $493,482.07
10 I/YR
FV $493,482.07
The ability to accumulate funds for retirement depends upon both the time available to build the
fund and the return you can earn. Molly has an extra ten years more than Isaac, so she has a
greater likelihood of building a larger retirement fund.
3. Calculating annual investment to meet retirement target.
Use Worksheet 14.1 to help
George and Jude Sullivan determine how much they need to retire early in about 20 years.
Both have promising careers, and both make good money. As a result, they’re willing to
put aside whatever is necessary to achieve a comfortable lifestyle in retirement. Their
current level of household expenditures (excluding savings) is around $75,000 a year, and
they expect to spend even more in retirement; they think they’ll need about 125 percent of
that amount. (Note: 125 percent equals a multiplier factor of 1.25.) They estimate that
their Social Security benefits will amount to $20,000 a year in today’s dollars and that
they’ll receive another $35,000 annually from their company pension plans. George and
Jude feel that future inflation will amount to about 3 percent a year, and they think they’ll
be able to earn about 6 percent on their investments before retirement and about 4 percent
afterward. Use Worksheet 14.1 to find out how big their investment nest egg will have to be
and how much they’ll have to save annually to accumulate the needed amount within the