Finish the yellow blank. Tell me how to get the answer for each question.

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 below, Use the information incuded in the Excel Simulation and the Excel functions descrbed be ow to complete the task. e e ere cei Allows you to re er o data from another cell in the works eet From he Excel Sim ulation below ifin a blank cell = 6 was entered the ormula would output the result from ce C6 or 10 is example. Basic Math tunctions: Alows you to use the basic math symbols to pertorm mathematical functions, You can use the to lowing keys: (plus sign to add (minus sgn to subtract), astenisk sign to multiply'i, and (forward slash to divide). From he Excel Simulation below if In a blank cell =C0+C8 was entered. tne formula would add the values from those cells and outout he result, or 12 in this example using the other math symbols the result would output an aopropriate answer for its function. tunc on Allows ou o es condition and re um a specr c value is the result is rue and different value if he result is a se. The syntax o he F unc on Is F es cond on, vak e tue at e if a se and specifc considerations need to be made when using this runcion. The test co ron argument is an eva aticof the status of a cell such as it tre value of a cell s greater than, less than or equal to another number or oel The va e e and vale_if faise arguments will return any specific result for each option, such as another cell reference, a value, or text. Throughout the entire equaton, if text is being used in the test conaition, value_i_true, or value_if false arguments then the text itsef shculd be enterod in quotations so that Excel will reccgnize the text as a string of text" instead of another function. From the Excel Simulation below, if in a blank cell-IF(Ce>2,'Long Term Bond",Short Tem Bond was entered, the formula would output the result of the value_if trve since the test conaition would be result as true, or in this case the text Long-Term Bond. Excel processes the IF function by separating it out into separate parts. First the fest condion-Excel thinks, nd cef C8 and defermine if the value is grealer than 2. Once Excel determines if the rcsult of that test condition is TRUE or FALSE, it will return the vave if true or vaiue ifalse. . PV Function: Allows you to perform the mathematical present ale calculation of a value. The syntax of the PV function is PVirate,nper.pmt.ffv).ftype, and results in the total amount that a series of future payments is worth now also nown as he present alue. The ate argument is the interest rate per period. The nper argument is the total number or payment periods Th pr i argument is the payment ma de each period hat es not change over the ifo of the nvestment and this argument must be included if the v)argument is not included. The [w)argument is the future value, or the cash basis to attain after the last payment is made and this argument must be included if the pmt argument is omitted. The type argument s a logical value oro or 1 which cates w en the payments ar de wher* 1 s the payment at the ginning or he period and 0 is the payment at the end or the period. Bot the and e values are optional arguments to have the formula work, which is why they are surrounded by brackets in the syntax, however, these values would not be entered with brackets in the actual function. For the purposes of this Excel Simulation,please 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 below, Use the information incuded in the Excel Simulation and the Excel functions descrbed be ow to complete the task. e e ere cei Allows you to re er o data from another cell in the works eet From he Excel Sim ulation below ifin a blank cell = 6 was entered the ormula would output the result from ce C6 or 10 is example. Basic Math tunctions: Alows you to use the basic math symbols to pertorm mathematical functions, You can use the to lowing keys: (plus sign to add (minus sgn to subtract), astenisk sign to multiply'i, and (forward slash to divide). From he Excel Simulation below if In a blank cell =C0+C8 was entered. tne formula would add the values from those cells and outout he result, or 12 in this example using the other math symbols the result would output an aopropriate answer for its function. tunc on Allows ou o es condition and re um a specr c value is the result is rue and different value if he result is a se. The syntax o he F unc on Is F es cond on, vak e tue at e if a se and specifc considerations need to be made when using this runcion. The test co ron argument is an eva aticof the status of a cell such as it tre value of a cell s greater than, less than or equal to another number or oel The va e e and vale_if faise arguments will return any specific result for each option, such as another cell reference, a value, or text. Throughout the entire equaton, if text is being used in the test conaition, value_i_true, or value_if false arguments then the text itsef shculd be enterod in quotations so that Excel will reccgnize the text as a string of text" instead of another function. From the Excel Simulation below, if in a blank cell-IF(Ce>2,'Long Term Bond",Short Tem Bond was entered, the formula would output the result of the value_if trve since the test conaition would be result as true, or in this case the text Long-Term Bond. Excel processes the IF function by separating it out into separate parts. First the fest condion-Excel thinks, nd cef C8 and defermine if the value is grealer than 2. Once Excel determines if the rcsult of that test condition is TRUE or FALSE, it will return the vave if true or vaiue ifalse. . PV Function: Allows you to perform the mathematical present ale calculation of a value. The syntax of the PV function is PVirate,nper.pmt.ffv).ftype, and results in the total amount that a series of future payments is worth now also nown as he present alue. The ate argument is the interest rate per period. The nper argument is the total number or payment periods Th pr i argument is the payment ma de each period hat es not change over the ifo of the nvestment and this argument must be included if the v)argument is not included. The [w)argument is the future value, or the cash basis to attain after the last payment is made and this argument must be included if the pmt argument is omitted. The type argument s a logical value oro or 1 which cates w en the payments ar de wher* 1 s the payment at the ginning or he period and 0 is the payment at the end or the period. Bot the and e values are optional arguments to have the formula work, which is why they are surrounded by brackets in the syntax, however, these values would not be entered with brackets in the actual function. For the purposes of this Excel Simulation,please