3 Assignment: 4 Develop a Bond Pricing Model for three different options: Base Case, Scenario 1...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
3 Assignment: 4 Develop a Bond Pricing Model for three different options: Base Case, Scenario 1 and Scenario 2 5 The base case has the key input areas highlighted: A yellow highlight indicates a numeric input, a light blue is a formula input 6 The green cells contain formulas, no need to do anything with these cells 7 8 9 Base Case 10 $5,000 Bond (Par value), 6% Coupon Interest Rate, 10 yrs 11 Year 1 12 Term (years) 13 Current Bond Market Yield 14 Bond Coupon Rate 15 Bond Face Value 16 Bond Payment (coupon) 17 Final Payment 18 PV of Coupons 19 Sum of Coupon PV 20 PV of Final Payment 21 PV (Price) of Bond 22 PV Year 2 Year Year Year 3 4 5 Year 6 Year Year 7 8 PV of Final Payment Year 9 Year 10 25 Scenario 1 The Bond Market yield is 8% 26 The bond market yield is +2% over the bond 27 Term (years) 28 Current Bond Market Yield 29 Bond Coupon Rate 30 Bond Face Value 31 Bond Payment (coupon) 32 Final Payment 33 PV of Coupons 34 PV of Final Payment 35 PV (Price) of Bond 36 37 Scenario 2 The Bond Market yield is 4% 38 The bond market yield is -2% over the bond c 39 Term (years) 40 Current Bond Market Yield 41 Bond Coupon Rate 42 Bond Face Value 43 Bond Payment (coupon) 44 Final Payment 45 PV of Coupons 46 PV of Final Payment 47 PV (Price) of Bond Year 1 Year 1 Year 2 Year 2 Year Year Year Year Year Year 3 4 5 6 7 8 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 9 Year 10 Year 10 Base Case Term (years) current bond market yield Bond Face Value Bond Payment (coupon) Final Payment PV of Coupons Sum of Coupon PV PV of Final Payment PV (Price) of Bond 3 2.00% $ 10,000 $ 500 PV $ $ LA LA LA LA $ $ $ Year 1 Year 2 500 $ 500 $ 500 $ 10,000 490.20 $480.58 $ 471.16 1,441.94 9,423.22 10,865.16 Year 3 $9,423.22 3 Assignment: 4 Develop a Bond Pricing Model for three different options: Base Case, Scenario 1 and Scenario 2 5 The base case has the key input areas highlighted: A yellow highlight indicates a numeric input, a light blue is a formula input 6 The green cells contain formulas, no need to do anything with these cells 7 8 9 Base Case 10 $5,000 Bond (Par value), 6% Coupon Interest Rate, 10 yrs 11 Year 1 12 Term (years) 13 Current Bond Market Yield 14 Bond Coupon Rate 15 Bond Face Value 16 Bond Payment (coupon) 17 Final Payment 18 PV of Coupons 19 Sum of Coupon PV 20 PV of Final Payment 21 PV (Price) of Bond 22 PV Year 2 Year Year Year 3 4 5 Year 6 Year Year 7 8 PV of Final Payment Year 9 Year 10 25 Scenario 1 The Bond Market yield is 8% 26 The bond market yield is +2% over the bond 27 Term (years) 28 Current Bond Market Yield 29 Bond Coupon Rate 30 Bond Face Value 31 Bond Payment (coupon) 32 Final Payment 33 PV of Coupons 34 PV of Final Payment 35 PV (Price) of Bond 36 37 Scenario 2 The Bond Market yield is 4% 38 The bond market yield is -2% over the bond c 39 Term (years) 40 Current Bond Market Yield 41 Bond Coupon Rate 42 Bond Face Value 43 Bond Payment (coupon) 44 Final Payment 45 PV of Coupons 46 PV of Final Payment 47 PV (Price) of Bond Year 1 Year 1 Year 2 Year 2 Year Year Year Year Year Year 3 4 5 6 7 8 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 9 Year 10 Year 10 Base Case Term (years) current bond market yield Bond Face Value Bond Payment (coupon) Final Payment PV of Coupons Sum of Coupon PV PV of Final Payment PV (Price) of Bond 3 2.00% $ 10,000 $ 500 PV $ $ LA LA LA LA $ $ $ Year 1 Year 2 500 $ 500 $ 500 $ 10,000 490.20 $480.58 $ 471.16 1,441.94 9,423.22 10,865.16 Year 3 $9,423.22
Expert Answer:
Related Book For
Data Structures and Algorithm Analysis in Java
ISBN: 978-0132576277
3rd edition
Authors: Mark A. Weiss
Posted Date:
Students also viewed these finance questions
-
For each of the following six program fragments: a. Give an analysis of the running time (Big-Oh will do). b. Implement the code in Java, and give the running time for several values of N. c. Compare...
-
How many divisions are required to find gcd(34, 55) using the Euclidean algorithm?
-
Drive the following relationship involving elastic constants of an isotropic material: V = 2(22+GG) = EE 2GG -1 3KK-2GG 2(3KK+GG) = 3KK-EE 6KK KK = ^^+ 2 3GG = 2GG(1+vv) 3(1-2vv) = EE 3(1-2vv)
-
. Suppose that the city of New York issues bonds to raise money to pay for a new tunnel linking New Jersey and Manhattan. An investor named Susan buys one of the bonds on the same day that the city...
-
Multiple Choice Questions 1. Eddie, a single taxpayer, has W-2 income of $49,487. Using the tax tables, he has determined that his tax liability is: a. $8,225. b. $6,514. c. $5,688. d. $4,991. 2....
-
When 2-methylcyclohexanone is converted into an enamine, only one product is formed despite the fact that the starting ketone is unsymmetrical. Build molecular models of the two possible products,...
-
Jerome M. Eisenberg is an antiquities dealer and a self-proclaimed expert in classical antiquities with a doctorate in Roman, Egyptian, and Near Eastern art. Maurice E. Hall Jr. is an art dealer who...
-
William Corporations income statement for the year ended December 31, 2014, and its comparative balance sheets as of December 31, 2014 and 2013, follow. During 2014, William engaged in these...
-
John just sold the home where he's lived for eight years and made a nice profit. Which of these statements about the profit he made is FALSE? Unset starred question He can include depreciation costs...
-
At the beginning of Year 2, the Redd Company had the following balances in its accounts: Cash ..................................................................$16,900 Inventory...
-
Write a function that checks if a given string is a valid palindrome. A palindrome is a word, phrase, number, or other sequences of characters that reads the same forward and backward (ignoring...
-
The following T-account (in billions of dollars) depicts an intervention by the Federal Reserve in the foreign exchange market: a) Did the Federal Reserve buy or sell U.S. dollars? b) What is the...
-
For each of the following cases, determine which would be the preferred macroeconomic model to analyze business fluctuations. a) Most wages are the result of collective bargaining and are therefore...
-
Oil leaks from offshore drilling platforms in the Gulf of Mexico have resulted in stricter regulations on this type of oil extraction. a) Discuss the effects of such regulations on the user cost of...
-
In Keyness liquidity preference theory, what variables determine the demand for real money balances? How does the demand for real money balances respond to changes in each of these variables?
-
Suppose a country is rapidly making the transition from an agricultural-based economy to an economy in which most of GDP comes from manufacturing. a) How do you think structural unemployment will be...
-
What are the risks involved with the letter of credit? Question 7 options: 1) The exporter might not ship the goods as mentioned 2) It is a costlier method of payment than open account or documentary...
-
5. Convert the following ERD to a relational model. SEATING RTABLE Seating ID Nbr of Guests Start TimeDate End TimeDate RTable Nbr RTable Nbr of Seats RTable Rating Uses EMPLOYEE Employee ID Emp...
-
The input is a list of league game scores (and there are no ties). If all teams have at least one win and a loss, we can generally prove, by a silly transitivity argument, that any team is better...
-
Find two functions f (N) and g(N) such that neither f (N) = O(g(N)) nor g(N) = O(f (N)).
-
Show that if the items are sorted, then a treap can be constructed in linear time, even if the priorities are not sorted.
-
Record the following details relating to a carpet retailer for the month of November 2017 and extract a trial balance as at 30 November 2017. 2017 Nov 1 Started in business with 15,000 in the bank. 3...
-
You are to enter up the necessary accounts for the month of October from the following information relating to a small printing firm. Then balance-off the accounts and extract a trial balance as at...
-
What would have been the balance on the account of C. De Freitas in MC17 on 19 May 2017? (A) A debit balance of 265 (B) A credit balance of 95 (C) A credit balance of 445 (D) A credit balance of 265
Study smarter with the SolutionInn App