Key Takeaways
Build a linked model before trusting a Walmart price target.
Start with connected statements. The book’s practical method builds a model of Walmart from historical financial reports, then projects its performance and uses those projections to estimate value. Six connected components do the work: the income statement, cash flow statement, balance sheet, depreciation schedule, working capital schedule, and debt schedule. Each schedule supplies information to the others, so a mistake in one can distort the whole analysis.
Keep assumptions visible. The model distinguishes typed inputs from formulas, using blue font for hardcodes and black for calculations. This makes it easier to see which assumptions drive the forecast and to revise them as new evidence arrives. The goal is not a perfect forecast on the first try, but a complete model that can be tested and improved.
A linked model is more than a spreadsheet convenience. It is an explicit map of cause and effect: sales create receivables, investment creates depreciation, and financing creates interest. That structure makes assumptions inspectable rather than hiding them inside a target price. The trade-off is that detail can create an illusion of precision. A beautifully linked model remains only as reliable as its definitions, source data, and forecast assumptions.
Separate Walmart's one-off tax events from earnings that represent ordinary operations.
Clean the operating picture. Reported statements can bury unusual gains or losses among recurring expenses. For analysis, the book moves such non-recurring items into a separate section, preserving both a cleaner view of ongoing performance and a reconciliation to reported net income. Walmart’s discontinued-operations line included a $1.0 billion tax benefit in 2011, followed by $67 million of tax and related interest expense in 2012. Treating those amounts as ordinary earnings would blur the company’s operating trend.
Stay consistent across peers. Whether an item belongs in EBITDA depends on its recurrence, its connection to the business, and whether comparable companies classify it similarly. The analyst’s task is to make a defensible choice, document it, and apply the same rule throughout the comparison.
Normalization is a form of measurement design: it decides which parts of a company’s past are expected to repeat. The same discipline appears in scientific measurement, where a researcher separates signal from noise before comparing results. But “one-off” is not always obvious. Repeated restructuring charges, for example, may be unusual individually yet routine in aggregate. Classification should therefore be tested against the company’s history, not accepted merely because management or an analyst labels an item exceptional.
Use business drivers and outside evidence, not historical growth alone, to forecast.
Make assumptions explainable. Revenue depends on what a company sells, how much it sells, and at what price. Costs may move with sales, remain relatively fixed, or respond to specific changes in the business. Historical ratios help establish a starting point, but they do not explain what will happen next. The book recommends checking annual reports, investor presentations, earnings calls, analyst estimates, and business conditions rather than relying on a single source.
Use Walmart as a first cut. The model initially assumed 6% annual revenue growth, close to the 2013 analyst consensus cited in the book. After checking estimates that implied slower growth, it lowered the forecast from 6% in 2013 to 2% in 2017. The author also held Walmart’s cost of goods sold near 75% of revenue, while treating that assumption as revisable.
The useful distinction is between a forecast and a trend extrapolation. A historical ratio is evidence, but it is not a causal explanation: sales could rise because of more volume, higher prices, or acquisitions, and each has different cost implications. Forecasts become more credible when each assumption has a business mechanism behind it. Consensus estimates offer a reference point, not independent truth, since analysts can share the same blind spots or react to the same public guidance.
Track cash conversion through receivables, inventory, payables, and accruals.
Measure operating timing. Operating working capital is current operating assets minus current operating liabilities, excluding cash and debt. It captures cash tied up in receivables, inventory, and prepayments, as well as cash temporarily retained through payables and accrued expenses. To forecast these balances, the model measures “days” against the related income statement item, generally using average balance-sheet balances and a 360-day year.
Watch the cash direction. Walmart’s 2012 figures included 4.4 days of receivables, 41.4 days of inventory, and 37.8 days of accounts payable. More inventory or receivables generally uses cash; more payables generally provides it. The working capital schedule converts assumed operating days into projected balances, then sends each year-to-year change to the cash flow statement with the appropriate sign.
Working capital is where reported growth can quietly consume cash. A retailer may book sales while waiting for payment, stock goods before selling them, or delay payment to suppliers. Looking at balances alone can mislead, because a growing business naturally needs more working capital; ratios and days put those balances in operating context. The 360-day convention simplifies arithmetic, but estimates still depend on seasonality and the date of the balance sheet, especially for businesses with sharply uneven sales cycles.
Model book depreciation and tax depreciation separately to reveal timing differences.
Separate accounting from tax. Depreciation allocates the cost of a long-lived asset over time. Straight-line depreciation spreads the depreciable amount evenly across its useful life. For tax purposes, U.S. companies commonly use MACRS, a system with prescribed schedules that typically assigns more depreciation to earlier years. When book and tax depreciation differ, reported tax expense and cash taxes can differ temporarily, creating deferred taxes.
Estimate carefully when detail is missing. Walmart reported $8.1 billion of depreciation and amortization in 2012, but its public information did not reveal a complete asset-by-asset schedule. The book therefore estimates useful lives for existing property and new capital spending, then checks whether projected depreciation follows a plausible trend. Its sample model used 14 years for existing property and 25 years for new capital expenditures, explicitly as assumptions rather than disclosed facts.
This schedule clarifies a critical distinction: depreciation affects accounting profit without being a current cash payment, while capital expenditure is an actual investment of cash. Deferred taxes similarly describe timing differences, not free or permanent savings. The model’s useful-life estimates are a practical workaround for incomplete disclosure, but their apparent specificity should not be mistaken for asset-level knowledge. Sensitivity testing is essential because estimates of asset lives can affect both forecast earnings and the implied value of future cash flows.
Make cash flows explain every projected balance-sheet movement.
Let transactions drive balances. The balance sheet must satisfy assets equal liabilities plus equity. Rather than guessing future balances independently, the book recommends projecting them from the cash flow statement. A rise in receivables uses cash and increases the receivable asset; a rise in accounts payable supplies cash and increases the liability. Net income changes retained earnings, while capital spending and depreciation affect property and equipment.
Use checks as controls. Each cash flow item should affect the appropriate balance-sheet account once, in the right direction, and in the correct year. The book groups common imbalances into four causes: an omitted cash flow, a cash flow used twice, a sign or period error, or an incorrect total. Its balancing procedure compares year-over-year balance changes with cash flow entries, crossing each matched entry off once.
This approach resembles double-entry bookkeeping as an error-detection system: a transaction is not just a number, but a relationship that must reconcile across statements. The balance sheet check is especially valuable because it tests the whole model rather than one formula at a time. Yet a balanced sheet is necessary, not sufficient. Two offsetting mistakes can still produce a balance, so reconciliation should be paired with source checks, formula review, and a reasonableness test of the business story.
Build debt last because interest feeds back into cash and borrowing capacity.
Follow the feedback loop. Debt balances determine interest expense; cash balances can generate interest income. Both affect net income, which affects cash flow, which in turn changes cash available to pay down debt. This circular reference is why the book builds the debt schedule after the other statements are linked and the balance sheet balances. Interest is often estimated using average beginning- and end-of-year debt balances when exact payment timing is unavailable.
Separate required from optional payments. The schedule distinguishes contractual debt payments from discretionary issuances or paydowns. An automatic paydown formula can use surplus cash to reduce debt, or raise debt if cash falls below the required level. For Walmart, the example assumed a $1 billion minimum cash cushion and used iterative Excel calculations to resolve the feedback loop.
The circularity reflects a real economic interaction, not merely an Excel quirk: financing costs influence the cash available for financing decisions. That makes the model’s cash floor and repayment rules substantive assumptions. A minimum cash reserve can protect operations, but an overly generous reserve also changes the amount of debt that appears repayable. Iteration solves the arithmetic, not the judgment; the model still needs to reflect actual debt contracts, refinancing access, and management policy.
Match enterprise value to operating metrics and equity value to shareholder earnings.
Value the right claim. Equity value belongs to shareholders. Enterprise value adds debt and other non-equity claims, then subtracts cash, to approximate the value attributable to the operating business. This distinction determines which financial metric belongs in a valuation multiple. Net income is after interest, so it pairs naturally with equity value; EBITDA is before interest, so it pairs with enterprise value.
Compare operations fairly. The book illustrates two delivery businesses with the same $5,000 of EBITDA but different depreciation and interest costs. One reports $2,925 of net income, while the other reports none. If the question is how the underlying operations compare, EV/EBITDA may be more informative than a shareholder earnings multiple. But it does not make debt, capital spending, or asset intensity irrelevant to the investment decision.
This matching rule prevents a common category error: comparing a value that belongs to one group of capital providers with a performance measure calculated before those providers are paid. EBITDA can help isolate operating performance across different financing structures, but it is not cash flow. Businesses with heavy reinvestment needs can look inexpensive on EBITDA while requiring substantial ongoing capital spending. The multiple is a lens, not a verdict, and should be interpreted alongside cash generation and balance-sheet obligations.
Align reporting periods and diluted shares before trusting comparable-company multiples.
Make the companies comparable. Comparable-company analysis requires current financials covering equivalent periods. Last twelve months, or LTM, combines annual and quarterly results to produce a trailing year. Calendarization adjusts companies with different fiscal year-ends so their results cover roughly the same dates. Costco reports on a 52- or 53-week fiscal year, so aligning it with Walmart required adjustments by the relevant number of days, not a simple comparison of annual totals.
Count the shares investors may own. The treasury stock method estimates dilution from in-the-money options by assuming option proceeds buy back shares at the current price. In the book’s Costco example, 432.4 million basic shares became about 434.3 million diluted shares after accounting for options. Period alignment and share dilution both affect calculated multiples, so sloppy inputs can create misleading precision.
Comparability is constructed, not discovered. Fiscal calendars, seasonal sales, accounting classifications, and option dilution all shape the denominator or numerator of a multiple. Costco’s week-based calendar shows why a clean-looking annual figure may not line up with a peer’s reporting period. The adjustments improve consistency but cannot eliminate uncertainty: allocating a fraction of a quarter assumes activity was evenly distributed, which may fail in seasonal retail. A good comparison states its adjustments and their limitations.
Triangulate Walmart's value instead of treating one valuation method as certainty.
Use three different lenses. Comparable-company analysis reflects current market pricing; precedent transactions reflect historical acquisition prices, often including a control premium; discounted cash flow estimates the present value of projected unlevered cash flows and a terminal value. Each has different weaknesses. In the book’s October 2012 Walmart case, the estimated share-price ranges were $67.08 to $98.00 for comparable companies, $108.31 to $149.53 for transactions, and $88.47 to $96.34 for the original DCF assumptions. The observed 52-week range was $56.26 to $77.60.
Interrogate the spread. The transaction examples were old, including a 2007 Dollar General deal. The DCF depended heavily on a 5.16% WACC and terminal assumptions; its terminal value contributed far more than the five years of projected cash flows. The methods therefore supply a range of judgments, not a guaranteed target or a current recommendation.
Triangulation is valuable because disagreement exposes assumptions. A high transaction value may reflect control benefits or a different market cycle; a high DCF may reflect optimistic growth, a low discount rate, or a generous terminal value. A football-field chart makes these ranges visible, but visual convergence can still mislead if methods share the same flawed forecast. The strongest conclusion is not the midpoint by default. It is the explanation of why each method differs and which assumptions deserve the most scrutiny.
Analysis
The book’s strongest contribution is procedural. It teaches the reader to treat valuation as a chain of linked judgments rather than a magic multiple or a spreadsheet output. The Walmart case gives that chain a narrative: retrieve filings, reorganize reported accounts, build operating assumptions, connect statements, estimate financing costs, and finally compare independent valuation approaches. This is especially useful for beginners because it shows where the numbers come from and how errors propagate.
Its core intellectual discipline is reconciliation. Adjusted earnings should still reconcile to reported earnings. Working capital movements should reconcile to cash flow. Cash flow should explain balance-sheet changes. Debt schedule cash should match balance-sheet cash. Those controls make a model auditable and teach financial statements as a system rather than three disconnected reports.
The main limitation is the tension between operational usefulness and false precision. Public disclosures seldom provide enough detail to forecast every account accurately, so the model fills gaps with conventions, historical ratios, and educated guesses. The book acknowledges this, but a spreadsheet’s exact figures can make assumptions look more certain than they are. This is most consequential in the DCF, where a low discount rate and terminal value can dominate the result. Beta is a historical measure of market sensitivity, not a direct guarantee of an individual stock’s future return, and terminal growth is a judgment about a distant future.
The Walmart conclusion is also time-bound. Its prices, consensus estimates, interest rates, and reported data belong to October 2012, not today. The lasting value is the method, not the old target price. Used well, the model is a disciplined way to ask what must be true for an investment to be attractive, identify which assumptions matter most, and revise the answer when evidence changes. Used poorly, it can turn uncertain premises into polished certainty.
Review Summary
Financial Modeling and Valuation receives positive reviews for its comprehensive coverage of financial modeling basics, requiring no prior knowledge. Readers appreciate the detailed explanations, step-by-step guidance, and practical case studies. The book is praised for its value to beginners and undergraduates entering finance. However, some reviewers note it can be dense and occasionally focuses on minor details while glossing over more complex concepts. The accompanying website is seen as a helpful resource. Overall, readers find it a solid foundation for learning financial modeling and valuation techniques.
People Also Read
Glossary
Operating working capital
Operating assets minus liabilitiesA modeling measure of current operating assets minus current operating liabilities, excluding cash, cash equivalents, and debt. Common components include receivables, inventory, prepayments, accounts payable, and accrued expenses. Its balance and year-to-year changes help show how much cash routine operations absorb or release.
Unlevered Free Cash Flow
Cash before financing claimsCash generated by a company’s operations that is available to all capital providers before interest, debt repayments, dividends, or other financing distributions. A common calculation starts with operating profit after taxes, then adjusts for non-cash items, working capital changes, and capital expenditures. It is discounted to estimate enterprise value.
Weighted Average Cost of Capital (WACC)
Blended required capital returnThe weighted average of the required returns for a company’s sources of capital, commonly debt and equity. Debt cost is generally adjusted for its tax benefit, and the weights reflect the capital structure, ideally using current market values. WACC is used as the discount rate for unlevered free cash flow.
Modified Accelerated Cost Recovery System (MACRS)
U.S. tax depreciation systemThe U.S. tax depreciation system that assigns property to prescribed recovery periods and applies set depreciation percentages. Compared with straight-line book depreciation, MACRS often records a larger share of an asset’s tax depreciation earlier. The resulting timing difference can affect current cash taxes and create deferred tax balances.
Circular reference
A calculation feeding itselfA cycle in a spreadsheet where a cell’s result depends, directly or indirectly, on its own value. In this model, debt affects interest, interest affects net income and cash flow, and cash flow affects the debt paydown decision. Spreadsheet iteration can calculate the loop, but correct assumptions and formulas remain necessary.
NYSF Balance Sheet Balancing Method
Trace cash flows to balancesThe book’s procedure for locating a projected balance-sheet imbalance. Compare the change in each balance-sheet account with its related cash flow, verify that the sign and year are correct, and mark each cash flow item as used once. Unmatched, duplicated, or directionally incorrect entries reveal common errors; incorrect totals are another possible cause.
Last Twelve Months (LTM)
Most recent trailing yearA twelve-month measure assembled from the latest available annual and quarterly financial results. A typical calculation adds recent quarters to the last annual period and subtracts the corresponding quarters from the prior year. LTM data helps make a valuation reflect more recent performance than the last published annual report alone.
Calendarization
Align fiscal reporting periodsAn adjustment that makes companies with different fiscal year-ends more comparable by estimating results for a common period. It can combine annual and quarterly data and adjust partial quarters by months or days. The method improves period consistency, although prorating a quarter assumes activity was distributed evenly during the period.
Treasury stock method
Estimate option share dilutionA method for estimating diluted shares from in-the-money options. It assumes options are exercised at their strike price and that the company uses the proceeds to repurchase shares at the current market price. The net increase in shares, rather than the full number of options, is added to basic shares outstanding.
Football field
Chart of valuation rangesA floating bar chart that displays the estimated value range produced by several valuation methods, such as comparable companies, precedent transactions, discounted cash flow, and recent share-price highs and lows. It makes differences among methods visually clear, but does not determine which assumptions or valuation range are most credible.
Download PDF
Download EPUB
.epub digital book format is ideal for reading ebooks on phones, tablets, and e-readers.