Spreadsheet: 696043d1600568504-residual-value-formula-looking-for-new-solution-see-attached-residual-value-formula
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 2017-03-01 00:00:00 | 2017-04-01 00:00:00 | 2017-05-01 00:00:00 | 2017-06-01 00:00:00 | 2017-07-01 00:00:00 | 2017-08-01 00:00:00 | 2017-09-01 00:00:00 | 2017-10-01 00:00:00 | 2017-11-01 00:00:00 | 2017-12-01 00:00:00 | 2018-01-01 00:00:00 | 2018-02-01 00:00:00 | 2018-03-01 00:00:00 | 2018-04-01 00:00:00 | 2018-05-01 00:00:00 | 2018-06-01 00:00:00 | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | 2020-10-01 00:00:00 | 2020-11-01 00:00:00 | 2020-12-01 00:00:00 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00
Chassis no: | FirstRegistrationDate: | BuyBackDate: | HoldingPeriod: | Make: | Model: | Deriative 1: | PurchasePrice: | ResidualValue: | Depreciation: | Interest: | Estimated LeasingCost | marts 17 | april 17 | maj 17 | juni 17 | [NAME] 17 | august 17 | september 17 | oktober 17 | november 17 | december 17 | januar 18 | februar 18 | marts 18 | april 18 | maj 18 | juni 18 | [NAME] 18 | august 18 | september 18 | oktober 18 | november 18 | december 18 | januar 19 | februar 19 | marts 19 | april 19 | maj 19 | juni 19 | [NAME] 19 | august 19 | september 19 | oktober 19 | november 19 | december 19 | januar 20 | februar 20 | marts 20 | april 20 | maj 20 | juni 20 | [NAME] 20 | august 20 | september 20 | oktober 20 | november 20 | december 20 | januar 21 | februar 21 | marts 21 | april 21 | maj 21 | juni 21 | [NAME] 21 | august 21 | september 21 | oktober 21 | november 21 | december 21 | januar 22 | februar 22 | marts 22 | april 22 | maj 22 | juni 22 | [NAME] 22 | august 22 | september 22 | oktober 22 | november 22 | december 22 | januar 23 | februar 23 | marts 23 | april 23 | maj 23 | juni 23 | [NAME] 23 | august 23 | september 23 | oktober 23 | november 23 | december 23
xOpelCorsa | 2017-03-30 00:00:00 |  | 24 | Opel | Corsa | 1,4 90HK 5dr Sport | 100000 | 50000
Chassis no: | FirstRegistrationDate: | BuyBackDate: | HoldingPeriod: | Make: | Model: | Deriative 1: | PurchasePrice: | ResidualValue: | Depreciation: | Interest: | Estimated LeasingCost | Month | No. of Months Depreciated | Total Depreciation | Residual Value
xOpelCorsa | 2017-03-30 00:00:00 |  | 24 | Opel | Corsa | 1,4 90HK 5dr Sport | 100000 | 50000 |  |  |  | 2019-03-01 00:00:00