Data & Finance for Work & Life
Cash is king… but not every stakeholder sees cash the same way. For example, equity shareholders may want to know how much cash is available after paying loans and interest, whereas debt stakeholders want to know how much cash is available before loans and interest. These diverging needs for stakeholders has given birth to Free […]
Levered vs Unlevered Free Cash Flow: What’s the Difference? Read More »
What is the value of a company? Strictly speaking, company value is equal to equity on the balance sheet (aka book equity value). After all, equity is equal to total assets minus total liabilities, and it makes sense that a company worth its net assets — right? Not exactly. Net asset value ignores several key
What is enterprise value (EV) used for? (& Why It’s Important) Read More »
You may have heard that “data is the new oil” — the most valuable commodity of the 21st century. But just like oil is useless until refined, data is useless until simplified and communicated. Data displays are a tool to help analysts do just that. Because they’re so important to data, data displays can be
What is a data display? Definition, Types, & Examples Read More »
Data functions are the nuts and bolts of the digital world. In development, they allow programmers to exchange directly with a database and modify object in-line. In Excel, they query, create, and modify arrays. In math, they allow statisticians to address datasets using Sigma (Σ) and Pi (∏) notation. But what exactly is a data
What is a data function? Examples in Math, Excel, Computer, & Programming Languages Read More »
So you’re an accountant and you want to become a financial analyst? First thing’s first: know you have a huge advantage with a background in debits & credits. Many financial analysts don’t bother to understand double-entry accounting at all. On the other hand, you may find it difficult to conceptualize forward-looking, predictive analytics that financial
11 Steps to Transition from Accountant to Financial Analyst Read More »
If you’re coming from Excel, manipulating colors in Tableau can feel unnecessarily complicated, especially while you’re learning. In Excel, changing the color of a column is as easy as highlighting and right-clicking the cells you want to change. However, colors in Tableau are usually modified at the data level. The methodology depends on whether you’re
Change Color of 1 Column in Tableau (Conditional Formatting) Read More »
Have you ever tried to put a floating object over a tiled object in Tableau dashboard, only to see a blur of layered content? In Tableau, the default background setting for floating objects is transparent, which is the source of this challenge. In early versions of Tableau, transparency wasn’t available. This meant the format of
How to Make a Floating Box Non-Transparent in Tableau Dashboard Read More »
If you’re new to finance, you may be wondering about the hype around so-called “financial statements.” To their users, financial statements are creative, holistic, and efficient representations not only of a company’s financial performance, but also its innermost business mechanics. Based on financial statements alone, users can deduce company performance, efficiency, competitiveness, and prospects. And
Financial Statements & their Utmost Importance to Users Read More »
Also known as big-ticket items, fixed assets are the money-making gears of a company’s financial makeup. They’re long-term, can be intangible or intangible, and can be physical or non-physical. At the accounting level, they’re loaded onto the balance sheet upon delivery. Over the course of their lives, fixed assets are recorded on the income statement
Fixed Assets vs Total Assets: Difference & a Healthy Ratio Read More »
Roll forwards are a critical part of accounting consistency and integrity. You may have discovered roll forwards whilst reviewing general ledger transactions, or while exploring methods of accounting reconciliation. A roll forward is a simple concept. However, it has become an umbrella term that’s used to describe different accounting activities. In this article, we’ll clearly
Roll Forward in Accounting: Definition, Types, & Examples Read More »
