According to the morningstar website, both Microsoft and Google have high bond ratings, with Microsoft slightly higher. Microsoft Google Morningstar Credit Rating AAA AA Amt Outstanding $16.9 Bil $3.0 Bil Debt/Assets 10.58% 5.31% Based on the ratings, the bond market appears to favor more experienced borrowers, since from a debt load perspective, Google has better standing. Google’s entire bond issue is encompassed in just three bonds with the longest maturation in 2021. It’s also interesting that all three mature on May 19. Duration Duration is calculated the weighted average of the present values of all future cash flows. It can be represented by the following equation (ref), where PV is the present value.   Calculations like this are easily done in Excel. For this exercise I chose bonds that mature in 2016 and payout semi-annually for both Google and Microsoft. Microsoft bond duration Microsoft Coupn 2.500% Par $1,000.00 Maturity 2/8/2016 Frequency semi-annual Discount rate 2.38% 1 2 3 4 5 6 Total 8/8/2013 2/8/2014 8/8/2014 2/8/2015 8/8/2015 2/8/2016 Payment $25.00 $25.00 $25.00 $25.00 $25.00 $1,025.00 PV(Ct) $24.42 $23.85 $23.30 $22.76 $22.23 $890.09 $1,006.64 PV(Ct)/PV 0.0243 0.0237 0.0231 0.0226 0.0221 0.8842 Duration 0.0121 0.0237 0.0347 0.0452 0.0552 2.6527 2.8236 Google bond duration Google Coupon 2.125% Par $1,000.00 Maturity 5/19/2016 Frequency semi-annual Discount rate 2.04% 1 2 3 4 5 6 Total 11/19/2013 5/19/2014 11/19/2014 5/19/2015 11/19/2015 5/19/2016 Payment $21.25 $21.25 $21.25 $21.25 $21.25 $1,021.25 PV(Ct) $20.83 $20.41 $20.00 $19.60 $19.21 $904.71 $1,004.75 PV(Ct)/PV 0.0207 0.0203 0.0199 0.0195 0.0191 0.9004 0.0104 0.0203 0.0299 0.0390 0.0478 2.7013 2.8486 Based on the data above, the duration for the Google bond is higher than for the Microsoft bond, however the difference is slight. You can download the original spreadsheet...

A review of the stock price and growth rate for Microsoft and Google over the past five years shows that they track very closely in general. However, the last year shows a marked deviation from this tracking as Microsoft stayed mainly flat and Google demonstrated strong growth. Using the data from the source above, we can project the anticipated stock price in 2018 if the growth rate remains constant over that time. Company Stock May 2008 Current Stock Effective Rate Stock May 2018 Google 580.07 909.18 56.74% 1425.05 Microsoft 29.99 34.87 16.27% 40.54 Here are the calculations used to arrive at the effective rates shown above (click to enlarge). Alternate approach In the example above, I calculate the effective rate based on the delta between May, 2008 and May, 2013. Another approach would be to start with the stock price five years ago and use Excel to find the annual rate (assuming annually compounding interest). In this case we get the following details. Company Annual Rate -5Y Today +5Y Google 9.40419% 580.07 909.18 1,425.02 Microsoft 3.0615% 29.99 34.87 40.55 The answers come out the more or less the same, but it helps to know what the annual interest rate is, not just the effective rate over the five year...

The course project for Corporate Finance this session involves an analysis of two competing companies, at least one of which is on the Dow. Sources suggested for information include http://finance.yahoo.com, http://www.morningstar.com and http://www.sec.gov/. Additional insights may be available in the Wall Street Journal. Choice of Microsoft and Google The first question involves a comparison of executive compensation between the two companies chosen. Since I own a software business, I chose Microsoft (MSFT) and Google (GOOG) as competing companies for my evaluation. In the software space, these two companies also represent very different approaches to software design, development and consumer consumption of the end result. Business Models Before I jump in to my analysis, it might be worth mentioning that, while both are software companies, they follow different business models. Microsoft has been more of a traditional software company, selling software as a product. That includes packaging, distribution, wholesale, OEM and other supply chain concerns. Google has been a software as a service (SaaS) company from the beginning. Delivery of their products has been almost exclusively online. Both companies have deviated from their roots in recent years. For example, Microsoft is attempting to move into the cloud  and services space with offerings like Bing, Azure and Office Online. Meanwhile, Google has been moving into a product space with their Android devices and Chromebooks. Google’s purchase of Motorola is further evidence of their interest in the product space.  Compensation Analysis The professor suggested that the 10-k filing would be a good place to get information for this project. Unfortunately, the 10-k filing section for Executive Compensation only made a reference to a Proxy document. I did a little more digging and discovered that I could find the Proxy statement using these steps: Go to http://www.sec.gov/ In the main search type the company name (ticker symbol doesn’t work). Also make sure the option next to search has “company filings” selected. Click the link under the “CIK” column for the company you want. Multiple results will come up. In my experience, you want the result with the SIC value in the description, as shown below. In the “filter results” panel near the top, type “DEF” into the “Filter Type” box Results are sorted by filing date by default. Choose...