Lourman, incorporated is considering the following project The project would provide net operating income each year as follows: Cost of Capital 18% Required: 1. Compute the annual net cash intlow from the project. 2. Complete the following timeline to compute the net present value of the future cash flows for this project. Don't forget to include the salvage value in year 5 3. Use Excel's NPV function to compute the present value of the cash flows from years 1.5. Do not include the original investment at time zero. 4. Use Excel's IRR function to compute the project's internal rate of return. 5. Compute the project's payback period. 6. Compute the project's accounting rate of return. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. Laurman, Incorporated is considering the following project: \begin{tabular}{|l|r|r|} \hline Required investment in equipment & $ & 1,750,000 \\ \hline Project life & 5 & years \\ \hline Salvage value & 225,000 & \\ \hline \end{tabular} The project would provide net operating income each year as follows: Cost of Capital 18% 3. Use Excel's NPV function to compute the present value of the cash flows from years 1.5. Do not indlude the original investment at time zero. 3. Use Excels NPV function to compote the present value of the cash flows from years 1.5 . Do not include the original investment at time zero. 42 43. 4. Use Excel's IAP function to compute the project's internal nate of return. 44 Write an if/then statement to ACCEPT or REJeCT the project based on IRR 5. Compute the project's payback period. years 6. Compute the project's accountine rate of return. Students: The scratchpad area is tor you to do any additional work you need to solve this question or can be used to show your work. Graded Worksheet