Excel 2007 : Calculating a payment when one knows the PV

[snyderbugg]

Hello. I have another quandry related to excel 2007. I have to figure out the cash payments per year related to a 25-year lease term required for a $300,000 present value baseed on a 10% discount rate. The payments are in the beginning of the year. I was hoping to use the PMT function, but oddly enough, to calculate the payment it requires putting in a payment amount? If anyone has an idea on how to handle this, I would appreciate it. I know the answer is is $30,046 due to the book I have, but I need to understand how to do this myself.

Thank you very much!
Ursula

[darkyam]

PMT doesn't require a payment amount. =-PMT(.1,25,300000,0,1)