What Business Peng 3rd Edition Actually Is
I get asked about Business Peng 3rd Edition regularly, and honestly, most people come at it from the wrong angle. It's not a productivity app, and it's not some new management theory. Business Peng 3rd Edition is a spreadsheet-based financial modeling toolkit built for small-to-mid market business valuation, primarily used by practitioners who do buy-side and sell-side diligence for transactions in the $1M to $50M EBITDA range. The core of it is a set of interconnected Excel workbooks — income statement driver sheets, balance sheet build-outs, working capital schedules, debt waterfalls, and a final model output that pulls everything together into LBO or DCF valuations. The "3rd Edition" part just means the publisher updated the macro handling, fixed some circular reference bugs from the 2nd edition, and added support for three-statement models that actually tie back without manual re-keying.
Business Peng 3rd Edition — Getting It Set Up
Here's the thing nobody tells you: install macros first, then open the workbook. Not the other way around. I spent about forty-five minutes debugging a "runtime error 1004" on my first attempt because I opened the file before enabling the macro environment. The 3rd edition uses VBA-heavy inter-sheet references, and if the macro layer isn't initialized when the workbook loads, several of the automated calculation tabs stay grayed out. Download the package from the official vendor site — the domain is businesspeng.com. There's no Steam or App Store version. The cost runs roughly $197 for a single-user license, with an academic tier at about $79 if you have a .edu email. No enterprise volume pricing worth asking for unless you're buying twelve seats, and even then the discount is marginal.
How the Model Actually Works
The default workflow starts with the driver inputs tab. You enter revenue growth assumptions, gross margin trends, operating expense percentages, and capital expenditure as a percent of revenue. The model projects five years forward, then optionally extends a terminal value phase. What makes the 3rd edition better than earlier versions is the sensitivity analysis engine — you can toggle between bull, base, and bear cases and the model recalculates every linked sheet automatically. The balance sheet side trips people up. The working capital schedule expects you to define days sales outstanding, days payable outstanding, and inventory turnover. If you leave any of those blank, the model doesn't error out — it just assumes zero change, which silently understate or overstate cash flow depending on the industry. I learned this the hard way on a manufacturing deal where the seller's DSO was 62 days but the default assumption baked into the template was 30. That gap alone shifted the implied enterprise value by about 8% in my favor, which would have been embarrassing to explain in a data room. The workaround is straightforward. Copy the "Assumption Check" sheet and run it before you commit to any presentation output. It flags every blank or suspiciously default-typed input cell. Takes about three minutes and has saved me from two material errors in the last six months.
Get the Full Details
Common Pitfalls and Where It Falls Apart
It's not a perfect tool. Here's what breaks: Multi-currency models are painful. The 3rd edition doesn't natively handle FX translation. If your target operates in euros and your acquirer is USD-based, you have to manually overlay a currency sheet and re-link the cash flow statement. I built a custom FX add-on tab using a standard formula block that references a daily rate lookup table. Took me an afternoon to set up and it's been reliable since. Nobody in the support forum seems to have shared this solution, which is surprising. Leveraged buyout capacity is limited to one facility type. The default LBO module only supports term loans and revolving credit facilities. If the target has subordinated debt, mezzanine financing, or convertible notes, you're on your own. I've seen this bite people during middle-market automotive supplier deals where the capital structure includes vendor roll-equity that the model simply ignores.
Excel version dependency. The macros are written for Excel 2019 and later. Office 365 works fine. Excel for Mac — don't bother. The VBA engine in the Mac version of Excel doesn't support the same object model, and several key functions silently fail. I ran into this when a colleague in London tried to use it and assumed he was going crazy for an hour before realizing the platform mismatch.
Who Should Use It (And Who Shouldn't)
If you're a junior associate at a boutique advisory firm doing your first handful of valuation comps, Business Peng 3rd Edition is worth the money. It will cut your base model build time from roughly four hours to about forty-five minutes, assuming you know what you're doing. If you don't already understand three-statement modeling, this won't teach you — it'll just hide the mechanics behind automation, which is dangerous. If you're modeling large-cap transactions or public comparables, look elsewhere. The tool assumes a private company, small-ticket structure. There's no integrated public market data feed, no comparable company screening module, and no scenario management beyond the three-case toggle. For that work, a full suite like Argus or even a properly built in-house model makes more sense. The one edge case I haven't found a clean workaround for: multi-entity holding structures with intercompany eliminations. The model assumes a single legal entity operating account. If the target has a parent-subsidiary relationship with internal revenue streams, you have to manually adjust the consolidated income statement after the model outputs it. I've started building an elimination overlay sheet that references the parent and subsidiary tabs directly, but it adds another layer of complexity that defeats the "quick model" premise for a lot of users.
That's the reality of Business Peng 3rd Edition. It's competent for what it targets, and it's genuinely better than the 2nd edition on the macro side. But it's not a plug-and-play silver bullet, and you should know exactly where it stops before you hand it to a client or put it into a formal process. Spend the first evening with the sample deal file — it's included in the download — and map the linkage chain yourself. That's the only way to trust the numbers when the actual deal data starts coming in.
