This liability is due in 6 years (the basement date is 31st December 2022). Calculate the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
This liability is due in 6 years (the basement date is 31st December 2022). Calculate the Macaulay duration of the portfolio based on the weights assigned from the excel file. Does the portfolio match the liability? If not, how to change the portfolio weight to match this liability? Present and discuss the findings. - What would you do if you would like to rebalance the portfolio by using other bonds? Discuss the immunisation method using the bond list provided in the excel file. - Comment on the pros and cons of using this method and use relevant literature to support the answer. - Based on the literature, compare and contrast the cash flow matching and duration matching methods (Hint: You may read the textbook about the cash flow matching immunisation). E. Answer the following questions to analyse the credit quality of the portfolio: (12 marks) - Use traditional ratio analysis (i.e., interest coverage, leverage, cash flow, net assets, and working capital) to evaluate the bonds' financial risk. - Evaluate the bonds' overall credit quality. - Any other ratios that should be considered when evaluating the bond credit rating? - Comment on the portfolio credit quality based on those bonds. Discuss the pros and cons of using ratio analysis. Use relevant literature to support the answer. This liability is due in 6 years (the basement date is 31st December 2022). Calculate the Macaulay duration of the portfolio based on the weights assigned from the excel file. Does the portfolio match the liability? If not, how to change the portfolio weight to match this liability? Present and discuss the findings. - What would you do if you would like to rebalance the portfolio by using other bonds? Discuss the immunisation method using the bond list provided in the excel file. - Comment on the pros and cons of using this method and use relevant literature to support the answer. - Based on the literature, compare and contrast the cash flow matching and duration matching methods (Hint: You may read the textbook about the cash flow matching immunisation). E. Answer the following questions to analyse the credit quality of the portfolio: (12 marks) - Use traditional ratio analysis (i.e., interest coverage, leverage, cash flow, net assets, and working capital) to evaluate the bonds' financial risk. - Evaluate the bonds' overall credit quality. - Any other ratios that should be considered when evaluating the bond credit rating? - Comment on the portfolio credit quality based on those bonds. Discuss the pros and cons of using ratio analysis. Use relevant literature to support the answer.
Expert Answer:
Answer rating: 100% (QA)
To calculate the Macaulay duration of the portfolio we need the weights assigned from the provided Excel file ... View the full answer
Related Book For
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill
Posted Date:
Students also viewed these finance questions
-
Eco Paper Ltd operates two paper mills in Pollution, a small town located within the United Kingdom (UK). During the last two years the business has lost a number of important customers to overseas...
-
List three specific parts of the Case Guide, Objectives and Strategy Section (See below) that you had the most difficulty understanding. Describe your current understanding of these parts. Provide...
-
Managing Scope Changes Case Study Scope changes on a project can occur regardless of how well the project is planned or executed. Scope changes can be the result of something that was omitted during...
-
Using real employed samples, multiple field studies indicate that fat women experience more negative outcomes than fat men. In one study conducted by Steven Gortmaker and colleagues and using over...
-
Consider some of the precautions that must be taken when conducting single-molecule spectroscopy experiments. (a) What is the molar concentration of a solution in which there is, on average, one...
-
Boarders sells a snowboard, Xpert, that is popular with snowboard enthusiasts. Below is information relating to Boarderss purchases of Xpert snowboards during September. During the same month, 121...
-
The trial balance of Kind Care Child Care, Inc., does not balance. The following errors are detected: a. Cash is understated by \($2,000\). b. A \($1,000\) debit to Accounts receivable was posted as...
-
The U.S. Energy Department states that 60% of all U.S. households have ceiling fans. In addition, 29% of all U.S. households have an outdoor grill. Suppose 13% of all U.S. households have both a...
-
The table below is Rebecca Minkoff's budgeted sales: April $452,000 May $467,000 June $498,000 July $520,000 Help Save & Exit Submit 82 August $507,000 Rebecca Minkoff estimates that sales are 30% in...
-
This problem continues the process of preparing the Kipley Company's Employee Payroll Register for the pay period ending January 8th, 20--. In previous chapters, gross wages were computed for each...
-
What is the average selling price for a ticket? b. What is the average variable cost per ticket? c. What is the average contribution margin per ticket? Do not round intermediate calculations. d. What...
-
What is the difference between a warrant to purchase a stock and an exchange-traded stock option?
-
How can a Wiener process be simulated?
-
What are u and d? What are the formulas used to calculate them?
-
What is the difference between a generalized Wiener process and a Wiener process?
-
How are weekends and holidays handled when volatility is estimated and used?
-
Simpson Inc. has a beta of 1.8.A required return of 15% based on the CAPM. If the risk-free rate of return is 4.2%. The expected stock market return is?
-
Representative data read from a plot that appeared in the paper Effect of Cattle Treading on Erosion from Hill Pasture: Modeling Concepts and Analysis of Rainfall Simulator Data (Australian Journal...
-
Patty Bayan is a single taxpayer living at 543 Space Drive, Houston, TX 77099. Her Social Security number is 466-33-1234. For 2012, Patty has no dependents, and her W-2 from her job at a local...
-
Indicate whether each of the items listed below would be included (I) in or excluded (E) from gross income for the 2012 tax year. ________a. Welfare payments ________b. Commissions ________c. Hobby...
-
On February 2, 2012, Alexandra purchases a personal computer for her home. The computer cost $3,000. Alexandra uses the computer 80 percent of the time in her accounting business, 10 percent of the...
-
What is the IQR? What does the IQR represent? The population parameters below describe the full-time equivalent number of students (FTES) each year at Lake Tahoe Community College from 19761977...
-
How many standard deviations away from the mean is the median? The population FTES for 20052006 through 20102011 was given in an updated report. The data are reported here. The population parameters...
-
A class of 20 students has a mean grade of 80 on a test. Nineteen of the students has a mean grade between 79 and 82, inclusive. a. What is the lowest possible grade of the other student? b. What is...
Study smarter with the SolutionInn App