Centralized Database Systems

A centralized database is stored at a single location such as a mainframe computer. It is maintained and modified from that location only and usually accessed using an internet connection such as a LAN or WAN. The centralized database is used by organizations such as colleges, companies, banks etc.

Centralized data base is another type of database system which is located, maintained and stored in a single location such as mainframe computer. Data stored in the centralized DBMS is distributed across the network computers. It includes set of records which can easily be accessed from any location by using internet connection such as WAN and LAN.  Centralized database system is commonly used in the organizations such as banks, schools, colleges etc to manage all their data in an appropriate manner.

Advantages of Centralized Database Systems

  1. It allows for working on cross-functional projects

A centralized database speeds up the communication which occurs within an organization. Instead of having layers of administrative red tape in place to handle cross-functional projects between teams, the core design allows for those teams to come together whenever it is necessary. That makes it possible to absorb analytical data faster, complete specific tasks with more quality, and make more progress toward the vision, mission, or goals which have been established.

  1. It is easier to share ideas across analysts

Many businesses are setup in a way that creates silos for individuals and teams. By implementing a strategy which centralizes information and analytics, those silos begin to disappear. Instead of having multiple people working on the same projects or datasets independently, the organization can coordinate their work to have them collaborating more often. When everyone can share their ideas with the rest of the organization, the diversity created allows for a better growth potential.

  1. Analysts can be assigned to specific problems or projects centrally

There is a higher level of accountability found within a centralized database. That is because there is much more transparency about the policies and procedures being implemented. Each person can be assigned to a specific problem that the organization must address. Those with the correct authorities can monitor the progress of that person in solving the identified issue. Instead of routing through numerous sections, teams, or departments, all of the communication for each problem or project is routed centrally, which reduces confusion.

  1. Higher levels of security can be obtained

When there is long-term funding granted to a centralized database, then there is a higher level of data security which develops for the organization. That is because the information which is obtained by the company serves the entire company. Everyone involved with the information retention is bound by certain protocols or limits with their access, which limits the amount of data leakage which may occur. The end result is that the valuable data stays internal more often than going external.

  1. Higher levels of dependability are present within the system

There are fewer breakdowns of internal reporting systems when a centralized database is present. Instead of having multiple channels open, which may come to different conclusions on their own, there is one central channel which includes everyone. Each person can access the data they require, offer their opinion, and listen to the company-wide chatter as specific conclusions are created. Dependability happens because people get onto the same page faster.

  1. It reduces conflict

When there is a centralized database responsible for the collection and storage of data, then conflicts within the organization are reduced. That occurs because there are fewer people involved in the decision-making processes which involve the data. When there are top managers or assigned individuals responsible for this information, the lower-level managers and lower tier employees are insulated from the burdens of using the data inappropriately, which leads to a happier working environment.

  1. Organizations can act with greater speed

When there is a core database responsible for managing information, decisions on actions or strategies occur with greater speed because there are fewer layers of data which must be navigated. Leaders of the business are able to operate more efficiently because the communication processes are built naturally into the system. That makes it easier for everyone to evaluate the pros and cons of any decision they may face.

  1. It helps an organization stay close to a focused vision

The centralized database can be configured to keep tabs on an entire organization with regards to its one purpose or vision. Inconsistencies are eliminated from the workflows because the data being collected is intended for specific purposes which are clearly communicated to everyone involved.

Disadvantages of Centralized Database Systems

  1. It can become unresponsive to the needs of the business

There are heavy workload requirements which become necessary when using a centralized database. Individuals and teams find that the time constraints placed on them may be unreasonable for the expectations asked. In time, if these constraints are not addressed as they should be, a centralized database creates unresponsive teams that are focused on specific tasks instead of collaboration. The teams can essentially rebel against the system to create their own silos for self-protection.

  1. There are lower levels of location-based adaptability

Using a centralized database means you are trading movement efficiencies for less flexibility at the local level. If there are changes which occur locally that affect the business, this data must be sent to the centralized database. There is no option to control the data locally. That means response times to local customers or the community may not be as efficient as they could be, as there may not be any information in place to deal with a necessary response.

  1. It can have a negative impact on local morale

When there is a centralized database being used, the responsibilities of local managers are often reduced. That occurs because the structure of the company may forbid local managers from hiring their own employees. It may force them to use data from the centralized system which they feel has a negative impact at the local level. Instead of being able to make decisions immediately, they are forced to wait for data to come from the centralized database. For those who wish to experience higher levels of responsibility with their management role, the centralized process can be highly demoralizing.

  1. Succession planning can be limited with a centralized database

Because the information is managed by a centralized database, there is little need to work on the development of new or upcoming managers. The only form of succession planning that is necessary with this setup involves bringing in an individual to replace a core analyst at some point. Should top-level managers experience a family issue, health event, or some other issue which interferes with their job, there may be no one with the necessary experience to take over the position, which reduces the effectiveness of the centralized database.

  1. It reduces the amount of legitimate feedback received

A centralized database may provide transparency. It may lead to greater levels of communication. Those are not always positive benefits. When anyone can offer an opinion or feedback on information they have received, they often feel a responsibility to send a response. Many employees may have general knowledge about certain policies or procedures, but not have access to the full picture. They waste time creating feedback which isn’t needed, which wastes time for everyone who reads that feedback. Over time, this can lead to lower levels of productivity and higher levels of frustration.

  1. It may increase costs

When a centralized system is in place, there is a reliance on the accuracy of the data being collected. Even one small miscalculation could have a grave impact on the centralized database. That may result in higher fees for rushed deliveries, incorrect orders that are labeled as being correct, and unnecessary changes to potential inventory controlled by the organization. The costs of fixing a mistake from a decentralized system tend to be lower than fixing the mistakes generated by centralized systems.

  1. There is a risk of loss

When there is a centralized database, everything is stored within that database. What happens to that information if the database should be lost for some reason? Because there are no other database locations, an organization loses access immediately. That could create a long-term outage which may affect the overall viability of the company. Even with cloud backup systems in place and other protections available, there is always a risk of complete loss present when using a centralized database.

These centralized database advantages and disadvantages must be considered at the local level. For some organizations, the centralized structure makes sense because it brings people and teams together with a common bond to work toward a specific mission. For others, the system may create too many data points, bogging down overall productivity.

Distributed Database Systems

A distributed database is basically a database that is not limited to one system, it is spread over different sites, i.e, on multiple computers or over a network of computers. A distributed database system is located on various sited that don’t share physical components. This maybe required when a particular database needs to be accessed by various users globally. It needs to be managed such that for the users it looks like one single database.

A distributed database is a collection of multiple interconnected databases, which are spread physically across various locations that communicate via a computer network.

Goals of Distributed Database system

The concept of distributed database was built with a goal to improve:

(i) Reliability

In distributed database system, if one system fails down or stops working for some time another system can complete the task.

(ii) Availability

In distributed database system reliability can be achieved even if sever fails down. Another system is available to serve the client request.

(iii) Performance

Performance can be achieved by distributing database over different locations. So the databases are available to every location which is easy to maintain.

Advantages of Distributed Databases

Following are the advantages of distributed databases over centralized databases.

(i) Modular Development

If the system needs to be expanded to new locations or new units, in centralized database systems, the action requires substantial efforts and disruption in the existing functioning. However, in distributed databases, the work simply requires adding new computers and local data to the new site and finally connecting them to the distributed system, with no interruption in current functions.

(ii) More Reliable

In case of database failures, the total system of centralized databases comes to a halt. However, in distributed systems, when a component fails, the functioning of the system continues may be at a reduced performance. Hence DDBMS is more reliable.

(iii) Better Response

If data is distributed in an efficient manner, then user requests can be met from local data itself, thus providing faster response. On the other hand, in centralized systems, all queries have to pass through the central computer for processing, which increases the response time.

(iv) Lower Communication Cost

In distributed database systems, if data is located locally where it is mostly used, then the communication costs for data manipulation can be minimized. This is not feasible in centralized systems.

Types of distributed database System

The two types of distributed systems are as follows:

  1. Homogeneous distributed databases system

In a homogeneous database, all different sites store database identically. The operating system, database management system and the data structures used – all are same at all sites. Hence, they’re easy to manage.

Example: Consider that we have three departments using Oracle-9i for DBMS. If some changes are made in one department then, it would  update the other department also.

  1. Heterogeneous Database

In a heterogeneous distributed database, different sites can use different schema and software that can lead to problems in query processing and transactions. Also, a particular site might be completely unaware of the other sites. Different computers may use a different operating system, different database application. They may even use different data models for the database. Hence, translations are required for different sites to communicate.

Example: In the following diagram, different DBMS software are accessible to each other  using ODBC and JDBC.

Distributed Data Storage

There are 2 ways in which data can be stored on different sites. These are:

  1. Replication

