EXCEL FORMULAS FOR BONDS! PLEASE HELP!

previous attempt C18 A D 1 On January 1, Ruiz Company issued bonds as follows: 3 Face Value: Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest annually.) 24 500,000 30 7% 6. 8. 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 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required. 1 of 2 Next > Prev G17 A 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 futu 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required. 14 a) 15 16 Market Interest Rate: 9% Annual Interest Payment: PV of Face Value: + PV of Interest Payments: 2$ 35,000.00 37,685.57 2$ 17 =pv(c14/1,c14*c6,c16,0) 18 2$ 397.263.46 19 =Bond Selling Price: 20 21 b) 22 5.5% Market Interest Rate: Next > 1 of 2 Prev ... G17 Annual Interest Payment: PV of Face Value: + PV of Interest Payments: = Bond Selling Price: $ 35,000.00 =pv(c16,(c4*c5),0,43) =pv(c15.04*c,c23,0,0) $ 609,003.09 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the follo The bond in (a) sold at a: discount The bond in (b) sold at a: premium Prev 1 of 2 !!! Next > Ruiz Company issued bonds on January 1 and has provided the relevant information. The the bond selling price given two different market interest rates using the Present Value Ta the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From blank cell, "=C3" was entered, the formula would output the result from cell C3, or $5 Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate multi-tab cell reference, type the equal sign first, then click on the other tab and then reference. The syntax of a multi-tab cell reference looks different than a normal cell re name surrounded by apostrophes and also an exclamation point before the cell locatie if in a blank cell on the Sheet1 tab "='Future Value of $1'!C13" was entered, the formula in the Future Value of $1 tab, or 1.10462 in this example. Basic Math functions: Allows you to use the basic math symbols to perform mathemat following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply. From the Excel Simulation below, if in a blank cell "=C4+C6" was entered, the formula w cells and output the result, or 31 in this example. If using the other math symbols the res Prev 1 of 2 Next > DEC 13AVOL previous attempt C18 A D 1 On January 1, Ruiz Company issued bonds as follows: 3 Face Value: Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest annually.) 24 500,000 30 7% 6. 8. 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 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required. 1 of 2 Next > Prev G17 A 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 futu 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required. 14 a) 15 16 Market Interest Rate: 9% Annual Interest Payment: PV of Face Value: + PV of Interest Payments: 2$ 35,000.00 37,685.57 2$ 17 =pv(c14/1,c14*c6,c16,0) 18 2$ 397.263.46 19 =Bond Selling Price: 20 21 b) 22 5.5% Market Interest Rate: Next > 1 of 2 Prev ... G17 Annual Interest Payment: PV of Face Value: + PV of Interest Payments: = Bond Selling Price: $ 35,000.00 =pv(c16,(c4*c5),0,43) =pv(c15.04*c,c23,0,0) $ 609,003.09 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the follo The bond in (a) sold at a: discount The bond in (b) sold at a: premium Prev 1 of 2 !!! Next > Ruiz Company issued bonds on January 1 and has provided the relevant information. The the bond selling price given two different market interest rates using the Present Value Ta the Excel Simulation and the Excel functions described below to complete the task. Cell Reference: Allows you to refer to data from another cell in the worksheet. From blank cell, "=C3" was entered, the formula would output the result from cell C3, or $5 Multi-Tab Cell Reference: Allows you to refer to data from another cell in a separate multi-tab cell reference, type the equal sign first, then click on the other tab and then reference. The syntax of a multi-tab cell reference looks different than a normal cell re name surrounded by apostrophes and also an exclamation point before the cell locatie if in a blank cell on the Sheet1 tab "='Future Value of $1'!C13" was entered, the formula in the Future Value of $1 tab, or 1.10462 in this example. Basic Math functions: Allows you to use the basic math symbols to perform mathemat following keys: + (plus sign to add), - (minus sign to subtract), (asterisk sign to multiply. From the Excel Simulation below, if in a blank cell "=C4+C6" was entered, the formula w cells and output the result, or 31 in this example. If using the other math symbols the res Prev 1 of 2 Next > DEC 13AVOL