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

Yes Bank is the fifth largest private lender in India. It accounts for approximately 2.3% of total bank loans and 1.6% of banks deposits domestically. RBI has recently imposed a moratorium on the bank. It has imposed a withdrawal limit of Rs 50,000/- for depositors. This has led to several...

READ MORE

Equity markets have generated highest returns for decades as compared to gold, fixed deposits, debt and other financial instruments. All of us want to generate high returns from our portfolio. Quite often, while looking at stock prices of different companies, we find the valuation of one...

READ MORE

There are a number of financial metrics used frequently to measure performance of a company. To name a few; EBITDA margin, EBIT or operating margin, Net income margin, earnings per share, return on equity, return on invested capital or Return on capital etc. While going through analyst reports,...

READ MORE

There is a lot of talk about the student debt crisis in the United States. An average graduate in the U.S. has a student loan of $35,000 still to be paid off. That is just insane! The high cost of college education is an issue not only in America, where student loan debt has reached an...

READ MORE

Is it possible to have a freelancing career in financial services? Yes, certainly – the financial services industry has undergone a radical transformation in recent years, thanks to the internet and cloud computing. There are today a number of jobs in the financial industry that can be done...

READ MORE

Excel has been around for more than 30 years now, and it still remains the best tool for data automation. Entering data is a laborious process, which takes up a lot of your time if you do it manually. Instead of getting stuck in the sort of grunt work that adds no value whatsoever to your...

READ MORE

Are you worried about losing focus or concentration at work? Do you feel mentally exhausted every night? Do you struggle with deadlines all the time? Well, then read on, this article is just for you. We all want to be more productive at work, but it’s easier said than done. We fall behind...

READ MORE

In this article, we briefly discuss the different valuation methodologies for startups. This is only an introduction to the different methodologies. For a more detailed study, you should sign up for our online course on Financial Modeling Skills - Multiples Based Valuation. So who is this...

READ MORE

College education has become more expensive than ever before. The average student debt of a college graduate in the United States is as high as $37,172, up by $20,000 since 13 years ago. It’s the same in India and other countries, where parents spend their lifetime savings on their kids’...

READ MORE