Its excel solver

-need to solve for pw for all projects and

- for project bc needs to be solve for (life, $annual nfc, initial investment,salvage,and pw)

AutoSave Off HD Project Selection Search Cortney X File Home Insert Formulas Data Review View Developer Help Share Comments Draw Page Layout Lo Recent Sources C' Existing Connections V Queries & Connections From Text/CSV Le From Web From Table/Range ? Solver 21 2 8 R Clear V Group Ungroup 119 Subtotal Properties Refresh All Edit Links Get Data Stocks Geography Sort ZL. Filter Reapply Advanced Text to Columns CC What-If Forecast Analysis Sheet V Get & Transform Data Queries & Connections Data Types Sort & Filter Data Tools Forecast Outline 17 Analyze D5 fx H 1 J K L M N O A B. D E F G 1 Project Init. Invest Annual NCF Life Salvage PW 2 A -25,000 6,000 4 4,000 3 B -20,000 9,000 4 0 4 C -50,000 15,000 4 20,000 5 BC 6 7 8 9 10 11 Budget 70000 12 13 Select projects to maximize PW at i = 15% and b = $70,000 14 Initial Annual Life, Salvage 15 Project investment, $ NCF, $ years value, $ 16 A -25,000 +6.000 4 +4,000 17 B 20,000 +9,000 4 18 19 C -50,000 +15,000 4 +20,000 20 21 0 5 10 35 + 1 Ready + III 160%