A $5000 Bond That Pays 6% Semi-Annually Is Redeemable at Par

question 1

Essay

A $5000 bond that pays 6% semi-annually is redeemable at par in 14 years. Calculate the purchase price if it is sold to yield 8% compounded semi-annually.

---

Definitions:

Conditional Formatting Rules Manager

A tool in applications like Excel that allows users to set rules for automatically formatting cells based on the cell's value.

ROUNDUP

In spreadsheet applications, ROUNDUP is a function that rounds a number away from zero, up to a specified number of digits.

AND

A logical operator used in programming and mathematics that results in true only if all the operands are true.

Serial Number

A unique identifier assigned to individual items, often used for tracking and inventory purposes.