please show work by excel.thank you

Excel File Edit View Insert Format Tools Data Window Help 1 Wed 10:47 PM Q OO AutoSave OFF ADES: L1_practice Home Insert Draw Page Layout Formulas Data Review View Tell me Share Comments V + Get Add-ins D Slicer Y A. TT Equatan EH E Data fram Picture Pictures Shopcs Icons PivatTable Recommended Tabic Pivot Tables My Add-ins Maps PivatChart Sparkline Link Text V Timeline y Recommended Charts NON Comment Symbol C18 fx - K L M N 0 0 A B E F G H J 1 FINDING BOND YIELD- USING EITHER EXCEL FUNCTION IRR OR RATE 2 3 Year Cash flow Data table: Effect of 4 0 800 discount rate on NPV 5 1 100 1,000.00 6 2 100 0% 1,000.00 7 3 NPV of Bond Cash Flows 100 2% 786.04 1200 8 4 100 4% 603.96 9 1000 5 100 6% 448.39 10 6 100 8% 314.93 800 11 7 100 10% 600 200.00 12 8 1100 12% 100.65 400 13 14% 14.45 200 14 Yield 16% -60.62 0 15 "could be solved using either IRR or RATE 18% -126.21 5% 10% 15% 16 20% -183.72 -400 17 Discount rate 18 19 20 21 22 23 24 25 26 27 28 -200 0% #1 #2 #3 24 #5 A6 #7 48 #9 #10 #11 #12 + Ready HE + 150% w P S 19