Limited Offer Get 25% off — use code BESTW25
No AI No Plagiarism On-Time Delivery Free Revisions
Claim Now
Prices start at $5 per page · plagiarism-free papers · free revisions for 14 days 24/7 support: support@bestwriters.com
Uncategorized

Quantitative Applications in Finance (FIN201)

  • Posted
  • Authoradmin
  • Length5,119 words
  • Reading time23 min
Write My Assignment FREE

Quantitative
Applications in Finance
(FIN201)

Assignment

Total
marks: 100

Student No: [Enter
your Student No.]

I have read the Assignment Guide in the ‘General assessment
information’ and have applied the word count principles to my
work.

My word count for this assignment is: [Enter
your word count] words

Your assignment should be loaded into KapLearn by 11.30 pm on
the due date.
All times are based on AEDT/AEST time zones.

Refer to ‘Time
remaining’ on the ‘Assignment’ page in KapLearn to ensure
you submit your assignment by the specified due date
and time.

Checklist

 I have completed my assignment using Word and Excel.

 I have completed my assignment using Calibri, Arial, Times New
Roman or Verdana fonts.

 I have added my Student No. on this page.

 I have added my word count on this page.

 I have added my Student No. in front of the filename in the
footer on the second page.

 I have saved the file to be uploaded as StudentNo_FIN201_AS_v7A3

 Each question of my assignment is within the word limit
guidelines for that question as per the ‘General assessment
information’ (Assessment 
Assignment 
General assessment information).

 My assignment file size is no larger than 2 MB.

 If tables were required, they are visible as text, not as links
or images.

 I have not removed the marking grid from the footer.

 I have submitted my assignment as per the instructions in
KapLearn.

Marker
feedback

Comment on overall performance:

For
marker use only.

Instructions
to students

• This assignment covers Topics 1 to 10 and accounts for 50% of
your final grade.

• There are two (2) sections in this assignment:

– Section A comprises six (6) short-answer questions worth a
total of 70 marks.

– Section B comprises two (2) short-answer questions worth a
total of 30 marks.

• You should answer all questions.

• Download the ‘Assignment Excel template’ (i.e.
FIN201_AS_v7.xlsx) under ‘Assignment’ in KapLearn. This file
contains data to enable you to answer questions.

• Your assignment submission must contain a Word
document (as the primary document with all final solutions)
and an Excel file (to provide backup and validation
of your workings).

• Submit all Excel workings in the appropriate
worksheets in the one (1) Excel file.

• The overall word limit for the assignment is 3000 words. Marks
will only be awarded for answers up to the word limit (plus
10%) for each question
. Any material written after this will
not be counted towards your mark for that question. Headings,
quotes and references within the body of the answer are included
in the word count. Numerical tables, calculations, and reference
lists are not included. For more information on word counts
and their rationale, go to Assessment 
Assignment 
General assessment information.

• Refer to the Criteria-based Marking Guide for
guidelines on what is expected for each question.

• The ‘General assessment information’ section in KapLearn
contains information about format and presentation, word limits,
citations and referencing, collusion, plagiarism and other
policies, useful resources, submitting your assignment and
accessing your results.

• Full workings must be shown for all calculations. Show all
calculations in the text of your assignment and not
attached as an appendix. Appendices to assignments will not be
read.

• Answers are to be in your own words. Reference and cite all
your sources (within the text of your answer) when quoting or
using material from external sources. Include a reference list at
the end of your assignment. For further information on
referencing, refer to the ‘Referencing Guide’ available
under the Additional resources
from the Learning Hub.

• Indicative weightings are noted beside each question. Use
these weightings to assist you with your allocation of time and
resources. The weightings indicate the relative importance of each
question.

• State all assumptions used in providing your
answer.

• Requests for special consideration or information pertaining
to special consideration written in the body of the assignment
will not be considered by the marker. Refer to the ‘special
consideration’ section of the Assessment Policy on Kaplan’s
website for more information.

• Please note: As with most post-graduate,
take-home assessments, this assignment will require students to
carry out a reasonable level of independent research and enquiry.
The majority of concepts covered in the assignment will be found
within the subject’s topic notes and text-book, however, there
will likely be a need to look beyond these resources in order to
achieve an exceptional overall result.

Learning
outcomes (LO) mapping

Marks

1. Examine the various quantitative techniques used to describe,
estimate and evaluate data

