
Let's walk through and understand the business model before we start designing KPIs
Now let's look at the factors driving profits so we can design KPIs
Examine revenue growth year over year using same-store sales to remove expansion effects, illustrated with Whole Foods data. A decline signals potential issues with awareness, promotions, and in-store sampling.
Analyze gross margin per sku to identify underperforming products and diagnose costs—raw materials, labor, overhead, freight, and packaging—using banana yogurt with frozen banana puree as an example.
Improve the cash position by shortening the collection cycle and lengthening the payables cycle, focusing on days sales outstanding and payable outstanding to widen the gap between them.
learn how to calculate days sales outstanding (DSO) from accounts receivable and credit sales, interpret industry benchmarks, and improve cash collection by negotiating terms and simplifying payments.
Calculate days payable outstanding (dpo) as accounts payable divided by cost of goods sold times days, and push toward the 90-day average by negotiating terms and paying at period end.
Measuring a company’s solvency made easy with these 3 frequently used ratios
In this video I will teach you 3 financial liquidity ratios that are commonly used by financial analysts and investors. Rather than just looking at the cash balance, let’s dive deeper by measuring the liquid assets relative to the firm's obligations
Explain key performance indicators for financial leverage, including debt to equity, debt to capital, debt to assets, and the financial leverage ratio, using a balance sheet example.
Learn how SpaBooker operates as an online marketplace linking consumers with local spa spots via a mobile app, earning commissions on bookings while growing supply, demand, and take rate.
Examine SpaBooker's income statement to map revenue, cost of sales, and EBITDA, and identify KPIs like gross booking value, take rate, and customer acquisition cost for break-even.
Track year-over-year growth in spa inventory by May 2020 (30) vs May 2019 (20), a 50% increase. Improve drivers like product design, self-service signup, territory expansion, and sales incentives.
Discover how gross booking value measures the platform's total bookings monthly. Track the growth pace toward milestones like ten million, and understand how inventory, users, and marketing influence progress.
Calculate the average spend per user as total booking value divided by unique users; track monthly trends and raise spend by offering higher value services and engaging users.
Define take rate as commission divided by the total booking value and track it monthly to gauge marketplace power. Increase commissions over time, improve billing accuracy, and automate invoicing.
Analyze the KPI of customer acquisition cost by dividing marketing costs by new users, track monthly trends, and optimize channels, content, and incentives to lower CAC.
Explore how spa booker functions as a marketplace that connects spas and users, driving growth through inventory expansion, higher gross booking value, and improved take rate.
Analyze take rate as commission over total booking value, illustrated by a 30% take rate on May data. Improve by renegotiating commissions, ensuring billing accuracy, and monitoring CAC across channels.
Please, please..deliver KPIs as insight and not just data. Please watch my 3 key bits of advice when it comes to how you should deliver KPIs to stakeholders.
In this video, we go over the optimal way to structure your Excel file
In this lecture I teach you how to create a drop-down menu for your months along with the Index/Match formula, which I show you how to build as telling-a-story so you don't forget how to use it.
Let's go over best practices with setting your KPI targets.
Let's define Accounting!
Let's discuss how data flows from the day-to-day business activities all the way to the financial statements.
Explore debits and credits through a car sale example, using t accounts and the dealer mnemonic to classify assets, expenses, liabilities, equity, and revenue for journal entries.
A quick overview of the 3 main financial statements.
Let's understand the Income Statement via a real life example!
Let's understand the Balance Sheet via a real life example!
Let's understand the Cash Flow Statement via a real life example!
Let's understand the Accounts Receivable via a real life example!
Let's understand the Accounts Payable via a real life example!
The matching principle requires recognizing revenues and expenses in the same period; for example, record a $5,000 commission in March by accruing a liability and later paying in April.
Learn the accrual principle of accounting by recording expenses when incurred rather than when paid, illustrated with a March advertising invoice billed in April under GAAP.
Learn how the historical cost principle records assets at their original cost, with a $10,000 machinery example and five-year amortization, and why mark-to-market violated it in Enron.
Analyze Enron's mark-to-market accounting that booked future revenue today, inflating earnings and stock performance, and review the 2001 bankruptcy, auditors, and the Sarbanes-Oxley internal controls framework.
Apply the objectivity principle to record revenues and expenses using evidence such as purchase orders, invoices, payments, and bank statements, ensuring audit-ready backup.
KPIs are simple yet powerful tools to measure the health of any business
In this class, I show you the best practices on setting KPIs and a step-by-step design of a KPI Dashboard. I will teach you how to interpret and speak about commonly used KPIs that are used by the most successful financial financial analysts.
We will go through two different businesses:
1) GutBuddy Yogurt Inc.
A manufacturer of yogurt. We will learn KPIs around sales as well as cost optimization.
2) SpaBooker Inc.
An online marketplace. We will learn KPIs around Take Rate, Customer Acquisition Cost, and many more.
I will cover Days Sales Outstanding (DSO)
This KPI gives a snapshot of the health of customer relations. How fast are you invoicing & collecting from customers? How favorable are your customer payment terms? These are all factors we will talk about in the course.
I will walk you through Days Payables Outstanding (DPO)
This KPI helps a business keep track of it's Working Capital optimization. I will teach you all the factors that could impact this KPI and how to improve it.
I will teach you how to structure your worksheet in Excel.
I will show you the model used by the most successful analysts. You will learn how to segregate your raw data from your formulas and finally create a separate great looking dashboard.
How to write your Excel formula like you are telling a story in your head!
If you are not familiar with the Index/Match formula, I will show you how to always remember how to write it like you are telling a story. This way you will never forget!
Bonus lectures - We will cover the Accounting basics
We will go over the flow of data in Accounting from business activities all the way to the Financial Statements.
I am a CPA and controller of a tech startup in New York City and have a wide range of experiences ranging from public/corporate accounting to financial planning & analysis over the past 12 years.
This class is meant for:
Accounting/Finance major students and those who are thinking about majoring in the field.
Accountants, financial analysts, controllers and CFOs
Accounting and/or Finance major college students.
Business owners