Data & Finance for Work & Life
Companies “going public” have to make two big decisions: 1. how to price their stock for the public markets, and 2. how to list their stock on the public markets. Traditional paths for pricing involve hiring an investment bank, who discusses with its inner circle of investors about a good offering price. Companies who decide […]
Book Building IPO: Example Companies & How to Identify Them Read More »
If you’ve spend some time researching types of IPOs, you’ve certainly stumbled upon traditional IPO paths such as the fixed price and book building methods, which involve serious collaboration with underwriters and investment banks to determine the opening stock price. But some companies — notably Google — have started challenging the need for institutional involvement.
Dutch Auction vs Open IPO: Key Differences & Which is Better for Your Company Read More »
Labor can be a tricky topic in accounting journals, especially on the balance sheet. Most students learn that labor and wages are a cost item on the profit and loss statement (P&L). However, labor expenses appear on the balance sheet as well, and in three notable ways: wages payable, works in progress, and capitalized expenses.
Labor on the Balance Sheet: Wages Payable, Works in Progress, & Capitalized Expenses Read More »
Last week, I was working on an accounting exercise in Tableau in which I needed to filter a trial balance for all accounts starting with “6” and “7.” Where I work, these are the accounts present on the profit and loss statement. The first thing I did was look at the wildcard filter settings, since
Filter On Two Substring Values With STARTSWITH() in Tableau Read More »
In the world of finance, one word can have many meanings. It is easy to get confused, whether you’re a beginner or seasoned professional. For example, the very word “asset” can mean money, a right to money, or simply an object that can be converted into money. Capital is another one of those many-purpose terms,
Is capital stock an asset? No, and Here’s Why It’s Confusing Read More »
If you’re anything like me, you can’t use waterfall charts enough. They’re the ideal visualization of the addition and subtraction of values from a total over time. In Excel, there’s a really simple way to create waterfall charts. However, getting/setting total columns? Not so easy. Total columns are essential to waterfall charts. Yet for some
How to Set the Total Bar in an Excel Waterfall Chart Read More »
Accounting is funny about big ticket items. If a company buys a car, building, large machine, or other big purchase, the asset starts to lose value immediately. On the books (specifically, under the account “Fixed Assets at Cost”), fixed assets lose value at a hefty linear rate. In most cases, this “book value” is very
Fixed Assets at Cost: Lost Asset Appreciation (& Examples) Read More »
Finance and legal departments are simultaneously similar and different. They’re similar insofar as both play a supporting role in an organization, yet they’re different in terms of tools, mediums, and applicable skills. Lawyers are text-oriented thinkers whereas finance professionals look at numbers and financial statements. The good news is that they share fundamental cognitive skills:
Finance to Law: Breaking into Law with a Finance Background Read More »
Finance and Administration is more than the sum of it’s parts. This article explains why. In most companies, the term “administration” applies to departments that play a supporting role for operational teams. Administrative departments include human resources (HR), public relations (PR), corporate development and strategy (CD&S), and of course, finance. The reason we call them
Finance and Administration Function: Specialist & Manager Read More »
Clusters are everywhere. In school, students are placed in different grades and classes. In business, employees belong to different departments. How do we decide who goes where? Shared characteristics such as age, subject matter, or skill, tell us who belongs together. In the same way, data analysts cluster data based on similarities among data points.
Data Cluster: Definition, Example, & Cluster Analysis Read More »
