Question

eBook Allison and Leslie, who are twins, just received $45,000 each for their 26th birthday. They both have aspirations to become millionaires. Each plans to make a $5,000 annual contribution to her "early retirement fund" on her birthday, beginning a year from today. Allison opened an account with the Safety First Bond Fund, a mutual fund that invests in high-quality bonds whose investors have earned 8% per year in the past. Leslie invested in the New Issue Bio-Tech Fund, which invests in small, newly issued bio-tech stocks and whose investors have earned an average of 14% per year in the fund's relatively short history. If the two women’s funds earn the same returns in the future as in the past, how old will each be when she becomes a millionaire? Do not round intermediate calculations. Round your answers to two decimal places. Allison: years Leslie: years How large would Allison's annual contributions have to be for her to become a millionaire at the same age as Leslie, assuming their expected returns are realized? Do not round intermediate calculations. Round your answer to the nearest cent. $ Is it rational or irrational for Allison to invest in the bond fund rather than in stocks? High expected returns in the market are almost always accompanied by a lot of risk. We couldn't say whether Allison is rational or irrational, just that she seems to have less tolerance for risk than Leslie does. High expected returns in the market are almost always accompanied by less risk. We couldn't say whether Allison is rational or irrational, just that she seems to have more tolerance for risk than Leslie does. High expected returns in the market are almost always accompanied by a lot of risk. We couldn't say whether Allison is rational or irrational, just that she seems to have more tolerance for risk than Leslie does. High expected returns in the market are almost always accompanied by less risk. We couldn't say whether Allison is rational or irrational, just that she seems to have less tolerance for risk than Leslie does. High expected returns in the market are almost always accompanied by a lot of risk. We couldn't say whether Allison is rational or irrational, just that she seems to have about the same tolerance for risk than Leslie does.

Answer 1

how old will each be when she becomes a millionaire?

Allison :

The number of years taken for the fund to become $1 million is calculated using the nper function in Excel with these inputs :

rate = 8%

pmt = -5,000 (this is the annual contribution to the fund)

pv = -45,000 (this is the staring value of the fund)

fv = 1,000,000 (this is the target value of the fund)

nper is calculated to be 29.77

Age of Allison when fund becomes $1 million = 26 + 29.77 ==> 55.77 years

Leslie :

The number of years taken for the fund to become $1 million is calculated using the nper function in Excel with these inputs :

rate = 14%

pmt = -5,000 (this is the annual contribution to the fund)

pv = -45,000 (this is the staring value of the fund)

fv = 1,000,000   (this is the target value of the fund)

nper is calculated to be 19.48

Age of Leslie when fund becomes $1 million = 26 + 19.48 ==> 45.48 years

How large would Allison's annual contributions have to be for her to become a millionaire at the same age as Leslie

This is calculated using the PMT function in Excel with these inputs :

rate = 8%

nper = 19.48 (this the number of years taken by Leslie to become a millionaire)

pv = -45,000 (this is the staring value of the fund)

fv = 1,000,000   (this is the target value of the fund)

PMT is calculated to be $18,365.95

0