The Chestnut Street Company plans to issue a bond semiannually on March $31$st and September $30$th$.$ The Controller has asked you to calculate information about the bond assuming two different market interest rates. The present value factor tables are included in the first four tabs of the Integrated Excel. Use the information included and the Excel functions described below to complete the task.

Information relating to this bond is found below:

Face Value: $ $825,000$

Number of Years: $10$

Stated Interest Rate: $7\%$

Number of Payments per Year: $2$

Here are some tips for using Excel: