Please use excel and show me the formulas used. I have attached example templates from the textbook mentioned in the question.

Magneto came up with a teleportation system to transport all the mutants. The new system will eliminate the annual fuel and maintenance costs of their current transportation method, X$-$Jet of about $$12\mathrm{.}5$M$.$ The teleportation system costs $$50$M with an estimated project life of $6$ years. At the end of the $6$th year, they are planning to sell the system to Marvel characters for $$5$M$.$ The system requires a fully recoverable working capital of $$2\mathrm{.}5$M$.$ Annual operating costs are estimated to be $$100$k$.$ This is considered a $5-$Yr MACRS property for tax depreciation purposes. The marginal tax rate is $35\%,$ and the MARR is $6\%.$ Use the standard Excel income statement and cash flow statement templates used in the textbook examples; otherwise, you will get zero points. A$.$ Determine the net after$-$tax cash flows and the PW$.(25$ points$)$ B$.$ What is the IRR of this investment? $(10$ points$)$ C$.$ Is this project acceptable? Why? Why not? $(5$ points$)$ Magneto came up with a teleportation system to transport all the mutants. The new system will eliminate the annual fuel and maintenance costs of their current transportation method, X$-$Jet of about $\backslash (\backslash$$ $12\mathrm{.}5\backslash$mathrm$\{$M$\}\backslash ).$ The teleportation system costs $\backslash (\backslash$$ $50\backslash$mathrm$\{$M$\}\backslash )$ with an estimated project life of $6$ years. At the end of the $6$th year, they are planning to sell the system to Marvel characters for $\backslash (\backslash$$ $5\backslash$mathrm$\{$M$\}\backslash ).$ The system requires a fully recoverable working capital of $\backslash (\backslash$$ $2\mathrm{.}5\backslash$mathrm$\{$M$\}\backslash ).$ Annual operating costs are estimated to be $\backslash (\backslash$$ $100\backslash$mathrm$\{$k$\}\backslash ).$ This is considered a $\backslash (5-\backslash$mathrm$\{$Yr$\}\backslash )$ MACRS property for tax depreciation purposes. The marginal tax rate is $\backslash (35\backslash \%\backslash ),$ and the MARR is $\backslash (6\backslash \%\backslash ).$ Use the standard Excel income statement and cash flow statement templates used in the textbook examples; otherwise, you will get zero points.

A$.$ Determine the net after$-$tax cash flows and the PW$.(25$ points$)$

B$.$ What is the IRR of this investment? $(10$ points$)$

C$.$ Is this project acceptable? Why? Why not? $(5$ points$)\backslash$begin$\{$tabular$\}\{|$c$|$c$|$c$|$c$|$c$|$c$|\}$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Income Statement$\}\backslash \backslash$

$\backslash$hline End of Year & $0$ & $1$ & $2$ & $3$ & $4\backslash \backslash$

$\backslash$hline Revenue & & $\backslash$$ $26,950$ & $\backslash$$ $29,645$ & $\backslash$$ $32,610$ & $\backslash$$ $35,870\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Expenses:$\}\backslash \backslash$

$\backslash$hline O$\backslash$&M & & $11,000$ & $12,100$ & $13,310$ & $14,641\backslash \backslash$

$\backslash$hline Depreciation & & $10,000$ & $13,333$ & $4,445$ & $2,222\backslash \backslash$

$\backslash$hline Taxable income & & $5,950$ & $4,212$ & $14,855$ & $19,007\backslash \backslash$

$\backslash$hline Income taxes $(40\backslash \%)$ & & $2,380$ & $1,685$ & $5,942$ & $7,603\backslash \backslash$

$\backslash$hline Net income & & $\backslash$$ $3,570$ & $\backslash$$ $2,527$ & $\backslash$$ $8,913$ & $\backslash$$ $11,404\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Cash Flow Statement$\}\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Operating Activities:$\}\backslash \backslash$

$\backslash$hline Net income & & $3,570$ & $2,527$ & $8,913$ & $11,404\backslash \backslash$

$\backslash$hline Depreciation & & $10,000$ & $13,333$ & $4,445$ & $2,222\backslash \backslash$

$\backslash$hline $\backslash$multicolumn$\{6\}\{|$l$|\}\{$Investing Activities:$\}\backslash \backslash$

$\backslash$hline Machine tools & $\backslash$$ $\backslash ((30,000)\backslash )$ & & $\backslash$multicolumn$\{3\}\{|$l$|\}\{=$NPV$(20\backslash \%,$C$25$:F$25)+$B$25\}\backslash \backslash$

$\backslash$hline Working capital & & & & & $\backslash \backslash$

$\backslash$hline Salvage value & $\backslash$multicolumn$\{3\}\{|$l$|\}\{=$NPV$(32\backslash \%,$C$24$:F$24)+$B$24\}$ & & $\backslash \backslash$

$\backslash$hline Gains tax & & & & & $\backslash \backslash$

$\backslash$hline Net Cash Flow $($in Actual $\backslash$$$)$ & $\backslash$$ $\backslash ((30,000)\backslash )$ & $\backslash$$ $13,570$ & $\backslash$$ $15,860$ & $\backslash$$ $13,358$ & $\backslash$$ $13,626\backslash \backslash$

$\backslash$hline Net Cash Flow $($in Constant $\backslash$$$)$ & $\backslash$$ $\backslash ((30,000)\backslash )$ & $\backslash$$ $12,336$ & $\backslash$$ $13,108$ & $\backslash$$ $10,036$ & $\backslash$$ $9,307\backslash \backslash$

$\backslash$hline & & $\backslash$$$(321\mathrm{.}06)$ & & & $\backslash$$$(321\mathrm{.}06)\backslash \backslash$

$\backslash$hline & PW$(32\backslash \%)=$ & $\backslash$$$(321\mathrm{.}06)$ & & W$(20\backslash \%)\backslash (=\backslash )$ & $\backslash$$$(321\mathrm{.}06)\backslash \backslash$

$\backslash$hline & IRR $=$ & $31\mathrm{.}34\backslash \%$ & & IRR' $=$ & $19\mathrm{.}40\backslash \%\backslash \backslash$

$\backslash$hline

$\backslash$end$\{$tabular$\}$