<div>
Is this a hypothetical question?<br />
<br />
I would have to highly dispute the fact that any gender, who reaches age 65, will on average, live 30 more years. <br />

</div>


Is this a hypothetical question?

I would have to highly dispute the fact that any gender, who reaches age 65, will on average, live 30 more years.


<div>
I'm seeing data from 2006 (and it says it was updated in April 2010)<br />
that shows a 65 year old female only living 19.72 more years.<br />
The only ones who make it to age 95 are those who make it to age 91.<br />

</div>


I'm seeing data from 2006 (and it says it was updated in April 2010)
that shows a 65 year old female only living 19.72 more years.
The only ones who make it to age 95 are those who make it to age 91.


<div>
did you get your problem solved?<br />
<br />
the facts in the question do not seem real, so the scenario must have been &quot;hypothetical&quot;<br />
<br />
the stats show, people who are age 65 will not be expected to live 30 more years, at least from the stats I was able to locate.
</div>


did you get your problem solved?

the facts in the question do not seem real, so the scenario must have been "hypothetical"

the stats show, people who are age 65 will not be expected to live 30 more years, at least from the stats I was able to locate.

<div>
<div class="content wysiwyg-content">
Any thoughts I’ve been working on this on for 4 days. I need to use an excel function to answer this question<br />
<br />
Ellen is planning her retirement and has an annuity with a present worth of $500,000. &nbsp;Actuarial tables show that people who live to be 65 (her age) will on the average live 30 additional years. &nbsp;If the annuity will earn 6% interest compounded monthly, how much per month (equal amounts) can she withdraw over her 30 years of retirement. &nbsp;If she unexpectedly only lives 15 years, how much will be remaining in the annuity for her heirs?
</div>
</div>


Any thoughts I’ve been working on this on for 4 days. I need to use an excel function to answer this question

Ellen is planning her retirement and has an annuity with a present worth of $500,000.  Actuarial tables show that people who live to be 65 (her age) will on the average live 30 additional years.  If the annuity will earn 6% interest compounded monthly, how much per month (equal amounts) can she withdraw over her 30 years of retirement.  If she unexpectedly only lives 15 years, how much will be remaining in the annuity for her heirs?

Finance Homework question

The Math / Science topic primarily includes discussions of mathematics, physics, statistics and economic analysis, but also biology, chemistry and other sciences.