| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sale or lease? | New Users to Excel | |||
| CAR LEASE CALCULATION WITH RESIDUAL | Excel Worksheet Functions | |||
| Lease term dates | Excel Worksheet Functions | |||
| IRR&NPV Financial lease | Excel Discussion (Misc queries) | |||
| Does anyone have a formula to calculate the car lease payments | Excel Discussion (Misc queries) | |||
Hybrid Mode
