# Order 191709 financial analysis of five companies edited

1
Financial Analysis of Five Companies
Student’s Name
Department, University Affiliation
Course Code: Course Title
(Dr.) Professor’s Name
May 31, 2022
2
Financial Analysis of Five Companies
Economist Harry Markowitz introduced the Theory of Modern Portfolio (MPT) in 1952.
This theory was concerned with properties of the return from the alternative vehicles of
investment. Portfolio Portfolios allude to a group of financial instruments like stocks, cash, and
bonds. Investors’ factors for the portfolio include risk tolerance, time, and personal investment
objectives or motivation. The financial managers control these portfolios to achieve the
appropriate allocation of the risk-return portfolio. The two types of risk in the MPT include
diversified and undiversified risks.
The diversified risks are the unsystematic risks reduced through appropriate
diversification, and they concentrate on an individual stock. The basic procedures approached in
MPT include valuation of security, which involves describing the universe assets based on
expected return and the expected risks. Another procedure is the decision of assets allocation,
determining how the assets should be distributed among the investment classes like stocks and
bonds. The third procedure is optimizing the portfolio by reconciling the risk and the return when
selecting securities, like determining the securities portfolio providing the best-expected return
for the specific level of the expected risk. The last procedure is diversified and the undiversified
risks.
3
Boeing Company
4
Pfizer
5
Monster Beverage Corporation
6
JP Morgan Chase
7
Old Dominion Freight Line
8
9
Mean, Variance, and Standard Deviation of every security’s annual return rate.
Mean gives the statistical measure for the central value for the data over a specific period.
It is shown in the excel function as average.
Variance entails the measure of the volatility measuring the quantity in which the stock
deviates from the mean. When the variance is high, more stock fluctuates. When the variance is
high, more risks are linked to the stock. In the excel function, it uses the formula VARP.
Standard Deviation entails the square root of the variance to measure the variance
between the set of values. The low standard deviation value denotes less variation, and data in
the dataset are close to the mean. The excel function is SQRT (Variance).
Calculation of correlation coefficient between these five companies
All five companies had a positive correlation coefficient value, which signals that they all
have a strong positive correlation.
Percentage of initial investment
The percentage of five securities weight for the initial investment I allocated was as
follows:
Old Dominion Freight Line 20%
JP Morgan Chase 15%
Monster Beverage Corporation 20%
Pfizer 35%
The Boeing Company 10%
In more than the two securities, the covariance is calculated using matrix algebra. The
matrix manipulations are done with a few functions like “MMULT (…) and TRANSPOSE (…).
It involved using the variance-covariance formula to calculate portfolio return and the portfolio
10
variance. After calculating the portfolio variance, the standard Deviation or the portfolio’s
volatility is calculated through the square root of the variance. The excel sheet formula shows the
portfolio return and the portfolio variance. It also shows the portfolio standard deviation and
portfolio CV.
Combination of weights that minimizes CV of portfolio
11
In this section, the Markowitz portfolio model was used to determine the minimum
variance portfolio for the specifically targeted return rate using the Solver function in excel.
After Solver has been launched, the target cell is set to minimize. It is the cell for storing the
portfolio standard deviation. The portfolio standard deviation is minimized by changing the
portfolio weights. Thus, the portfolio weight for each company is unique.

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
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.
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend