AAlignmentNumberConditionalFormat asCellFormatting $*$ Table $*$ Styles $*$CellsEditingClipboardFontStylesC$17$f$\_($x$)=$ C$3**$ 'Present Value of $$1^(\text{'})!$ P$26$

$\backslash$table$[[,$A$,$B$,$C$,\backslash$table$[[$D$],[$E$]],$F$],[16,,$Annual Interest Payment:,$ $35,000\mathrm{.}00,,],[\backslash$table$[[17],[18]],,$PV of Face Value:,$ $37,685\mathrm{.}57,,],[,,$PV of Interest Payments:,,,$],[19,,=$ Bond Selling Price:,,,$],[\backslash$table$[[20],[21]],,,,,],[,$b$)$ Market Interest Rate:,,$5\mathrm{.}5\%,,],[22,,,,,],[23,,$Annual Interest Payment:,$ $35,000\mathrm{.}00,,],[24,,$PV of Face Value:,,,$],[25,,$PV of Interest Payments:,,,$],[26,=,$Bond Selling Price:,,,$],[27,,,,,],[28,2.$ Use the Excel IF function to answer either "Premium" or "Discount" to the following items.,,,,$],[29,,,,,],[30,,$The bond in $($a$)$ sold at a:$,,,],[31,,,,,],[32,,$The bond in $($b$)$ sold at a:$,,,],[33,,,,,],[34,,,,,],[35,,,,,],[36,,,,,]]$

$...$ ty of $$1$

Present Value of Annuity of $$1$

Sheet$1$

READY

$100\%$

Attempt$($s$)$

$\frac{0}{3}$

Show Me