![]() ![]() ![]() Your amortization schedule calculations are "in arrears". ![]() But for US leases and loans, a simple daily or monthly rate is typically used.Īlso, as you say, leases are paid "in advance". That said, I might note that for US leases, XNPV is not the correct way to calculate interest rate and amortization schedule calculations. If you want to use XNPV to calculate the initial value of the lease, your interest rate and amortization schedule calculations must mimic the way that XNPV is calculated. I made that change to the original worksheet "XNPV" DAYS(C8,B8)+1 could be written just as easily as C8-B8+1, which works in all versions of Excel. If you want your workbook to be usable with versions before Excel 2013, do not use the DAYS function. Just download the file.įirst, a word to the wise. Refer to the the Excel file "Lease Schedule v2.xlsx" ( click here). ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |