Utility of stock analysis worksheet - image
|

The Utility of Stock Analysis Worksheet: How to Interpret its Intrinsic Value and Overall Score?

Some people might question the utility of my Stock Analysis Worksheet. Why? Because it mostly rates its stocks as overvalued or of a low overall score. Some users find it frustrating and send emails to me about the plight. I can understand this feeling. We want the worksheet to throw a list of names of high-scoring, undervalued stocks….

Cost of Equity - WACC - Image
|

Cost of Capital: How Businessmen and Investors use it to evaluate investments?

The cost of capital is the cost that a company must bear for the funds it has raised to do the business. Doing business calls for arranging cashflows both for short and long terms.   There are two ways companies can raise money. The first is through equity. This is done by the distribution of ownership among…

How to analyze stocks in excel - image

How to Analyze Stocks in Excel: Fundamental Analysis of Indian Stocks

Given a chance, an informed investor would not buy-sell stocks blindly. They would do stock analysis before investing. But only a few people do it. Why? Because of the lack of suitable tools. So what is the solution? We can analyze stocks in Excel. Please Check: Stock Screener Derived From Stock Analysis Worksheet. Generally, when…

Absolue PE Method - image2
|

Absolute PE Method: How to estimate intrinsic value using this method?

In this method, we first estimate the ‘absolute PE’ of a stock. Then multiply the calculated PE with EPS. This will give us the fair price or intrinsic value of the stock. We will read about this in more detail. What is the PE formula? Conventional PE = Market Price / EPS. The same formula we…

Financial Ratio Analysis - image

Financial Ratio Analysis: How to interpret ratios to analyse a company?

[This article comes in a series of articles written about the fundamental analysis]. People who are interested in long term investing in stocks knows about financial ratio analysis. If you have heard about terms like price to earning ratio, price to book value ratio etc, you know ratios. But in this financial ratio analysis we…

Residual Income Model - Image
|

Residual Income Method: A great way to estimate intrinsic value of companies

Residual income method is a unique and a comparatively easier way to estimate intrinsic value of companies. What makes it unique is the factor called “residual income“. I’m a big fan of valuing companies using discounted cash flow method (DCF). Why? Because if done accurately, its computed intrinsic value can be very accurate. But its…

Authorized Capital - Thumbnail
|

Authorised Capital: How it is different from Paid-up capital?

‘Authorised Share Capital’ and ‘Paid Up Share Capital’ are two terms that we as investors must know about. Why? Because changes in the numbers of these metrics can effect our investment returns (read here). Company needs capital to establish its assets and run its operations. From where the company will source its capital? It can…

PEG Ratio: A Combination of PE & PEG To Value Indian Stocks

PEG ratio is a useful valuation metric for stock investors. Potential investors can use it to gauge if a stock is overvalued or undervalued. PEG is a ratio which establishes a correlation between company’s price valuation with its future growth prospects (see here). We are more conversant with the use of P/E ratio (Price to Earnings…

How stock price is determined - IMAGE

How Stock Price Is Determined? What makes share price increase or decrease?

Generally speaking, good news about a company can take its stock price up, and bad news can take the price down. In real world, lots of news keeps floating about companies. Some news are good and some may be bad. Hence the struggle of price moving up or down is happening every second. But what…