Spreadsheet Assignment #2 i 4 Calculating NPV - Excel Saved FILE HOME INSERT PAGE LAYOUT FORMULAS Calibri 11 4 A DATA REVIEW VIEW Sign In % 8% Paste BIU 4 4 Alignment Number Conditional Format as Cell Cells Editing Clipboard 2 Al Font fx A B C 4 5 6 Asset investment $ 7 Estimated annual sales $ 8 Costs 9 Net working capital 10 11 12 13 Pretax salvage value Tax rate Project and asset life Required return 69 69 69 EA 14 15 15 16 2 Formatting Table Styles Styles D E F G H 2,900,000 2,190,000 815,000 300,000 210,000 21% 3 12% Complete the following analysis. Do not hard code values in your calculations. You must use the built-in Excel function to calculate the NPV. 17 18 Aftertax salvage value 19 Sell equipment $ 210,000 20 Taxes 21 Aftertax cash flow 22 23 Sales 24 Costs 25 Depreciation Sheet1 READY Attempt(s) $ 2,190,000 $ 2,190,000 $ 2,190,000 815,000 966.667 815,000 966.667 815,000 966.667 + 100%