Please answer it in excel and show all formulas used

4,000,000 8,500,000 95,000,000 500.000 620.000 680 000 730.000 590 000 Land cost Aftertax land value Equipment Equipment salvage Contract sales/tons Contract $/ton Year 1 production Year 2 production Year 3 production Year 4 production Spot market $/ton Variable costton Fixed costs NWC percent Reclamation costs Charitable expense Tax rate Required return Year 1 depreciation Year 2 depreciation Year 3 depreciation Year 4 depreciation 954,100,000 | $2,700,000 | | $6,000,000 12% 14.29% 24.49% 17.49% 12.49% $ Time O cash low Equipment and NWO Toal YA Salles Contra Spot Sales VG Delo ET THE NI Deb Boon ginwa Ending NW NWC cash low Total dash low Book value Salvage MV BV Tao Salvage or Ilma Gash low 2 2 Profitability Index Average accounting retum RR (Highest) RR (Lowest) NPV