Please answer on excel document and upload a screen shot of the solutions. The first part solution and second part solution must be on seperate sheets.

10,000,000) IC NWC (100,000650,000)(750,000) 450,0001,050,000 7,500,000 15,000,000 15,000,000 10,500,000 6,500,000 4,000,000 8,000,000 8,000,000 5,600,000 4,000,000 500,000 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 Sales 6 500,000 500,000 500,000 500,000 EBT T(.34) NI +D 1,000,000 4,500,000 4,500,000 2,400,000 1,530,000 1,530,000 660,000 2,970,000 2,970,000 1,584,000 340,000 816,000 10 2,000,000 2,000,000 2,000,000 2,000,000 2,000,000 3,584,000 2,000,000 12 13 14 15 16 17 18 19 Question (5 bonus pts on final): If each year's price per unit decreases from the current level by 15%, do we still accept the project? Please reference all cells and make the link in cell "A1", 20 21 OCF Salvage FCF 2,660,000 4,970,0004,970,000 (10,100,0002,010,000 4,220,000 4,970,000 4,034,000 3,050,000 NPV-$3,597,996.91 Accept! IRR- 22.3096 Accept! so that the cell "A1" is the only cell to change to update the final conclusion. (Note that VCs vary with sales accordingly.) Please print and turn in your work on 2 pages ONLY: one contains the new solution table; the other contains the formulas (See "Formulas" column, then "Show Formulas") Deadline: Start of Monday (11/27) class. Each one's formula sheet should be different. Identical formula sheets will earn 5 deficit points. 23 24 25 You may be asked to present your results in class. Bonus Question Pagel-SolutionTable Page2-SolutionFormulas