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)