Return on Assets (ROA) and Return on Equity (ROE) are two standard measures used to evaluate the health and future prospects of a company. This type of analysis was introduced in the 1920s, being employed by the DuPont corporation. It algebraically splits ROE into three different measures Profit margin Turnover Leverage This is accomplished by starting with the ratio of net income to equity Then multiplying by assets and sales, like this Some shuffling and we can get the three items listed above   Variation Some authors prefer to normalize out taxes and interest in the ROA and ROE equations, so that in place of net income they instead use after-tax interest plus net income.   DuPont Analysis for Google Assets 96,692.00 Equity 75,473.00 Net income 11,193.00 Interest Expense 85.00 Tax rate 16.58% After-tax interest 70.91 After-tax interest + Net Income 11,263.91 ROA 11.6% ROE 14.9% DuPont Sales 53,499 profit margin 21.1% turnover 55.3% leverage 128.1% DuPont Analysis for Microsoft Assets 134,105.00 Equity 76,688.00 Net income 16,406.00 Interest Expense 405.00 Tax rate 22.85% After-tax interest 312.46 After-tax interest + Net Income 16,718.46 ROA 12.5% ROE 21.8% DuPont Sales 76,012.00 profit margin 22.0% turnover 56.7% leverage 174.9% Observations Profit margin and turnover are roughly the same for both companies. However, Microsofts total Assets are greater than Google’s by about 40%. That significantly increases Microsoft’s leverage position. The higher ratio for leverage may shed some light on my previous analysis showing that Microsoft has a higher bond rating and a higher debt load to...

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

When it comes time to inform an investment decision, it’s essential to know whether or not a present opportunity represents enough present value to justify the investment. If so, at what level and over what time period. Certainly risk factors in, and with such a broad range of opportunities today, including stock markets, bonds, start ups, etc., there’s a lot to take in to account. The answer to the value and timing of an investment with respect to other available investments is given by the Present Value formula (ref for all equations). where P is the present value C is the anticipated future cash flow r is the interest rate of an alternative investment of similar risk t is the number of investment periods. This may change depending on compounding Another way to look at this is as a cash flow C and a Discount Factor D. where The rate r above is the opportunity cost of captial, or opportunity cost. Note that for multiple cash flows, the equation can be summed  Amount, Time and Risk From an investment perspective, the focus of the above equation is cash flow. More specifically, Amount of cash flow Timing of the cash flow Risk associate with the cash flow All three items factor in to the present value formula, and the present value formula informs many financial decisions, including being the basis for perpetuity and annuity analysis and...

In the first lecture of my corporate finance course, the professor make a case in favor of having financial markets, including their intermediaries, like banks. He summarized his case into the four following points. Transport consumption over time (save money, invest) Reduction of risk (through diversification) Liquidity (allows trade to happen faster) Information (trends, evaluation of health) Information From a business manager’s perspective, the fourth bullet is critical. The information that comes from financial markets informs nearly every decision he makes, including production schedules, marketing functions, labor decisions, benefits structure and timing, etc. Since business decisions should be informed by data (unfortunately we find that is not always the case, but I’ll comment on that more in another post), the financial markets provide that data. Opportunity Cost of Capital One common question is whether or not some opportunity represents enough value to justify investment. If so, at what level and over what time period. Certainly risk can factor in, but with such a broad range of opportunities today, including stock markets, bonds, start ups, etc., there’s a lot more to take in to account. Ultimately the information that comes from the financial markets drives the valuation of investment opportunities, including their amount, timing and...

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