Frequently Asked Questions (FAQs)

Fair value, also known as Intrinsic value, is a stock's true underlying worth based on its financial health and performance. It is calculated by estimating the company's future projections, such as cash flows, and then discounting them to their present value. Learn more about fair value here.

Fair value is important because it can help investors identify undervalued stocks. If a stock is trading below its fair value, it may be a good investment opportunity.

To subscribe, go to Google Marketplace. Search for "Stock Finance Pro" and install the add-on. Then, choose one of our subscription plans.

Stock Finance Pro is FREE to use until September 30, 2024. This is an excellent opportunity to understand how our solution can benefit you. 

Start your FREE TRIAL.

The Ticker Symbol is usually displayed next to a company's name and stock price on financial news websites or other platforms. We recommend using the Ticker Symbols from Yahoo Finance for our solution.

Our calculator provides fair value using various valuation models, such as the Discounted Cash Flow (DCF) analysis. It estimates the company's future cash flows for five years and discounts them to their present value using a discount rate. We provide the company's Fair Value for each model. However, we also provide an average Fair Value using all our valuation models.

Our Fair Value Calculator uses proprietary algorithms, historical data, and market trends to provide insights into the stock's fair value. You input the ticker symbol to get the company's Fair Value based. You can then change some data points to suit your needs and re-calculate the Fair Value.

The discount rate is a critical input in the DCF analysis, and it can significantly impact the calculated Intrinsic Value. A higher discount rate will result in a low valuation and vice versa.

There is no one-size-fits-all answer to how to choose a discount rate. However, some standard practices include the following:

• Risk-free rate plus a risk premium: This method simply involves adding a risk premium to the risk-free rate. The risk premium should reflect the company's specific risk. This is the recommended approach for most investors.
• Capital asset pricing model (CAPM): The CAPM is a complex model that considers several factors, including the risk-free rate, the market risk premium, and the company's beta.
• Weighted average cost of capital (WACC): The WACC is the average cost of capital that a company uses to finance its operations. It is calculated by taking a weighted average of the company's debt and equity costs.

No, our calculator is designed for novice and experienced investors. It provides easy-to-understand information, and our user-friendly design makes it accessible to users with varying levels of investment knowledge.

We offer a range of data, including historical financial data, trading volume, and more. We aim to provide you with the information you need to make informed investment decisions.

We provide Trading volume data, a crucial market activity and liquidity indicator. A higher trading volume could indicate increased investor interest and potentially greater price volatility.

However, you can generate more returns as a long-term investor, so we do not recommend Day Trading. Some of the greatest investors of all time, Warren Buffett, Charlie Munger and Peter Lynch, are long-term investors.

Yes, we take the security of your personal and financial information seriously. We use industry-standard security measures to protect data and ensure secure transactions. We use Stripe for processing our payments.

We use a third-party provider to serve the most up-to-date data when provided by the market and the company. The data will be updated depending on its availability. For example, Revenue data are released every quarter. Therefore, revenue figures are updated once the company releases them each quarter.

It is important to note that our calculator is just a tool. It cannot predict the future with certainty, and its results should be used as a guide, not as a gospel.

Additionally, our valuation models are based on several assumptions, such as the company's future growth rate and its cost of capital. The calculated intrinsic value will be correct only if the assumptions are correct. You can modify some of the assumptions after conducting research with fundamental analysis.

The following cells can be updated to recalculate the Fair Value:

You can use our calculator to screen for undervalued stocks. Consider investigating further if you find a stock trading below its Fair Value.

However, conducting in-depth research with fundamental analysis before making investment decisions is essential. Before investing, you could review the company's financial health, competitive landscape, and management team. Learn more here on how to start your investment journey in the stock market.

If you experience technical issues, please contact our customer support team. We're here to assist you and address any problems you encounter.

Unfortunately, we currently do not provide personalised financial advice. Our solution provides data and insights, but your investment decisions based on the information are solely your responsibility.

No, the mobile version of Google Sheets differs from the PC version and does not have a full Toolbar menu. Instead, formatting options appear at the bottom of the display when you tap a cell or select a range of cells.

While you can't access the full Toolbar menu in the Google Sheets mobile app, you can access the Stock Finance Pro features by using the browser on your mobile:

• Open your mobile browser and go to Google Sheets.
• Request to use the desktop version of the site.
• This displays the full Toolbar menu, but the user experience might be less optimised for mobile screens. So, consider using a tablet for a more desktop-like experience since it offers a larger screen.

Yes, we offer monthly subscriptions. So, you can cancel your subscription at any time. Your access to our services will remain active until the end of the current billing cycle. Please note that we do not offer refunds once the billing cycle has started.

Our fair value calculator automatically displays the data you need for the valuation. To use our calculator, you will need to input or update the following information:

• Enter the company's ticker symbol
• Update the Dividend Growth Rate (if required)
• Provide your expected Perpetuity Growth Rate for the company
• Change the Margin of Safety to your preference
• Provide your preferred Discount [Risk-Free] Rate
• Update Growth Decline Rate
• Enter how much dilution you expect from the company

You can easily check the number of remaining API calls by visiting the "My Account" section from the Stock Finance Pro extension [in your Google Sheets]. This feature helps you monitor and manage your usage efficiently.

While we currently do not offer automatic alerts, you can manually check your API call usage anytime under the "My Account" section to stay updated. We recommend regularly checking this to ensure you do not exceed your allocated number of calls.

Stock Finance Pro provides valuation analysis for stocks listed on major markets across the US, Europe, and Asia. This enables comprehensive coverage for investors looking into international investment opportunities. We recommend entering the Ticker Symbol exactly as written on Yahoo Finance to confirm whether a stock is supported before running a query.

Financial data for stocks listed in the US, Europe, and Asia is regularly updated to ensure that our valuation models reflect the most current market conditions and company financials.