15

2. Evaluate the strengths and limitations of statistical analysis
techniques in finance

21

3. Apply quantitative techniques to describe financial data and
test claims of performance

12

4. Analyse the factors that influence the risk and return of asset
classes and financial securities

32

5. Assess statistical models used in estimating the value of
financial assets and constructing efficient portfolios

20
Total
marks
0

Criteria-based Marking Guide

The Criteria-based Marking Guide provided at the end of each question
is designed to assist students to understand what is expected of them
in each question and to let them know how their performance will be
judged. It provides advice about the criteria used in the marking of
the question and what discriminates between an excellent,
satisfactory and unsatisfactory answer.

Data
file and Excel Template

You have been provided with data on a number of stocks and an index
in order to run a number of statistical analysis techniques. The data
to enable you to answer Questions 1 through 8 is contained in
‘Assignment Excel template’ (i.e. FIN201_AS_v7.xlsx)
under ‘Assignment’ in KapLearn. Again, your excel file submission
is to help show your workings. All answers must be clearly shown
in your word document submission
.

The Excel workbook is separated into worksheets for each question,
which have been labelled accordingly. As a guide, cells
that might need to be populated by formulas (or Excel outputs) in
order to answer the question have been shaded yellow.

Note: The excel template and yellow shaded areas are a guide
only. You may alter the spreadsheet if you wish providing your
workings are shown

Section
A (70 marks)

Instructions
to students

There are six (6)
short-answer questions in this section. Answer all
questions.

Questions
1 to 5

You have been provided a sample of historical price level of the
following shares and index at the end of each month from June 2007 to
June 2017 (‘Section A Monthly Price&Index’ tab) in order to
run a number of statistical analysis techniques.

Qantas Airways Limited (QAN)

Telstra Corporation Limited (TLS)

Westpac Banking Corporation (WBC)

Question
1 (10 marks | Word limit: 200 words)

LO1: Examine the various quantitative
techniques used to describe, estimate and evaluate data.

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

(a) Using the historical price level of the QAN, TLS and WBC shares
and AORD index available in the tab ‘Section A Monthly
Price&Index’, calculate the monthly rate of returns (%) of
these shares and index to two (2) decimal places in the tab ‘Section
A_Q1’. From your Excel results, paste a copy of the monthly returns
for the shares and index for the months of July 2007 and June 2017
only in the answer section of your Word document (and in the format
below). (2 marks)

Month QAN
returns
TLS
returns
WBC
returns
AORD
returns

July
2007

June
2017

(b) Use Excel’s Data Analysis to work out the descriptive
statistics for these monthly returns to two (2) decimal
places. From your Excel results, paste a copy of the following
descriptive statistics in the answer section of your Word document
(and in the format below). (4 marks)

QAN returns

TLS returns

WBC returns

AORD returns

Sample size

Sample mean (%)

Sample standard deviation
(%)

Sample variance (%)

Skewness

Kurtosis

(c) Evaluate QAN, TLS, WBC and AORD return series, with reference to
sample mean, sample standard deviation, skewness and kurtosis
statistics. (4 marks)

Criteria-based marking guide for Question
1(a)–(c)

Excellent (Mark range:
8–10 marks)

Satisfactory (Mark range:
5–7.5 marks)

Unsatisfactory (Mark
range: 0–4.5 marks)

• correct calculation of
monthly rate of returns and presenting the results for the
appropriate months in word document

• correct use of Excel’s
Data analysis

• accurately fill the
table of descriptive statistics in word document

• accurately evaluate four
return series with respect to sample mean, sample standard
deviation, skewness and kurtosis statistics

• mostly correct
calculation of monthly rate of returns

• encounter problems in
the use of Excel’s Data analysis

• encounter problems in
filling the table of descriptive statistics in word document

• encounter problems when
evaluating four return series with respect to sample mean, sample
standard deviation, skewness and kurtosis statistics

• incorrect calculation of
monthly rate of returns

• unable to use Excel’s
Data analysis

• unable to fill the table
of descriptive statistics in word document

• unable to evaluate four
return series with respect to sample mean, sample standard
deviation, skewness and kurtosis statistics

Insert your answers to
Question 1(a)–(c)

End of answers to Question 1(a)–(c)

Question
2 (10 marks | Word limit: 200 words)

