Question

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 1.5T: price of car $30,420, fees and taxes is $5,400, interest rate at 4% paid for 5 years, depreciation of the vehicle after 5 years is $17,146

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

cash flow chart using the arrows

Answer 1

Cash flow chart using Table
Car Model	Price	Fees & taxes	Interest 4%	Depreciation	value of the car at the end of 5 years
2020 accord ex-l 1.5T	30420	5400	6084	-17146	24758
2017 Honda Accord EX-L:	15000	1989	3000	-7512	12477

Cash flow chart using the Arrows

Used 3D cone instead of arrows, due to Technical Problem. You can Replace it with arrows.

Interest = Value x 4 % x 5Yrs