Solve in excel

Suppose your company is considering buying one of two tank trucks to haul high$-$tech liquid material with a discount rate of $7\%.$ Truck A is a relatively cheap truck. It costs $$150,000$ and has a $8-$year life, during which it will produce an annual cash flow of $$150,000.$ Truck B is much more expensive. It costs $$150,000$ and has only a $4-$year life, after which it has to be replaced. during the first $2$ years of it$$s life, it will produce cash flows of $$225,000$ and the remaining $2$ it will produce $$175,000$ and $$50,000$ respectively. Which truck should the company buy?