Originally Posted by Don Guillett[_2_]

I didn't look at your file but here is something you can try.

Function npv_5(d As Range, i As Range, e As Range)
Static values(4) As Double
values(0) = d * i
values(1) = values(0) * (1 + e)
values(2) = values(1) * (1 + e)
values(3) = values(2) * (1 + e)
values(4) = values(3) * (1 + e)
npv_5 = NPV(Cells(4, "m"), values()) - 0
End Function

=npv_5($D9,$I9,$E9)

On Jan 17, 5:00*pm, jjones42 wrote:
I have a question regarding present values of uneven payments. *We
signed a lease that orignally was approx 30 months long and had three
payments even payments. *The next month, it was amended and required
three upfront payments monthly and then an annual payment on January
15th of each year through 2014.

I am using the XNPV function, but you will see on the attached that I am
not zeroing out on my amortization table which makes me think I am doing
this all wrong.

Can someone take a look at the attached spreadsheet (had to zip it
because its the only way they accept excel) and let me know if they
agree with my calc. *The original lease is on the first tab and the
amended lease is on the second.

Thanks!

+-------------------------------------------------------------------+
|Filename: Capital Lease Amortization Table.zip * * * * * * * * * * |
|Download:http://www.excelbanter.com/attachment.php?attachmentid=278|
+-------------------------------------------------------------------+

--
jjones42