Data & Finance for Work & Life
Convertible loans and options intimidate many people, but they’re less complex than they seem. In the context of company share counts, they have a dilutive effect. This is due to the standard Earnings per Share (EPS) metric, which is net income divided by total shares. If there are convertible loans and other options that could […]
Convertible Loan & Stock Option Dilution: Examples for FDSO Read More »
Cash flow management is the lifeblood of all sizable businesses. Most companies use accounting software or ERPs to project short term cash flows based on the values of sales & purchases made on credit. However, predicting long term cash flows (>1 quarter into the future), requires manual analysis, since accountants have not provided the ERP
3 & 12 Month Cash Flow Projection: Excel Guide & Template Read More »
Cash is king — financial analysts and accountants know this well. But when a company grows to more than its founding team, understanding where cash is disbursed and received is not an easy task. One way to tackle this is to directly track all cash transactions, such as receipts from customers or payments to employees,
Excel Guide: How to Prepare Cash Flows with the Indirect Method Read More »
Tableau’s sorting function can be tricky. Have you tried sorting a grand total column that aggregates values from calculated fields, or maybe tried using a window (across/down) calculation instead of the grand total? In other words, have you tried sorting a dimension by a table calculation of calculated fields? Unfortunately, directly sorting on aggregates of
Sort by Grand Total or Window Calculation in Tableau Read More »
Data fields are fundamental building blocks of data. They are so essential that analysts in various disciplines have appropriated them to meet the needs of their use cases. Though these applications are a testament to the value of a data field, they create confusion as to the precise meaning behind them. The purpose of this
What is a data field? Definition, Types, & Examples Read More »
“Lenders” and “creditors” are an essential part of the economy. The terms represent the same underlying idea. And yet, a small survey of my colleagues revealed that some consider them opposites. It’s easy to see why: though they represent the same concept, we often use them in opposite situations. The purpose of this article is
Lender vs Creditor: What’s the Difference? Read More »
Excel users often find themselves dragging colored box references when moving a formula in an asymmetric worksheet. The all-too-frustrating reality, however, is that when a formula references the same cell multiple times, you have to drag each reference in the formula. Unfortunately, there is no shortcut to select all instances of a cell reference within
Grab & Drag All Instances of Cell Reference in Excel Formula Read More »
If you’re coming from Excel, Tableau may feel like a blessing and a curse. On the one hand, it automates and simplifies in a few clicks what could take hours in Excel. On the other, it uses a different calculation logic and requires you to think about data as aggregates rather than individual cells. When
Tableau SUMIF, IF SUM & Aggregates On Multiple Conditions Read More »
If you’ve tried to understand data attributes while learning to program or exploring a big data tool, chances are you ended up with a lot of questions. Data attributes are simple, but their meaning can get lost in the noise. The purpose of this article is to clearly define data attributes, explain the different types,
What is a data attribute? Definition, Types & Examples Read More »
The term “stakeholder” has gained popular use in the past decade, but the principle behind the term is as old as capitalism. A stakeholder is an entity or individual that has an interest in the success of a project. While that interest may be moral, sentimental, or familial, more often than not, it’s financial. This
Is a lender a stakeholder? Read More »
