PLEASE PROVIDE EXCEL FORMULAS FOR THE BLANK BOXES IN THIS EXCEL PROBLEM!! :) including the specific match function for that formula too i am not familiar with that, will thumbs up if correct thank you!

. D G H 1 22 23 24 investment years of equipment usage t= t= 2 3 t= 1 t= 8.7% Discount rate: Tax Rate: Part 1: Before replacement 0 22.0% Sales Revenue Expenses other than Depreciation Depreciation 20 30 After 2.600 525 2,000 4 500 EBIT Sales Revenue (constant) Expenses other than Depreciation Cost of equipment Expected life of equipment Annual Depreciation (straight line) Before 2.600 1.215 1,600 8 200 31 32 22 33 EBIT After Taxes** Add back: Depreciation Free Cash Flow (Before) 0 Part 2: After replacement 35 36 Disposal of Old Equipment: see handout Old equipment was depreciated on a straight-line basis Age of old equipment: Accum. Deprec. On old equip Net Book Value of old equip Proceeds of sale: Gain/ (Loss) Tax on Gain (Loss)* Net cost of new Equipment Proceeds of sale of old equipment Tax on Gain / Loss: Sales Revenue Expenses other than Depreciation Depreciation EBIT EBIT After Taxes Add back: Depreciation Free Cash Flow (After) 980 44 45 46 47 48 49 50 Part 3: Incremental*** cash flows *Tax OUTFLOW if Gain Tax INFLOW if loss EBIT *(1-tax rate) *** difference between FCF before new equip, and FCF after PV of Incremental Cash Flows: Cumulative Cash for Payback: Cumulative PV for Disc. Payback: NPV: IRR: Payback: Disc Payback: Profitability Index: