Using Data Analytics to Analyze Data DA13.1 Data analytics can be used to understand present values. Problem GlobalPie plans to issue 10 year, semi annual bonds. They want to know what the proceeds will be under various scenarios. Set up a chart that uses a formula to state whether the bond is at par, at a discount, or at a premium. Show the proceeds, the interest rates, and the payments under the three scenarios. a. Formula for issue Instructions: There are four parts to this problem. Use Excel to perform the following: a. Use a formula to calculate whether the bond is issued at a discount, at par, or at a premium. b. Use formulas to calculate the payment rate, market rate, n, PMT, FV, and PV given the information above for each of the three scenarios. Label with the outcomes in part a. c. Graph the PMT, FV, PV, Bond interest rate, Market Rate for the three scenarios. b. Response to part b d. Discuss what you see in the graph in part c. Bond Interest Rate Market Rate PMT FV c. Chart for part c GlobalPie plans to issue 10 year, semi annual bonds. They want to know what the proceeds will be under various scenarios. Set up a chart that uses a formula to state whether the bond is at par, at a discount, or at a premium. Show the proceeds, the interest rates, and the payments under the three scenarios. Instructions: There are four parts to this problem. Use Excel to perform the following: a. Use a formula to calculate whether the bond is issued at a discount, at par, or at a premium. b. Use formulas to calculate the payment rate, market rate, n, PMT, FV, and PV given the information above for each of the three scenarios. Label with the outcomes in part a. c. Graph the PMT, FV, PV, Bond interest rate, Market Rate for the three scenarios. d. Discuss what you see in the graph in part c. Using Data Analytics to Analyze Data DA13.1 Data analytics can be used to understand present values. Problem GlobalPie plans to issue 10 year, semi annual bonds. They want to know what the proceeds will be under various scenarios. Set up a chart that uses a formula to state whether the bond is at par, at a discount, or at a premium. Show the proceeds, the interest rates, and the payments under the three scenarios. a. Formula for issue Instructions: There are four parts to this problem. Use Excel to perform the following: a. Use a formula to calculate whether the bond is issued at a discount, at par, or at a premium. b. Use formulas to calculate the payment rate, market rate, n, PMT, FV, and PV given the information above for each of the three scenarios. Label with the outcomes in part a. c. Graph the PMT, FV, PV, Bond interest rate, Market Rate for the three scenarios. b. Response to part b d. Discuss what you see in the graph in part c. Bond Interest Rate Market Rate PMT FV c. Chart for part c GlobalPie plans to issue 10 year, semi annual bonds. They want to know what the proceeds will be under various scenarios. Set up a chart that uses a formula to state whether the bond is at par, at a discount, or at a premium. Show the proceeds, the interest rates, and the payments under the three scenarios. Instructions: There are four parts to this problem. Use Excel to perform the following: a. Use a formula to calculate whether the bond is issued at a discount, at par, or at a premium. b. Use formulas to calculate the payment rate, market rate, n, PMT, FV, and PV given the information above for each of the three scenarios. Label with the outcomes in part a. c. Graph the PMT, FV, PV, Bond interest rate, Market Rate for the three scenarios. d. Discuss what you see in the graph in part c