Using Data Analytics to Analyze Data DA13.1 Data analytics can be used to understand present values....
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. Market Rate Bond term years Interest paid times per year Bond interest rate Face Value Instructions: Scenario 1 Scenario 2 Scenario 3 10% 10 2 10% 12% 8% $ 800,000 Student Work Area a. Formula for issue Scenario 1 Scenario 2 Scenario 3 The bond is issued at 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. b. Response to part b Bond Interest Rate Market Rate In PMT FV PV c. Chart for 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. Market Rate Bond term years Interest paid times per year Bond interest rate Face Value Instructions: Scenario 1 Scenario 2 Scenario 3 10% 10 2 10% 12% 8% $ 800,000 Student Work Area a. Formula for issue Scenario 1 Scenario 2 Scenario 3 The bond is issued at 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. b. Response to part b Bond Interest Rate Market Rate In PMT FV PV c. Chart for part c
Expert Answer:
Posted Date:
Students also viewed these finance questions
-
Write Python program which implements the following two classical cryptosystem a) Affine Cipher b) Vigenere Cipher Your program should consist of at least five functions: a) Two functions named...
-
A crate of books is to be put on a truck with the help of some planks sloping up at 30. The mass of the crate is 100 kg, and the coefficient of sliding friction between it and the planks is 0.5. You...
-
Helen Corp. manufactures Products W, X, Y, and Z from a joint process. Additional information is as follows: {Required:} Assuming that total joint costs of \(\$ 160,000\) were allocated using...
-
What is Digital Systems direct labor price variance for January? a. $37.50 U b. $105.00 U c. $112.50 U d. $120.00 U Digital Systems has budgeted three hours of direct labor per connector at a...
-
For your design of a data entry system for Elsinore, take into consideration all the objectives for data entry discussed throughout this chapter. Draw any displays necessary to illustrate your...
-
Question 7 of 8 - 1 9 Current Attempt in Progress Assume that Marigold Inc. decided to sell DemandTV Ltd . , a subsidiary, on September 3 0 , 2 0 2 3 . There is a formal plan to dispose of the...
-
Past flooding along the Arkansas River (referred to as river in the following) has caused the Army Corps of Engineers (referred to as Corps in the following) to evaluate some of the drainage plans...
-
Kapangan Manufacturing Company uses a job-order costing system and started the month of October with a zero balance in its finished goods inventory accounts. Job A15 was unfinished at the end of...
-
P g Solve the equation for d d+b d d = Enter your answer as an expression.
-
Differentiate y = sec (1+x)
-
Nicholas Jay, Kamla Paul, and Stephanie Ram plan to liquidate their partnership. They have always shared losses and gains in a 1:4:5 ratio, and on the day of the liquidation their balance sheet...
-
Starting website for case info: https://www.oyez.org/cases/1964/496 In 1879, Connecticut passed a law that banned the use of any drug, medical device, or other instrument in furthering contraception....
-
How are your grades? In a recent semester at a local university,300 students enrolled in both StatisticsI and PsychologyI. Of these students, 87got an A in statistics,64 got an A in psychology, and50...
-
What are conversion costs? What are prime costs?
-
Comprehensive Problem: Reviewing the Accounting Cycle} Fodor Freight Service provides delivery of merchandise to retail grocery stores in northern Manitoba. At the beginning of 2018 , the following...
-
Cash-Basis and Accrual-Basis Income} Martin Sharp, who repairs lawn mowers, collects cash from his customers when the repair services are completed. He maintains an inventory of repair parts that are...
-
Preparation of Adjusting Entries} Osaga Beach Resort operates a resort complex that specializes in hosting small business and professional meetings. Osaga Beach closes its fiscal year on January 31,...
Study smarter with the SolutionInn App