LO1: Examine the various quantitative
techniques used to describe, estimate and evaluate data.

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO3: Apply quantitative techniques to describe
financial data and test claims of performance.

(a) Set up a hypothesis test at 5% significance level to determine
whether QAN’s mean return is significantly different from zero.
Show all your workings in the Word document.

(i) What are the null and alternative hypothesis for this test? (1
mark)

(ii) Explain the risks associated with Type I and Type II errors
in this context. (2 marks)

(iii) What type of test and distribution would you recommend for
this test? Provide reasons for your recommendation. (1
mark)

(iv) Based on your recommendation above, determine the appropriate
critical value and test statistic for the hypothesis testing at 5%
significance level. (2 marks)

(v) What is your conclusion for this hypothesis test? (1
mark)

(b) Set
up the null hypothesis and alternative hypothesis to determine
whether TLS’s monthly return is significantly
different from WBC’s monthly return.

(i) What are the null and alternative hypothesis for this test? (1
mark)

(ii) By Using Excel’s paired t-Test (see tab Section A_Q2), find
the critical value and test statistic for the hypothesis testing at
5% significance level. (1 mark)

(iii) What is your conclusion for this hypothesis test? (1
mark)

Criteria-based marking guide for Question
2(a)–(b)

Excellent (Mark range:
8–10 marks)

Satisfactory (Mark range:
5–7.5 marks)

Unsatisfactory (Mark
range: 0–4.5 marks)

• correct set up of the
null and alternative hypothesis

• accurately explain the
risks associated with Type I and Type II in in relation to
hypothesis testing determining whether QAN’s mean return is
significantly different from zero

• correctly identify the
appropriate hypothesis test for the QAN’s returns with
appropriate justification

• correct critical value,
the test statistic at 5% significance level and conclusion

• correctly identify the
appropriate null and alternative hypothesis to determine whether
TLS’s monthly return is significantly different from WBC’s
monthly return

• correct result of paired
t-test for TSL and WBC monthly returns and conclusion

• correct set up of the
null and alternative hypothesis

• adequate explanation of
the risks associated with Type I and Type II in in relation to
hypothesis testing determining whether QAN’s mean return is
significantly different from zero

• mostly correct
identification of the appropriate hypothesis test for the QAN’s
returns with appropriate justification

• mostly correct critical
value, the test statistic at 5% significance level and conclusion

• most correctly identify
the appropriate null and alternative hypothesis to determine
whether TLS’s monthly return is significantly different from
WBC’s monthly return

• mostly correct result of
paired t-test for TSL and WBC monthly returns and conclusion

• incorrect set up of the
null and alternative hypothesis

• inadequate explanation
of the risks associated with Type I and Type II in in relation to
hypothesis testing determining whether QAN’s mean return is
significantly different from zero

• incorrectly identify the
type of hypothesis test for the QAN’s returns and incorrect
justification

• incorrect critical
value, the test statistic at 5% significance level and conclusion

• incorrectly identify the
null and alternative hypothesis to determine whether TLS’s
monthly return is significantly different from WBC’s monthly
return

• incorrect result of
paired t-test for TSL and WBC monthly returns and conclusion

Insert your answers to
Question 2(a)–(b)

End of answers to Question 2(a)–(b)

Question
3 (10 marks | Word limit: 500 words)

LO1: Examine the various quantitative
techniques used to describe, estimate and evaluate data.

LO3: Apply quantitative techniques to describe
financial data and test claims of performance.

An outlier of a sample may affect the accurate statistical analysis.
If an observation is away from its sample mean by more than 3
standard deviations, it can be considered as an outlier.

(a) Standardise the monthly returns using the formula to two (2)
decimal places using tab ‘Section A_Q3’. From your Excel results,
paste a copy of the standardised returns for the shares and index for
the months of July 2007 and June 2017 only in the answer section of
your Word document (and in the format below). (4
marks)

Month

QAN
standardised returns

TLS
standardised returns

WBC
standardised returns

AORD
standardised returns

July 2007

June 2017

(b) Identify all the standardised monthly returns which are either
greater than 3 or smaller than –3 (i.e. more than 3 standard
deviations away from zero). Report the stock, month, actual value
and standardised value. (2 marks)

(c) You decide to replace the outlier with the mean observation
calculated for Question 1 in ‘Section A’ instead.
Explain how this is likely to affect the mean return,
standard deviation, skewness, and kurtosis of the monthly returns
(note: no calculations are required). (2
marks)

(d) What are two alternative adjustments you could make to the data
in order to avoid having the outlier skew the results. (2
marks)

Criteria-based marking guide for Question
3(a)–(d)

Excellent (Mark range:
8–10 marks)

Satisfactory (Mark range:
5–7.5 marks)

Unsatisfactory (Mark
range: 0–4.5 marks)

• correct standardisation
of monthly rate of returns and presenting the results for the
appropriate months in word document

• correct identification
of the outlier

• accurately explain the
effect of replacing the outlier with the mean on descriptive
statistics and provide two alternative adjustments to the data

• mostly correct
standardisation of monthly rate of returns

• encounter problems in
the identification of the outlier

• encounter problems in
explaining the effect of replacing the outlier with the mean on
descriptive statistics and provide two alternative adjustments to
the data

• incorrect
standardisation of monthly rate of returns

• unable to identify
outliers

• unable to explain the
effect of replacing the outlier with the mean on descriptive
statistics and provide two alternative adjustments to the data

Insert your answers to
Question 3(a)–(d)

End of answers to Question 3(a)–(d)

Question
4 (20 marks | Word limit: 600 words)

LO1: Examine the various quantitative
techniques used to describe, estimate and evaluate data.

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO3: Apply quantitative techniques to describe
financial data and test claims of performance.

LO4: Analyse the factors that influence the
risk and return of asset classes and financial securities.

Run a regression analysis for WBC stock against the AORD Index using
the monthly rate of returns data from July 2007 to June 2017
inclusively (see tab Section A_Q4).

Hint: Use the ‘Regression’ function in the ‘Data
Analysis’ add-in. Select ‘Residuals’ and ‘Residual plots’
from the regression window.

(a) Provide the estimated regression equation for WBC, with
coefficients to four (4) decimal places.
(2
marks)

(b) Predict the WBC returns when the monthly return on the AORD is
7.5%, as a % to two (2) decimal places. (2
marks)

(c) At 0.05 level of significance, is there evidence of a linear
relationship between WBC and AORD? Show all your
workings in relation to your conclusion. (3
marks)

(d) What is the R-square statistic and interpret its meaning for
this regression? (2 marks)

(e) Generate the residual plot (scatter plot of residuals of the
above regression against AORD) for the above regression. Paste your
residual plot from excel file to word document. Comment on
heteroskedasticity of this regression with reference to the residual
plot. (2 marks)

(f) Discuss the ways of eliminating heteroskedasticity issues. Your
discussion requires three (3) points. (3 marks)

(g) Calculate the Durbin-Watson statistic for the above regression,
and provide this in the Word document of your assignment, to four (4)
decimal places. Comment on the serial correlation of this regression
with reference to Durbin-Watson statistic. (3
marks)

(h) Discuss the ways of eliminating serial correlation issues. Your
discussion requires three (3) points. (3 marks)

Criteria-based marking guide for Question
4(a)–(h)

Excellent (Mark range:
16–20 marks)

Satisfactory (Mark range:
10–15.5 marks)

Unsatisfactory (Mark
range: 0–9.5 marks)

• correct use of excel’s
data analysis to obtain regression coefficients and correctly
present regression equation

• correctly predict the
WBC returns

• correct setup of null
and alternative hypothesis, identification of relevant statistics
to perform the hypothesis test on linear relationship between WBC
and AORD

• correctly identify and
interpret R-square statistic

• relevant residual plot
with appropriately comment on heteroscedasticity of the regression

• correctly discuss three
ways of eliminating heteroscedasticity issues

• accurately calculate the

Durbin-Watson statistic

• correctly identify
serial correlation with reference to Durbin-Watson statistic

• correctly discuss three
ways of eliminating serial correlation issues

• encounter problems in
using of Excel’s data analysis to obtain regression coefficients
and presentation of regression equation with minor errors

• predict the WBC returns
with minor errors

• mostly correct setup of
null and alternative hypothesis, identification of relevant
statistics to perform the hypothesis test on linear relationship
between WBC and AORD

• correct identification
and mostly correct interpretation of R-square statistic

• mostly correct residual
plot and comment on heteroscedasticity of the regression

• correctly discuss two
ways of eliminating heteroscedasticity issues

• encounter problems in
calculating the Durbin-Watson statistic

