Latest / VoraPrep Audio — Professional Licensure & Certification Exam Prep / [CPA] BAR: Financial Statement Analysis: A Comprehensive Toolkit for BAR
Transcript
- Hey, welcome to VoraPrep Audio. Glad you could tune in. So let’s talk about a classic exam trap. You get a question about a company, Apex Corp., and the first thing you see is that revenue surged 25% last year. And your brain just goes, "Great! Growth is good. This company is killing it." It's so tempting to just grab that one shiny number and run with it. But then you look a little closer. You see their cost of goods sold jumped by almost 37%. And their net income? Flat. Didn't budge. All that extra sales activity, and it produced zero extra profit. Suddenly, that 25% revenue growth doesn't feel so great. It feels... expensive. This is the entire game of financial statement analysis. It’s about not falling for the headline number. It's about looking at the relationships, the trends, and the context to uncover the real story. And on the BAR exam, telling that full story is where you get the points. The three big tools you’ll use for this are Horizontal Analysis, Vertical Analysis, and Financial Ratios. Think of the first two, horizontal and vertical, like different camera lenses. Horizontal analysis is your time-lapse camera. You're setting it up and watching how the company's financial picture changes over several years. You're looking for the motion, the trends. Is that mountain of inventory growing or shrinking over time? That's horizontal. Then you have vertical analysis. This is more like a portrait lens. You're zooming in on a single year, one snapshot in time, and looking at the composition. You're asking, "Of all the assets this company has, what percentage is cash? What percentage is tied up in inventory?" It's all about the relationships within a single period. Let's break them down. Horizontal analysis is pretty straightforward. You're just calculating the percentage change from one period to the next. The formula is the current period amount, minus the base period amount, all divided by that base period amount. It shows you the speed and direction of change. Are sales growing at 5% or 50%? Is debt shrinking or ballooning? Vertical analysis is what we use to create what are called common-size financial statements. This is a really powerful idea. You take every single line item on the income statement and show it as a percentage of total revenue. Or you take every line on the balance sheet and show it as a percentage of total assets. What this does is it completely neutralizes size. It lets you compare a tiny startup to an industry giant like Apple, because you're not looking at the raw dollars, you're looking at the percentages. It's also perfect for comparing a company to its industry average. Now, on the exam, especially in a task-based simulation, you'll be swimming in data. Here’s how to approach it without getting lost. First, just stop and read the actual question. What are they asking you to do? Are they asking you to spot a trend? That screams horizontal analysis. Are they asking you to compare two different-sized companies or see what’s eating up all the cash? That’s probably vertical. Or are they asking about something very specific, like the company's ability to pay its short-term bills? That’s a direct signal to go find a liquidity ratio. Once you know what you’re looking for, scan the exhibits for only the numbers you need. They will give you more data than you need on purpose. Ignore the distractions. If you're calculating a liquidity ratio, you don't need the non-financial data about square footage. Just find the accounts you need. Then, do the math carefully. A simple mistake here, like using ending inventory instead of *average* inventory for a turnover ratio, can send you down the wrong path. And finally, the most important step: interpret the number. A ratio of 2.4 means nothing by itself. Is that good? Is that bad? You have to compare it to something—the company's own history, or an industry benchmark they provide in the exhibits. That's how you draw a real conclusion. Let's walk through a full example. Imagine we're looking at acquiring a company called Apex Manufacturing. We have two years of data. In 20X1, revenue was $400,000. In 20X2, it's $500,000. So let's do some horizontal analysis on that. The change is $100,000, divided by the base of $400,000. That's a 25% increase. Just like our hook at the beginning. Looks good. But now let's look at Cost of Goods Sold, or COGS. It went from $220,000 to $300,000. The increase is $80,000, divided by the base of $220,000... and that comes out to a 36.4% increase. Whoa. That's a huge red flag right there. Our sales went up 25%, but the cost of those sales went up over 36%. Our margins are getting squeezed. And sure enough, if you look at net income, it was $80,000 in both years. Zero growth in profit. Now let's switch to our other lens, vertical analysis, and look just at 20X2. Revenue is our base, so it's 100%. COGS was $300,000 on revenue of $500,000. So, COGS is 60% of revenue. If we do the same math for the prior year, COGS was 55% of revenue. This confirms what we saw with horizontal analysis: the cost to make each dollar of sales is going up. Our net profit margin has fallen from 20% down to 16%. Okay, one more piece of the puzzle. Let's look at a ratio. The exhibits tell us inventory went from $100,000 to $150,000. To calculate inventory turnover, we need COGS divided by *average* inventory. So, the average is ($100,000 plus $150,000) divided by 2, which is $125,000. Our COGS for 20X2 was $300,000. So, $300,000 divided by $125,000 gives us an inventory turnover of 2.4 times. Now for that crucial context step. The simulation tells us the industry average turnover is 5.0. Apex is turning its inventory less than half as fast as its competitors. This stuff is just sitting on the shelves, collecting dust. So, what's the story we tell? The tempting, but wrong, answer is to just say, "Apex is growing fast with 25% revenue growth." The real, high-scoring answer is: "While Apex's top-line revenue is growing, its financial health is deteriorating due to significant margin compression and very poor inventory management, which presents a major risk for an acquisition." See the difference? We used all the tools to tell the full story. And that brings up a good point about ratios in general. You need to know the formulas, but you really need to know the 'why'. For example, think about the Current Ratio versus the Quick Ratio. The Quick Ratio is almost the same, but it specifically excludes inventory from the numerator. Why? Because inventory can be hard to sell quickly. It’s not as liquid as cash or receivables. So the Quick Ratio gives you a more conservative, "what-if-we-had-to-pay-our-bills-tomorrow" look at liquidity. Understanding that 'why' is more valuable than just memorizing a formula. If you need a quick way to remember the flow of analysis, you can think of it as an "Analysis Pyramid." H-V-R-B. H for Horizontal: how have we performed Historically? V for Vertical: what's our internal Volume or structure? R for Ratios: how do we Rate on specific metrics? And finally, B for Benchmarking: how do we Balance against others? Be careful of what I call 'analysis paralysis'. This happens when you get a big simulation and you just start calculating every ratio you can think of, hoping something sticks. Don't do that. It’s a waste of precious time. Start with the question. If it asks about the ability to pay bills, go straight to liquidity ratios. If it asks about profitability, go to profit margins. Be targeted. And remember, on the exam, synthesis is everything. They're not going to ask you to just calculate one number in a vacuum. They’ll give you financial statements, maybe some industry reports, and ask you to evaluate a situation or recommend a course of action. The points are in connecting the dots between horizontal trends, vertical structure, and ratio analysis to build a coherent argument. If you want to practice building that skill, VoraPrep is a full exam-prep app. It’s got lessons, thousands of practice questions, and an AI tutor to help you connect these concepts, all in one place. You can get started for free at Vora Prep dot com. So, to wrap it all up: Horizontal analysis is for trends over time. Vertical analysis is for structure in a single period and for comparing different-sized companies. Ratios are for diagnosing specific issues. And benchmarking is what gives all those numbers meaning. Use them together, and you won’t just be calculating numbers—you'll be telling the story behind them. Alright, that's it for today. Keep up the great work, and I'll talk to you next time.