Calculation on excel using this spreadsheet 2. You are given the following data on 8/24/2015 settlement date:
Fantastic news! We've Found the answer you've been seeking!
Question:
Calculation on excel using this spreadsheet
Transcribed Image Text:
2. You are given the following data on 8/24/2015 settlement date: Maturity 8/31/2017 Annual Coupon Rate Bid Price Asked Price 1.875 102.4922 102.5078 | 8/15/2025 6.875 144.6719 144.6875 and the following data on 8/28/2015 settlement date: Maturity Annual Coupon Rate Bid Price 102.1875 Asked Price 102.2031 8/31/2017 1.875 8/15/2025 6.875 142.4531 142.4688 a) On 8/24/2015, open a repo position using the 8/31/2017 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. b) On 8/24/2015, open a reverse repo position using the 8/15/2025 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. Use an annual repo rate of 1.0% and an annual reverse repo rate of 1.5%. Explain why you made a profit/loss in each of the above transactions. Also, make sure to account for accrued interest in your calculations and choose the bid or ask price appropriately. If you are using the Excel function for accrued interest, make up an Issue Date as the coupon payment date just prior to the settlement date. 2. You are given the following data on 8/24/2015 settlement date: Maturity 8/31/2017 Annual Coupon Rate Bid Price Asked Price 1.875 102.4922 102.5078 | 8/15/2025 6.875 144.6719 144.6875 and the following data on 8/28/2015 settlement date: Maturity Annual Coupon Rate Bid Price 102.1875 Asked Price 102.2031 8/31/2017 1.875 8/15/2025 6.875 142.4531 142.4688 a) On 8/24/2015, open a repo position using the 8/31/2017 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. b) On 8/24/2015, open a reverse repo position using the 8/15/2025 maturity bond and close the position on 8/28/2015. Compute the profit/loss on this transaction. Use an annual repo rate of 1.0% and an annual reverse repo rate of 1.5%. Explain why you made a profit/loss in each of the above transactions. Also, make sure to account for accrued interest in your calculations and choose the bid or ask price appropriately. If you are using the Excel function for accrued interest, make up an Issue Date as the coupon payment date just prior to the settlement date.
Expert Answer:
Related Book For
Accounting Texts and Cases
ISBN: 978-1259097126
13th edition
Authors: Robert Anthony, David Hawkins, Kenneth Merchant
Posted Date:
Students also viewed these finance questions
-
You are given the following data for a company: Cost of debt = 8%, cost of retained earnings = 12%, cost of new common equity = 14%, tax rate = 35% and retained earnings = $1000. The firms target...
-
You are given the following data: Based on these data, estimate the following regressions a. Yi =A1 + A2X2i+ ui b. Yi = C1 + C3X3i + ui c. Yi = B1 + B2X2i + B3X3i + ui d. Is A2 = B2? Why or why not?...
-
You are given the following information concerning four stocks: a) Using 20X0 as the base year, construct three aggregate measures of the market that simulate the Dow Jones Industrial Average, the...
-
Molly earns a gross yearly salary of $132,676. She has no dependent children and made the following tax deductible purchases: Charitable contributions: $5,401 Student loan interest: $1,429 When she...
-
If consumer protection legislation equates to good marketing practices, why do we have so much legislation? Would market forces not sort these issues out without state intervention?
-
When you shine light of band gap energy or higher on a semiconductor and promote electrons from the valence band to the conduction band, do you expect the conductivity of the semiconductor to (a)...
-
Papa and Mamae Ltd buys 667/3 per cent of the shares in Son and Daughter Ltd. You are to draw up the consolidated balance sheet from the following balance sheets constructed immediately control had...
-
On March 1 of the current year, the following accounts and their balances appear in the ledger of Mocha Corp., a coffee processor: Preferred 2% Stock, $25 par (300,000 shares authorized, 120,000...
-
Parkview Fish Tacos sells tacos for $5.40 each. The cost of each taco follows: Materials (food) Labor Variable overhead Fixed overhead ($7,200 per month, 4,500 tacos per month) Total costs per taco $...
-
Show that in the multiple regression of y on a constant, x1 and x2 while imposing the restriction 1 + 2 = 1 leads to the regression of y x1 on a constant and x2 x1.
-
Which of the following statements best describes the relationship between consumption spending and disposable income? The correlation between levels of income and levels of disposable income is high...
-
Which of the following situations would not support the auditor's decision to reduce control risk below maximum for the audit of intangible assets? a. The client employs a qualified specialist who...
-
Distinguish between qualitative and quantitative forecasting techniques. What are the advantages and disadvantages associated with each approach?
-
How could a manager use QuickZoom to access underlying information as reported in an income statement?
-
List the steps you would take to create a balance sheet for a date other than the current system date.
-
What is the place of sales forecasting in the company planning process?
-
FederalWay, Inc., es una importante cadena de grandes almacenes.La parte dominante del negocio de la empresa consiste enproporcionar mercancas y servicios a los consumidores a travs detiendas d 1...
-
Suppose a population of bacteria doubles every hour, but that 1.0 x 106 individuals are removed before reproduction to be converted into valuable biological by-products. Suppose the population begins...
-
Burtis Company produces a number of products. In 20x2 the selling price of product A, whose sales are normally 10,000 units per year, was calculated as follows: In 20x3 the company estimates that...
-
On April 1, 2008, the Texidor Company issued bonds with a face value of $250,000 for $260,000 cash. These bonds paid an annual interest of 8 percent. The interest was paid semiannually on April 1 and...
-
Import Distributors, Inc. (IDI), imported appliances and distributed them to retail appliance stores in the Rocky Mountain states. IDI carried three broad lines of merchandise: audio equipment...
-
You have agreed to text your friend every 3 hours while driving across the country. You began your trip at 8 AM. What time will it be when you text your friend the 15 th time?
-
If it is \(7: 00\) now, what time was it 34 hours ago?
-
What is the product of 4 and 19 modulo 12 ?
Study smarter with the SolutionInn App