What should be the shape of the yield curve

Assignment Help Financial Management

Reference no: EM132102650 , Length: word count:2000

Question 1

This question has seven parts (a) - (g). Attempt all of them.

Refer to worksheet "Data Q1" in the file 2018 FIN205.xlsx to answer this question. This worksheet contains monthly data on yields of Australian Government Bonds and New South Wales (NSW) Treasury Bonds from January 2008 - December 2009. You may use the worksheet "Yield curves" as a template to answer part "a" of the question.

For questionsa - e, consider Australian Government Bonds only.

a. Pick the month you were born. Draw the yield curve for that monthin 2008 and 2009. Also, draw the yield curve for the month falling exactly in the middle. (For instance, if you were born in April, draw the yield curves for April 2008, October 2008 and April 2009.)

b. What should be the shape of the yield curve under normal circumstances? Why?

c. Compare the shapesof the three yield curves that you have drawn. From the yield curves, can you infer anything about the market's expectation about the future of Australian economy?

d. What is the yield on 2-year bond in January 2008? Under the expectations theory, what interest rate do investors expect on a 1-year bond next year(i.e., January 2009)? Using the same method calculate the expected interest rates on 1-year bonds for all the months of 2009.

e. How do the expected interest rates compare with the actual interest rates in 2008? Do your calculations validate/not validate the expectations theory? List some possible reasons why the expectations hypothesis may not hold.

For questionsf - g, consider bothAustralian Government Bondsand NSW Treasury Bonds for theperiod January 2008 - December 2009.

f. For 3, 5 and 10 year bonds what was the average spread between Australian Government Bonds andNSW Treasury bonds?

g. Draw a graph plotting the spread between Australian Government Bonds and NSW Treasury Bonds. Comment on the pattern of the spread. Can you provide an explanation for this pattern?

Question 2

This question has six parts (a) - (f). Attempt all of them.

Refer to worksheet "Data Q2" in the file 2018 FIN205.xlsx to answer this question. This worksheet contains data on the adjusted end of month share price from January 2015 - June 2018 of two companies: AMP Limited (AMP.AX) and Qantas Airways Limited (QAN.AX). You will also find the value of S&P/ASX200 market index over this period. The basic data is provided in columns A - D. You will need to manipulate the data to answer the questions below. Some excel formulas are provided in the worksheet.

Pick the month you were born. For you the relevant data will be month 2015- June 2018.

a. Suppose you are a financial analyst working for Star Bank.Use an appropriate graph to plot the AMP and Qantas share prices from month 2015 - June 2018. Provide a brief comment on the pattern you observe.

b. Compute the monthly return on AMP, Qantas shares and the ASX200 index by using the following formula:

Return_t = (P_t - P_(t-1)/P_(t-1)×100,

where, P_t is the share price (or the value of ASX200 index) in time period t. (Please note that you lose the first observation when calculating returns. For instance, if you were born in June, you will only be able to calculate the returns only from July 2015.)

Compute the mean, variance and standard deviationof all three returns. Based on your calculations what can you infer about the performance of AMP, Qantas and ASX200 index over the last three years? Provide a brief explanation.

c. Calculate the beta of AMP and Qantas. For this you will have to first calculate the covariance of AMP and Qantas returns with the ASX index. Use the following formula in excel:

=covariance(Return of company X,Return of ASX200)

Beta's can then be calculated by

β_X= (Covariance(Return of Company X, Return of ASX200))/(Variance (return of ASX200)).

d. Briefly explain why AMP and Qantas have high/low values of beta.

e. Assume the monthly risk-free rate to be 0.14%. According to the Capital Asset Pricing Model (CAPM) are the AMP and Qantas shares are underpriced? Explain.

f. Write a short report for the management of your company evaluating the past performance and future prospects of AMP and Qantas shares.

Instructions for part (f):For this question you are expected to do some research on AMP and Qantas.

In addition to these websites you are free to use any other appropriate website/article as reference for your report. Make sure that you cite all your references.

You can find the financial statements of AMP and Qantas by doing a search on the Yahoo finance website. Also, search for news coverage and announcements related to these companies. Classify the financial situation and the news/announcements as "positive" or "negative". Summarize how the share prices have reacted to "positive/negative" developments in the past. Use your findings to provide some predictions for future prospects of these companies.

Attachment:- Major Assignment.rar

Reference no: EM132102650

Questions Cloud

What have you learned from the exercise : An extremely interesting model in Marketing is the Product Life Cycle and how the Marketing Components (Positioning, Targeting, Product Strategies.

Discuss whether your solutions are training-based or not : Discuss whether your solutions are training-based or non-training-based, or a combination of both, and why you made the decisions you did.

How much money you project you will need to raise : You must intend to raise money for your startup company. You can start with money from friends and family but at some point you will need funds from outside.

Employees unless there are confidentiality issues : Many decisions come from the bottom up rather than the top down, and executives even sit in the same area with employees unless there are confidentiality issues

What should be the shape of the yield curve : FIN205 Business Finance - What should be the shape of the yield curve under normal circumstances - Compare the shapesof the three yield curves

What is the value chain analysis of pepsico : How would you assess whether a website had good customer orientation? What is the value chain analysis of PepsiCo? In detail

What are the aspect of unemployment : Write a minimum of a five-page essay, using proper APA format, on the topic of unemployment in the U.S. Use a minimum of three scholarly sources.

What levels of pay and benefits should you offer : What Levels of Pay and Benefits Should You Offer?An important element of the human resource function is the determination and administration of pay and benefits

Determine diffusion determinants and diffusion inhibitors : Determine which reference groups influence this market segment. Strategize which diffusion rate is most appropriate for this product to move it into national.

Reviews

len2102650

9/2/2018 11:01:50 PM

Quality of arguments, analytical and evaluations skills Provides well-argued and articulated statements with supporting evidence. Evidence of originality and independent thought. Has highly developed analytical skills & consistently demonstrates high levels of critical analysis. Demonstrates ability to reflect on conclusions and their implications. Provides well-argued and articulated statements, but limited use of supporting evidence. There is evidence of independent thought. Has good analytical skills and is capable of good levels of critical analysis. Able to justify conclusions and their implications. Able to synthesise and draw conclusions from multiple perspectives. Well-reasoned arguments based on broad evidence. Demonstrates some evidence of analytical and evaluative skills. Able to apply fundamental concepts and draw and justify conclusions. Arguments based on limited evidence. Demonstrates very limited evidence of analytical and evaluative skills Able to apply very limited concepts to draw and justify conclusions.

len2102650

9/2/2018 11:01:26 PM

Major Assignment Relevant learning objectives High Distinction (85%+) Distinction (75%-84%) Credit (65%-74%) Pass (50%-64%) Fail 0-49% Academic writing and presentation skills Highly developed skills in expression and presentation of ideas. Fluent writing style. No major grammatical and spelling errors. Well-developed skills in expression and presentation of ideas. Fluent writing style. No spelling errors, minor grammatical errors. A satisfactory standard of expression. Relatively clear and concise in expression of ideas. Few spelling and/or grammar errors. Some inconsistency in sentence structure. Clarity of expression could be enhanced by some revision. Many spelling errors and/or poor grammar. Poor communication of ideas due to careless writing and lack of proof-reading. Too many spelling and/or grammar errors.

len2102650

9/2/2018 11:01:16 PM

len2102650

9/2/2018 11:01:01 PM

You can find the financial statements of AMP and Qantas by doing a search on the Yahoo finance website. Also, search for news coverage and announcements related to these companies. Classify the financial situation and the news/announcements as “positive” or “negative”. Summarize how the share prices have reacted to “positive/negative” developments in the past. Use your findings to provide some predictions for future prospects of these companies.

len2102650

9/2/2018 11:00:47 PM

5. The completed the assignment (MSWord document)needs to be submitted online via “Assignment Submission Point: Word Document Only”, under Assessment Task 2 folder. Make sure your name and student number are on every page of your submission. 6. The EXCEL file used for your calculations must be submitted via “Excel Workbook Submission Point”, under theAssessment Task 2 folder. 7. Explain your answers. Do not simply state them. State the formula used to derive an answer. Keep a copy of your assignment in case the original submission is lost due to any technical issues. PDF or paper copies will not be accepted. This is an individual assignment(not a group assignment). If portions of your assignment are copied or very close to copying, all parties will be penalized for copying. Copying would be considered plagiarism and CDU has strict policies. It is up to you to keep your assessment confidential.

len2102650

9/2/2018 11:00:36 PM

Maximum Marks: 30 Due date: Sunday, hours, Darwin time Instructions: 1. This assignment has two questions. Attempt both of them. 2. Download and save the file FIN205.xlsx to answer this assignment. The data required for Questions 1 & 2 are provided on separate worksheets titled “Data Q1” and “Data Q2” respectively. 3. Graphs and calculations should be done using EXCEL. 4. Your assignment should be written in MSWord format. You have to copy and paste EXCEL outputs (for instance, graphs, tables etc.) into your main assignment which is the MSWord document. Any answer not in the main document will not be marked.

Write a Review

Required(*) Message

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!

Submit Assignment

User Account

All Pages