I am trying to figure out how to use functions in Excel to calculate an
annuity from a present amount. Do you happen to know how I would do this?
For Example:
Present Amount = $100,000
Period = 30 years (annual payments at beginning of each year)
Interest Rate = 6% / year
Annual Amount of Withdrawel Available = ?
Value at end of 30yr period = $0

Thank for your assistance,

James Richey

Use the PMT function, as in:

=pmt(6%,30,100000)
=7264.89

Regards,
Fred.

"JRR" wrote in message
...
I am trying to figure out how to use functions in Excel to calculate an
annuity from a present amount. Do you happen to know how I would do this?
For Example:
Present Amount = $100,000
Period = 30 years (annual payments at beginning of each year)
Interest Rate = 6% / year
Annual Amount of Withdrawel Available = ?
Value at end of 30yr period = $0

Thank for your assistance,

James Richey

Thanks Fred. It doesn't get any easier than that.
Here is an interesting link if you want more info. JRR:
http://gs.fanshawec.ca/tlc/math270/3_4_Annuities.htm

Regards,
Ryan--


--
RyGuy


"Fred Smith" wrote:

Use the PMT function, as in:

=pmt(6%,30,100000)
=7264.89

Regards,
Fred.

"JRR" wrote in message
...
I am trying to figure out how to use functions in Excel to calculate an
annuity from a present amount. Do you happen to know how I would do this?
For Example:
Present Amount = $100,000
Period = 30 years (annual payments at beginning of each year)
Interest Rate = 6% / year
Annual Amount of Withdrawel Available = ?
Value at end of 30yr period = $0

Thank for your assistance,

James Richey