Show how to get these npv in excel

Rocky Transportion runs a large fleet of trucks for a construction business and need to purchase $100$ trucks this year. The Hino Trucks cost $$100,000$ each and has annual operating expenses of $$8,000$ and an expected life of $5$ years. At the end of $5$ years it is expected that the trucks can be sold for $$25,000$ each.

The alternative, a Mercedes truck, costs $$140,000,$ has annual operating costs of $$10,000$ and has an expected life of $7$ years, at the end of which you expect its salvage value to be $$40,000.$

Each truck will be depreciated straight$-$line over its expected life. The firm's total tax rate is $40\%$ and our required rate of return is $11\%.$ Which truck should you choose?

EAA Hino $=-$$$21,448\mathrm{.}48$

EAA Mercedes $=-$$$25,256\mathrm{.}97$

Suzie Sizemore owns Sizemore Aviation that operates in the Caribbean and parts of South America. She currently operates a Cessna Caravan, which she purchased five years ago for $$1,000,000$ and which was being depreciated straight$-$line over $10$ years, at the end of which it would have a zero salvage value. Right now, it has a market value of $$625,000.$

She believes that if she updates to a Pilatus PC$-12$ turboprop that she can make her trips faster, carry more cargo and$/$or passengers and thus make more money. She has already prepared herself professionally and spent $$25,000$ to get training and certification on the Pilatus model last year. The downside is that the Pliatus sells for $$3,000,000$ and would only be economical to operate for $5$ years, at which time it would have an estimated salvage value of $$1,000,000.$ This plane would be depreciated straight$-$line over $5$ years.

Given the new plane's speed and efficiency, she believes that her revenue would increase by $$400,000$ per year and at the same time her expenses would go down by $$100,000$ per year. Her marginal tax rate is $30\%$ and her required rate of return is $9\%.$ Should she make the change? Show all work and report all relevant numbers.

$NPV=-$$$12,722\mathrm{.}40$