Home Blog

Summing Multiple Worksheets (Tabs) in Excel

0
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

0
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

0
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

0
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

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