Creative Financial Models Improve Decision-Making

Table of Contents

While monthly time periods are often sufficient for annual budgeting, some business models require planning with more granular time periods.

Corporate Performance Management (CPM) solutions are designed to empower finance and operations to generate insights that deliver more value, more efficiently, and more often.

So, I am surprised that so many CPM solutions still require that all models be set up with months for the time period. Moreover, while solutions such as A3 Modeling enable the user to plan within any time period, just as you can in a spreadsheet, many solutions require you to plan by month and assume a single, 12-month fiscal year. Not only does this make it difficult to deal with companies that have multiple entities with different fiscal years, but it also means you actually cannot do daily or weekly modeling.

In addition, many retailers use a “13-month” calendar with 4 weeks in each time period so they can get more consistent period-over-period trending and reporting. These retailers need a CPM solution that at the very least enables 13-month reporting. To keep this blog simple, let’s call any software that requires you to plan only by month: 12-month-only software (12-MOS).

Here are a couple of typical conversations I’ve witnessed between a 12-MOS sales rep and a prospect.

Conversation 1: The “ruled-out” retailer prospect

Context: The sales rep has been trained to ask if the prospect wants to plan with a 13-month year because the 12-MOS does not support this requirement.

Sales repDo you plan with a 12-month fiscal year?

ProspectActually, we do our reporting with a 13-month year.

Sales repOh, we don’t do that.

ProspectOK, bye!

Conversation 2: The daily model debate with a hospitality-industry prospect

Context: the FP&A manager at a large resort, a large museum that wants to plan daily admissions, or an airline that plans by daily flights, builds up the planning model by day to forecast financials and staffing.

Sales repWhy would you want to plan by day? Don’t you want to plan by month?

ProspectYeah, I want to plan by months…. but, in our industry, holidays and weekends totally change our model. The daily trends are material to us. Can your software plan with days as time periods or at least weeks?

Sales repAha! I got it, in this case, create a line item for each month with the number of weekends in the month as a driver.

ProspectThat’s not how we approach the planning process. Gotta go, bye!

A3 Solutions budgeting and forecasting Best Practices sometimes require creative financial models to improve decision-making. If you don’t “fit in the box”, you are entitled to a Free Trial Model. If you have an interesting planning model that requires daily or weekly planning where 12-MOS is not sufficient, send over your model and we’ll load it up in the cloud for you to explore hands-on.

About A3 Solutions and A3 Customers

A3 Solutions is the developer of A3 Modeling, the leading spreadsheet automation platform for web-based Enterprise Budgeting and Corporate Performance Management solutions. More flexible, with a lower total cost of ownership (TCO) than competing products, A3 Modeling is available as a SaaS and On-Premise offering that tightly integrates with leading enterprise OLAP and relational database technology from Oracle/Hyperion and Microsoft.

To find out how American Airlines, Avon, Cox Communications, McDonald’s, Safeway, Toyota, Williams Sonoma, Verizon, and other Fortune 1000 enterprises use A3 Modeling to align their organizations, accelerate decision-making, and turn strategy into action, visit A3Solutions.com or call 1 (415) 302-0158.787

Share this article with a friend

Create an account to access this functionality.
Discover the advantages