Equipment Master

Currently we have a spreadsheet for our companies equipment and vehicles. We are trying to have it show us a 10 year out look of what we still owe and what we will owe all within the same 10 year column just separated by colors. So for instance, currently, anything we still owe money on is in yellow with how much we still owe per year, and in orange we have the cost of a new one over the same 10 year span but starting at the end of life date. Help please?