To use Stock Finance Pro, you must install the app from the [Google Workspace Marketplace](https://workspace.google.com/marketplace/app/stock_finance_pro/156572510618). Once you activate a Subscription Plan, please reload your browser to see the active status and start winning in the Stock Market.

Navigate to your [**Google Spreadsheet**](https://sheets.google.com). *Using this application, you agree that the Fair Value provided is only for educational and informational purposes. Stock Finance Pro is not responsible for any investment decision you make from using this calculator.*

Once you have installed the Stock Finance Pro [add-on](https://workspace.google.com/marketplace/app/stock_finance_pro/156572510618), click **Extensions**.

Find **Stock Finance Pro** in your list of Extensions.

Type the company's ticker symbol. For example, type "**GOOG**" and click "**OK**".

**NOTE:** We currently only support stock evaluations for companies listed in the US, European, and Asian markets. We recommend using the ticker symbols from [Yahoo Finance](https://finance.yahoo.com/?guccounter=1).

If you already have an existing sheet generated by Stock Finance Pro, you can enter or change the company's Ticker Symbol here.

Hovering over a cell that has a note will display additional details.

**NOTE**: Our API will be triggered even if you enter an invalid ticker and click refresh or recalculate the data. Please note that invalid ticker will still count as an API call, and the balance will be deducted from your account.

Once you enter a ticker symbol and press enter on your keyboard, you will instantly see financial information about the company, including our default Fair Value.

Once you have entered a Ticker Symbol, you will immediately receive a default **AVERAGE FAIR VALUE** for the company. The average number is a combination of all the financial valuation models we use. We recommend that you adjust the critical parameters such as the growth rate to fit your investment thesis.

**NOTE**: Financial models are used for different purposes to value a stock. The model to use depends on various factors and the information available. No single valuation model is universally applicable, and using multiple models can provide a more comprehensive view of a stock's value.

You can change the company **Sector** by clicking the dropdown (if you disagree with the classification).

There are **11 Sectors** to choose from: Basic Materials, Communication Services, Consumer Cyclical, Consumer Defensive, Energy, Financials, Healthcare, Industrials, Real Estate, Technology, Utilities

This **Financial Statement** table shows simplified data from the company's last four financial years.

This table displays the data for the End Date, Total Revenue, Gross Profit, Operating Expenses, Net Income, Total Assets, Total Liabilities, Shareholders' Equity, Cash From Operations, and Capital Expenditures.

 
Chart summary is disabled for charts with more than 200 rows. This limit will be removed soon.
Return to chart
Chart summary is disabled for charts with more than 200 rows. This limit will be removed soon.
Return to chart

No single valuation model works perfectly in every situation. To get a more accurate picture of a stock's value, we use four different models and then calculate an Average Fair Value. The right model to use depends on various factors and the specific information available at the time. Here are the four valuation models we use:

1. **EPS Valuation (Earnings Per Share)**
2. **Discounted Cash Flow (DCF)**
3. **Dividend Discount Model (DDM)**
4. **Reverse Bull & Bear Valuation**

You can view the fair value determined by each of these models individually.

On the right-hand side, you can find the **SHARES TRADING VOLUME** section. This section displays key information, such as the average trading volume, total outstanding shares, and company ownership details.

Below is the **Business Description**, which explains what the company does.

The **KEY STATISTICS** table gives extra details about the company's current situation. Here's what to look for:

- **Green cells** indicate positives but should still be checked carefully before making any investment decisions.
- **Red cells** signal potential problems that need more investigation.

In this example:

- The Price Target From (12) Analysts is highlighted in *green* because "$185.79" is higher than the Latest Stock Price of "$178.37"
- The P/E Ratio (TTM) is highlighted in *red* because the value "27.32" is much higher than the industry average of "20".

The **Future Growth Rate** shows analysts' yearly growth predictions. Do you agree with this rate? If not, adjust the number to reflect how much you think the company’s revenue, profits, and cash flow will grow yearly.

The **Margin of Safety** is a crucial concept in investing that helps protect you from errors in analysis or unexpected market changes. By buying securities at a price significantly below their intrinsic value, you reduce your risk. Our default settings is 50% but you should aim for a margin of safety of at least 20-30% to ensure a buffer against potential losses.

We suggest you customise the list below to match your investment strategy and then recalculate for a new Fair Value. Conduct a thorough fundamental analysis of the company to help you decide on the right numbers to use:

- Dividend Growth Rate (if applicable)
- **Future Growth Rate**
- Margin of Safety
- **Discount (Risk Free) Rate**
- Growth Decline Rate
- Terminal Multiplier

When you enter the Ticker symbol, we provide a default Fair Value. You can change key data points to match your investment thesis and recalculate to get a new Fair Value. The following data points \[cells\] can be updated to recalculate the Fair Value:

Enter the Ticker symbol to receive a default Fair Value. You can modify key data points according to your investment thesis and recalculate to obtain a new Fair Value. The following data points \[cells\] can be updated for recalculation:

- Ticker Symbol \[B4\]

- Total Revenue \[C12:C16\]

- Gross Profit \[D12:D16\]

- Operating Expense \[E12:E16\]

- Net Income \[F12:F16\]

- Total Assets \[G12:G16\]

- Total Liabilities \[H12:H16\]

- Shareholders' Equity \[I12:I16\]

- Latest Stock Price \[C22\]

- Market Cap \[C24\]

- EPS (TTM) \[C26\]

- Forward P/S Ratio \[C29\]

- Forward P/E Ratio \[C30\]

- Annual Dividend \[C31\]

- Dividend Growth Rate \[C32\]

- Future Growth Rate \[C33\]

- Margin of Safety \[C34\]

- Discount (Risk Free) \[C36\]

- Rate Growth Decline Rate \[C37\]

- Cash Equivalent & Short-term invest \[C38\]

- Total Debt (Most Recent Quarter) \[C42\]

- Free Cash Flow (TTM) \[C45\]

- Terminal Multiplier \[C47\] Currency Conversion \[C49\]

- Outstanding Shares % Increase in 5-Year Outlook (Bear Case) \[D74\]

- Sector \[E4\]

- Industry \[E5\]

- Outstanding Shares % Increase in 5-Year Outlook (Bull Case) \[E74\]

- Total Shares Outstanding \[K6\]

When no data is in these cells, they will be automatically highlighted in Dark Blue.

The number of **changes permitted** depends on your price plan:

1. **Free**: Recalculation of Fair Value counts as an API call and reduces your monthly balance.

2. **Pro**: Recalculation of Fair Value counts as an API call and reduces your monthly balance.

3. **Pro Plus:** Recalculation of Fair Value counts as an API call and reduces your monthly balance.

4. **Pro Premium**: *Unlimited* Recalculation of Fair Value.

If you have exhausted your API calls and cell updates in a month, you must upgrade to the next tier to continue using the service or wait until next month.

Google Sheets is a powerful online tool to help you do quantitative analysis. Learn how to use formulas to manipulate and analyze datasets, such as Google Sheets' COUNTIF and SUMIF functions, among many others.

Google Sheets

Googleusercontent

Google Account

Scribe

Stockfinancepro

This guide provides a step-by-step process for generating an analysis table using Stock Finance Pro in Google Spreadsheet. By following these instructions, you can easily input the Ticker Symbol of a company you want to analyse and generate a comprehensive table for financial analysis. Unlock the power of calculating a company's intrinsic value like a savvy investor!

How to Calculate Fair Value Using Stock Finance Pro