# Finance Assignment | Professional Writing

You are required to construct an investment portfolio containing of investments in 5 Australian companies, chosen from stocks listed in the S&P/ASX 200. Moreover, you are required to graph two estimated efficient frontiers for your portfolio.

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

To complete your graphs, you are required to determine estimated expected returns, standard deviations and correlations of the 5 stocks in your portfolio. In order to complete this task, you should go to http://au.finance.yahoo.com/ (Links to an external site.). Click on ‘S&P/ASX 200’ and then on ‘Components’. Then select 5 companies, with a view to building a reasonably well diversified portfolio. For each company, go to ‘Historical Data’ and obtain monthly data covering the most recent 24 months up to and including the end of February 2020 (March 1 2020 data – your first adj. closing price will be March 1 2018).

For each month, estimate the monthly holding period return as the ratio of Adj. Close Prices for that month/Adj Close Price for the previous month, minus 1.

You will have a sample (size 24) of monthly returns for each of your 5 companies, covering the same two year period.

(a)        Using the Solver function in Microsoft Excel, determine the optimal weights for each stock in your portfolio across an appropriate set of monthly expected returns and graph

Save Time On Research and Writing
Hire a Pro to Write You a 100% Plagiarism-Free Paper.

(i)         the unrestricted efficient frontier.

(ii)        the restricted efficient frontier .

(b)        Explain the sense in which your frontiers can be described as ‘efficient’, and the difference (if any) between your restricted and unrestricted efficient frontiers. Which is the more efficient?

(c)        Suppose you are able to borrow or lend limitless amounts of at a certain rate of interest. Illustrate and explain the implications for the efficient frontier, and also for portfolio selection decisions where investors have the same information but differing degrees of risk aversion. No calculations are necessary in this section.

(d) Suppose the rate of interest on borrowing is higher than the rate of interest at which you can lend. Illustrate and explain the implications for the efficient frontier, and also for portfolio selection decisions where investors have the same information but differing degrees of risk aversion. No calculations are necessary in this section.

(e)       With reference to your research

(ii) Identify one key limitation of your analysis.

Get Finance homework help today

Calculate the price
Pages (550 words)
\$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Statistics
Thank you for doing great work.
Customer 462485, June 3rd, 2022
SEO
This was a job well done
Customer 463679, April 20th, 2023
Environmental studies and Forestry
Excellent work.
Customer 458115, May 2nd, 2022
Health Care
It is exactly my expectation. Thank you.
Customer 454755, June 30th, 2020
SEO
Great job
Customer 463961, May 13th, 2023
Other
Although I did not receive my paper on time, the customer care team ensured that I would receive a quality paper. I am pleased with the revision of this paper.
Customer 452455, March 2nd, 2023
Accounting
the first time around paper was very poor and plagiarized according to grammaly with the help of online support it was reassigned and improved greatly
Customer 453819, February 20th, 2020
IT
Customer 463245, November 16th, 2022
Good analysis and computation,
Customer 463053, July 9th, 2022
Construction Management
Impressive
Customer 463153, July 14th, 2022
Thank you!
Customer 453187, January 11th, 2022
Film & Theater studies
Good work.
Customer 462687, July 4th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend