Revenue Per Share Three Years Formula in Excel

Are you looking to quickly analyze a company’s average revenue per share over the past three years in Excel? The Revenue Per Share Three Years formula with MarketXLS is designed to help you do just that. By pulling in reliable, up-to-date market data directly into your spreadsheet, you can make informed decisions faster, all within Excel.

Understanding Revenue Per Share Three Years

The Revenue Per Share Three Years measure calculates a company’s average total revenue from the past three years, divided by its average shares outstanding over the same period. This formula is useful for:

• Assessing long-term revenue trends
• Comparing multiple companies’ revenue-per-share growth
• Identifying consistent revenue performance over several years

? Pro Tip: This formula is especially useful when you need a snapshot of a company’s multi-year revenue performance without manually calculating average revenues and share counts.

Syntax and Parameters

Below is the typical syntax for the RevenueThreeYears function in Excel:

=RevenueThreeYears(Symbol)

Return Value

• Type: Numeric value or "NA" if the data is not available or an error occurs.
• Description: Returns the 3-year average revenue per share for the specified symbol.

?? Note: If an invalid symbol is provided, or if your MarketXLS license is not valid, the function will return "NA".

Examples and Usage

Below are some real-world examples of how to use the Revenue Per Share Three Years formula:

1. To retrieve the 3-year average revenue per share for Microsoft:

   =RevenueThreeYears("MSFT")

2. Using an index symbol like the S&P 500 (^SPX):

   =RevenueThreeYears("^SPX")

3. For an option contract (format may vary):

   =RevenueThreeYears("@MSFT 110122C00020000")

4. For a cryptocurrency symbol:

   =RevenueThreeYears("BTCUSD:DEFAULT")

? Pro Tip: Use cell references if you have symbols listed in cells. For instance, if cell A1 contains MSFT, then you can enter:

=RevenueThreeYears(A1)

Performance and Data Considerations

• The formula retrieves data from MarketXLS’s web-based service, so a stable internet connection is required.
• Large spreadsheets or frequent recalculations may impact performance due to multiple web calls.
• Data availability can vary for non-U.S. markets or less-common symbols.

Common Questions

1. Why do I get “NA” instead of a value?

   • Possible reasons include an invalid or unrecognized symbol, expired license, or missing data for the specified symbol.

2. Does the formula automatically update?

   • Yes. Whenever your Excel recalculates, it attempts to fetch the latest available data. You can also manually recalculate by pressing F9.

3. Are historical data adjustments included in the calculation?

   • Yes. MarketXLS factors in any reported adjustments or restatements when available, ensuring accuracy in multi-year revenue averages.

?? Note: Always verify data consistency with official filings if you require audited figures for critical decisions.

Feel free to explore Revenue Per Share Three Years alongside other MarketXLS formulas—such as EPS, Market Capitalization, and Shares Outstanding—to get a fuller picture of a company’s performance over time.