Can you please help with 2-5? Can you also include them in formulas please? Thank you!

Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods. All answers must be entered as a formula. Click OK to begin. OK Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods. QB Comparison of Capital Budgeting Methods - Excel REVIEW VIEW ped FILE HOME INSERT PAGE LAYOUT FORMULAS DATA 11 men Paste __= BOK Number v nt A B D E ences $ Calibri -AA Wrap Text General BIU- Merge & Center - $ . % *8.99 Conditional Formatas Cell Formatting Table Styles Clipboard Font Alignment Styles A1 X fo Laurman, Inc. is considering the following project: 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment 1,750,000 3 Project life 5 years 4 Salvage value 225.000 5 6 The project would provide net operating income each year as follows: 7 Sales $ 2,750,000 8 Variable expenses 1.600.000 Contribution margin $ 1.150.000 10 Fixed expenses Salaries, rent and other fixed out of pocket costs 520,000 Depreciation 350.000 13 Total fixed expenses 870.000 14 Net operating income 280.000 15 16 Cost of Capital 18% 17 18 1. Compute the annual net cash inflow from the project 19 20 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 va 21 Year 9 $ 11 12 Proy 1 of 1 !!! Next Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods KB FILE HOME INSERT Comparison of Capital Budgeting Methods - Excel REVIEW VIEW PAGE LAYOUT FORMULAS DATA Con A Gene Autosum Paste SI Wrap Text Merge Center 5.% * Conditional Format set Formatting Table Styles Insert Deste format Clear Chad Fort Sort & Find & Fiber Select Latine Ant Cels G2 19 A 1 C D 18 1. Compute the annual net cushindow from the project 20 Complete the following timeline to compote the net pre value of the future cash flows for this project. Don't forget to include the salge valoe in years 21 Year 22 0 2 23 Net cash flow 24 Discount Factor 1 (1+r)^n) 1.000 25 Present value of the cash flows 26. Net present value 27 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 to 29 NPV of Cash Flows from Years 1-5 30 Dedoct the cost of the investment 31 Net present value 12 Write an Althen statement to ACCEPT OF REJECT the project based on NPV 33 34 4. Use Excel's IRR function to compute the project's internal rate of retum 35 Write an if the statement to ACCEPT or REJECT the project based on IRR 16 37 5. Compute the project's payback period. year 38 39 6. Compute the proiect's accountine rate of return. Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods. All answers must be entered as a formula. Click OK to begin. OK Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods. QB Comparison of Capital Budgeting Methods - Excel REVIEW VIEW ped FILE HOME INSERT PAGE LAYOUT FORMULAS DATA 11 men Paste __= BOK Number v nt A B D E ences $ Calibri -AA Wrap Text General BIU- Merge & Center - $ . % *8.99 Conditional Formatas Cell Formatting Table Styles Clipboard Font Alignment Styles A1 X fo Laurman, Inc. is considering the following project: 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment 1,750,000 3 Project life 5 years 4 Salvage value 225.000 5 6 The project would provide net operating income each year as follows: 7 Sales $ 2,750,000 8 Variable expenses 1.600.000 Contribution margin $ 1.150.000 10 Fixed expenses Salaries, rent and other fixed out of pocket costs 520,000 Depreciation 350.000 13 Total fixed expenses 870.000 14 Net operating income 280.000 15 16 Cost of Capital 18% 17 18 1. Compute the annual net cash inflow from the project 19 20 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 va 21 Year 9 $ 11 12 Proy 1 of 1 !!! Next Comparison of Capital Budgeting Methods 1. Complete the capital budgeting methods KB FILE HOME INSERT Comparison of Capital Budgeting Methods - Excel REVIEW VIEW PAGE LAYOUT FORMULAS DATA Con A Gene Autosum Paste SI Wrap Text Merge Center 5.% * Conditional Format set Formatting Table Styles Insert Deste format Clear Chad Fort Sort & Find & Fiber Select Latine Ant Cels G2 19 A 1 C D 18 1. Compute the annual net cushindow from the project 20 Complete the following timeline to compote the net pre value of the future cash flows for this project. Don't forget to include the salge valoe in years 21 Year 22 0 2 23 Net cash flow 24 Discount Factor 1 (1+r)^n) 1.000 25 Present value of the cash flows 26. Net present value 27 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 to 29 NPV of Cash Flows from Years 1-5 30 Dedoct the cost of the investment 31 Net present value 12 Write an Althen statement to ACCEPT OF REJECT the project based on NPV 33 34 4. Use Excel's IRR function to compute the project's internal rate of retum 35 Write an if the statement to ACCEPT or REJECT the project based on IRR 16 37 5. Compute the project's payback period. year 38 39 6. Compute the proiect's accountine rate of return