12 2345676 13 14 15 16 17 18 (Question 7) A 1 Growth rate 2 Discount rate 3 Cast 4 Year 1 cash flow 5 6 7 89 10 11 12 1341516716 19 20 540Mid.xls 6 NPV 18 7 IRR Discount rate B 10% 15%. $500 0 $100 0 $10.4 16.60% C Growth D Year Cash flow Add Change Delete E 0 -500.00 Table Row input cell: Column input cell: OK 0% 5% 0% $100.0 $115.0 5% $57.8 $71.4 10% $20.7 $33.1 15% -$12.3 -$0.9 20% 25% $10 4 -$20.8 -$31.3 -$41.7 -$58.4 -$48.8 -$68.0 -$91.7 30% -$82.8 35% -$113.2 -$104.9 40% -$74.0 -$96.7 -$132.7 -$125.0 -$117 3 F (Question 8) CHAR Reset All Help G 2 300.00 330 00 Cancel 15% 10% $145.0 $130.0 $85.0 $98.6 $45.5 $57.9 $21.7 20% $160.0 $112.2 $70.2 $33.1 -$10.4 $0.0 -$39.2 -$29.6 -$65.1 -$56.2 -$88.5 -$80.2 -$109.7 -$102.0 H Answer: Subject to the.... To make DATA|TABLE what should be written on cell 10" Row input cell, and Column input cell Answer: B10: Answer: Row input cell: Answer: Column input cell: