I need help with the Excel formulas for the following yellow blanks in the photos. thanks!
X B c D $ aurman, Inc. is considering the following project: tequired investment in equipment roject life alvage value 2,205,000 7 225,000 $ 2,750,000 1.600.000 1,150,000 $ The project would provide net operating income each year as follows: Sales 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 870.000 290.000 5 6 Company discount rate 1896 7 Compute the annual net cash inflow from the project. 39 Note: depreciation is the only noncash expense on the income statement Complete the table to compute the net present value of the investment, 21 $ 630.000 Year's 23 Now Z Sheet1 READY B30 X > D E N 19 (Note: depreciation is the only noncash expense on the Income statement) 20 2. Complete the table to compute the net present value of the investment. 21 22 Year(s) 23 Now 1-7 24 Initial investment $ 12,205,000.00) 25 Annual cost savings 26 Salvage value of the new machine 27 Total cash flows 28 Discount factor 1000 29 Present value of the cash flows 30 Net present value 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 $ 2.295,000.00 36 3. Use Excel's RATE function to compute the project's internal rate of return 3.5 years 35 4 Compute the project's payback period 39 40 5. Compute the project's unadjusted rate of return -2 Sheet1 READY 100% Now 19 (Note: depreciation is the only noncash expense on the income statement) 20 2. Complete the table to compute the net present value of the investment. 21 22 Year's) 23 1-7 24 Initial investment S 12,205,000.00) 25 Annual cost savings 26 Salvage value of the new machine 273 Total cash flows 28 Discount factor 1.000 29 Present value of the cash flows 30 Nes present value 31 32 Use Exce's PV function to compute the present value of the future cash flows 33 Deduct the cost of the investment Net present value 35 36 3. Use Excel's RATE function to compute the project's interna rate of return 2 205 000.00 58 4. Compute the project's payback period 3.5 years 40 5. Compute the project's unadjusted rate of return Sheet1