please do cell D36 using formula. All the formulas given in Chegg answers in previous posted questions are wrong.

Excel SIM: Comparison of Capital Budgeting Methods 1. Determine the payback period for an investment. 2. Evaluate the acceptability of an investment project using the net present value method. 3. Evaluate the acceptability of an investment project using the internal rate of return method. 4. Compute the simple rate of return for an investment. 10 points Comparison of Capital Budgeting Methods - Excel ? FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In eBook Calibri 11 AA % Paste BIU- Alignment Number Cell Cells Editing Conditional Format as Formatting Table Styles Styles Print Clipboard Font D36 V References A B D E 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment $ 3 Project life 4 Salvage value 5 6 The project would provide net operating income each year as follows: Sales 2,205,000 7 225,000 7 $ 8 2,750,000 1,600,000 1,150,000 9 $ 10 11 Variable expenses Contribution margin Fixed expenses: Salaries, rent and other fixed out-of pocket costs Depreciation Total fixed expenses $ 520,000 350,000 12 13 870,000 D36 A B D E 1 Laurman, Inc. is considering the following project: 2 Required investment in equipment $ 3 Project life 4 Salvage value 5 6 The project would provide net operating income each year as follows: Sales 2,205,000 7 225,000 10 points 7 $ 8 2,750,000 1,600,000 1,150,000 9 $ eBook 10 11 Variable expenses Contribution margin Fixed expenses: Salaries, rent and other fixed out-of pocket costs Depreciation Total fixed expenses Net operating income $ 520,000 350,000 12 Print 13 870,000 280.000 14 $ References 15 $ 630,000 16 Company discount rate 18% 17 18 1. Compute the annual net cash inflow from the project. 19 20 2. Complete the table to compute the net present value of the investment. 21 22 Year(s) 23 Now 1-7 7 Sheet1 HE ! + 100% READY Attempt(s) 2/3 Hint Show Me D36 A B D E $ 630,000 18 1. Compute the annual net cash inflow from the project. 19 20 2. Complete the table to compute the net present value of the investment. 21 10 points 7 eBook 225,000.00 225,000.00 0.314 70,633.13 Print 22 Year(s) 23 Now 1-7 24 Initial investment $ (2,205,000.00) 25 Annual cost savings $ 630,000.00 26 Salvage value of the new machine $ 27 Total cash flows $ (2,205,000.00) $ 630,000.00 $ 28 Discount factor 1.000 3.182 29 Present value of the cash flows $ (2,205,000.00) $ 2,401,262.38 $ 30 Net present value $ 266.895.52 31 32 Use Excel's PV function to compute the present value of the future cash flows $ 33 Deduct the cost of the investment $ 34 Net present value $ 35 36 3. Use Excel's RATE function to compute the project's internal rate of return 37 38 4. Compute the project's payback period. 39 40 5. Compute the project's simple rate of return. References 2,471,895.52 2,205,000.00 266.895.52 3.5 years 12.70% Sheet1 READY + 100% Attempt(s) 2/3 Hint Show Me