.

Develop a spreadsheet model, and use it to find the project's NPV and MIRR Key Output: NPV - art 1. Input Data (in thousands of dollars) MIRR uipment cost et WC/Sales irst year sales (in units) ales price per unit ariable cost per unit onvariable costs $12,500 5% 1,100 $28.00 $18.00 $1,450 $1,500 40% 12% 2.5% arket value of equipment at Year 4 ax rate ACC nflation Years Accum'd art 2. Depreciation and Amortization Schedul Initial Cost 2 4Depr'n ear 20.0% 32.0% 19.0% 12.0% quipment Depr'n Rate quipment Depr'n, Dollars nding Bk Val: Cost - Accum Dep'rn Equipment art 3. Net Salvage Values, in Year 4 stimated Market Value in Year 4 ook Value in Year 4 xpected Gain or Loss axes paid or tax credit et cash flow from salvage