need help solving this in excel show work and explain how you got answers please.

Intro Your company needs to buy a new truck You've narrowed the selection to a choice between Daimler (Mercedes-Benz) and Navistar. A 1 Truck 2 Initial cost 3 Fixed costs 4 Cost per mile 5 Life span 8 Salvage value B Daimler 300.000 8,000 0.12 8 D Navistar 200,000 12.000 annual 0.16 8 years o in year 8 0 Whichever truck you buy, it will be driven 70.000 miles per year. Your discount rate is 13% and your marginal tax rate is 21%. Attempt 1/30 for 10 pts. Part 1 What is the NPV of the Daimler truck? D+ decimals Submit Attempt 1/30 for 10 pts. Part 2 What is the NPV of the Navistar truck? 0+ decimals Submit Attempt 1/5 for 10 pts Part 3 Which truck should you buy? O Navistar ONeither O Daimler Submit