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
The If Function in Excel – What would you do without it?
The IF function in excel is one of the most used Excel functions and is
Index Match – A combination made in heaven
Index-Match function has become more popular tool in excel than VLOOKUP function as it solves
Annual Report – A credible storehouse of all financial information
WHAT IS AN ANNUAL REPORT? Every public corporation is required by law to publish annually
EBITDA is not the same as Cash Flows
WHAT IS EBITDA? The term EBITDA stands for Earnings(E) before(B) Interest(I), Taxes(T), Depreciation(D) and Amortization(A).