Computation of Price-Earnings Ratio (P/E) Using Twelve-Month Trailing and Leading EPS

Introduction

The price-to-earnings ratio is one of the most familiar equity-valuation multiples because it compares the market price of a share with the earnings attributed to that share. The formula is simple, but interpretation is not. A P/E can be high because investors expect strong growth, durable profitability, lower perceived risk, or unusually high returns on capital; it can be low because growth expectations are weak, earnings are temporarily elevated, or investors perceive substantial risk. This exercise uses historical 2017 inputs for Microsoft, Apple, and Facebook, now Meta Platforms, and should therefore be treated as a valuation-method exercise rather than a current investment recommendation. The supplied prices are $87.18 for Microsoft, $164.94 for Apple, and $159.39 for Facebook, paired with trailing and forecast earnings-per-share estimates. Historical company filings help establish the financial context, but the assignment inputs do not always equal GAAP diluted EPS reported in annual filings. That difference illustrates an important rule: analysts must state whether they are using GAAP, adjusted, trailing-twelve-month, or forecast earnings because the denominator can materially change the multiple (Investor.gov, 2026; Microsoft Corporation, 2017).

Trailing and Forward P/E Measure Different Time Horizons

The basic calculation is market price per share divided by earnings per share. A trailing P/E normally uses earnings generated during the previous twelve months, whereas a forward or leading P/E uses expected earnings for a future period. Using the assignment data, Microsoft’s trailing P/E is approximately 25.20 and its forward P/E is 23.75; Apple’s values are approximately 17.15 and 14.48; Facebook’s are approximately 25.88 and 18.91. The supplied S&P 500 comparison multiple is 20.88. Forward multiples fall when projected earnings rise faster than price, but the decline should not be interpreted automatically as improvement in value. Forecast earnings can be wrong because revenue, margins, expenses, taxes, or economic conditions differ from expectations. Facebook’s multiple contracts much more sharply than Microsoft’s because its forecast denominator rises substantially. That observation tells the analyst what assumptions are embedded in the forecast, not whether the stock will outperform. Trailing and forward P/E are therefore best read together: one summarizes pricing relative to recently realized earnings, while the other expresses pricing relative to an uncertain estimate of future earnings.

Relative Multiples Do Not Prove Overvaluation or Undervaluation

Apple has the lowest trailing and forward P/E in the supplied dataset, while Microsoft and Facebook trade above the assignment’s broad-market benchmark on trailing earnings. Those facts are descriptive, not sufficient valuation conclusions. Calling Microsoft or Facebook “overvalued” simply because the multiple exceeds 20.88 would ignore differences in expected growth, margins, business risk, reinvestment needs, payout policy, and return on equity. Likewise, calling Apple “undervalued” because its P/E is lower would assume that all three firms deserve the same multiple. Damodaran’s valuation framework treats P/E as a function of fundamentals rather than a standalone score, which is why comparisons are usually more informative among businesses with similar economics or after adjustments for growth and risk (Damodaran, 2025). Sector composition also limits comparison with a broad index. A market benchmark contains companies with different capital structures, cyclicality, accounting profiles, and growth opportunities. A useful relative-valuation analysis therefore asks why multiples differ and whether the difference is justified by fundamentals instead of assuming that the lowest multiple is the cheapest opportunity.

Stable-Growth Models Fail When Growth Exceeds the Required Return

The historical assignment also attempts to derive a fundamental P/E from a stable-growth relationship related to the Gordon dividend-discount model. A common form using current earnings can be written as payout ratio multiplied by one plus growth, divided by cost of equity minus growth. The denominator imposes a crucial condition: perpetual growth must be lower than the required return. The supplied assumptions violate that condition for Microsoft and Apple because Microsoft combines an 11 percent cost of equity with 14 percent growth, while Apple combines 9 percent with 17 percent growth. A negative denominator produces a negative multiple, but that output does not mean either company has negative economic value. It means the stable-growth model has been applied outside its valid domain. High-growth companies require a multi-stage approach in which near-term growth eventually converges toward a sustainable rate below the discount rate. The same logic applies to the Gordon dividend model. When growth equals or exceeds the required return indefinitely, the mathematical relationship no longer describes an economically plausible mature firm and should not be forced into a numerical conclusion.

Dividend and Book-Value Models Have Their Own Limits

Facebook illustrates a different limitation because it did not pay a dividend during the period examined. A dividend-discount model based on current payout can therefore return zero even though the business obviously possessed substantial market value. That result reflects the model’s dependence on distributions, not an absence of economic worth. A free-cash-flow-to-equity framework can be more useful when a company retains earnings rather than paying dividends. The price-to-book ratio requires similar caution. Using the supplied figures gives approximate P/B multiples of 7.65 for Microsoft, 6.24 for Apple, and 5.14 for Facebook. Those values are high relative to accounting book equity, but technology businesses can create substantial value from software, networks, brands, data, intellectual property, and human capital that are not fully recorded as book assets. A high P/B therefore does not independently establish overvaluation. Any “fundamental P/B” calculation built with the same invalid assumption that perpetual growth exceeds the required return will also produce meaningless negative outputs. The analyst must first decide whether book value is economically informative for the business being valued.

Free Cash Flow Requires Consistent Definitions and Signs

Free cash flow to the firm and free cash flow to equity can provide richer information than simple multiples, but they must be calculated consistently. FCFF represents cash available to all capital providers, while FCFE represents cash available to common equity after considering debt-related financing. Using the assignment’s simplified FCFF method, Microsoft is approximately 39,507 plus after-tax interest of 2,637 multiplied by 0.70, minus capital expenditures of 8,696, yielding roughly 32,657. Apple similarly produces approximately 53,031. The historical Facebook calculation contains a substantive sign error: it adds capital expenditures of 6,733 to operating cash flow of 24,216. If that figure is truly capital expenditure, it should be subtracted under the stated formula, producing approximately 17,483 rather than 30,949. Small rounding differences are unimportant compared with reversing the sign of a major cash outflow. FCFE also requires clearly identified net capital spending, working-capital changes, and net borrowing. When an assignment does not identify every component precisely, the result should be labeled as a calculation based on supplied inputs rather than presented as audited intrinsic value.

Cash Flow Amounts Are Not Yet Equity Values

One year of FCFF or FCFE does not by itself tell an investor what a share is worth. Intrinsic valuation requires forecasts of future cash flows, a discount rate appropriate to the claim being valued, a terminal-value assumption, and adjustments for debt, cash, nonoperating assets, and diluted shares where relevant. FCFF is normally discounted at the weighted average cost of capital to estimate enterprise value, after which debt and other claims are reconciled to reach equity value. FCFE is normally discounted at the cost of equity because it already represents cash available to common shareholders. Comparing the raw 2017 FCFF amounts of Microsoft, Apple, and Facebook mainly reveals differences in cash-generation scale under the assignment definitions. It does not establish which company offered the highest expected return or the greatest margin of safety. The distinction matters because large firms naturally generate more total cash than smaller firms. Valuation is about what investors pay relative to the future cash they expect to receive, adjusted for timing and risk, rather than which company reports the largest absolute cash-flow number in one year.

What the Historical Exercise Actually Demonstrates

The strongest conclusions from the 2017 dataset are methodological and comparative. Apple had the lowest trailing and forward P/E among the three companies under the supplied inputs. Facebook’s multiple contracted the most when expected earnings replaced trailing earnings, revealing the strongest forecasted EPS growth embedded in the exercise. Microsoft remained at a relatively high multiple under both denominators. None of those observations is sufficient for a buy or sell recommendation. A rigorous comparison would examine revenue growth, margins, return on invested capital, capital intensity, competitive position, balance-sheet risk, accounting quality, payout policy, and the reliability of forecasts. Damodaran’s market-wide work shows why multiples vary systematically with growth, risk, and payout rather than functioning as isolated indicators of mispricing (Damodaran, 2026). The exercise also demonstrates that valuation errors often arise before the final arithmetic: using an unsuitable denominator, comparing unlike companies, or applying a stable-growth formula to a high-growth phase can invalidate a result even when every calculator entry is mathematically correct.

Conclusion

P/E analysis is useful because it compresses price and earnings into an intuitive comparison, but the apparent simplicity of the ratio can encourage conclusions that the underlying economics do not support. Trailing P/E summarizes price relative to realized earnings, forward P/E incorporates uncertain forecasts, and neither tells an investor whether a stock is fairly valued without considering growth, risk, payout, and business quality. The historical Microsoft, Apple, and Facebook exercise also illustrates why valuation models must respect their assumptions. Stable-growth P/E and dividend formulas become invalid when perpetual growth equals or exceeds the required return; book value may be a weak anchor for intangible-intensive technology firms; and free-cash-flow analysis fails when capital expenditures are given the wrong sign or when cash flow is mistaken for equity value. The correct analytical sequence is therefore to define the metric, verify the data, test whether the model applies, check the arithmetic, and only then interpret the result. Used this way, the 2017 exercise becomes a lesson in valuation discipline rather than a retrospective investment recommendation.

References

Damodaran, A. (2025). Pricing and valuation: Understanding the fundamentals of multiples. New York University Stern School of Business.

Damodaran, A. (2026). Market-wide regressions of multiples: U.S. companies. New York University Stern School of Business.

Investor.gov. (2026). Price-Earnings (P/E) Ratio. U.S. Securities and Exchange Commission.

Microsoft Corporation. (2017). Form 10-K for the fiscal year ended June 30, 2017. U.S. Securities and Exchange Commission.

Editorial Staff

Academic Master Education Team is a group of academic editors and subject specialists responsible for producing structured, research-backed essays across multiple disciplines. Each article is developed following Academic Master’s Editorial Policy and supported by credible academic references. The team ensures clarity, citation accuracy, and adherence to ethical academic writing standards

Content reviewed under Academic Master Editorial Policy.

This author does not have any more posts.