The Chestnut Street Company plans to issue a bond semiannually on March 31st and September 30th. The Controller has asked you to calculate information about the bond assuming two different market interest rates in the Excel Simulation belowPlease fill the yellow blank only, and give me the equation about how to get the answer.

1 The Chestnut Street Company plans to issue $825,000, 10-year bonds that pay 7 percent 2 semiannually on March 31st and September 30th 4 Information relating to this bond is found below: Face Value: Number of Years: Stated Interest Rate: 825,000 10 7% 7 Number of Payments per Year