Home Blog

Summing Multiple Worksheets (Tabs) in Excel

If you are consolidating multiple structurally identical worksheets (tabs) in Excel, say to roll-up various product line financials for a business unit, you may...

Operating Leverage

What is corporate risk? A company’s risk comes down to the fluctuations of its free cash flows (FCF).  Assuming that the past reflects the future,...

Modeling of Cyclical (Seasonal) Data

This post references the following Excel workbook: Seasonality Many times in finance the historical data that needs to be modeled and/or used as a basis...

Managing Business Value Creation

Business at its most fundamental level is about creating value.  Without value creation (a.k.a., a value proposition), a business is limited in what it...

WMT vs. TGT vs. AMZN 2018

Seven years ago we compared Target (TGT) to Wal-Mart (WMT), and found that Wal-Mart dominated Target on almost every financial ratio except stock valuation. ...