Memuat
Memuat
Want to go deeper?
Join one of our courses or ask us directly on WhatsApp.
Picked from the software, topic, and level of “Claude from Zero to Expert Class #64: Simple Financial Analysis for Small Businesses”.
Other ways we can help with Claude.
Learn with a mentor
Scheduled AI & Machine Learning courses with live guidance and a certificate.

Midjourney Course: Create Stunning AI Images from Text
★ 4.9

DALL-E Course: Creating Professional AI Images from Text
★ 4.9

Stable Diffusion Course: AI Art from Beginner to Professional
★ 4.9
Have it built for you
No time to learn Claude? Our team can do the project for you.

AI Image Creation with Stable Diffusion — Unlimited Custom Visual Production
★ 4.9

AI Image & Video Creation with Leonardo AI — All-in-One Visuals for Business
★ 4.9

AI Image Creation with Midjourney — Cinematic AI Art for Business
★ 4.9
Get notified about new Claude classes
At most one email a week. Unfollow anytime with one click.
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Hi, and welcome back to Claude from Zero to Expert. Today we tackle something that often gives business owners a headache: finances. We'll prepare the data, build a profit and loss statement, compare margins per product, calculate the break-even point, and read cash flow. All in plain language.
Laras was once thrilled because Sunset Coffee's revenue last month reached well over ten million rupiah. But at the end of the month, the money in her account felt like much less. This is a common trap. High revenue doesn't always mean high profit. What matters is how much is left after every cost is paid. Let's simplify it into four questions. First, is my business making a profit? The answer is in the profit and loss statement. Second, which product is most profitable? We look at the margin per product, which is the money left from each sale after ingredient costs. Third, what's the minimum sales needed to avoid a loss? That's called the break-even point. Fourth, is there enough cash this week? Cash flow answers this. Even a profitable business can struggle if the money hasn't come in yet. We'll work through all four with Claude. Claude helps build and explain, but we still check the numbers ourselves.
The first step is preparing the data. Laras builds an October recap in a spreadsheet. First row, the iced coffee cup: six hundred sold, priced at eighteen thousand rupiah, with ingredients costing seven thousand per cup. The one-liter iced coffee sold forty bottles, with ingredients costing thirty-two thousand per bottle. Cold brew sold fifty bottles, with ingredients costing twenty thousand. Gift hampers sold ten packages, with contents costing eighty thousand per package. Total revenue for October is eighteen million four hundred fifty thousand rupiah. All these numbers are examples, but you can copy the structure for your own business. Before sending data, check a few things. First, send a recap per product, not a full list of transactions per customer. For this analysis, a recap is enough. Second, separate per-unit ingredient costs from fixed monthly costs such as rent and wages. The two are calculated differently. Third, make sure personal money isn't mixed in. If Laras pays for household shopping from the business cash, any report will be misleading. What you must not send: customer names, phone numbers, or addresses. Also bank account numbers and the password for your point-of-sale app. This data isn't needed for analysis and is risky if it leaks.
Laras sends that recap to Claude, plus her fixed monthly costs: rent, Dimas's wage, electricity and water, other costs, and the marketing budget. The statement appears in the right panel. The three cards at the top sum it all up: revenue of over eighteen million, gross profit of eleven million one hundred seventy thousand, and net profit of three million nine hundred fifty thousand. The table below shows the flow. Revenue minus ingredient costs gives gross profit. Gross profit minus fixed costs gives net profit before tax. So out of eighteen million in revenue, only about four million is really left. Laras checks this number against her cash records before trusting it. The second question: which product is most profitable? Laras asks for a comparison of each product's margin as a chart. Cold brew is highest, at about sixty-four percent. Hampers are lowest, at about forty-seven percent, because the contents and packaging cost a lot. The margin formula is written under the chart, so Laras can recalculate it herself. Should hampers be dropped? Not necessarily. Claude itself mentions that hampers help attract office orders. Numbers help us ask questions, but decisions still consider the business strategy.
The third question: what's the minimum sales needed to avoid a loss? Laras asks using the simplest example, as if she only sold iced coffee cups. Claude explains the steps. Each cup leaves eleven thousand rupiah after ingredients. Fixed costs of seven million two hundred twenty thousand divided by eleven thousand is about six hundred fifty-seven cups a month. The monthly number becomes a daily target: about twenty-two cups a day. A daily target like this is much easier for Dimas to track at the cashier. The fourth question is cash flow. Remember the meeting coffee subscription for Maju Bersama Co.? Every Monday, Sunset Coffee delivers coffee. The ingredients are paid for in cash the next day. Then on the first of the month, rent and wages are due. But the office only pays at the end of the month. On paper this business is profitable, yet in the middle of the month it can run short of cash. So Laras asks Claude for a weekly cash table: when money comes in and when it goes out. Here's the weekly cash table Claude built. In week one, the opening balance is four million and cash in is three million eight hundred thousand, but cash out is almost seven million because of rent and wages. The closing balance is just nine hundred thousand. In week two, cash starts to recover because the big expenses are behind us. In week three, the balance rises again to almost six million. In week four, the office subscription payment comes in, and the month-end balance looks healthy. The lesson: week one is the riskiest week. Laras decides to set aside a reserve from the end of the previous month, and asks the office to pay every two weeks. The formula is simple: opening balance plus cash in minus cash out.
Where does Claude's role end? For building profit and loss tables and monthly recaps, Claude is a big help. But official reports for a bank application should be prepared or checked by an accountant. For rough margins and break-even points, Claude is fast and clear. For the tax you're required to pay, local regulations can change, so ask a tax consultant or the tax office. For decisions, Claude can list your options along with their risks. Decisions about loans and large investments are still yours, after talking with an expert. Claude is a patient calculation buddy, not an official financial advisor. The app screens in this video are simulations, and menu names may differ slightly because Claude is updated often. To make it a habit, schedule a monthly routine. On the first of every month, recap last month's sales and costs. Send the recap to Claude and ask for a profit and loss statement and margin per product, in the same format every month. Recalculate the key numbers with a calculator, especially revenue, total costs, and net profit. Finally, note one decision for this month. For example, boosting sales of cold brew, which has the highest margin. One decision you act on is worth more than ten reports that just sit in a folder.
We've prepared data safely, built a profit and loss statement, compared margins per product, calculated the break-even point, and read cash flow, while knowing when to ask an expert. In the next episode we help Laras hire a new barista: writing the job post, screening applicants fairly, and preparing the interview. See you there!
Try these on your own after watching to lock in what you learned.
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
Notes are saved with the current video time and are only visible to you.
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.

Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
See our clients →