SUMPRODUCT in Excel – a matrix calculation function
WHAT IS SUMPRODUCT IN EXCEL FUNCTION? The SUMPRODUCT in Excel function is found under the
Excel Offset function – a perfect set off to the lookups
WHAT IS EXCEL OFFSET FUNCTION? Offset function returns a reference to a range that is
EV/EBITDA Multiple – do you feel the weight of expectations
WHAT IS ENTERPRISE MULTIPLE? EV/EBITDA also known as Enterprise multiple or EV multiple is a
Operating Cash Flow – The only metric that matters
WHAT IS OPEARTING CASH FLOWS (OCF)? The amount of cash generated by the business from
COUNTIFS Function in Excel – count you in or not?
The COUNTIFS function is a versatile tool and is categorized under Statistical functions in Excel.
Revenue – the top line that everyone is chasing
WHAT IS REVENUE? Revenue is the total amount of income generated by the sale of
Treasury Stock – is a share buy back worth it?
WHAT IS TREASURY STOCK? Treasury stock is also known as treasury shares or reacquired stock.
Leveraged Buyout – is it worth the risk?
WHAT IS A LEVERAGED BUYOUT? A Leveraged Buyout is the transaction where one company is
Dividends – Does it affect company value?
INTRODUCTION If any person is looking out for building long term wealth, then investing in
EBITA – better than EBITDA?
WHAT IS EBITA? The full form of EBITA is Earnings before Interest, Tax and Amortization.
Net Working Capital – positive or negative?
INTRODUCTION A company’s finance team one of the job is to evaluate whether their company
INDIRECT Function – nothing direct about it
The Indirect function returns the reference specified by a text string. It is used to
Market to Book ratio – did you create value?
WHAT IS MARKET TO BOOK RATIO? The market to book ratio is also known as
Contribution Margin – did you break even?
The target of all the companies is to make sufficient profits so as to cover
SUMIF Excel Function – add but with conditions
WHAT IS THE SUMIF EXCEL FUNCTION? SUMIF Excel function is one of the most useful
DCF Calculation – a scientific valuation methodology
WHAT IS DISCOUNTED CASH FLOW (DCF)? Discounted Cash Flow is one of the financial valuation
Leverage ratio – will you take debt over equity?
WHAT IS LEVERAGE RATIO? A company’s inherent financial risk can be measured by one of
PE Ratio – is it under/over valuation?
WHAT IS THE PRICE TO EARNINGS RATIO? The Price to Earnings Ratio is the financial
Income Statement – Did you turn green this time?
WHAT IS AN INCOME STATEMENT? A company’s financial performance over any specific accounting period is
Liquidity Ratios – Its all about cash
An investor or a financial analyst calculates varies ratios using the income statement and balance