Please show your work on excel for the problem, how you got your answer and for the format in second picture please.

Supreme Chancellor Palpatine $($Sith Lord Darth Sidious$)$ of the Galactic Empire decided to hedge against risk through the strategic use of the first Death Star built by Geonisians after the destruction by the rebels. He is considering the following three options:

Option $1$: Use what is left of it and build the bigger $(160$ km in diameter$)$ second Death Star to annihilate the rebels.

Option $2$: Scrap what is left of it and salvage the Quadanuim steel and Kyber crystals to build more nimble intergalactic frigates and corvettes equipped with small$-$scale super lasers to chase and neutralize rebels in every corner of the galaxy.

Option $3$: Do nothing.

The static valuation of the first Death Star's future profitability based on the conventional discounted cash$-$flow model is $100,000,000$ Imperial Credits. Palpatine estimates the implied volatility of the return on the projected cash flows to be $15\%.$ The risk$-$free interest rate is $5\%($use continuous compounding$).$

Option $1$ will increase the underlying asset value by $30\%$ with a $20,000,000$ Imperial Credit implementation cost.

Option $2$ will reduce the underlying asset value by $10\%$ while creating an additional savings of $25,000,000$ Imperial Credits at any time over the next two years.

A$.$ Show the binomial lattice of the underlying asset values $($each is worth $4$ points $=20$ points$)$ over two years.

B$.$ What is the option's value at each node? $($Each is worth $5$ points $=30$ points$)$

C$.$ What is your decision at each blue colored node? Expand?Contract?Keep it Open$/$Do nothing? $($Each is $4$ points $=20$ points$)$Please help me with this Engineering Econ Stats problem. Please show your work on excel on how you got the answers.

$$