# 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.

Don't use plagiarized sources. Get Your Assignment on
Finance Assignment | Professional Writing
Just from \$13/Page

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

(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

Pages(550 words)

Approximate price:-

## Why Choose Our Assignment Writing Services

### Quality Homework Papers

We aim at 100% customer satisfaction. As such, we never compromise on the quality of our assignment services and strive to maintain the highest standards of work for all our clients. Our writers craft each paper carefully to match the requirements on the instructions form while at the same time being surgical and objective while handling client work.

### Professional Homework Help

We receive many applications from writers around the world daily. Nevertheless, we only choose the cream of the crop to tackle your “help with homework” requests. Hence, our homework helpers are highly-qualified individuals who adhere to our quality policy.

### Affordable Homework Help Services

We maintain a fair pricing policy for all our homework help services. Our pricing system generates quotations based on the requirements of each paper. Hence regardless of the complexity or duration of a paper, our system determines the most accurate and pocket-friendly price for all our clients.

### On-Time Assignment Delivery

At MyHomeworkWriters, we guarantee all students swift delivery of their assignments. We understand that time is an essential factor in the academic world. We, therefore, ensure that all assignments are delivered on or before the agreed deadline. This leaves room for editing to incase the client wants changes done to the work delivered by our writers.

### 100% Original Assignment Papers

We maintain a zero-plagiarism policy in all our papers. Our writers stick to the instructions to deliver plagiarism-free work. Other than that, they extensively research the work they are handling and are keen to avoid any chance of similarities with previously written papers. Our editors check every completed work to ascertain it’s at the set standards.

Our main objective is to assist you through every step of your academic journey. Thus, we completely understand that you might run into trouble once in a while when interacting with our system. If you do run into trouble, please get in touch with our support agents and they will immediately provide you with assistance. Feel free to contact us via the Chat window or email us.

## How myhomeworkwriters works?

Fill in the order form and provide all details of your assignment.

### 2). Proceed with the payment

Choose the payment system that suits you most.

### 3). Track Progress

You will be able to track the progress of your paper from our system.

## Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
\$0.00

## Our Assignment Services

Myhomeworkwriters holds a reputation for providing high-quality assignment writing services. You only need to give us all the requirements for your “do my homework” order, and our writers will give you the best results.

### Research Services

Our team is skilled and equipped in searching for information required to complete work handed over to them. Regardless of the complexity of the work, we are determined to get the job done. Extensive research when handling client requests makes it possible for us to be able to stick to the boundaries and guidelines set by the clients. Thus enabling us to keep the work original and plagiarism free.

### Writing Services

We have highly qualified writers to assist you whenever you place in "help with my homework" order. Our essay writing service is designed to not only help students get good grades but also excel in their studies. Our writers are highly experienced and educated specialists and professionals who want to do more than creating a difference in the academic field.