• most correctly identify
serial correlation with reference to Durbin-Watson statistic

• correctly discuss two
ways of eliminating serial correlation issues

• unable to use Excel’s
Data analysis to obtain regression coefficients and incorrect
presentation of regression equation with minor errors

• incorrectly predict the
WBC returns

• incorrect setup of null
and alternative hypothesis, identification of relevant statistics
to perform the hypothesis test on linear relationship between WBC
and AORD

• incorrectly identify and
interpret
R-square statistic

• mostly correct residual
plot and comment on heteroscedasticity of the regression

• incorrectly discuss ways
of eliminating heteroscedasticity issues

• unable to calculate the
Durbin-Watson statistic

• incorrectly identify
serial correlation with reference to Durbin-Watson statistic

• incorrectly discuss ways
of eliminating serial correlation issues

Insert your answers to
Question 4(a)–(h)

End of answers to Question 4(a)–(h)

Question
5 (10 marks | Word limit: 300 words)

LO1: Examine the various quantitative
techniques used to describe, estimate and evaluate data.

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO4: Analyse the factors that influence the
risk and return of asset classes and financial securities.

(a) Discuss the use of autoregressive (AR) models in finance. (4
marks)

(b) Run an AR1 model for TLS stock using the monthly rate of returns
data from August 2007 to June 2017 inclusively (see tab Section
A_Q5).

AR(1) model for TLS stock:

Hint: Use the ‘Regression’ function in the ‘Data Analysis’
add-in.

(i) Provide the estimated AR(1) equation for AR(1) model for TLS
stock, with coefficients to four (4) decimal places. (2
marks)

(ii) What are the implications for estimation and inference if the
errors of the AR(1) model estimated in (i) are also serially
correlated? (2 marks)

(iii) Discuss why is it not appropriate to test for autocorrelation
in an AR model using the
Durbin-Watson test. (2
marks)

Criteria-based marking guide for Question
5(a)–(b)

Excellent (Mark range:
8–10 marks)

Satisfactory (Mark range:
5–7.5 marks)

Unsatisfactory (Mark
range: 0–4.5 marks)

• correctly discuss the
benefit of AR models in finance

• correct use of Excel’s
Data Analysis to obtain AR(1) coefficients and correctly present
AR(1) equation

• correct discussion of
the presence of autocorrelation in the AR(1) model

• correct discussion of
the inappropriateness of the
Durbin-Watson test for
detecting autocorrelation in an AR models

• most correctly discuss
the benefit of AR models in finance

• encounter problems in
using of Excel’s Data Analysis to obtain AR(1) coefficients and
present AR(1) equation with minor errors

• mostly correct
discussion of the presence of autocorrelation in the AR(1) model

• mostly correct
discussion of the inappropriateness of the
Durbin-Watson
test for detecting autocorrelation in an AR models

• incorrectly discuss the
benefit of AR models in finance

• unable to use Excel’s
Data Analysis to obtain AR(1) coefficients and incorrectly present
AR(1) equation

• incorrect discussion of
the presence of autocorrelation in the AR(1) model

• incorrectly discuss the
inappropriateness of the Durbin-Watson test for detecting
autocorrelation in an AR models

Insert your answers to
Question 5(a)–(b)

End of answers to Question 5(a)–(b)

Question
6 (10 marks | Word limit: 300 words)

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO4: Analyse the factors that influence the
risk and return of asset classes and financial securities.

LO5: Assess statistical models used in
estimating the value of financial assets and constructing efficient
portfolios.

An equally weighted three-stock portfolio consist of shareholdings in
Qantas Airways Limited (QAN), Telstra Corporation Limited (TLS)
and Westpac Banking Corporation (WBC).

Calculate the portfolio returns (in the column named ‘ri’)
using the monthly returns data from July 2007 to June 2017 (to two
(2) decimal places) in the tab ‘Section A_Q6’.

Consider the CAPM regression model given below:

Run a regression analysis for above CAPM model using the portfolio
monthly rate of returns data from July 2007 to June 2017
inclusively. Use 3.0% p.a. as the risk-free return () and AORD
monthly returns as market returns ().

Hint: Use the ‘Regression’ function in the ‘Data
Analysis’ add-in.

(a) Provide the estimated CAPM regression equation, with
coefficients to four (4) decimal places. (2 marks)

(b) What is the beta (β) value of the portfolio? (1
mark)

