Fill out the blanks for questions 22-28 on excel, please show formulas as well. Show and explain graph.

NPV IRR 0.005 $(5,000.00)$(10,000.00) 1 $ 500.00$ 1,000.00 2600.00$1,000.00 $700.00$ 1,000.00 4 $ 400.00 $1,000.00 5$ 300.00 $ 1,200.00 6$ 800.00$ 1,500.00 $ 900.00$1,500.00 8 $ 1,200.00 $1,500.00 9 $ 800.00$ 1,500.00 10700.00$1,500.00 11 1,500.00$1,500.00 121,900.00 1,500.00 13 2,100.00 1,500.00 14 $1,200.00$4,000.00 5$1,500.00$4,000. 22 Calculate Using Excel Functions 23 NPV 24 IRR 22. B23:B24 -> Drag to C23:24 23. E6->drag to E6:F21 24. E23 ->drag to F23 25. H6 26. H7 - drag to H8:H36 27. 17 -> Drag to 17:J37 28. Graph line graph H6:J37 explain the graph