Suppose the capital budget was $100,000. What is the NPV of the best project(s)?

File Edit Excel View Insert Format Tools Data Window Help Cash Flows AutoSavo Draw Formulas Data Page Layout Insert ome Review View Tell me Calibri (Body) 12 General L"!! |||||| Paste BIU $ % 3S F G . WACC PI B C D E 10.00% Fixed Budget = $250,000 Project Initial Investment PV of Inflows NPV IRR A -$80,000 $100,000 $20,000 B $70,000 $112,000 $42,000 -$100,000 $145,000 $45,000 D $40,000 $36,000 -$4,000 E -$60,000 $79.000 $19,000 F $110,000 $126,500 $16,500 12.00% 20.00% 16.00% 8.00% 15.00% 11.00% 1.25 1160 1.45 0.90 1.32 1.15 Ranking by NPV Project Initial Investment PV. of Inflows NPV IRR -$100,000 $145,000 $45,000 B -$70,000 $112,000 $42.000 A $80,000 $100,000 $20,000 -$60,000 $79.000 $19,000 F $110,000 $126,500 $16,500 D $40,000 $36,000 $4,000 PI 16.00% 20.00% 12.00% 15.00% 11.00% 8.00% 1.45 1.60 1.25 1.32 1.15 0.90 Investment NPV $100,000 $45,000 $170,000 $87,000 $250,000 $107.000 Ranking by IRR or PL Project Initial Investment PV of Inflows NPV IRR B -$70,000 $112,000 $42,000 C $100,000 $145,000 $45,000 E $60,000 $79,000 $19,000 $80,000 $100,000 $20,000 F $110,000 $126,500 $16,500 D $40,000 $36,000 $4,000 PI 20.00% 16,00% 15.00% 12.00% 11.00% 8.00% 1.60 1.45 1.32 1.25 1.15 0.90 Investment NPV $70,000 $42,000 $170,000 $87,000 $230,000 $106,000 ANPVA ANPV Capital Rotoring