Open Always
Email: Call Now! +1-315 515-4588
Open Always
Email: Call Now! +1-315 515-4588

Business Studies Assignment on Quantitative Finance

Assignment Writing Help

This assignment question was recently posted by one of our customers and shared with our professional writers. If you are looking for assignment help on this topic or similar topic, click on ORDER NOW button to submit your details. Once we have your order details, your assignment will be assigned to one of our best writers, who will then proceed to write your paper and deliver it within your specified deadline. Thank you for choosing us today!

Business Studies Assignment on Quantitative Finance

Module Title: Quantitative Finance
Module Code: NBS-7047B
Reassessment Question
Part A: Diversification (500 words)
What do we mean by โ€˜diversificationโ€™ and why is it important for investors? (20 marks)
Part B: Optimal Capital Allocation (2,500 words)
You are an investment analyst in a large financial institution. A client enquires about a potential investment in
Apple Inc. and Inc. Her investment budget is $1,000,000 and her utility (U) has the form:
๐‘ˆ = ๐ธ๐‘ฅ๐‘๐‘’๐‘๐‘ก๐‘’๐‘‘ ๐‘…๐‘’๐‘ก๐‘ข๐‘Ÿ๐‘› โˆ’
โˆ™ ๐‘…๐‘–๐‘ ๐‘˜ ๐ด๐‘ฃ๐‘’๐‘Ÿ๐‘ ๐‘–๐‘œ๐‘› ๐‘“๐‘Ž๐‘๐‘ก๐‘œ๐‘Ÿ โˆ™ ๐‘‰๐‘Ž๐‘Ÿ๐‘–๐‘Ž๐‘›๐‘๐‘’
Using a profile investment questionnaire, you determine that the client is conservative with respect to risk
since her risk-aversion factor (A) is equal to 10. You are required to undertake a thorough investment analysis
in order to propose the optimal capital allocation for the client. Your analysis, along with your final
recommendation, should be presented in a comprehensive report.
Section 1: Download from Yahoo! Finance ( the monthly dividend-adjusted
prices for Apple Inc. (Symbol: AAPL) and Inc. (Symbol: AMZN) for the most recent 5-year period
(i.e., 60 monthly observations). Plot the stock price evolution for both firms on the same graph and comment
on each firmโ€™s performance (Figure 1). Calculate the monthly period returns for both stocks; plot them on the
same graph and comment on each firmโ€™s risk (Figure 2). Plot the scatter diagram of the two stock returns, add
the trend line and display its equation on the graph (Figure 3). What can you infer with respect to the
relationship between the two stock returns? Calculate for both return series descriptive statistics (mean,
median, skewness, kurtosis, variance and standard deviation), their covariance and correlation factors (Table
1). What is their meaning from both a statistical and financial perspective? (20 marks)
Section 2: Construct the investment opportunity set for the two stocks using 1% weight increments and plot
the efficient frontier (Figure 4). Assuming an annual T-Bill rate of 10% calculate also the Sharpe ratio for each
weight combination (Table 2). What is approximately the weight combination for the minimum-variance
portfolio and what for the optimal risky portfolio? (20 marks)
Section 3: Using the โ€˜Solverโ€™ add-in in Microsoft Excel find the exact weight combination for the minimumvariance portfolio and the optimal risky portfolio. Indicate the position of both portfolios on the efficient
frontier; draw the minimum-variance capital allocation line (CAL) and the optimal CAL, add their trend lines
and display their equations on the graph (Figure 5). What is the key difference between these two CALs? For
what kind of investor will you propose the minimum-variance CAL? What is the slope of the optimal CAL? What
is the intercept of both CALs? (20 marks)
Section 4: Using the โ€˜Solverโ€™ add-in in Microsoft Excel find the exact optimal capital allocation and identify the
complete portfolio on the optimal CAL (Figure 6). If the risk-aversion factor for your client was 20 instead of
10, would the optimal capital allocation portfolio โ€˜moveโ€™ towards the left or towards the right relative to the
current position on the optimal CAL? According to your analysis, what is the proportion of your clientโ€™s
investment budget (in both % and $) that should be allocated in T-Bills, Appleโ€™s stock and Amazonโ€™s stock
(Table 3)? (20 marks)
Specific guidelines:
๏‚ท The report should be typed in Microsoft Word using Times New Roman font with a size of 12 points;
use normal margins (2.5cm on top, bottom, left and right); line spacing must be 1.5 lines with an extra
line between paragraphs and headings; alignment must be justified. All sections, tables and figures
must be clearly titled and sequentially numbered. All tables and figures should be self-explanatory and
should include necessary axis definitions and legends. Numbers in the text, tables and figures should
have a reasonable number of decimal points in order to allow an accurate representation and
comparisons (usually between 2 and 4 decimal points).
๏‚ท The report should not exceed 3,000 words in total (500 words for Part A and 2,500 words for Part B)
and should be structured following the parts and sections above.
๏‚ท For Part B, each section should include details about the data used and of your calculations (e.g.
formulas used). Also, you should include as a minimum the figures and tables suggested in the
description of each section above. Moreover, all calculations should be performed using Microsoft
Excel in a single workbook with multiple worksheets. You should upload the Excel file along with the
Word (or pdf) file containing your report with your submission. You will lose 40 marks for not
uploading the Excel file.
๏‚ท Include at least 5 references to articles in credible professional magazines, academic journals and/or
textbooks. Do not include articles that you do not cite within your report or that you have not at least
partly read. Do not use material that exists exclusively on the Internet (e.g., websites and blogs) or
module lecture notes/slides as sources in your references.
Word Length: 3,000
Submission Details
The deadline for submission for all reassessment coursework is 15:00 on 10 September 2020.
The assignment will be submitted electronically via e:Vision or Blackboard; there will not be an option to
submit a hard copy. Even late assignments, or those that have extensions, should be submitted electronically
rather than in paper format. Work uploaded after 15:00 on the specified deadline day will incur a late penalty
unless there is an approved extension. Students are advised not to leave it to the last few minutes before
15:00 to upload work, just in case they encounter any upload problems.
Electronic submission will be by PDF and for those submitted via e:Vision, printing will be in black and white
unless your Module Organiser has indicated otherwise. As part of the upload process, a coversheet will be
automatically attached to your work before the work is printed out.
Students will need to fill in the following on the e-cover sheet:
1. Add in the markerโ€™s name where they have been asked by their lecturer to do so.
2. Students should add in the Word Count for their piece of work, including the footnotes and
endnotes, references (in the main text), tables and illustrations and if applicable the abstract, title
page and contents page. Any appendicised material and the bibliography or reference list should
not be included in the word count.
3. Students should also apply their Specific Learning Difficulty (SpLD) e-sticker, if appropriate
Where your module is being marked via Blackboard, please go to the module Blackboard site and submit your
work via Reassessment 19-20, in the left hand column. General instructions regarding Blackboard submissions
can be found here.
How will you know where to submit your work?
Your coursework submission page on the portal will tell you. If there is a link to submit directly from the page,
this means you are submitting via e:Vision. If there is an instruction beside the assessment item saying โ€˜work
to be submitted via Blackboardโ€™, then you must go to the module Blackboard site. If in doubt, please contact
your hub immediately to check.
University Policy on Plagiarism and Collusion
It is important that all students familiarise themselves with the rules and regulations regarding plagiarism and
collusion. Understanding these rules will help you to avoid plagiarism and to maintain the quality of your
academic work.
The current rules and regulations can be found here.
Information and support on how to avoid plagiarism can be found in
Individual study skills support and advice on referencing is also provided by the Learning Enhancement Service
at the Dean of Students Office.
You may be requested to provide a digital copy of your coursework (after an initial examination of the hard
copy by the coursework assessors) for use with plagiarism detection software. Instances where plagiarism is
suspected will be investigated. Students who are found to have plagiarised will be penalised.
In proven cases offenders will be punished and the punishment may extend to degree failure, temporary
suspension or expulsion from further study if the case comes before a Discipline Committee of the University.
Coursework Deadlines
All reassessment coursework must be submitted by 15:00 on 10th September 2020. Failure to submit on time
without an approved extension will result in a penalty for late submission.
Please note that the deadline represents the last time that a piece of work can be submitted, and not a target.
You are advised to plan ahead, and submit work well in advance of the deadline. This will help to ensure that
any last minute delays do not result in late submission.
Extensions to Coursework Deadlines
In exceptional circumstances, you may be entitled to request an extension to a deadline for the submission of
work required for assessment. Requests for coursework extensions should be applied for online via eVision
together with appropriate supporting evidence.
Extension requests can be submitted on the following grounds:
๏‚ท Medical (subject to a doctorโ€™s note)
๏‚ท Serious personal issues (subject to supporting evidence)
Extension requests cannot be considered for the following:
๏‚ท Poor time management
๏‚ท Transport or parking delays
๏‚ท IT problems (unless evidence can be provided from an IT technician)
๏‚ท Medical or personal circumstances that are not accompanied by supporting evidence
You should plan your work so that minor delays do not prevent submission on time. In all cases, you should
ensure that you make regular backup copies of all coursework in progress.
Where extenuating circumstances prevented you from applying for an extension in advance of the deadline,
work submitted after the deadline should be accompanied by an online extension application. Allowance will
be given for acceptable extenuating circumstances and in such cases penalties for late submission will not be
Extension requests will be considered by the Coordinator in those instances where acceptable extenuating
circumstances exist and the request is submitted before the deadline. The designated member of academic
staff in the School will consider all other requests.
Penalties for Late Submission
If you submit coursework after the published deadline, without an approved extension, the following penalties
will apply:
Work submitted Marks deducted
After 15:00 on the due date and before 15:00 on the
day following the due date. (Up to 24 hours)
10 marks
After 15:00 on the second day after the due date
and before 15:00 on the third day after the due
date. (Up to 72 hrs)
20 marks
After 15:00 on the third day after the due date and
before 15:00 on the 20th day after the due date.
(Over 72 hrs)
All the marks the work merits if submitted on time (i.e.
no marks awarded.)
After 20 working days Work will not be marked and a mark of zero will be
Late submission of pass/fail marked work for assessment in the absence of acceptable extenuating
circumstances will be awarded a fail mark.
Saturdays & Sundays will not be taken into account for the purposes of calculating marks deducted.

Academic Writing Help

All writing formats, 24/7 customer support via live chat, email or phone number, and timely delivery guaranteed.

Are you looking for homework writing help? Click on Order Now button below to Submit your assignment details.

Homework Writing Help
We Can Help you with this Assignment right now!

Are you looking for homework writing help on this topic? This question was posted by one of our client seeking homework help.ย  If you are therefore looking for an assignment to submit, then click onย ORDER NOW button or contact us today. Our Professional Writers will be glad to write your paper from scratch, and delivered within your deadline. Perfect choice for your excellent grades!


We ensure that assignment instructions are followed, the paper is written from scratch. If you are not satisfied by our service, you can either request for refund or unlimited revisions for your order at absolutely no extra pay. Once the writer has completed your paper, the editors check your paper for any grammar/formatting/plagiarism mistakes, then the final paper is sent to your email.

Privacy| Confidentiality

We do not share your personal information with any company or person. We have also ensured that the ordering process is secure; you can check the security feature in the browser. For confidentiality purposes, all papers are sent to your personal email. If you have any questions, contact us any time via email, live chat or our phone number.

Our Clients Testimonials

  • I appreciate help on the assignment. It was hard for me but am good to go now

    Impact of pollution on Environment
  • Am happy now having completed the very difficult assignment

    Creative Message Strategies
  • Your writer did a fine job on the revisions. The paper is now ok

    Ethics: Theory and Practice
  • The paper was so involving but am happy it is done. Will reach you with more assignments

    Title: Privatization in or of America
  • I expected perfection in terms of grammar and I am happy. Lecturer is always on our head but was pleased with my paper. Once again, thanks a lot

    Title: Bundaberg Inquiry
  • The paper looks perfect now, thank to the writer

    Health Care Systems
  • You helped me complete several other tasks as you handled paper. wonna thank you

    Critique Paper on Political Change

Related Articles

Religious studies Research Paper Assignment on The Quakers branch of Christianity.

Religious studies Research Paper Assignment on The Quakers branch of Christianity.
Read More

Describe one challenge that project managers face when executing information technology projects.

Describe one challenge that project managers face when executing information technology projects.
Read More

Get more from usโ€ฆ

Would you like this sample paper to be sent to your email or would you like to receive weekly articles on how to write your assignments? You can simply send us your request on how to write your paper and we will email you a free guide within 24-36 hours. Kindly subscribe below!

Email Address: