Please help with the correct cell formula. This is my fourth request :( I am having a hard time getting the function...
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 On January 1, Ruiz Company issued bond On January 1, Ruiz Company issued bonds as follows: Face Value: Number of Years: Stated Interest Rate: Interest payments per year (Note: the bonds pay interest annually.) 2$ 500,000 30 7% 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 fu 12 present value tables (found by clicking the tabs at the bottom of this worksheet). 13 Note: Rounding is not required. 14 a) Market Interest Rate: 9% DEC P. .. 00 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. 14 a) Market Interest Rate: 9% 15 Annual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: 16 35,000.00 =pv(c6/c5,c3*c5 X =PV(c6,(c3*c5), 17 18 19 397,263.46 20 21 b) Market Interest Rate: 5.5% 22 Annual Interest Payment: IDV of Faca Value 23 35,000.00 24 Sheet1 y of $1 Present Value of Annuity of $1 READY Step 1 Of 1 Cells highlighted in red have been filled automatically as they are partially attempted, left blar attempts exhausted). Cells highlighted in green are the correct responses. and what was marked correct and incorrect from 19 Bond Selling Price: V$ 397,263.46 20 21 b) Market Interest Rate: 5.5% 22 23 Annual Interest Payment: PV of Face Value: +PV of Interest Payments: =Bond Selling Price: 35,000.00 =pv(c14/c4,c6,c3 X =pv(c14/1,c4*c6 V$ 609,003.09 24 25 26 27 28 2. Use the Excel IF function to answer either "Premium" or "Discount" to the following items. 29 30 discount The bond in (a) sold at a: 31 premium 32 The bond in (b) sold at a: 33 34 25 Sheet1 y of $1 Present Value of Annuity of $1 READY Step 1 Of 1 Cells highlighted in red have been filled automatically as they are partially attempted, left blank, incc attempts exhausted). Cells highlighted in green are the correct responses
