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. ...