Calculate the duration of the nfls liability

Assignment Help Finance Basics
Reference no: EM131030578

As part of a legal settlement related to a concussion lawsuit, the NFL has agreed to pay $900 million in damages to former players. The NFL will pay the total of $900 million in 65 equal annual payments, with the first payment to occur in exactly one year.

To insure its ability to make these future payments, the NFL will invest today in risk-free 30-year bonds that pay annual coupons. Assume the
pure yield curve is flat at 5%.

Using Excel and Goal Seek, answer the following questions.

1. How much money should the NFL invest in its bond portfolio today to fully fund its future liability?

2. Calculate the duration of the NFL's liability.

3. If the NFL wants its bond portfolio to be immunized against interest rate risk, what should be the coupon rate of the 30-year bonds it selects?

Please confine all work to a single spreadsheet.

Reference no: EM131030578

Questions Cloud

Determine the rate of heat transfer from the steam : Saturated steam coming off the turbine of a steam power plant at 30°C condenses on the outside of a 3-cmouter-diameter, 35-m-long tube at a rate of 45 kg/h. Determine the rate of heat transfer from the steam to the cooling water flowing through th..
What are the most important items to add to that policy : Organizations should have policies that describe which users have access to sensitive systems and data, for what purpose, and for how long. Assume that you are an IT manager in charge of creating yourorganization's new Acceptable Use Policy. What ..
Suggest a timeline for establishing an erm plan : Provide a list of essential personnel whom you believe should be involved in creating and maintaining an ERM plan for an organization. Describe the role of each person. Suggest a timeline for establishing an ERM plan, giving your opinion on how fr..
Compare to the output of the calculator to actual survives : Compare to the output of the calculator to actual survives that's been conducted on building that's used renewables energy in Ireland to ensure the quality of work.
Calculate the duration of the nfls liability : How much money should the NFL invest in its bond portfolio today to fully fund its future liability? Calculate the duration of the NFL's liability.
Describe the relationship between the two containers : A prune juice contanier is a rectangular prism that measure 12 inches by 3.5 inches by 4 inches. Describe the relationship between the two containers answer using l*w*h.
Discuss data networking standards and recalling names : Describe and discuss data networking standards, recalling names, and order of the seven layers of the OSI reference model and the TCP/IP protocol stack. Discuss the different protocols that make up the TCP/IP suite, including: IP, TCP, UDP, ARP, a..
What is relationship of water table to surface topography : In Figure 1, what is the relationship of the water table to surface topography? Considering the cost of drilling and operating a ground-water well, where would you site the least expensive well?
Determine the rate of heat transfer to the pan : Water is boiled at 1 atm pressure in a 25-cm-internaldiameter stainless steel pan on an electric range.

Reviews

Write a Review

Finance Basics Questions & Answers

  How much will your dream car cost by the time

You hope to buy your dream car four years from now. Today, that car costs $82,500. You expect the price to increase by an average of 4.8 percent per year over the next four years. How much will your dream car cost by the time you are ready to buy ..

  Ez toy inc lists fixed assets of 25 million on its balance

ez toy inc. lists fixed assets of 25 million on its balance sheet. the firms fixed assets were recently appraised at 32

  What will be the level of accounts receivable

If this policy is adopted, the company's average sales will fall by 25%. What will be the level of accounts receivable following the change? Assume a 365-day year. Round your answer to the nearest cent.

  Analyze how capital structure decision-making practices

Analyze how capital structure decision-making practices impact financial management.

  Calculate the needed additional money

Marie requires $26,000 as a down payment for a house four years from now. She earns 5.25 percent on her savings. Marie can either deposit one lump sum to day for this purpose or she can wait a year and deposit a lump sum.

  Which component has the most significance in the total

What are the components of WACC? Which component has the most significance in the total? Over which component does management have the greatest influence?

  The common stock of modern interiors has a beta of 161 and

the common stock of modern interiors has a beta of 1.61 and a standard deviation of 27.4 percent. the market rate of

  Explain why you would change your nominal required rate

Explain why you would change your nominal required rate of return if you expected the rate of inflation to go from 0 (no inflation) to 4 percent. Give example of what would happen if you did not change your required rate of return under these cond..

  Find the projects simple regular payback

The ABC Company is planning a project which has an up-front cost paid today at t = 0. The project will create positive cash flows of $70,000 a year at the end of each of the next 5 years.

  Advantages and disadvantages of financing with a portfolio

Compare two (2) methods that a company can use in order to finance international trade. Examine the advantages and disadvantages of financing with a portfolio of currencies

  Replace a computer system with a new model

TelCo must decide whether to replace a computer system with a new model. TelCo forecasts net before tax cost savings from the new computer over five years as given below (in $000). It has a 12 percent cost of capital, a 35 percent tax rate, and..

  If the required rate of return was 63 how much will you

the live forever life insurance company is attempting to sell you and your family a policy that will pay you 18600 a

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd