Subject Code : ASB4416
Assignment Task:

Background 
You have to apply the skills you’ve learnt during Lecture 2, Lecture 3, and Lecture 4 and use Excel to answer the assignment question. You must answer all your questions in one document (i.e. Word) and provide screenshots or copy and paste your working from Excel into the document. You will need to clearly explain the steps you have taken in Excel. 

Do not present your answers in essay form. You are assessed on how you use Excel to answer the questions, and then how you discuss your findings. Therefore your answers need to be clear and concise. 
 
You can collect data to complete the assignment from whatever source you feel best BUT you need to clearly specify the source of any data used. 

Assignment 
Using the Merton’s structural model with a one-year horizon, calculate the probability of default (using both the iterative approach and two-equation approach) for two US non-financial firms between Q1 2017 and Q4 2017 (i.e. a full calendar year). Compare the results and describe your calculations. To complete this assignment you should, 

1. Download the following information between Q1 2017 and Q4 2017 for each firm: 
a. the daily equity price and amount of common shares in circulation (to calculate the market equity), 
b. the quarterly total book liabilities. 

2. Download the daily S&P 500 index price for the Q1 2017 to Q4 2017 period. 

3. Assume the risk free rate to be 3% throughout the whole period. 

4. For each firm, calculate the probability default (using both the iterative approach and two-equation approach) using the Merton’s structural model with a one-year horizon. As part of your calculations you will need to: 
a. Calculate the asset volatility, 
b. Perform CAPM calculations, 
c. Derive the implied default probability, 
d. Calibrate the Merton model. 

5. In your report, you will need to: 
a. briefly describe the two firms, including industry, overall structure, and performance over the period, 
b. explain and briefly describe the data feeding into the model and how it is used, 
c. describe the calculations performed in the Excel workbook, 
d. compare and explain the different approaches for calculating 


This ASB4416: Accounting Assignment has been solved by our Accounting Experts at UniLearnO. 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.

Be it a used or new solution, the quality of the work submitted by our assignment experts remains unhampered. You may continue to expect the same or even better quality with the used and new assignment solution files respectively. There’s one thing to be noticed that you could choose one between the two and acquire an HD either way. You could choose a new assignment solution file to get yourself an exclusive, plagiarism (with free Turnitin file), expert quality assignment or order an old solution file that was considered worthy of the highest distinction.

Eureka! You've stumped our genius minds (for now)! This exciting new question has our experts buzzing with curiosity. We can't wait to craft a fresh solution just for you!

  • Uploaded By : Alex Cerry
  • Posted on : February 22nd, 2019

Whatsapp Tap to ChatGet instant assistance