In this approach, the entire relation is stored redundantly at 2 or more sites. If the entire database is available at all sites, it is a fully redundant database. Hence, in replication, systems maintain copies of data.

This is advantageous as it increases the availability of data at different sites. Also, now query requests can be processed in parallel.

However, it has certain disadvantages as well. Data needs to be constantly updated. Any change made at one site needs to be recorded at every site that relation is stored or else it may lead to inconsistency. This is a lot of overhead. Also, concurrency control becomes way more complex as concurrent access now needs to be checked over a number of sites.

  1. Fragmentation

In this approach, the relations are fragmented (i.e., they’re divided into smaller parts) and each of the fragments is stored in different sites where they’re required. It must be made sure that the fragments are such that they can be used to reconstruct the original relation (i.e, there isn’t any loss of data).

Fragmentation is advantageous as it doesn’t create copies of data, consistency is not a problem.

Fragmentation of relations can be done in two ways:

  • Horizontal fragmentation – Splitting by rows – The relation is fragmented into groups of tuples so that each tuple is assigned to at least one fragment.
  • Vertical fragmentation – Splitting by columns – The schema of the relation is divided into smaller schemas. Each fragment must contain a common candidate key so as to ensure lossless join.

Valuation of Securities

Security valuation is important to decide on the portfolio of an investor. All investment decisions are to be made on a scientific analysis of the right price of a share. Hence, an understanding of the valuation of securities is essential. Investors should buy underpriced shares and sell overpriced shares. Share pricing is thus an important aspect of trading. Conceptually, four types of valuation models are discernible.

They are:

(i) Book value,

(ii) Liquidating value,

(iii) Intrinsic value,

(iv) Replacement value as compared to market price.

(i) Book Value:

Book value of a security is an accounting concept. The book value of an equity share is equal to the net worth of the firm divided by the number of equity shares, where the net worth is equal to equity capital plus free reserves. The market value may fluctuate around the book value but may be higher if the future prospects are good.

(ii) Liquidating Value (Breakdown Value):

If the assets are valued at their breakdown value in the market and take net fixed assets plus current assets minus current liabilities as if the company is liquida­ted, then divide this by the number of shares, the resultant value is the liquidating value per share. This is also an accounting concept.

(iii) Intrinsic Value:

Market value of a security is the price at which the security is traded in the market and it is generally hovering around its intrinsic value. There are different schools of thought regarding the relationship of intrinsic value to the market price. Market prices are those which rule in the market, resulting from the demand and supply forces. Intrinsic price is the true value of the share, which depends on its earning capacity and its true worth. According to the fundamentalist approach to security valuation, the value of the security must be equal to the discounted value of the future income stream. The investor buys the securities when the market price is below this value.

Thus, for fundamentalists, earnings and dividends are the essential ingredients in determining the market value of a security. The discount rate used in such present value calculations is known as the required rate or return. Using this discount rate all future earnings are discounted back to the present to determine the intrinsic value.

According to the technical school, the price of a security is determined by the market demand and supply and it has very little to do with intrinsic values. The price movements follow certain trends for varying periods of time. Changes in trend represent the shifts in demand and supply which are predictable. The present trends are the offshoot of the past and history repeats itself according to this school.

According to efficient market hypothesis, in a fairly large security market where competitive conditions prevail, market prices are good proxies for intrinsic values. The security prices are determined after absorbing all the information avail­able to market participants. A share is thus generally worth whatever it is selling for in the market.

Generally, fundamental school is the basis for security valuation and many models are in use, based on these tenets.

(iv) Replacement Value:

When the company is liquidated and its assets are to be replaced by new ones, their prices being higher, the replacement value of a share will be different from the Breakdown value. Some analysts take this replacement value to compare with the market price.

Factors Influencing Security Valuation:

Security price depends on a host of factors like earnings per share, prospects of expansion, future earnings potential, possible issue of bonus or rights shares, etc. Some demand for a particular stock may give pleasure of power as a shareholder or prestige and control on management. Satisfaction and pleasure in the non-monetary sense cannot be considered in any practical and quantifiable sense. Many psychologi­cal and emotional factors influence the demand for a share.

In money terms, the return to a security on which its value depends consists of two components:

(i) Regular dividends or interest, and

(ii) Capital gains or losses in the form of changes in the capital value of the asset.

If the risk is high, return should also be high. Risk here refers to uncertainty of receipt of principal and interest or dividend and variability of this return.

