Professional Assignment 2

profileKnowledgeSeeker1
PA2_439627_31901120.docx

APPLE 1

APPLE 2

Apple – Financial Statement

Name

University

Financial Management

Prof

December 2020

Apple

The most important stakeholders of a company are their investors. Investors could be someone who is part of the company where they actually serves a purpose or it could be just a person who wants to be a part of the company but every investor usually always do a research on their own about the company they intend to invest in. Cash flow, income statement and balance sheet are most important financial statements of a company that an investor can use to get insights about it. Having such insights helps the investors make a better decision on their investment plan and can help calculate the rate of return on their investment over a period of time. (Crawford, n.d.)

We have three important financial statements, income statement, cash flow and the balance sheet for the Apple inc. (Please refer appendix section). We have the historical data of Apple Inc. and we will now be using adjusted closing values in order to calculate the rate of return for the past 20 years. (Please refer financial statement IV under appendix section). Once we have the close price for past 20 years, all we have to do in put those values into our formula in order to calculate the rate of return. This is one of the very important aspect as an investor, as it helps them understand if the company is making profits or surviving losses. And this eventually helps them make decision on whether to invest or not in a particular company. (Beattie, 2020).

Formula:

ROI = Final Value of Investment – Initial value of investment / Cost of investment * 100

The above formula helps the investor calculate the profit/loss percentage based on the investment done towards a company. It is very well known that the higher the percentage value, higher the profits. Now plugging are values into the above formula:

ROI = [(444.46 – 0.92) / 0.92] * 100

= 48,210 %

The final percentage value states that the Apple Inc. has grown significantly in the last 20 years, with the return rate of 48,210% approximately. After looking at this data investors will be more inclined to make their investment in Apple Inc.

Beta is another important aspect; which investors consider before investing into any company. Beta helps the investor understand the risks that comes along with the stocks. If the value of Beta is more than one, then the returns are considered to be higher, but with higher returns comes higher risks. On the other hand, if the value of Beta is less than 1, then the returns are considered to be low, but with low risk as well. (Nickolas, 2019). In order to get the value of beta, we need to divide the value of convergence to its variance. Hence, for apple we get the value of beta as 1.29. And like I mentioned above, if the value of beta is higher than 1, then there are higher returns with higher risks. So, in this case too, Apple stocks have higher returns, but it comes with great risk.

Return on Annual rate of U.S. treasuries can be calculated using the value of beta. We need to calculate this rate as a risk-free rate hence we require U.S. treasury bond yield rate and the premium towards equity (Chen, 2019). Once we have all the intended values, we simply plug it into our formula:

Return = Yield rate + Value of Beta * Premium Equity

= (1.24 + 1.29) * 5.50

= 8.28 %

This 8.28% is the percentage of the risk-free returns that the investors will get by investing into U.S. national treasuries.

Debt is another important aspect that the investor needs to consider before investing into any company. If the company has an ample amount of debt, it won’t be a good idea to invest into such company unless they consider taking extremely high amount of risks. Cost of debt helps the investors get the insights of the company and its structure. By understanding the debt, the investors get to know the risk involved by investing in a particular company. This cost of debt is nothing but the average rate of interest that a company or a firm pays off against their debt. (Zarzycki, 2018). This cost of debt can be calculated by dividing expenses on interest paid to the tax amount subtracted by 1. We know for apple the interest amount is $3577 and the Tax rate is 1114365.

Cost of Debt = interest amount / (1 – Tax rate)

= 3.22 %

The percentage of cost of debt is only 3.22 % which is very low, and hence Apple Inc. can be a good company to do the investments for any investors.

Weighted average cost of capital (WACC) is nothing, but the analysis of company’s capital utilized on each of its equally distributed proportion of departments. WACC and Beta are inter-related where if the value of Beta goes up than the value of WACC goes up as well. On the other hand, if the value of Beta goes down then the value of WACC also goes down.

WACC = Equity / Debt + Equity * Re + Debt / Debt + Equity * Rd * (1 – T)

Where,

Re = Cost of Equity

Rd = Cost of Debt

T = Tax shield

Now, let’s calculate WACC for Apple inc.,

WACC = 7.16%

7.16% indicates a strong capital structure of apples each source.

After performing a bunch of calculations, I believe it is safe to say that the investors can invest into Apple Inc. as they can expect higher returns. Apple inc. also have a good future and will be a great investment opportunity for the investors.

Average Annual Rate of Return

We will now be calculating Average annual rate of return for 5 big companies. We will be calculating average annual rate of return for the year 2019 and 2020 (latest). You’ll find data related to average annual return for past 20 years in the Appendix.

Apple

We know that the Average price of Apple stocks in the year 2019 and 2020 were $208.2559 and $314.1174. (Apple inc., n.d.). Now in order to calculate the average annual rate of return, we use the following formula:

Average Annual rate of return = (Final stock price - Initial stock price) / Initial stock price

= 314.1174 - 208.2559 / 208.2559

= 0.5083

Hence, we get the final Average Annual rate of return as 0.5083, which is equivalent to 51%. It means that the apple had 51% of Average annual rate of return hike from the year 2019 to 2020.

Microsoft

Similarly, we know that the Average price of Microsoft stocks in the year 2019 and 2020 were $130.382 and $178.147. (Microsoft inc., n.d.). Now in order to calculate the average annual rate of return, we use the same formula as before:

Average Annual rate of return = (Final stock price - Initial stock price) / Initial stock price

= 178.147- 130.382 / 130.382

= 0.366

Hence, we get the final Average Annual rate of return as 0.366, which is equivalent to 37%. It means that the Microsoft inc. had 37% of Average annual rate of return hike from the year 2019 to 2020.

Walmart

Similarly, we know that the Average price of Walmart inc. stocks in the year 2019 and 2020 were $108.4054 and $120.8603 (Walmart inc., n.d.). Now in order to calculate the average annual rate of return, we use the same formula as before:

Average Annual rate of return = (Final stock price - Initial stock price) / Initial stock price

= 120.8603 - 108.4054 / 108.4054

= 0.114

Hence, we get the final Average Annual rate of return as 0.114, which is equivalent to 11%. It means that the Walmart inc. had 11% of Average annual rate of return hike from the year 2019 to 2020.

Marriot

Similarly, we know that the Average price of Marriot inc. stocks in the year 2019 and 2020 were $129.393 and $102.9254 (Marriot inc., n.d.). Now in order to calculate the average annual rate of return, we use the same formula as before:

Average Annual rate of return = (Final stock price - Initial stock price) / Initial stock price

= 102.9254 - 129.393 / 129.393

= -0.2045

Hence, we get the final Average Annual rate of return as -0.2045, which is equivalent to negative 20%. It means that the Marriot inc. suffered losses of 20% of Average annual rate of return from the year 2019 to 2020.

Coca Cola

Similarly, we know that the Average price of Coca Cola inc. stocks in the year 2019 and 2020 were $50.8279 and $49.4781 (Coca Cola inc., n.d.). Now in order to calculate the average annual rate of return, we use the same formula as before:

Average Annual rate of return = (Final stock price - Initial stock price) / Initial stock price

= 49.4781 - 50.8279 / 50.8279

= -0.0325

Hence, we get the final Average Annual rate of return as -0.0325, which is equivalent to negative 3%. It means that the Coca Cola inc. suffered losses of 3% of Average annual rate of return from the year 2019 to 2020.

To conclude I would say that the investors should consider all the above-mentioned aspects and factors before investing into any company. Companies with technologies are booming in today’s world. Especially due to this pandemic, all the major companies are going online, because of which some are making profits, and some are struggling to survive. I would say the best bet would be to invest in any IT company such as apple or google, who can survive and return profits even in the situations like COVID 19.

References

Apple Inc. Common Stock (AAPL). (n.d.). Retrieved on October 11, 2020 from https://www.nasdaq.com/market- activity/stocks/aapl

Apple Inc. (APPL). (n.d.). Retrieved on October 11, 2020 from https://finance.yahoo.com/quote/AAPL?p=AAPL Beattie, A. (June 1 , 2020). A Guide to Calculating Return on Investment (ROI). Retrieved on October 11, 2020 from https://www.investopedia.com/articles/basics/10/guide-to-calculating-roi.asp Chen, J. (June 25, 2020). Risk-Free Rate of Return. Retrieved on October 11, 2020 from https://www.investopedia.com/terms/r/risk-freerate.asp

Crawford, C. (n.d.). Purpose of Financial Analysis. Retrieved on October 11, 2020 from https://smallbusiness.chron.com/purpose-financial-analysis-59178.html Hargrave, M. (April 20 , 2020). Weighted Average Cost of Capital – WACC. Retrieved on October 11, 2020 from https://www.investopedia.com/terms/w/wacc.asp

Marriott International, Inc. (MAR). (n.d.). Retrieved on October 11, 2020 from https://finance.yahoo.com/quote/MAR?p=MAR&.tsrc=fin-srch

Microsoft Corporation (MSFT). (n.d.). Retrieved from on October 11, 2020 https://finance.yahoo.com/quote/MSFT?p=MSFT&.tsrc=fin-srch Nickolas, S. (June 11, 2019). The Formula for Calculating Beta. Retrieved on October 11, 2020 from https://www.investopedia.com/ask/answers/070615/what-formula-calculating-beta.asp

Ross, S. A., Westerfield, R. W., Jordan, R. D., (2018). Fundamentals of corporate finance (12 th ed.). McGraw-Hill

The Coca-Cola Company (KO). (n.d.). Retrieved on October 11, 2020 from

https://finance.yahoo.com/quote/KO?p=KO&.tsrc=fin-srch

Walmart Inc. (WMT). (n.d.). Retrieved on October 11, 2020 from

https://finance.yahoo.com/quote/WMT?p=WMT&.tsrc=fin-srch

Appendix

page2image24751904

Figure 1: Income Statement, Retrieved from Apple Inc. (APPL). (n.d.). https://finance.yahoo.com/quote/AAPL?p=AAPL

page3image24674304

page3image24674512

Figure 2: Balance Sheet, Retrieved from Apple Inc. (APPL). (n.d.). https://finance.yahoo.com/quote/AAPL?p=AAPL

page4image24883600

Figure 3: Cash Flow, Retrieved from Apple Inc. (APPL). (n.d.). https://finance.yahoo.com/quote/AAPL?p=AAPL

page5image24750448

Figure 3: Close Price

page7image24760176

Figure 4: Annual Rate of Return

page8image24677008

Figure 5: Annual Rate of Return

page9image24642992

Figure 6: Annual Rate of Return

page9image24644864

Figure 7: Annual Rate of Return

page10image25012176

Figure 8: Annual Rate of Return