View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.misc
CASuziqQ CASuziqQ is offline
external usenet poster
 
Posts: 4
Default How do I calculate a lease?

Thank you for all your help Ron!

"Ron Rosenfeld" wrote:

On Wed, 30 Jan 2008 10:55:01 -0800, CASuziqQ
wrote:

I have used the templates; I guess my problem is not understanding how the
sales tax portion of the lease works.

Thank you for all your help Ron!


I've never leased anything, and I haven't reviewed your contract, so it's hard
to tell.

From what you wrote, it seems as if they are just adding the tax payment onto
the lease payment, and that the tax payment is the same for the entire duration
of the lease.

If that is the case, then you could treat these as two separate payments

1. The lease payment, which is broken down into interest and principal.
2. The tax payment, which is completely separate.
--ron