How do I set up a perpituity calculator?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to set up a perpituity calculator in excel 2003 that allows for
3 things a yearly payment amount, a growth rate of the payment amount and a
required rate of return. The result I am looking for is the present value of
the calculation
 
Do you mean an annuity calculator?

Wouldn't you also need the number of years?
 
The formula for this calculation is A1 / ( Required Rate - Grwoth Rate)
 
Vasant,

Thanks for your reply. The formula I was looking for is

A1 / (Required rate - growth rate)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating Initial Payment - Excell 0
APR Fee Calculation 1
CUMIPMT 0
Amortization w/ variable interest rate 1
formula in excel 2
EXCEL 2007 Formula to calculate INTEREST only on a 3 month bridge 3
Annuity Payments From A Present Amount 2
Financial function - calculating loans with deferred payments 2

Back
Top