I need to make a cash flow chart for two model of cars and the end result i am looking for is the value of the car at the end of 5 years when it will be traded in.

the first model is a 2020 accord ex-l: total price of car $30,420, interest rate at 4%, fees and taxes is $5,400, depreciation of the vehicle after 5 years is $17,146

2017 Honda Accord EX-L: the total price is $15,000, fees and taxes is $1,989, interest rate is 4%, depreciation of the vehicle after 5 years is $7,512