(c) Comment on the portfolio beta value in comparison to the slope
coefficient of the regression equation for WBC (WBC stock’s beta
value) which you have obtained in Question 4. (3
marks)

(d) Discuss the limitations of CAPM. (4
marks)

Criteria-based marking guide for Question
6(a)–(d)

Excellent (Mark range:
8–10 marks)

Satisfactory (Mark range:
5–7.5 marks)

Unsatisfactory (Mark
range: 0–4.5 marks)

• correct use of Excel’s
Data Analysis to calculate CAPM coefficients and presentation of
estimated CAPM equation

• correctly identify the
beta (β) value of the portfolio

• accurate comparison
between portfolio beta and WBC stock’s beta

• correctly identify four
(4) limitations of CAPM and appropriate discussion of the
limitations

• encounter problems of
using Excel’s Data Analysis to calculate CAPM coefficients and
present the estimated CAPM equation with minor errors

• correctly identify the
beta (β) value of the portfolio

• mostly accurate
comparison between portfolio beta and WBC stock’s beta

• fair identification of
the limitations of CAPM and some discussion of the limitations

• encounter problems of
using Excel’s Data Analysis to calculate CAPM coefficients and
present the estimated CAPM equation with major errors

• incorrectly identify the
beta (β) value of the portfolio

• inaccurate comparison
between portfolio beta and WBC stock’s beta

• poor discussion of the
limitations of CAPM

Insert your answers to
Question 6(a)–(d)

End of answers to Question 6(a)–(d)

Section
B (30 marks)

Instructions
to students

There are two (2)
short-answer questions in this section. Answer all
questions.

Question
7 (11 marks | Word limit: 300 words)

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO4: Analyse the factors that influence the
risk and return of asset classes and financial securities.

LO5: Assess statistical models used in
estimating the value of financial assets and constructing efficient
portfolios.

You have been provided a sample of historical monthly returns of the
following shares and index at the end of each month from July 2007 to
June 2017 (‘Section B_Q7_Monthly Returns’ tab) in order to run a
number of statistical analysis techniques.

AGL Energy Limited (AGL)

Commonwealth Bank of Australia (CBA)

Graincorp Limited (GNC)

Melbourne IT Limited (MLB)

(a) Using the monthly returns from July 2007 to June 2017, calculate
the variance-covariance matrix of AGL, CBA, GNC and MLB to five (5)
decimal places on the’ Section B_Q7’ tab.

From your Excel results, paste a copy of the covariance matrix in
the answer section of your Word document (and in the format below).
(4 marks)

Monthly return
covariance matrix

AGL

CBA

GNC

MLB

AGL

CBA

GNC

MLB

(b) Suppose you have a portfolio with an equal amount into these
four shares (i.e. the portfolio consists of ¼ of AGL, ¼ of CBA, ¼
of GNC and ¼ of MLB). Using Excel or otherwise, calculate the
variance of this portfolio, to five (5) decimal places and
report it on the word file. (3 marks)

(c) You expect the long-term monthly returns of the stocks to be as
follows:

AGL

0.54%

CBA

0.55%

GNC

0.27%

MLB

0.60%

Use the variance/covariance matrix you have calculated for part a)
and find the expected optimal allocation (portfolio weight) to each
share in the portfolio (weights must all be greater than
zero and add up to 100%) with least expected variance but with an
expected return of at least 0.55% per month. Provide the weights (%)
of the optimised portfolio and its expected variance to five (5)
decimal places). (4 marks)

Hint: Use Excel’s Solver function.

Optimised weights

AGL

CBA

GNC

MLB

Weights (%)

Returns (%)

0.54%

0.55%

0.27%

0.60%

0.55%

Variance

Criteria-based marking guide for Question
7(a)–(c)

Excellent (Mark range:
9–11 marks)

Satisfactory (Mark range:
5.5–8.5 marks)

Unsatisfactory (Mark
range: 0–5 marks)

• correct calculation of
covariance matrix (using either the population formula or the
sample formula) and the variance of an equally weighted portfolio

• within the constraints
provided, accurately work out the optimal portfolio weights of the
portfolio with the smallest expected variance

• almost correct
calculation of covariance matrix and the variance of an equally
weighted portfolio

• encounter problems in
working out the optimal portfolio weights of the portfolio with
the smallest expected variance

