Fixed-Income Analysis - Strucutured Response - Accounting and Finance Assessment Answer

Download Solution Order New Solution
Internal Code: 1AIEDA

Accounting and Finance Assessment Answer

Assignment Task: In this assignment, you are asked to perform a range of calculations and evaluations related to the material covered in the course. Most of the tasks are related to the valuation and analysis of a particular bond. The maximum mark for the assignment is 100 marks. Task 1 The following Bloomberg screen presents Apple Inc. fixed-income security for you to evaluate.  In the first task of your assignment, answer the following questions. Accounting and Finance Assessment Answer Figure 1. Bloomberg screen for an Apple Inc. fixed-income security.
  1. Provide a brief description of the security, including a) type of the security, b) maturity date, c) coupon rate and frequency, d) seniority ranking, e) credit rating, f) spread at issue, and g) par value. (3.5 marks)
  2. Calculate the above security’s full price, clean price and accrued interest as of the date of the screen (22 Aug 2016) assuming the yield to maturity of 1.19%. Show calculations. (6 marks)
For questions 3-11, assume today is 2 Aug 2017 and make appropriate estimation using this assumption.
  1. Current (annualised) US Treasury spot rates are as follows:
Accounting and Finance Assessment Answer
  1. Assuming that Z-spread is equal to 40 basis points, calculate the bond’s arbitrage-free price. Show calculations
    1. If the bond is bought today at the arbitrage-free price and sold on 2 Aug 2018 at $100.00, what will be realised the rate of return on a bond, if no reinvestment of coupons is assumed? Show calculations. 
    2. From the US treasury spot rates above and assuming Z-spread of 40 basis points, calculate appropriate discount rates (implied spot rates) for this bond’s cash flows. Show calculations. 
    3. Using bond-specific spot rates you calculated in Question 5, derive six-monthly forward rates, including six- months forward rate 6 months from now  - 0.5f0.5,  six-month forward rate 12 months from now - 1f0.5, and six-months forward rate 18 months from now - 1.5f0.5 for the bond.  Show calculations. 
    4. Estimate the bond’s arbitrage-free price using forward rates calculated in question 6 and comment on the comparability of spot rate and forward rate pricing  Show calculations.
    5. There is another Apple Inc. 2.5 year semi-annual 2% coupon paying a bond in the market priced at $101.5. Using bond-specific spot rates as calculated in Question 5 (for 0.5 years, 1 year, 1.5 year and 2 years), bootstrap 2.5-year spot rate for the bond.  Show calculations. 
    6. Estimate the original bond’s (displayed in Figure 1) Macaulay Duration and Convexity (YTM is as, in Q2, the valuation date is 2 Aug 17). Show calculations. 
Hint: for semiannual coupon paying bonds you will be using the semiannual cash flows, yields and periods as inputs for your calculation of the Macaulay Duration and Convexity. You will need to convert the output of your calculations into the annualised (standard) form. To do that you should divide Macaulay Duration and Convexity based on the semiannual periods by 2 and 4 respectively to arrive with the final answer.
  1. Estimate the original bond’s (displayed in Figure 1) Approximate Modified Duration and Approximate Convexity by applying 10bp interest rate shock to annualised yield to maturity (YTM is as, in Q2, the valuation date is 2 Aug 17). Show calculations. 
  2. Assume the following interest rate tree 
Accounting and Finance Assessment Answer
  1. Calculate the value of the (option-free) bond using the binomial model.
  2. Assume the bond is callable on 2 Aug 2018 and 2 Feb 2019 at $100.00, calculate the value of the bond.
  3. Calculate the value of the call option and comment on who bears the cost of the call option.  
Task 2 You are provided with recent Apple Inc(in separate XL file) . financial statements (in a separate file), including Income statement, Balance sheet and Cash flow statement.
  1. Use the statements to calculate the following measures for the last five financial years
  1. EBITDA
  2. FFO
  3. FCF before dividends
  4. FCF after dividends
  5. Debt/capital
  6. Debt/EBITDA
  7. FFO/debt
  8. FCF after dividends/debt
  9. EBITDA/interest expense
  10. EBIT/interest expense.  
Based on the calculated measures, discuss Apple’s 
  1. Profitability and cash flows
  2. Leverage
  3. Coverage
Task 3 Consider a pool of 1000 mortgages with the average size being $500 thousand, which is expected to be paid off in 25 years with fortnightly frequency (26 payments per year). The annual mortgage interest is 4.5%.
  1. Estimate the value of fortnightly mortgage payments from the pool 
  2. Suppose that the servicing fee is 0.5%, fill in the following table 
Accounting and Finance Assessment Answer In your assignment, up to 30 additional marks can be achieved by addressing the following criteria, which will be applied to the assignment as a whole. Please refer to the course rubric for the definition of each marking category.  
This Accounting and Finance Assessment has been solved by our Accounting and Finance experts at My Uni Paper. Our Assignment Writing Experts are efficient to provide a fresh solution to this question. We are serving more than 10000+ Students in Australia, UK & US by helping them to score HD in their academics. Our Experts are well trained to follow all marking rubrics & referencing style.

Get It Done! Today

Country
Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
+

Every Assignment. Every Solution. Instantly. Deadline Ahead? Grab Your Sample Now.