AgTalk Home
AgTalk Home
Search Forums | Classifieds | Skins | Language
You are logged in as a guest. ( logon | register )

Lease Calculator in Excel
View previous thread :: View next thread
   Forums List -> Computer TalkMessage format
 
Hiline
Posted 9/21/2019 12:59 (#7747089)
Subject: Lease Calculator in Excel


WC MN
Does anyone have an Excel spreadsheet or the formula, to calculate an annual lease payment. For example, a $100,000 equipment purchase, 5% interest rate, five annual payments, first payment in advance and a 20% residual balance.

Payment schedule

1. October 1, 2019 (advance payment)
2. October 1, 2020
3. October 1, 2021
4. October 1, 2022
5. October 1, 2023
6. October 1, 2024 (20% residual)
Top of the page Bottom of the page


Jump to forum :
Search this forum
Printer friendly version
E-mail a link to this thread

(Delete cookies)