A 3 year bond with semiannual coupons of 13% has a yield of 18.92%. You are...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A 3 year bond with semiannual coupons of 13% has a yield of 18.92%. You are to use Excel's "SumProduct" function to compute the duration of this bond. Given two ranges of values, "SumProduct" computes their dot product. Create a table as shown, with entries appropriate to your bond, replacing the question marks with appropriate formulas. 1 2 23 A B с D E Face Coupon Yield 4 5 100 <your coupon> <your yield> 6 Time Cash Flow Present Value 7 Coupon 1 0.5 ? ? 00 Coupon 2 1 ? ? 9 10 11 12 Coupon 3 1.5 ? ? Coupon 4 2 ? ? Coupon 5 2.5 ? ? 13 14 Coupon 6 Redemption 3 ? ? 3 100 ? In a single cell, use the functions "SumProduct" and "Sum" to compute the duration of this bond using only the cells shown above. (a) What is the duration of this bond? (b) What formula using the functions SumProduct and Sum (and using 37 characters or less) calculates this Win duration? Go to Settings to A 3 year bond with semiannual coupons of 13% has a yield of 18.92%. You are to use Excel's "SumProduct" function to compute the duration of this bond. Given two ranges of values, "SumProduct" computes their dot product. Create a table as shown, with entries appropriate to your bond, replacing the question marks with appropriate formulas. 1 2 23 A B с D E Face Coupon Yield 4 5 100 <your coupon> <your yield> 6 Time Cash Flow Present Value 7 Coupon 1 0.5 ? ? 00 Coupon 2 1 ? ? 9 10 11 12 Coupon 3 1.5 ? ? Coupon 4 2 ? ? Coupon 5 2.5 ? ? 13 14 Coupon 6 Redemption 3 ? ? 3 100 ? In a single cell, use the functions "SumProduct" and "Sum" to compute the duration of this bond using only the cells shown above. (a) What is the duration of this bond? (b) What formula using the functions SumProduct and Sum (and using 37 characters or less) calculates this Win duration? Go to Settings to
Expert Answer:
Answer rating: 100% (QA)
Face Coupon Yield value 100 013 01892 R2 0065 00946 SUMPRODUCTBC12... View the full answer
Related Book For
Posted Date:
Students also viewed these programming questions
-
Silas is farsighted and wants to read the newspaper. Withoutglasses, Silass near point (the closest point he can see in focus)is far away, so he has to try to read the paper by holding his...
-
Let A, B be sets. Define: (a) the Cartesian product (A B) (b) the set of relations R between A and B (c) the identity relation A on the set A [3 marks] Suppose S, T are relations between A and B, and...
-
Suppose that a client performs an intermixed sequence of push and pop operations on a pushdown stack. The push operations insert the integers 0 through 9 in order onto the stack; the pop operations...
-
Suppose the shipping department of a firm charges 20% of its total monthly costs to the printing department and that the printing department charges 10% of its total monthly costs to the shipping...
-
Give an example of a relation schema R and a set of dependencies such that R is in BCNF, but is not in 4NF.
-
Explain how organizations should choose appropriate T&D methods.
-
Do you believe one party or the other in the proposed transaction would have an advantage if Pettit & Schayes is hired to perform the due diligence and advise both clients on the arrangement?
-
Jessica Lange owns her own high-end hair salon and employs several hair stylists. Customers usually pay using either a debit card or a credit card, but they sometimes write checks or pay with cash....
-
Think of a company that you are interested in exploring. Choose one of their securities (either their stock or a bond they issued). Go to one of the websites we visited in the lecture and check the...
-
Required: a. What is the percentage of capitalized costs at BMW and VW? b. BMW's net income in 2009 was 210 mil., while BMW's equity was 19,915 mil. How will BMW's net income, equity and ROE change...
-
Table 3.9 # 3-1 #3-2 # 3-3 3-8. Using Table 3.9, in which Anne Brown's annual salary is listed at the end of 2015 was $50,000 and John Williams' was $35,000. Under a merit pay system, calculate...
-
You have the decision to make. You will be flying to East Lansing. Michigan for a one-day stay. You will need to rent a midsize car while you are there, and you want to do this in the most economical...
-
1. y'= find all solutions. 3x+2x+1 y-2 3. 5. 6. xyy' = (y - 1)3/2 xy + y2 + y = 0 (3y + 3y cos y + 1)y + 13. 2. (sin x) (sin y) + (cos y) = 0 (2x + 1)y 1+x y In ly + xy = 0 In Exercises 7-10 find all...
-
The following information relates to Cooper Company: Costs Incurred: Raw materials purchased Direct labor Indirect labor Equipment maintenance Insurance on factory Rent on factory Equipment...
-
Find the probability of obtaining an even number in one roll of a die. (Round to one decimal place) Let A = even number P(A) =
-
Find a polar equation for the curve represented by the given Cartesian equation. 4y 2 = x
-
You and a prospective client are considering the measurement of investment performance, particularly with respect to international portfolios for the past 5 years. The data you discussed are...
-
Suppose that JPMorgan Chase sells call options on $1.25 million worth of a stock portfolio with beta = 1.5. The option delta is .8. It wishes to hedge out its resultant exposure to a market advance...
-
Farmer Brown grows Number 1 red corn and would like to hedge the value of the coming harvest. However, the futures contract is traded on the Number 2 yellow grade of corn. Suppose that yellow corn...
-
When a honeybee flies through the air, it develops a charge of +17 pC. How many electrons did it lose in the process of acquiring this charge?
-
Falling raindrops frequently develop electric charges. Does this create noticeable forces between the droplets? Suppose two 1.8 mg drops each have a charge of +25 pC; these are typical values. The...
-
A housefly walking across a surface may develop a significant electric charge through a process similar to frictional charging. Suppose a fly picks up a charge of +52 pC. How many electrons does it...
Study smarter with the SolutionInn App