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).
CAPM – can you really price the risk in equity markets?
WHAT IS CAPITAL ASSET PRICING MODEL (CAPM)? Capital Asset Pricing Model is one of the
Finance Degree – what you are pursuing in 2024?
Finance has been the most popular and lucrative career domain amongst the population of most
CAGR – how does compounding even work?
What is Compound Annual Growth Rate (CAGR)? Compound Annual Growth Rate is commonly referred to
ROIC – do we finally have a good measure of value creation?
Return on Invested Capital (ROIC) measures profits on all capital (short term debt, long-term debt,