What is a Long-term Investment (or “LTI”)? There are different items that could be classified as a long-term investment.  A parent company may have a small ownership stake in another company (i.e. there may be a strategic reason to have an ownership position in a key supplier).  Note – this must...

Continue reading

What does the Income Tax Expense line on the income statement mean? All companies calculate their income taxes using two sets of rules:   Accounting Rules (IFRS or US GAAP, depending on where the company is based)   Tax Rules (these are set by each country’s government tax agency) The Income Tax Expense line...

Continue reading

In this article, we’ll explore the topic of Equity Value, basic and diluted shares outstanding, and key ratios related to equity value. Table of Contents How do you calculate equity value? What are basic shares outstanding? What are fully diluted shares outstanding? When do we use Equity Values in ratios? What are some problems with Equity...

Continue reading

Earnings Per Share (EPS) is one of the most widely used metrics in financial analysis—and for good reason. It represents the portion of a company’s profit allocated to each outstanding share of common stock, making it a key indicator of profitability and shareholder value. Whether you're a seasoned investor, a...

Continue reading

What is meant by Enterprise Value? A simple way to think about enterprise value is that it represents the market value of all the assets of the firm, regardless of how they are funded.  In contrast, equity value refers to only the common equity holders’ residual stake in the value of...

Continue reading

How to Model Multi-Stage Terminal Values As James Bond theme-song singer Shirley Bassey once crooned, "Cash Flows are forever, they are all I need to please me.... I've no fear that they might desert me". Ok, maybe not quite. For those who use Discounted Cash Flow ("DCF") for valuation, you have probably...

Continue reading

Copy & Paste in Excel Using the CTRL + ENTER and SHIFT + F8 Shortcuts When working in Excel, one of the most common sequences is to fill in one cell (with a link or a formula) and then copy and paste the same thing into adjacent cells. How many ways...

Continue reading

How to Work Simultaneously in Multiple Parts of the Same Excel Workbook “Mirror, mirror on the wall….” Many of us struggle to work with Excel files because you can only see one part of a file at a time…when you want to make a change to one part of a model...

Continue reading

My Balance Sheet Doesn’t Balance: How to Balance Your Balance Sheet in 3 Easy Steps Have you ever been there?  It’s late at night, you’ve been slugging away at your model for days.  Now comes the pièce de résistance – it’s time to build the balance sheet and bring the model across...

Continue reading

Ensuring Consistent Excel Formulas In a previous TTS Resource, we discussed how to evaluate a formula with “Edit” mode, as well as with the F9 key. But what if you have already reviewed your formula for correct syntax and want to ensure consistent Excel formulas for other cells? This is where CTRL +...

Continue reading