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

I have a lease and used the Loan Calculator template, but when it came time
to balance at the end of the year I was several thousand dollars off what the
lender said the balance was...

The amount amount I used is 71,445 @ 8.88% with monthly payments of 1,479.28
for 60 months. But then I read the agreement (imagine that) and it showed
66,000 financed @ 8.88% plus sales tax of 112.75 per month.

Any suggestions? By the way I am an intermediate user so please don't get
tooooo technical.

Thank you very much
CASuziqQ