Errata....

I wrote:
We cannot use XNPV for calculating the PV of the capital lease payments.

I meant to add: unless the payments are on annual anniversary dates.

But Goal Seek or Solver can always be used.


I wrote:
Instead, I have developed a formula that I believe you can use.
[....]
(Note: I will rely on Goal Seek for now. I am still tweaking my
formula.)

I won't bother posting unless you are very interested.

As it is currently designed, it only handles payments on monthly anniversary
dates. It would not handle the payment 14 days after the start date for the
capital lease.

I could tweak it to handle that. But then it would not match __exactly__
with the monthly interest charges in the amortization schedule.

Of course, I could always special-case it. But that's exactly why I don't
think it is worthwhile, since Goal Seek and Solver work just fine for this.