For this assignment you will need to use only formulas in most of the cells similar to assignments 1-4), though there will be several changes for this assignment Madison Manufacturing is looking to add a new assembly line to its manufacturing plant The project is expected to have a five year espan, after which it will be shutdown schedule (depreciation rates are 33% 45% 15 and 7 for years 1, 2, 3, and 4 respectively. An additional $35,000 in working capital will also be needed at the start of the project The embly lines expected to generate $250,000 in revenue par year with associated operating expenses of $100.000 per year. It is forecast that the equipment will have no salvage value by the end of the project A Under this Base Case scenario, setup your calculation calls below to compute NPV, IRR, and the Pl for this project. Once your spreadsheet is working take the values you get in cells $9.00 and land type them into cells E89, FS, and 069. 8. Now you should change you input cells (teaving your creation cells alone and compute NPV, IRR, and for Worse Case Now change your inpur conserving the calculation is one and compute NPV, IRR and Pfor Best Case Scene with the following changes to the Base Case Inputs Revenue of 5350,000, Operating Expenses of $60,000, and a tax rate of 269 Once again take the values you get in cells 59-61 and typethem in cells E70, F70, and G70 that the probability of each scenario is already included below INUTE Tax Rate 269 input calls Salvage Value 0 NOWC 35,000 Euipment Com 350,000 Depreciation Rate 0.33 0.45 0.15 0.07 0 0 1 2 5 Year Revue Operating spent Depreciation EDIT TH NOTAT Depreciation Change in LT Operating Assets Change in NOW FCF NPV Profitability Index [po NPV IRR PI Scenario Analysis Worst Case Base Case Best Case Prab 0.30 0.40 0.30 expected NPV Investment Decision Sheet1