please answer as a formula

Luarman, los. is coesideriag the following peoject: Requifed investment in equipment Project tife Salvare value Laurman, Ise, is coexidering the following project: \begin{tabular}{|c|c|c|c|c|} \hline The project would provide net operating income cach & & & & \\ \hline Sales & & & s & 2,750,000 \\ \hline Variable expenses & & & & 1,600,000 \\ \hline Contribution margin & & & 5 & 1,150,000 \\ \hline Fixed expenues: & & & & \\ \hline Salaries, rent and otber Exed out-of pocket costs & 5 & 520,000 & & \\ \hline Depreciation & & 350,000 & & \\ \hline Tocal fixed expenses & A & & & 870000 \\ \hline Net operating income & & & 5 & 280000 \\ \hline \end{tabular} Cost of Conital 18% 1. Compule the annual net cash inflow froes the project 2. Conptect the following timeline to compute the net present valae of the fulure cash flows for this project. Dont forget to include the salvage value in year 5. Year Net cash foom 2. Complete the following timeline to coenprote the set present value of the future cash flows for this project. Don't forget to include the salvage value in year 5. 21 22 23 Net cash flow 24 Diceuet Factor =1/(1+t) ) 25 Present value of the cash Bows. 25 Net pecient valoe 27 28 3. Une Excel's NPV function to coenpule the persent value of the cash Bows from years 1-5. Do sot include the original inveutineat at time nero. 29 NPV of Cach Flews from Years is to Dedact the cont of the investment 31 Net present valoe 12. Write an if then statement to ACCEPT of RIUDCT be project based en NPV 13 34 4, Use Excely IRR function bo compule the Frojects internal rule of refum 15 Write an ifthes stafersent to ACCIPT of RIJICT the pepject based on IRR 36 37 5. Compuse the projectr paybuck period. 34 \$3 6. Comprile the projecrs accountiog rate of return. 4I Sheet 1