I need the formulas for F & G in Part $1$ and E and F in part $2$

Bond Pricing - Excel 5 Bond Pricing - Excel Paste S Clipboard K16 L The u t Strt s to nnual on to this is Rite: N u m of per 12 to FILE of this but the VLOOKUP furamy when HOME CSibri INSERT PAGE LAYOUT SS2SDo0 32 s,ooo FORMULAS REVIEW VIEW Sign In PAGE LAYOUT REVIEW VIEW 5 Sign In HOME Calibri INSERT FORMULAS DATA Alignment Number DATA Conditional Formatting Cells Editing Alignment Number Cells Editing Calculate the amount that will paid on March Calculate the of interest that would when the the in f. A. the Rate i" When Bnd prie, y.w fEctU A"ume Market Rate is: will this bond interest? Glculitfng the pri, show the f.ctUfm the futu n workshtS the appmpriate future (fo und in workshts For the to the in ument, function should the 'Au in your functon should an to Wue in Lookup_VElue the of that will the of the u the E*l'in Present Value of Annuity' of Sl Bond Pricing Format as Cell Table Styles Styles 28,375 392,420.78 FILE Paste S Clipboard K16 2) so in the interest the VLOOKUP in Number n to the in argument. Cal:ulat the mount that will paid on March the interest would when deter-mining the selling Conditional Format Cell Formatting Table Styles 24.87747 429," 7 Cal : u I ate the selling of this using the IF the ward premium" Discount" cn in . 1 Present Value of Annuity of $1 Bond Pricing