The above returns are in terms of money received over a period of years. But money of Re. 1 received today is not the-same as money of Re. 1 received a year hence or two years hence etc. Money has time value, which suggests that earlier receipts are more desirable and valuable than later receipts. One reason for this is that earlier receipts can be reinvested and more receipts can be got than before. Here the principle operating is compound interest.

Thus, if Vn is the terminal value at the period n, P is the initial value, g is rate of compounding or return, n is the number of compounding periods, then Vn = P (1 + g)n.

If we reverse the process, the present value (P) can be thought of as reversing the compounding of values. This is discounting of the future values to the present day, represented by the formula-

P = Vn /(1+ g)n

Graham’s Approach to Valuation of Equity:

In their book on Security Analysis (1934) Benjamin Graham, and David Dodd, argued that future earnings power was the most important determinant of the value of stock. The original approach of identifying the undervalued stock is to find out the present value of forecasted dividends, and if the current market price is lower, it is undervalued. Alternatively, the analyst could determine the discount rate that makes the present value of the forecasted dividends equal to the current market price of the stock. If that rate (I.R.R. or discount rate) is more than the required rate for stocks of similar risks, then the stock is underpriced.

Graham and Dodd had argued that each dollar of dividends is worth four times as much as one dollar of retained earnings (in their original Book); but subsequent studies of data showed no justification for this. Graham and Rea have given some questions on Rewards and risks for financial data analysts to answer yes or no and on the basis of these ready to answer questions, they decided to locate undervalued stocks to buy and overvalued stocks to sell.

Such readymade formulas or questions are now out of favour due to various empirical studies which showed that earnings models are as good as or better than dividend models and that a number of factors are ably studied for common stock valuation and no unique formula or answer is justifiable.

Securities Valuation in India:

In India, the valuation of securities used to be done by the CCI for the purpose of fixing up the premium on new issues of existing companies. These guidelines used by CCI were applicable upto May 1992, when the CCI was abolished. Although the present market price will be taken into account a more rational price used to be worked out by the CCI on certain criteria.

Thus, the CCI used the concept of Net Asset Value (NAV) and Profit-Earning Capacity Value (PECV) as the basis for fixing up the premium on shares. The NAV is calculated by dividing the net worth by the number of equity shares. The net worth includes equity capital plus free reserves and surplus less contingent liabilities.

Valuation of Preference Shares

Preference Shares are a type of share capital that provides shareholders a preferential right over equity shareholders in two key aspects: (1) Receiving dividends at a fixed rate before equity shareholders, and (2) Repayment of capital during winding up of the company. They usually do not carry voting rights, except in special cases. Preference shares may be cumulative, non-cumulative, redeemable, or convertible. They are considered a hybrid security, combining features of both equity and debt, offering stability to investors and flexible financing to companies.

Valuation of Preference Shares:

Valuation depends on whether preference shares are irredeemable or redeemable.

A. Irredeemable Preference Shares

  • These shares have no maturity date; holders get a fixed dividend forever.

  • Value is calculated as the present value of perpetual dividends.

Formula:

Value of Irredeemable Preference Share = Annual Preference Dividend / Required Rate of Return

B. Redeemable Preference Shares

  • These shares are repayable after a fixed period (say 5 or 10 years).

  • Value is based on the present value of dividends for n years plus present value of redemption value.

Formula:

Need of  Valuation of Preference Shares:

  • Investment Decision-Making

Valuation of preference shares helps investors decide whether to buy, hold, or sell such securities. Since preference shareholders receive fixed dividends and priority over equity shareholders, knowing the fair value ensures they do not overpay or undervalue their investment. By comparing the intrinsic value with the market price, investors can judge potential returns and risks. This process builds confidence in investment decisions, especially for risk-averse investors who prefer stable returns rather than uncertain equity dividends.

  • Corporate Financing Decisions

Companies issue preference shares as a source of capital, combining features of both debt and equity. Before issuing or redeeming such shares, firms must know their value to ensure cost-effective financing. Valuation helps management compare preference shares with other funding sources like debentures or equity. It also influences dividend payout policies and redemption strategies. Thus, correct valuation ensures balanced capital structure, reduces financing costs, and maintains investor trust, which is essential for smooth business operations and long-term sustainability.

  • Regulatory and Legal Requirements

Valuation of preference shares becomes necessary during mergers, acquisitions, liquidation, or restructuring of a company. Laws and accounting standards often require that shareholders, including preference shareholders, receive fair value for their holdings. Accurate valuation ensures compliance with statutory provisions and prevents disputes among stakeholders. It also helps in calculating compensation payable to preference shareholders when the company decides to redeem or convert their shares. Thus, valuation ensures transparency, fairness, and legal compliance in corporate financial transactions and governance.

  • Redemption and Conversion Decisions

Preference shares are often redeemable after a fixed period or convertible into equity shares. In both cases, valuation plays a vital role. For redemption, it helps determine the repayment amount and its impact on company finances. For conversion, valuation ensures fair exchange ratios between preference and equity shares, avoiding shareholder conflicts. This process safeguards the interests of both the company and investors. Therefore, proper valuation ensures smooth redemption or conversion, maintains fairness, and supports effective long-term financial planning.

Present Value of Equity Shares

Method # 1. Based on Balance Sheet:

i. Book Value:

It is the net worth of a company divided by number of outstanding shares. Net worth is equal to paid-up equity capital plus reserves and surplus minus losses.

ii. Liquidation Value:

Liquidation value is different than a book valuation. In that it uses the value of the assets at liquidation, which is often less than market and sometimes book. Liabilities are deducted from the liquidation value of the assets to determine the liquidation value of the business. Liquidation value can be used to determine the bare bottom benchmark value of a business.

iii. Replacement Cost:

Replacement costs provide an alternative way of valuing a company’s assets. The replacement, or current, cost of an asset is the amount of money required to replace the asset by purchasing a similar asset with identical future service capabilities. In replacement cost, assets and liabilities are valued at their cost to replace.

Method # 2. Based on Dividends:

i. One Year Holding Period:

As per this model, the investor intends to purchase now, hold it for one year and sell it off at the end of one year. Thus, the investor would receive dividend of one year as well as the share price at the end of year one.

To value a stock, we have to first find the present discounted value of the expected cash flows.

Where,

Po = the current price of the stock

D1 = the dividend paid at the end of year 1

ke = required return on equity investments (Discounting factor)

P1 = the price at the end of period one

Let ke = 12%, Div = 0.16 and P1 = Rs.60.

Po = Rs. 53.71

If the stock was selling for Rs. 53.71 or less, the share should be purchased

ii. Multiple Year Holding Period:

As per this model, an investor may hold the shares for a number of years and sell it off at the end of it. Thus, he receives dividends for these periods as well as market price of the share after it.

Where,

Po = the current price of the stock

D1, D2, D3……. Dn = annual dividend paid at the end of year 1, 2, 3…n

ke = required return on equity investments (Discounting factor)

Pn = the price at the end of period n

For example:

If an investor expects to get Rs.3.5, Rs.4 and Rs.4.50 as dividend from a share during the next 3 years and hopes to sell it off at Rs.75 at the end of the third year, and if required rate of return is 15%, the present value of the share will be

iii. Constant Growth Model (Gordon’s Share Valuation Model):

As per this model, dividends will grow at the same rate (g) into the indefinite future and the discount rate (k) is greater than growth rate

Where,

k = discount factor

g = growth rate

Do = current dividend

D1 = Dividend at end of year one

For example:

Alembic Company has declared a dividend of Rs. 2.5 per share for the current year. The company has been following a policy of enhancing its dividends by 10% every year and is expected to continue its policy in future also. The investor’s required rate of return is 15%. The value of the share will be

iv. Multiple Growth Model (Also called as the Two Stage Growth Model):

The constant growth model has a very unrealistic assumption of constant growth. The growth may take place at varying rates. In the multiple growth model, the future time period is viewed as divisible into two different growth segments, the initial extraordinary growth period and the subsequent constant growth period.

Where,

Po = the current price of the stock

D1, D2, D3……. Dn = annual dividend paid at the end of year 1, 2, 3…n

ke = required return on equity investments (Discounting factor)

g = constant growth rate of dividends at the start of the second stage

For example:

Hindalco paid a dividend of Rs.1.75 per share during the current year. It is expected to pay a dividend of Rs.2 per share during the next year. Investors forecast a dividend of Rs.3 and Rs.3.5 per share respectively during the two subsequent years. After that, it is expected that annual dividends would grow at 10% per year into an indefinite future. The investor’s required rate of return is 20%. 

Method # 3. Other Approaches:

i. Price to Book Value Ratio:

The book value of a company is the value of the net assets expressed in the balance sheet. Net assets means total assets minus intangible assets and liabilities. This ratio gives the investor an idea of how much he is actually paying for the share.

ii. Earnings Multiplier Approach:

Under this approach, the value of equity share is estimated as follows:

Po = EPS × P/E ratio.

Where,

EPS = Earning Per share

P/E ratio = Price Earning Ratio

P/E ratio = Market price per share / earnings per share

iii. Price to Sales Ratio:

It is calculated by dividing a company’s current stock price by its revenue per share for the recent twelve months. This ratio reflects what the market is willing to pay per rupee of sales.

iv. Market Value Method:

This method is used only in case of listed companies, since they have a market value.

Market value of a company = No. of shares outstanding × market price per share

Present Value of Bonds

The method for valuation of bonds involves three steps as follows:

Step 1: Estimate the expected cash flows

Step 2: Determine the appropriate interest rate that should be used to discount the cash flows.

& Step 3: Calculate the present value of the expected cash flows (step-1) using appropriate interest rate (step- 2) i.e. discounting the expected cash flows

STEP 1: Estimating cash flows

Cash flow is the cash that is estimated to be received in future from investment in a bond. There are only two types of cash flows that can be received from investment in bonds i.e. coupon payments and principal payment at maturity.

The usual cash flow cycle of the bond is coupon payments are received at regular intervals as per the bond agreement, and final coupon plus principle payment is received at the maturity. There are some instances when bonds don’t follow these regular patterns. Unusual patterns maybe a result of the different type of bond such as zero-coupon bonds, in which there are no coupon payments. Considering such factors, it is important for an analyst to estimate accurate cash flow for the purpose of bond valuation.

STEP 2: Determine the appropriate interest rate to discount the cash flows

Once the cash flow for the bond is estimated, the next step is to determine the appropriate interest rate to discount cash flows. The minimum interest rate that an investor should require is the interest available in the marketplace for default-free cash flow. Default-free cash flows are cash flows from debt security which are completely safe and has zero chances default. Such securities are usually issued by the central bank of a country, for example, in the USA it is bonds by U.S. Treasury Security.

Consider a situation where an investor wants to invest in bonds. If he is considering to invest corporate bonds, he is expecting to earn higher return from these corporate bond compared to rate of returns of U.S. Treasury Security bonds. This is because chances are that a corporate bond might default, whereas the U.S. Security Treasury bond is never going to default. As he is taking a higher risk by investing in corporate bonds, he expects a higher return.

One may use single interest rate or multiple interest rates for valuation.

STEP 3: Discounting the expected cash flows

Now that we already have values of expected future cash flows and interest rate used to discount the cash flow, it is time to find the present value of cash flows. Present Value of a cash flow is the amount of money that must be invested today to generate a specific future value. The present value of a cash flow is more commonly known as discounted value.

The present value of a cash flow depends on two determinants:

  • When a cash flow will be received i.e. timing of a cash flow
  • The required interest rate, more widely known as Discount Rate (rate as per Step-2)

First, we calculate the present value of each expected cash flow. Then we add all the individual present values and the resultant sum is the value of the bond.

The formula to find the present value of one cash flow is:

PRESENT VALUE FORMULA FOR BOND VALUATION

Present Value n = Expected cash flow in the period n/ (1+i) n

Here,

i = rate of return/discount rate on bond
n = expected time to receive the cash flow

By this formula, we will get the present value of each individual cash flow t years from now. The next step is to add all individual cash flows.

Bond Value = Present Value 1 + Present Value 2 + ……. + Present Value n

Growth in Dividends: Normal growth and Super normal growth

One of the most important skills an investor can learn is how to value a stock. It can be a big challenge though, especially when it comes to stocks that have supernormal growth rates. These are stocks that go through rapid growth for an extended period of time, say, for a year or more.

Many formulas in investing, though, are a little too simplistic given the constantly changing markets and evolving companies. Sometimes when you’re presented with a growth company, you can’t use a constant growth rate. In these cases, you need to know how to calculate value through both the company’s early, high growth years, and its later, lower constant growth years. It can mean the difference between getting the right value or losing your shirt.

Supernormal Growth Model

The supernormal growth model is most commonly seen in finance classes or more advanced investing certificate exams. It is based on discounting cash flows. The purpose of the supernormal growth model is to value a stock that is expected to have higher than normal growth in dividend payments for some period in the future. After this supernormal growth, the dividend is expected to go back to normal with constant growth.

To understand the supernormal growth model we will go through three steps:

  • Dividend discount model (no growth in dividend payments)
  • Dividend growth model with constant growth (Gordon Growth Model)
  • Dividend discount model with supernormal growth

Dividend Discount Model: No Dividend Payments Growth

Preferred equity will usually pay the stockholder a fixed dividend, unlike common shares. If you take this payment and find the present value of the perpetuity, you will find the implied value of the stock.

For example, if ABC Company is set to pay a $1.45 dividend during the next period and the required rate of return is 9%, then the expected value of the stock using this method would be $1.45/0.09 = $16.11. Every dividend payment in the future was discounted back to the present and added together.

We can use the following formula to determine this model:

V= Dn/K

Where:

V=Value

Dn​=Dividend in the next period

k= Required rate of return​

Constant Growth Model: Gordon Growth Model

Next, let’s assume there is a constant growth in the dividend. This would be best suited for evaluating larger, stable dividend-paying stocks. Look to the history of consistent dividend payments and predict the growth rate given the economy the industry and the company’s policy on retained earnings.

Again, we base the value on the present value of future cash flows:

V = D1/ (k-g)

Where:

V=Value

D1=Dividend in the first period

k= Required rate of return

g=Dividend growth rate​

Dividend Discount Model with Supernormal Growth

Now that we know how to calculate the value of a stock with a constantly growing dividend, we can move on to a supernormal growth dividend.

One way to think about the dividend payments is in two parts: A and B. Part A has a higher growth dividend, while Part B has a constant growth dividend.

A) Higher Growth

This part is pretty straight forward. Calculate each dividend amount at the higher growth rate and discount it back to the present period. This takes care of the supernormal growth period. All that is left is the value of the dividend payments which will grow at a continuous rate.

B) Regular Growth

Still working with the last period of higher growth, calculate the value of the remaining dividends using the V = D÷ (k – g) equation from the previous section. But D1, in this case, would be next year’s dividend, expected to be growing at the constant rate. Now the discount goes back to the present value through four periods.

A common mistake is discounting back five periods instead of four. But we use the fourth period because the valuation of the perpetuity of dividends is based on the end of year dividend in period four, which takes into account dividends in year five and on.

The values of all discounted dividend payments are added up to get the net present value. For example, if you have a stock that pays a $1.45 dividend which is expected to grow at 15% for four years, then at a constant 6% into the future, the discount rate is 11%.

Annuities, Types, Valuation, Uses

An annuity is a financial product that provides certain cash flows at equal time intervals. Annuities are created by financial institutions, primarily life insurance companies, to provide regular income to a client.

An annuity is a reasonable alternative to some other investments as a source of income since it provides guaranteed income to an individual. However, annuities are less liquid than investments in securities because the initially deposited lump sum cannot be withdrawn without penalties.

Upon the issuance of an annuity, an individual pays a lump sum to the issuer of the annuity (financial institution). Then, the issuer holds the amount for a certain period (called an accumulation period). After the accumulation period, the issuer must make fixed payments to the individual according to predetermined time intervals.

Annuities are primarily bought by individuals who want to receive stable retirement income.

Types of Annuities

There are several types of annuities that are classified according to frequency and types of payments. For example, the cash flows of annuities can be paid at different time intervals. The payments can be made weekly, biweekly, or monthly. The primary types of annuities are:

  1. Fixed annuities

Annuities that provide fixed payments. The payments are guaranteed, but the rate of return is usually minimal.

  1. Variable annuities

Annuities that allow an individual to choose a selection of investments that will pay an income based on the performance of the selected investments. Variable annuities do not guarantee the amount of income, but the rate of return is generally higher relative to fixed annuities.

  1. Life annuities

Life annuities provide fixed payments to their holders until his/her death.

  1. Perpetuity

An annuity that provides perpetual cash flows with no end date. Examples of financial instruments that grant the perpetual cash flows to its holders are extremely rare.

The most notable example is a UK Government bond called consol. The first consols were issued in the middle of the 18th century.

Valuation of Annuities

Annuities are valued by discounting the future cash flows of the annuities and finding the present value of the cash flows. The general formula for annuity valuation is:

Uses of Annuities:

  • Retirement Income:

One of the primary uses of annuities is to provide a steady stream of income during retirement. Individuals can convert their retirement savings into an annuity, ensuring they receive regular payments for a specified period or for the rest of their lives. This helps manage longevity risk and provides financial security in retirement.

  • Wealth Management:

Annuities can be used as a wealth management tool, allowing investors to grow their assets on a tax-deferred basis. The accumulation phase of certain annuities lets individuals invest their funds in various financial instruments, potentially increasing their wealth over time before withdrawing it later.

  • Educational Funding:

Parents can use annuities to save for their children’s education. By purchasing an annuity that provides payments when their children reach college age, parents can ensure they have the funds needed to cover tuition and other educational expenses.

  • Structured Settlements:

Annuities are often used in structured settlements resulting from legal claims or personal injury cases. Instead of receiving a lump sum, individuals can opt for an annuity that pays out over time, providing financial stability and reducing the risk of mismanaging a large sum of money.

  • Estate Planning:

Annuities can play a role in estate planning by providing a way to transfer wealth to heirs. Certain types of annuities allow individuals to designate beneficiaries, ensuring that funds are passed on according to their wishes while potentially avoiding probate.

Present Value of an Annuity payable times a year

An annuity due is a series of equal consecutive payments that you are either paying as a debtor or receiving as a lender. This differs from an annuity, as an annuity is a form of investment. Annuities are paid at the end of a period, while an annuity due payment is made at the beginning of a period. This payment covers the period to come.

Some examples of this could be a premium on insurance or rent due. If you were renting a house to someone, their monthly payments are an annuity due.

Time Value of Money 

Present value can be a difficult topic to digest. It refers to a concept called “the time value of money”. Time value of money can be explained thusly—if you were given $1 today, it is worth more than the same $1 five years from now. This is due to the changing value of money and inflation, and the potential of money to earn interest.

The present value of an annuity due (PVAD) is calculating the value at the end of the number of periods given, using the current value of money. Another way to think of it is how much an annuity due would be worth when payments are complete in the future, brought to the present.

Calculating the PVAD

For this formula, the following values are used:

P = periodic payment

r = rate per period

n = number of periods

The formula used is:

PVAD = P + P [ (1 – (1 + r) – (n – 1) ) ÷ r ]

Present Value of Deferred annuities

An annuity is essentially a finance related contract, which permits the person who is buying it to pay on a lump-sum basis or make payments in series, in return for acquiring disbursements at regular intervals in future. Deferred Payment Annuity is a type of an annuity in which the payments that are received start somewhere in the future instead of starting at the time it is initiated.

Deferred payment annuity generally provides tax-deferred development and growth at a variable or fixed rate of return, similar to a regular annuity. Deferred payment annuity is usually bought for under-age or small children so that the benefit payment amount can be postponed till they complete a certain or desired age. Such annuities are extremely helpful when it comes to planning for retirement.

Deferred annuities are a type of annuity contract that delays payments to the investor until the investor elects to receive them. When the investor is in savings mode, he makes payments into some sort of investment account. The investment grows and compounds in a tax-deferred manner, and the investor pays no taxes on its growth until he decides to convert the investment into an annuity and start receiving regular payments.

A deferred annuity is essentially an investment vehicle that is sold by companies that provide insurance to people. The value of a deferred annuity can typically be calculated in two different ways i.e. future based value or present based value. It is these particular values that can assist you in determining the amount you should invest in order to fulfill your investment related goals.

Deferred annuity formula is used to calculate the present value of the deferred annuity which is promised to be received after some time and it is calculated by determining the present value of the payment in the future by considering the rate of interest and period of time.

Present Value Calculation

As per this method, you need to take the present value i.e. the amount you are thinking of investing today, into consideration. Next, you will have to provide definitions for the variables. For example, if you wish to make a saving of 100,000 dollars by the time a decade comes to an end and you come across an annuity that would offer you a minimum of 5% return on an annual basis, then your present value would typically be a minimum of 61,391 dollars today.

Future Value Calculation

For this, you will have to make note of the future value, which is the amount that you would receive after the maturity of the annuity. Next, define all the variables. For example, if you are planning to make an investment of 10,000 dollars and wish to find out how your asset would grow in case you were to get a 5% rate of interest over a period of twenty years, then your investment’s future value would be 26,532 dollars.

An annuity is the series of periodic payments received by an investor on a future date and the term “deferred annuity” refers to the delayed annuity in the form of installment or lump-sum payments rather than an immediate stream of income. It is basically the present value of the future annuity payment. The formula for a deferred annuity based on an ordinary annuity (where the annuity payment is done at the end of each period) is calculated using ordinary annuity payment, the effective rate of interest, number of periods of payment and deferred periods.

Deferred Annuity = P Ordinary * [1 – (1 + r)-n] / [(1 + r)t * r]

error: Content is protected !!