Calculate the price of a bond using tables. Show step by step cell workout.

1. Calculate the price of a bond using tables Bond Pricing- Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIE Sign In Paste B 1 u.: ?.. Algnrmert Number. Conditional Format as. Cell Cells Editing Formatting Table Styles Styles Font Xf On January 1, Ruiz Company issued bonds as follows: 1 IOn Januaty 1, Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year 500,000 15 796 9 Required: 10 1) Calculate the bond selling price given the two market interest rates below. 11 Use formulas that reference data from this worksheet and from the appropriate future or