Excel File Edit View Insert Format Tools Data Window Help N$33% Sun 9:56 AM Jean Castillo . Worksheet1.xls (? Q-Search in Sheet Home Layout Tables Charts SmartArt Formulas Data Review Edit Font Alignment Number Format Cells Themes Arial abcd Wrap Text Number HA Normal Bad Good Aa Merge Paste Conditiona Neutral Calculation Check Cell Formatting Insert Delete Format : Themes Aa G18 D Unit Production Unit Price Unit cost Sales Variable costs Depreciation Expense EBIT Tax (21%) NOPAT= EBIT . Tax Depreciation Fixed Assets Shipping & Installation fee Gross Fixed Assets Expenditure Net Working Capital Changes in Net Working Capital 18 Salvage Value Annual after-tax Cash Flows Payback Period PV of Expected FCF Discounted Payback NPV IRR MIRR Years of straight-line depreciation Salavage Value (% of purchaing costs) Working Capital Growth rate Corporate Tax Rate Cost of Capital Production Growth Rate Inflation rate eeles Sheet1 Sheet2 Sheet3 + Normal View Ready Circular Sum= 0 37557 25 COWPXOCS