• incorrect calculation of
covariance matrix and the variance of an equally weighted
portfolio

• unable to work out the
optimal portfolio weights of the portfolio with the smallest
expected variance

Insert your answers to
Question 7(a)–(c)

End of answers to Question 7(a)–(c)

Question
8 (19 marks | Word limit: 600 words)

LO2: Evaluate the strengths and limitations of
statistical analysis techniques in finance.

LO4: Analyse the factors that influence the
risk and return of asset classes and financial securities.

LO5: Assess statistical models used in
estimating the value of financial assets and constructing efficient
portfolios.

Note: Use Figure 1 to answer part (a) of this question
below.

Figure
1

(a) (i) What does Figure 1 depict and what is
the financial name or description given to the diagram?
(2 marks)

(ii) Which portfolio (A or B) would be
preferred and why? (2
marks)

Section B_Q8’ tab of the excel workbook gives three portfolio
returns (Portfolio_A, Portfolio_B and Portfolio_C). The risk-free
rate is given as 3.00% p.a.

(b) Based on the monthly returns data from July
2007 to June 2017 and assuming the risk-free rate is 3.0% p.a.,
calculate the Sharpe ratios for each of the three portfolios (A, B,
and C), as a % rounded to two (2) decimal places. Compare the three
portfolios based on their Sharpe ratios. (3
marks)

(c) Discuss the advantages and disadvantages of Sharpe ratio for
measuring portfolio performance. (2 marks)

(d) What is tracking error? (2
marks)

(e) Based on the given monthly returns date from July 2007 to June
2017 and using AORD returns (from Section A of the assignment)
as the benchmark calculate the annualised tracking error (%)
of Portfolio_A, Portfolio_B and Portfolio_C, to two (2) decimal
place. Compare three portfolios based on the tracking error. (3
marks)

Note: Use standard deviation method.

(f) Based on the given monthly returns date from July 2007 to June
2017 and using AORD returns as the benchmark calculate the
information ratio (%) of Portfolio_A, Portfolio_B and Portfolio_C, to
two (2) decimal place. Compare three portfolios based on the
information ratio. (3
marks)

(g) Discuss the advantages and disadvantages of information ratio
for measuring portfolio performance. (2
marks)

Criteria-based marking guide for Question
8(a)–(g)

Excellent (Mark range:
15.5–19 marks)

Satisfactory (Mark range:
9.5–15 marks)

Unsatisfactory (Mark
range: 0–9 marks)

• correct explanation of
risk and return considerations in portfolio construction and
identification of key portfolio theory and associated model

• correctly calculate
Sharpe ratios for three portfolios with a comparison

• correct identification
of advantages and disadvantages of Sharpe ratio

• correctly calculate
tracking errors for three portfolios with a comparison

• correctly calculate
Information ratios for three portfolios with a comparison

• correct identification
of advantages and disadvantages of information ratio

• mostly correct
explanation of risk and return considerations in portfolio
construction and identification of key portfolio theory and
associated model

• most correctly calculate
Sharpe ratios for three portfolios with a comparison

• mostly correct
identification of advantages and disadvantages of Sharpe ratio

• most correctly calculate
tracking errors for three portfolios with a comparison

• most correctly calculate
Information ratios for three portfolios with a comparison

• mostly correct
identification of advantages and disadvantages of information
ratio

• incorrect explanation of
risk and return considerations in portfolio construction and
identification of key portfolio theory and associated model

• incorrectly calculate
Sharpe ratios for three portfolios with a comparison

• correct identification
of advantages and disadvantages of Sharpe ratio

• incorrectly calculate
tracking errors for three portfolios with a comparison

• incorrectly calculate
Information ratios for three portfolios with a comparison

• incorrect identification
of advantages and disadvantages of information ratio

Insert your answers to
Question 8(a)–(g)

End of answers to Question 8(a)–(g)

End of
Assignment

The post Quantitative Applications in Finance (FIN201) appeared first on My Assignment Online.

Plagiarism Free Assignment Help

Expert Help With This Assignment — On Your Terms

✓ Native UK, USA & Australia writers ✓ Deadline from 3 hours ✓ 100% Plagiarism-Free — Turnitin included ✓ Unlimited free revisions ✓ Free to submit — compare quotes

admin

Academic writer and editor at BestWriters.

Get your paper off your plate tonight

Post your instructions for free. Prices start at $5 per page.

Place an order