Project Part 3
docx
keyboard_arrow_up
School
Bowie State University *
*We aren’t endorsed by this school
Course
001
Subject
Finance
Date
Jul 1, 2024
Type
docx
Pages
9
Uploaded by BarristerFreedomKookabura48
Project Part 3: Microsoft vs. Apple Bonds
Aniko McClendon
University of Maryland Global Campus
FINC 330-6883 Business Finance
Salma Asif
September 28, 2023
Introduction
Microsoft Corporation’s mission is to provide customers with technology that is consistent to their needs. They offer various products, that includes hardware devices, cloud-
based solutions like Office 365, operating systems, and software applications, which is were their revenue stems from along with online advertising. They are committed to providing excellent products and services to help customers meet their needs, while continuing to enhance their services effectively. The purpose of this project is to help my client invest in bonds and stocks that I think are best, there will be an investigation for the bond and stock performance for Microsoft Corporation and its competitor Apple Corporation, then evaluating both company’s data stock performance for Microsoft for the last 3 years and its competitor Apple for the last year. Recommendations will be made to help the company strategize for the for the future, these suggestions can also help with the financial leverage of the company to increase shareholder wealth, we must consider that Microsoft’s financial health when considering these changes.
Bond Performance
1.
2. For the first bond the last price was 99.65 and for the second bond the last price was 99.79. Assuming that par value of the bond is $1,000, the investor would pay $996.50 for the last
price for first bond. Because $996.50 x 1000/100 = 996.50. For the last price of the second bond,
it came to 997.90. Because 99.7 x 1000/100 = 997.90.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
3. Assuming that par value of the bond is $1000. The annual coupon interest payment for the first bond would be 33. Because the coupon rate is 3.300% x 1000 = 33. For the second bond the annual coupon interest payment would be 52. Because the coupon rate is 5.200% x 1000 = 52. In this case to get the annual coupon interest payment you must multiply the coupon rate times 1000.
4. Assuming that par value of the bond is $1000. The current yield of bonds for the first bond shown would be 3.31, to get the answer you must divide the annual coupon interest payment by the last bond price which would be 33/996.5 = 3.31. For the second bond the current yield of bonds would be 5.21, 52/997.90 = 5.21.
5. According to the Business Insider website the YTM for the first bond is 5.03% and for the second bond the YTM was 5.10%
6. a. If I were to buy a bond issued by Microsoft, the bond that I would choose is the second bond and that is because even though it cost a little over a dollar more to purchase compared to the first bond, the second bond has a higher coupon interest payment which came to 52, in comparison to the first bond which was 13 lower, coming in at 33. The current yield of bonds for
the second bond came in higher than the first bond as well by 1.90. And last reason as to why I think the second bond would be the best one to buy is because the YTM was 0.07% percent
higher than the first bond as well.
b. Both bonds are callable since they can be paid to client before the maturity date. I think that in
this case I will change my decision to buy them, even though with callable bonds you can get redeem them earlier than the mature date, Microsoft still has the right to pay the pre-agreed value. I think that it would be safer to have a non-callable that way you are certain to get the full bond amount.
c. For both bonds, S&P Investors rating is AAA, Moody’s investors gave the company a rating of Aaa. The purpose of a bond rating is to measure how trustworthy and responsible the company is financially and how well the company is with paying bonds on time.
d. If I was an investor who is looking for a bond to invest in, I would remain to invest in Microsoft, their financial health is persistent and based off their bond rating I trust them enough to make payments on time even though their bonds are callable.
e. Microsoft’s debt/equity ratios support my decision still because over the last three years has decreased. This means that the company has earned enough to not have to borrow from others over years. They may have been more responsible with paying off debt or strategized ways to increase revenue to outweigh debt owed which is good either way. Microsoft’s financial leverage
ratio however is a bit on the higher side, but improvement is shown over the past three years. Typically, a financial leverage ratio under one is consider acceptable, Microsoft’s ratio came to 2.55 but decreased slightly by 0.36 by 2022. This would be a cause of concern for potential Investors, but my stance still stays the same with my decision to invest into the company.
Market Ratios
Apple
2022
Price/Earnings ratio
21.27
Price/Cash Flow ratio
17.37
Price/Book ratio
40.62
Price/Forward Earnings
21.28
PEG ratio
2.53
Dividends per share
0.91
After reviewing the market ratio results for Microsoft and its competitor Apple. For Microsoft’s Price/Earnings ratio it increased by 1.75 to 37.62 then in 2020 it decreased by 12.11 to 25.51. In comparison to Apple in 2022 their ratio came to 21.27. This may mean that even though Microsoft’s ratio dropped, they still have higher growth regarding their earnings in comparison to Apple whose P/E ratio came to 21.27. For the Price/Cash Flow ratio, again Microsoft experienced some growth then another drop from 2021-2022 bringing the ratio to 20.56, while Apple’s ratio came to 17.37, in this situation both companies have a good ratio, which shows that they both generating cash flow well. For Price/Book ratio Microsoft’s ratio came to 10.29, the two years prior it was a slight decline, Apple’s ratio however came to 40.62, four times higher than Microsoft’s ratio this shows that their competitor may be overvalued. For Price/Forward earnings ratio Microsoft didn’t have a record for 2022 but looking at the previous years, I predict that their ratio would still be higher than Apple which came to 21.28. Regarding the PEG ratio, Microsoft didn’t have a record for 2022 here as well, while looking at them competitor’s ratio for 2022 which came to 2.53, but from looking at Microsoft’s previous years you can tell that their ratio wouldn’t be far from Apple. For the dividends per share ratio Microsoft’s ratio increased over the past three years to 2.54, while Apple’s ratio came to 0.91, Microsoft
2022
2021
2020
Price/Earnings ratio
25.51
37.62
35.87
Price/Cash Flow ratio
20.56
31.15
25.76
Price/Book ratio
10.29
16.60
13.60
Price/Forward Earnings
-
36.90
33.00
PEG ratio
-
2.87
2.57
Dividends per share
2.54
2.30
2.09
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
with their competitor’s ratio being so slow they don’t seem to be as competitive as Apple. Based upon Microsoft’s financial performance and sustainability explained, I think that common stockholders are receiving an adequate return on their investment, and I still find it reasonable to purchase stocks with the company.
Recommendations
After reviewing the results of my analysis for Microsoft, some specifics recommendations I must suggest help keep Microsoft in a positive financial standing would be to come out with a cost efficient but new hardware product, something that you haven’t produced before that would be helpful and useful for your consumer base to drive sales. I noticed that Microsoft is doing quite well will debt to equity my suggestion would be to stay consistent with paying off any debt, investors pay attention to factors like this when deciding a company to invest in. Another recommendation I would suggest is to reevaluate the cost of your products see where you may want to raise prices or lower them, sometimes when products are too costly it takes longer to sell that item however, when the cost for products are lower it might encourage more customers to buy it especially if the product or services is popular.
Reflection
After completing this assignment, I learned how every factor with a company’s previous
and current financial statements, valuation, dividends etc. are important things to research and investigate when deciding to invest into a company. I also learned that things could change financially as the world goes through changes everything is a chain reaction, so one year a company you decided to invest into could be performing very well and the next year you witness
a decline, these are situations you must be prepared for. How I could apply this to everyday life is first when I’m ready to make my own investments in the future I’ll have better knowledge regarding how to read financial statements and charts and being able to evaluate previous years to make better investment decisions. Another way I can use this in the future is when I start me own business, I’ll be able to evaluate my own financial charts to see where I may need areas for improvement or to show where I’ve excelled.
References
https://www.microsoft.com/investor/reports/ar13/financial-review/business-description/
index.html
https://markets.businessinsider.com/bonds/5_200-microsoft-bond-2039-us594918ad65?
miRedirects=1
https://markets.businessinsider.com/bonds/microsoft_corpdl-notes_201717-27-bond-2027-
us594918by93
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Related Documents
Related Questions
financial management ch 15 hw
please show work.
question 10
(EBIT-EPS analysis) Three recent graduates of the computer science program at the University of Tennessee are forming a company that will write and distribute new application software for the iPhone. Initially, the corporation will operate in the southern region of Tennessee, Georgia, North Carolina, and South Carolina. A small group of private investors in the Atlanta, Georgia area is interested in financing the startup company and two financing plans have been put forth for consideration:
• The first (Plan A) is an all-common-equity capital structure.
$2.5 million dollars would be raised by selling common stock at $20 per common share.
• Plan B would involve the use of financial leverage.
$1.1 million dollars would be raised by selling bonds with an effective interest rate of 10.6
percent (per annum), and the remaining $1.4 million would be raised by selling common stock at the $20 price per share.…
arrow_forward
GThda kahlo - Google Search
X O Frida Kahlo Flashcards Quizle x
O Cemputeh
nheducation.com/ext/map/index.html?_con%3con&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252
https://cdn.musc. E Individual Differen.
M
- Corporate Finance
4 SPAN101: Element..
Canvas Dashboard
Course Registration
Saved
Problem 12-11 Internal rate of return [LO12-4)
You buy a new piece of equipment for $31,706, and you receive a cash inflow of $4,200 per year for 17 years. Use Appendix D for an
approximate answer but calculate your final answer using the financial calculator method.
What is the internal rate of return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal
places.)
Internal rate of return
nces
Mill
MacBook Air
トト
吕口
F3
888
F4
F7
Fe
F9
F5
F2
@
2#
$
%
&
*
2
3
4
5
6.
7
8
W
R
T
Y
o
ーの
つ
arrow_forward
Learning
SE MINDTAP
evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆
lomework
6300.
1
mancial Lailuialvi vi a spicoubnicel.
Hide Feedback
Correct
X
f6
Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan
to make your first deposit one year from today.
a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent.
4
b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations.
Round your answer to the nearest cent.
6
Hide Feedback
Incorrect
F
Check My Work Feedback
Review the FVAN definition and its equation.
Q Search
Understand the difference between an ordinary annuity and an annuity due.
Be careful about the order of mathematical operations if using the equation.
If using a financial calculator, be…
arrow_forward
A4
arrow_forward
QUESTION 6
Which of the following statements would be part of a vision statement?
Company XYZ is a globally recognized financial institution providing
services now and in the future.
ABC Memorial Hospital provides an appropriate mix of services to the
residents of ABC region and surrounding areas.
BCD Company makes, distributes, and sells the finest-quality widgets.
To be the largest and most complete antique radio community site on the
Internet.
arrow_forward
Mini Case
Suppose you decide (as did Steve Jobs and Mark Zuckerberg) to start a company. Your product is a software platform that integrates a wide range of media devices, including laptop computers, desktop computers, digital video recorders, and cell phones. Your initial client base is the student body at your university. Once you have established your company and set up procedures for operating it, you plan to expand to other colleges in the area and eventually to go nationwide. At some point, hopefully sooner rather than later, you plan to go public with an IPO and then to buy a yacht and take off for the South Pacific to indulge in your passion for underwater photography. With these plans in mind, you need to answer for yourself, and potential investors, the following questions:
1. Briefly describe the use of stock options in a compensation plan. What are some potential problems with stock options as a form of compensation?
2. Briefly explain how regulatory agencies and legal…
arrow_forward
Business 123 Introduction to Investment
May I please have the solution for the following assignment?
Thank you so much,
arrow_forward
Please suggest me exactly 5 journal with author and url regarding this content:Financial Inclusion in Banking
Assesing the contribution of banking in promoting financial inclusion globallyAnalyzing the use of financial technology (fintech)to enhance accessto financial services
arrow_forward
Mini Case
Suppose you decide (as did Steve Jobs and Mark Zuckerberg) to start a company. Your product is a software platform that integrates a wide range of media devices, including laptop computers, desktop computers, digital video recorders, and cell phones. Your initial market is the student body at your university. Once you have established your company and set up procedures for operating it, you plan to expand to other colleges in the area and eventually to go nationwide. At some point, hopefully sooner rather than later, you plan to go public with an IPO and then to buy a yacht and take off for the South Pacific to indulge in your passion for underwater photography. With these issues in mind, you need to answer for yourself, and potential investors, the following questions.
What is an agency relationship? When you first begin operations, assuming you are the only employee and only your money is invested in the business, would any agency conflicts exist?
If you expanded and hired…
arrow_forward
Homework: Corporate Reporting X M Question 10 Homework.
o.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launch Url=https%253A%252F%252Flms.mheducation.com%252Fmghmiddlewar
Dorate Reporting and Analysis Problems...
X
Saved
Required information
[The following information applies to the questions displayed below.]
Raphael Corporation's balance sheet shows the following stockholders' equity section.
Preferred stock-5% cumulative, $ par value, 1,000 shares authorized, issued, and outstanding
Common stock-$ par value, 4,000 shares authorized, issued, and outstanding
Retained earnings
Total stockholders' equity
Total amount paid to the preferred shareholders
Total amount paid to the common shareholders
$ 75,000
100,000
400,000
$575,000
2. If two years' preferred dividends are in arrears at the current date and the board of directors declares cash dividends of $23,750,
compute the total amount paid to (a) preferred shareholders and (b) common shareholders.
arrow_forward
4
arrow_forward
None
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
Related Questions
- financial management ch 15 hw please show work. question 10 (EBIT-EPS analysis) Three recent graduates of the computer science program at the University of Tennessee are forming a company that will write and distribute new application software for the iPhone. Initially, the corporation will operate in the southern region of Tennessee, Georgia, North Carolina, and South Carolina. A small group of private investors in the Atlanta, Georgia area is interested in financing the startup company and two financing plans have been put forth for consideration: • The first (Plan A) is an all-common-equity capital structure. $2.5 million dollars would be raised by selling common stock at $20 per common share. • Plan B would involve the use of financial leverage. $1.1 million dollars would be raised by selling bonds with an effective interest rate of 10.6 percent (per annum), and the remaining $1.4 million would be raised by selling common stock at the $20 price per share.…arrow_forwardGThda kahlo - Google Search X O Frida Kahlo Flashcards Quizle x O Cemputeh nheducation.com/ext/map/index.html?_con%3con&external_browser=D0&launchUrl=https%253A%252F%252Flms.mheducation.com%252 https://cdn.musc. E Individual Differen. M - Corporate Finance 4 SPAN101: Element.. Canvas Dashboard Course Registration Saved Problem 12-11 Internal rate of return [LO12-4) You buy a new piece of equipment for $31,706, and you receive a cash inflow of $4,200 per year for 17 years. Use Appendix D for an approximate answer but calculate your final answer using the financial calculator method. What is the internal rate of return? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Internal rate of return nces Mill MacBook Air トト 吕口 F3 888 F4 F7 Fe F9 F5 F2 @ 2# $ % & * 2 3 4 5 6. 7 8 W R T Y o ーの つarrow_forwardLearning SE MINDTAP evo/index.html?deploymentid=60338517901669990751687760&elSBN=9780357517642&nbld=3626933&snap... ☆ lomework 6300. 1 mancial Lailuialvi vi a spicoubnicel. Hide Feedback Correct X f6 Quantitative Problem 1: You plan to deposit $2,200 per year for 6 years into a money market account with an annual return of 2%. You plan to make your first deposit one year from today. a. What amount will be in your account at the end of 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 4 b. Assume that your deposits will begin today. What amount will be in your account after 6 years? Do not round intermediate calculations. Round your answer to the nearest cent. 6 Hide Feedback Incorrect F Check My Work Feedback Review the FVAN definition and its equation. Q Search Understand the difference between an ordinary annuity and an annuity due. Be careful about the order of mathematical operations if using the equation. If using a financial calculator, be…arrow_forward
- A4arrow_forwardQUESTION 6 Which of the following statements would be part of a vision statement? Company XYZ is a globally recognized financial institution providing services now and in the future. ABC Memorial Hospital provides an appropriate mix of services to the residents of ABC region and surrounding areas. BCD Company makes, distributes, and sells the finest-quality widgets. To be the largest and most complete antique radio community site on the Internet.arrow_forwardMini Case Suppose you decide (as did Steve Jobs and Mark Zuckerberg) to start a company. Your product is a software platform that integrates a wide range of media devices, including laptop computers, desktop computers, digital video recorders, and cell phones. Your initial client base is the student body at your university. Once you have established your company and set up procedures for operating it, you plan to expand to other colleges in the area and eventually to go nationwide. At some point, hopefully sooner rather than later, you plan to go public with an IPO and then to buy a yacht and take off for the South Pacific to indulge in your passion for underwater photography. With these plans in mind, you need to answer for yourself, and potential investors, the following questions: 1. Briefly describe the use of stock options in a compensation plan. What are some potential problems with stock options as a form of compensation? 2. Briefly explain how regulatory agencies and legal…arrow_forward
- Business 123 Introduction to Investment May I please have the solution for the following assignment? Thank you so much,arrow_forwardPlease suggest me exactly 5 journal with author and url regarding this content:Financial Inclusion in Banking Assesing the contribution of banking in promoting financial inclusion globallyAnalyzing the use of financial technology (fintech)to enhance accessto financial servicesarrow_forwardMini Case Suppose you decide (as did Steve Jobs and Mark Zuckerberg) to start a company. Your product is a software platform that integrates a wide range of media devices, including laptop computers, desktop computers, digital video recorders, and cell phones. Your initial market is the student body at your university. Once you have established your company and set up procedures for operating it, you plan to expand to other colleges in the area and eventually to go nationwide. At some point, hopefully sooner rather than later, you plan to go public with an IPO and then to buy a yacht and take off for the South Pacific to indulge in your passion for underwater photography. With these issues in mind, you need to answer for yourself, and potential investors, the following questions. What is an agency relationship? When you first begin operations, assuming you are the only employee and only your money is invested in the business, would any agency conflicts exist? If you expanded and hired…arrow_forward
- Homework: Corporate Reporting X M Question 10 Homework. o.mheducation.com/ext/map/index.html?_con=con&external_browser=0&launch Url=https%253A%252F%252Flms.mheducation.com%252Fmghmiddlewar Dorate Reporting and Analysis Problems... X Saved Required information [The following information applies to the questions displayed below.] Raphael Corporation's balance sheet shows the following stockholders' equity section. Preferred stock-5% cumulative, $ par value, 1,000 shares authorized, issued, and outstanding Common stock-$ par value, 4,000 shares authorized, issued, and outstanding Retained earnings Total stockholders' equity Total amount paid to the preferred shareholders Total amount paid to the common shareholders $ 75,000 100,000 400,000 $575,000 2. If two years' preferred dividends are in arrears at the current date and the board of directors declares cash dividends of $23,750, compute the total amount paid to (a) preferred shareholders and (b) common shareholders.arrow_forward4arrow_forwardNonearrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning

Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning