In this inventory forecast, I share a quick and easy way to model stock balances and purchases. But take note — there’s lots of nuance to be aware of. A roll-forward inventory forecast can be approached in two ways, depending on the availability and reliability of data. 1) Using Purchase Schedules from Procurement: This method…
Business modelers get jittery when they see volatile functions. These are functions that recalculate each time a cell is calculated, even if the function’s arguments don’t change. What are some of the volatile functions? RAND(), NOW(), TODAY(), CELL(), OFFSET(), INDIRECT() The values can’t be assumed to be the same from one moment to the next.…
There are 9 traits and characteristics FP&A professionals should have. That doesn’t even include the technical ones. This is what they are:
Financial presentations can be dense. To captivate your audience and build greater engagement, it’s crucial to maintain focus. Here are three great strategies to minimize distractions and connect more effectively.
In this course, explore advanced Excel functions and techniques designed specifically for financial planning and analysis (FP&A). The course covers topics from mastering INDEX XMATCH and dynamic array functions such as FILTER, UNIQUE, DROP, and TAKE.
This is a favorite dynamic rolling forecast technique. We use it in FP&A for capturing trailing months and future months of financial data. You’ve probably never seen this done.
I see a lot of seasoned finance and accounting people promoting the learning of skills that most FP&A professionals don’t really need. What two of these skills are overrated for FP&A professionals?
Take all the work and oversight of a highly qualified, high-functioning CFO. Put it into a list. Then take all the responsibilities, experience, institutional knowledge, fiduciary duties, and relationships and sprinkle these traits among a group of teams and people.
Weekly cash flow forecasts usually aren’t necessary unless a company is dealing with liquidity issues. Distress or rapid growth can both be a culprit. Here’s how to use a monthly cash flow to back into an optional weekly forecast.
Carl Seidman—a FP&A advisor, fractional CFO, adjunct professor, and Microsoft MVP in Excel—shows you how to translate numbers into actionable strategies as you identify potential cash flow crises and master the art of building accurate cash flow forecasts.
Discount Applied Successfully!
Your savings have been added to the cart.
