Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I set up a perpituity calculator?
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 |
#2
|
|||
|
|||
Do you mean an annuity calculator?
Wouldn't you also need the number of years? -- Vasant "Gutter" wrote in message ... 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 |
#3
|
|||
|
|||
The formula for this calculation is A1 / ( Required Rate - Grwoth Rate)
"Gutter" wrote: 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 |
#4
|
|||
|
|||
Vasant,
Thanks for your reply. The formula I was looking for is A1 / (Required rate - growth rate) "Vasant Nanavati" wrote: Do you mean an annuity calculator? Wouldn't you also need the number of years? -- Vasant "Gutter" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make a Fresnel Zone Calculator | Excel Worksheet Functions | |||
How do you set up a loan using the loan calculator w/odd payments. | Excel Discussion (Misc queries) | |||
payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
Auto Loan Calculator | Excel Worksheet Functions | |||
how do i add employees to payroll calculator template | Excel Worksheet Functions |