Order custom papers, masters thesis and dissertation in 3 guided steps; human written!
Posted: December 16th, 2022
i need this project done in the next 8hrs
Looking for reliable dissertation help or thesis writing? Our expert team of MPhil and PhD-qualified professionals provides top-notch online assistance for dissertations, research papers, and essays—free from errors, plagiarism, and hidden fees. We select each specialist based on their academic expertise, ensuring high-quality thesis writing and research paper support. Beyond writing, we offer personalized guidance, one-on-one doubt-clearing sessions, and free study resources. Whether you need instant dissertation help or long-term research paper support, our experts are ready to help you succeed.
a sample project is attached the data is different so dont copy
if wrongly done or late be sure i will dispute
bid only if you can handle
Our custom dissertation help and thesis writing services meet your unique requirements. Unlike companies using pre-written content, we craft every dissertation, research paper, or essay from scratch based on your specific instructions and grading rubric. A subject-specialized writer will deliver a well-researched dissertation or thesis tailored just for you. Beyond essays, our academics and scholars offer PowerPoint presentations, cover letters, editing, tutoring, and business reports—comprehensive dissertation help and research paper support for all your academic needs.
Completing dissertations or research papers can be overwhelming, but expert dissertation help and thesis writing are smart ways to improve your grades. Our platform connects you with top-rated tutors in education, law, and nursing, offering high-quality research paper support and sample resources. Working with experienced professionals enhances your dissertation or thesis writing, boosting confidence in your coursework—at affordable fees. Sign up today for instant dissertation help, research paper guidance, and stress-free learning!
You will find an Excel workbook called AssignmentData.xlsx which is needed to
complete this assignment. It contains weekly index data for five asset classes and one
in-dividual asset (Gold).
Due to the reputation of “Education Institution of America” for producing work-ready
graduates, you are head-hunted by a small asset management company to work parttime
as a portfolio manager whilst you complete your degree.
It is your first day on the job and your boss is keen to see how much you really know. She
provides you with a list of five asset classes and tasks you and your team to investigate the
efficient asset allocation between these asset classes. Moreover, you are asked to satisfy a
17% expected return target on the portfolio you construct. To get started you decide to
collect historical performance data for the last five years in order to estimate the expected
return and variance-covariance structure of the asset classes (the data in the Excel file).
To perform the asset allocation you decide to construct a minimum variance portfolio. You
recall the 17% expected return target imposed by your boss and note that there was no
mention of short-selling constraints. In order to construct this portfolio you should copy the
assignment data into an Excel workbook and perform the following tasks/answer the
following questions:
1. (a) Transform the index values into simple weekly returns (you do not need to
report these in your submission).
(b) Using the returns data, estimate (and report) the vector of expected returns for
the five asset classes, as well as the variance-covariance matrix of these returns.
These expected returns etc. should be annualized (i.e., in annual units).
(c) Report which of the asset classes are efficient and which are inefficient. For each
of the inefficient asset classes, find another asset class that dominates it.
(d) Compute and report the parameters A, B, C and .
(e) Construct and plot the MVS (with short sales allowed) for expected (annual)
returns ranging between −10% and 35%. Your figure should also indicate the
positions of the five asset classes.
(f) Identify the global minimum variance portfolio (MVP), i.e. report the portfolio
weights (in the five asset classes), expected return, and variance of the MVP.
(g) Determine and report the portfolio weights for the efficient portfolio with 17%
expected return.
2
You are eager to impress so you send the results to your new boss just before you
leave for your lunch break. Upon your return, the boss has looked at your report and
notes that the risk of the portfolio is a little higher than she expected and wondered if
adding an additional asset would help reduce the risk. Knowing all about diversification,
you suggest that maybe adding an asset that has a low correlation with the existing five
asset classes might help. “Gold!”, your boss exclaims. You have heard many stories
about gold being a great diversifier and so you offer to do the analysis again with the
additional asset (gold) included in the portfolio. Using the additional gold index data in
the Excel spreadsheet, perform the following tasks:
2. (a) Using the same methodology as in Question 1 (simple returns etc.),
reconstruct the vector of (annual) expected returns and the variancecovariance
matrix for the five asset classes plus gold (i.e., six assets in total).
(b) Compute and report the new A, B, C and parameters.
(c) Construct and plot the new MVS (with short sales allowed) for expected (annual)
returns ranging between −10% and 35%. You should also plot the MVS from
1.(e) for comparison and indicate the positions of the five asset classes and gold.
(d) Identify the new global minimum variance portfolio (MVP), i.e. report the port folio
weights (in the six assets), expected return, and variance of the MVP.
(e) Determine and report the new portfolio weights for the efficient portfolio with
17% expected return.
(f) Calculate and report the reduction in risk of the 17% returning efficient
portfolio that can be achieved by adding gold to the portfolio.
You inform your boss of these findings and she is happy with the addition of gold to the
portfolio and the reduction in risk. However, she informs you that the 15% returning
portfolio you have constructed is not as ‘efficient’ as it might be as you have forgotten all
about the risk-free asset... oops! You quickly do some research and determine that the
appropriate risk-free rate to use is 1% per annum. Perform the following tasks to adjust
your portfolio weights:
3. (a) Construct and plot the MVS (with short sales allowed) for the five asset
classes and gold plus the risk-free asset paying 1%.
(b) Identify the tangency portfolio, i.e. report its portfolio weights, expected return,
and variance of returns. Furthermore, illustrate its tangency property
graphically by plotting the MVS from 2.(c) on the same set of axes.
(c) Determine and report the new portfolio weights for the efficient portfolio with
17% expected return.
(d) Calculate and report the reduction in risk of the 17% returning efficient
portfolio that can be achieved by adding the risk-free asset bond to the
portfolio of six risky assets.
3
A little embarrassed from your mistake of not including the risk-free asset, you send the new
updated results to your boss at 4:50pm. She is impressed with your efficiency as well as the
efficiency of the portfolio. However, she hasn’t quite finished with you just yet! She is
worried about the need to short sell certain asset classes in the currently proposed
portfolios. Many of the firm’s clients do not like, and some do not allow, short selling in their
portfolios. Therefore, your boss wants you to investigate the effect a no short sales
constraint will have on the MVS without a risk-free asset and any subsequent investment
decisions. To do this you are asked to perform the following tasks:
4. (a) Construct and plot the risky asset only MVS with no short sales allowed for
the five asset classes plus gold. (Recall you will need Solver to do this.)
(b) Plot the MVS for the unconstrained problem—found in 2.(c)—on the same set
of axes. Also, indicate the positions of the five asset classes plus gold.
(c) List the portfolio weights for all the data points used in constructing your no
short sales allowed graph.
(d) Identify and report the range of expected returns for which the short sales
con-straint is not binding.
(e) Discuss the compositions of the portfolios at the end-points of the MVS with
no short sales.
4
You Want Quality and That’s What We Deliver
We’ve put together our writing team with care, choosing talented writers who shine in their fields. Each one goes through a tough selection process, where we look for folks with deep expertise in specific subjects and a solid history of academic writing. They bring their own mix of know-how and flair to the table, making sure our content hits the mark—packed with info, easy to read, and perfect for college students like you.
We don’t do AI-written essays or copycat work—everything’s original. Competitive pricing is a big deal for us; we keep costs fair while delivering top-notch quality. Our writers are some of the best out there, and we charge rates that stack up well against other services. This means you get stellar content without draining your wallet. Our pricing is straightforward and honest, built to give you real value for your money. That’s why students turn to us for high-quality writing services that won’t break the bank.
Academic integrity is at the heart of what we do. Every paper starts from scratch, with original research and writing tailored just for you. We write 100% authentic—no plagiarism research essays. Our strict quality control process includes scanning every draft with top tools like SafeAssign and Turnitin, so you get a similarity score and proof of originality. We’re obsessive about proper citation and referencing too, crediting every source to keep things legit. It’s all about giving you peace of mind with content that meets the highest standards.
When you decide to place an order with Dissertation Writer, here is what happens: