Excel is a tool most commonly used for data analysis, building financial models for efficient decision making. It is used by people with diverse back grounds (ie; bankers, analysts, professionals, students etc.). In excel there are a lot of inbuilt functions which can be used for quick data...

READ MORE

What is Market Capitalization ? Market capitalization means the market value of equity shares of the Company. It is an important component of a Company’s valuation. It can be calculated as Share price multiplied by the total number of outstanding shares of the Company. Example: ABC Limited...

READ MORE

What is Net Present Value? Net present value is the difference between present value of cash inflows and present value of cash outflows. It is a technique used to evaluate potential investment decisions. Decisions could be for an investment in or replacement of a fixed asset, investment or...

READ MORE

“IF YOU WERE BORN POOR ITS NOT YOUR FAULT. BUT IF YOU DIE POOR ITS YOUR FAULT.”This is a famous quote from Bill Gates. Every one of us want to become rich. We may at times buy lottery tickets to test our luck… People also go to Casinos for gambling… to change their fortunes. I know many...

READ MORE

What is Cash flow Statement? Cash flow statement is a statement reported by Corporates in their filings along with the Income Statement and the Balance Sheet. It is very important to understand the Cash flow statement but is often overlooked by investors and analysts. While the income...

READ MORE

Total shareholder return is rate of return earned by an investor by investing in stocks of Companies during the investment period. An investor investing in stocks makes money in two ways; First is the capital appreciation or loss from rise or fall in the share price of the Company. Second is...

READ MORE

Description : Understand the basic difference between fundamental and technical analysis of stocks to determine the quality of long-term investments Fundamental Analysis Fundamental analysis is done to identify the intrinsic value of an asset/ security. A fundamental analysis involves...

READ MORE

Using keyboard short cut keys while working on Power Point documents help improve efficiency. Here is a list of 80+ keyboard shortcuts for commonly used functions. Practicing these short cuts would help you to memorize them, thus improving the productivity drastically while working on...

READ MORE

Using Excel short cuts help work much faster and improve efficiency. Here is a list of 100+ keyboard shortcuts for commonly used functions. Practicing these short cuts would help you to memorize them, thus improving the productivity drastically while working on complex data analysis or financial...

READ MORE

XLOOKUP is a function which is newly introduced function in MS Office 365. It can be used in place of VLOOKUP as well as HLOOKUP, Index, Match and much more. Here are a few advantages of using a XLOOKUP function. Lookups in both vertical and horizontal ranges XLOOKUP does not break when we...

READ MORE