On January 1, Ruiz Company issued bonds as follows: Face Amount $500,000 15 Number of Years:...

Transcribed Image Text:

On January 1, Ruiz Company issued bonds as follows: Face Amount $500,000 15 Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest semi-annually.) Required: 1) Given the differnet market ineterest rates below, calculate the following items. Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all function arguments as cell references. a) Market Interest Rate: Semi-annual interest payment: 8% 2 9% $20,000 $459,277.78 Bond Selling Price: b) Market Interest Rate: Semi-annual interest payment: 6.0% $20,000 $598,002.21 Bond Selling Price: 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: The bond in (b) sold at a: Discount Premium On January 1, Ruiz Company issued bonds as follows: Face Amount $500,000 15 Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest semi-annually.) Required: 1) Given the differnet market ineterest rates below, calculate the following items. Calculate the bond selling price USING THE EXCEL PV FUNCTION (fx). Note: Enter all function arguments as cell references. a) Market Interest Rate: Semi-annual interest payment: 8% 2 9% $20,000 $459,277.78 Bond Selling Price: b) Market Interest Rate: Semi-annual interest payment: 6.0% $20,000 $598,002.21 Bond Selling Price: 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. The bond in (a) sold at a: The bond in (b) sold at a: Discount Premium

Answer rating: 100% (QA)

rie f bnd V f ll interest yments V f fe vlue f bnd If ... View the full answer