• Skip to main content
  • Skip to footer
Revelwood Logo

Revelwood

Your SUPER-powered WP Engine Site

  • Who We Are
    • About Us
      • Our Company
      • Our Team
      • Partners
    • Careers
      • Join Our Team
  • What We Do
    • Solutions
      • Workday Adaptive Planning
      • IBM Planning Analytics
      • BlackLine
    • Services
      • Implementation Services
      • Customer Care
        • Help Desk
        • System Administration as a Service
      • Training
        • Workday Adaptive Planning Training
        • IBM Planning Analytics / TM1 Training
    • Products
      • DataMaestro
      • LightSpeed
      • IBM Planning Analytics Utilities
  • How We Help
    • Use Cases
    • Client Success Stories
  • How We Think
    • Knowledge Center
    • Events
    • News
  • Contact Us

Financial Performance Management

Workday Adaptive Planning Tips & Tricks: Revenue Cohort Modeling

June 8, 2022 by Revelwood Leave a Comment

Tips & Tricks

Do you know about cohort modeling in Workday Adaptive Planning?

A cohort model provides meaningful insight of data grouped into subsets based on any characteristic important to the company. The groups are called “cohorts.” Cohorts can be based on time (i.e. season, monthly, yearly), segment (i.e. commercial, residential), or size (i.e. low, medium, high), just to name a few. Cohorts follow a pattern of behavior that helps analysts project future trends. This can help companies focus efforts on lowering churn and optimizing revenue.

Cohort model vs. Regular model

Compared to a regular model, a cohort model provides a more granular view of the data. Projecting revenue at the cohort level helps companies understand outliers that would otherwise be missed in a regular revenue model.

For example, in a regular model, projected revenue shows overall revenue for the year and may show growth. However, if you dig further into the segments, you will see that one cohort, such as small businesses in the manufacturing industry, had a large decline in sales.

If this information was available early in the year, further decline could have been prevented and management could have strategized to avoid a blow to the bottom line in the following year. Maintaining and analyzing multiple cohort models on a regular basis is crucial for successful strategic planning.

Where to use cohort modeling

  • Subscription base revenue – tech, gaming, food, streaming, service, etc.
  • Contract billing – by milestone, period, ASC 606 amortization, etc
  • Seasonality base revenue
  • Freemium – lead conversion
  • Sales Rep capacity or conversion

How to build cohort models in Workday Adaptive Planning

Cohort model in Adaptive may comprise of multiple sheets. Below is an example of a cohort model structure.

  1. 1. Planned # of Customers/Cohort
  • Modeled sheet
  • Create number data entry column to input number of customers
  • Create calculated account and link the data entry column
  • Input by cohort dimension – this can be by month/period, type of cohort, etc (ex. Jan, Feb, Mar – the month new customers are acquired)
  • No timespan

Table

Description automatically generated

  1. 2. Cohort Drivers/Curves 
  • Modeled sheet
  • Create number data entry columns, display as % (ex. 12 columns representing 12 months of the year) – this is where to input cascading percentages (aka curve)
  • Create calculated accounts for each data entry column and link
  • No timespan

Application, table

Description automatically generated with medium confidence

  1. 3. Revenue per product/customer by month
  • Modeled Sheet
    • With timespan Graphical user interface, application, table

Description automatically generated
  1. 4. Cohort Waterfall
  • Cube sheet
  • Create standard account as a trigger – in this case using active month designation
    • The active month designation to trigger what month the cohort waterfall calculates for each acquisition month
  • Create calculated account with formula using iff and switch (this serves as an index match)

iff(isblank(ACCT.Cohort_Waterfall.Cohort_ActiveMonths),blank(),

iff(this.version.isactuals,blank(),

ACCT.NewCustomers_byCohort.No_Customers[Sales Region=this, Sales Channel=this, Order Type=this, Products=this, Cohort Acquisition Month=this]

*

switch(ACCT.Cohort_Waterfall.Cohort_ActiveMonths,

1,ACCT.Cohort_Drivers.M1[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

2,ACCT.Cohort_Drivers.M2[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

3,ACCT.Cohort_Drivers.M3[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

4,ACCT.Cohort_Drivers.M4[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

5,ACCT.Cohort_Drivers.M5[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

6,ACCT.Cohort_Drivers.M6[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

7,ACCT.Cohort_Drivers.M7[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

8,ACCT.Cohort_Drivers.M8[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

9,ACCT.Cohort_Drivers.M9[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

10,ACCT.Cohort_Drivers.M10[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

11,ACCT.Cohort_Drivers.M11[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

12,ACCT.Cohort_Drivers.M12[Sales Region=this, Sales Channel=this, Order Type=this, Products=this],

0)))

Cohort modeling is a powerful feature in Workday Adaptive Planning. Try it out and see what insights you can discover.

Graphical user interface, application, table, Excel

Description automatically generated

Table

Description automatically generated

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start with Workday Adaptive Planning? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Read more Workday Adaptive Planning Tips & Tricks:

Workday Adaptive Planning Tips & Tricks: Check Boxes in Modeled Sheets

Workday Adaptive Planning Tips & Tricks: Excel Reporting Using a Report Template

Workday Adaptive Planning Tips & Tricks: Expand/Collapse Feature in OfficeConnect

Home » Financial Performance Management » Page 12

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Adaptive Planning, Financial Performance Management, Planning & Forecasting, Planning & Reporting, Workday Adaptive Planning, Workday Adaptive Planning Tips & Tricks

IBM Planning Analytics Tips & Tricks: WildcardFileSearch

May 31, 2022 by Revelwood Leave a Comment

Depending on your business process, you may need to load similar data from multiple files. One such example is loading headcount from different HR systems. This may be necessary if your company has gone through a merger. Another example is if you have forecast data coming from several managers in operations that don’t have access to IBM Planning Analytics. Instead of manually combining the files, you can use the WildcardFileSearch TurboIntegrator function to easily loop through all of the files.

The WildcardFileSearch function allows TurboIntegrator processes to search for files within a folder.  WildcardFileSearch requires 2 parameters: Path and PriorFileName. The Path can include ‘?’ and ‘*’ as wildcard characters. The ‘?’ is the wildcard for 1 character while ‘*’ is the wildcard for one or more characters. The PriorFileName tells the function were to begin the search. If this parameter is blank, the search begins with the first file in the Path. Below is an example of this function:

WILDCARDFILESEARCH( ‘C:\TM1Server\Files\TM1_*.csv’, ‘TM1_20220301.csv’)

In this example, the function will return the first filename that begins with “TM1_” and ends in “.csv” in the “C:\TM1Server\Files\” folder that occurs after the “TM1_20220301.csv” file.

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters!

Read More IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Converting an Alias Back to the Element Name in TurboIntegrator

IBM Planning Analytics Tips & Tricks: Updating ODBC Connections for Multiple Processes

IBM Planning Analytics Tips & Tricks: FILL Function

Home » Financial Performance Management » Page 12

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Financial Performance Management, IBM Cognos TM1, Wildcardsearch

Modern Accounting: Achieving Finance Transformation

May 26, 2022 by Revelwood Leave a Comment

This is a guest blog post from our partner BlackLine, explaining four essential steps for transformation success.

Making the Move to F&A Digital Transformation

For controllers, CFOs, CTOs, and business leaders in general, planning a move to digital finance transformation can be daunting—and it can raise some serious concerns. What if, for example, the transformation causes more problems than it solves in the intermediate term? What if it adds interim state technical complexities to an already challenging ecosystem further challenging the partnership between finance and IT?

Mike Polaha, BlackLine senior vice president finance solutions and technology, has seen these and other issues arise in his time working with global organizations. Digital transformation has been proven to deliver significant benefits, he notes, but the keys to success are in the preparation and being smart with the ways you organize and sequence the strategy and work plans.

4 Steps to Finance Transformation While Avoiding Common Pitfalls

Base Your Strategy on Diagnostics

Your strategy and corresponding business case should have a clear goal, and that goal should be informed by benchmarks of similar companies in the affected finance processes.

“You don’t want your strategy to be informed by hunches,” says Polaha. Instead, it’s good to use an outside consulting group—the Hackett Group, for example, or some other company with a benchmarking service—to see where you currently stand, then focus your strategy to gain the greatest competitive advantage at maximum efficiency.

Benchmarking can also be critical in selling the transformation to executive management.

“It can help you show executive leaders how, by making certain investments, you can not only improve your cost to serve, but likewise how the service can be differentiated in what it can now provide,” he says. “You’re more finitely tethering the functional investment to the overall business strategies.”

Adopt a Leading-Practice Orientation

Polaha notes, “every company is unique, of course, but all companies share certain fundamental characteristics. Once a company realizes this, it’s able to benefit by looking at, and emulating, industry leading practices.”

 Here is where a relationship with a top-end system integrator like Deloitte or EY can pay dividends.

“These companies have lots of experience with finance transformation,” he says. “They can show you a well-documented way of adopting best-practice processes for your specific areas of concentration.

“Also, BlackLine can help implement leading practice solutions based on our own experiences with customer installations and our regular participation in customer advisory boards. In essence, our application is crowdsourced by enabling best practice inherent in the composition of our solution design.”

Admit You’re Not a Software Company & Embrace the Cloud

According to Polaha, “too many companies think that they can develop their own applications. The problem is they first have to build the applications, and then they have to maintain and upgrade them. Then typically at some point they start to fall behind and can’t catch up.”

An example is one company that tried to upgrade their intercompany reconciliations by customizing their ERP software. “It then became very difficult, and costly, for them to implement vendor upgrades without the fear of breaking everything they’d developed.”

Using the cloud can help speed application deployments and allow companies to digitize rapidly at scale. The company also avails itself to a future proof architecture by allowing the SaaS provider to continually embed the latest evolutions in process and solution capability.

Polaha notes, “there are times when companies have too many applications with significant overlap. It’s better to partner with fewer vendors that can use the cloud to cover multiple applications.

“If you’re using one finance vendor for account reconciliations and another to do cash application for accounts receivable, it’s much more efficient to give those jobs to a single, cloud-based vendor to simplify the overall technological and contractual footprint.”

Harmonize Finance Data with the Enterprise

Here’s where finance can be an evangelist and a valuable partner to IT.

Data analytics are growing in popularity as a tool for business planning, but Polaha notes that analytics are only effective when they’re based on data that’s harmonized—unified—so that all data uses common, standardized naming and formatting conventions.

As an example, today’s finance groups are making increasing use of analytics-driven rolling forecasts that produce continuous predictions based on the previous time period’s data. Rolling forecasts can be very effective planning tools, says Polaha, but only if they are based on harmonized data.

“The problem is that without harmonized data, some people will be basing their planning instances on their unique views of the data. So, you end up with 50 instances of planning and forecasting software, and you can’t put Humpy Dumpty back together again.”

Once finance has harmonized its own data, it can then become an evangelist for data harmonization across the enterprise.

“Finance can then present a common view of finance data to IT,” says Polaha. “IT can use that for further harmonizing their own data and applications,” he says.

“That’s the ultimate prize for transformation, isn’t it? To get finance, IT, and the entire enterprise moving smoothly into a digital future.”

Home » Financial Performance Management » Page 12

Filed Under: Financial Close & Consolidation Tagged With: BlackLine, enterprise performance management, finance transformation, Financial Performance Management, FP&A, modern accounting, modern FP&A, Revelwood + BlackLine

FP&A Done Right: The Value of Scenario Planning

September 17, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, highlighting the value of scenario planning in modern finance.

Considering all that’s happened over the last year, the case for robust scenario planning has rarely been stronger. Scenario planning—the practice of establishing strategies for variables (possible futures) in key business factors—helps organizations thrive amid uncertainty. To put it simply, scenario planning arms finance with the ability to incorporate responses as changes happen.

Without the ability to adjust revenue and expense assumptions over time, model multiple scenarios simultaneously, or see the impacts of new markets, staffing changes, or regulations, companies won’t have the ability to weather whatever comes next—much less respond to changes in real time.

In a recent webinar by the Association for Financial Professionals, two panelists explored the value of scenario planning and management in modern finance.

“COVID-19 has been described as being the great accelerator and really has forced all of us to do some sort of scenario or contingency planning over the last year,” said Jack Alexander, a former CFO turned adviser, author, and coach. “And my hope is that finance and operating executives will utilize scenario planning broadly in the future and integrate those more into the key planning and management activities.”

Alexander described working with a client pre-pandemic that was facing two major uncertainties. “In this case, the company was unsure whether the economy would continue to expand or contract, and they also had a significant contract that was up for recompete. So they had basically four possible scenarios on a two-by-two matrix combining those two uncertainties,” he said. “And then I also encourage the development of a black swan scenario too—low-probability, high-impact events—and that sort of covers things including what happened with COVID.”

Kinnari Desai, vice president and head of corporate finance at Workday, described a multistep process for accelerating the scenario planning process.

Align leaders’ top priorities

First, organizations need to identify their top two or three priorities. “This could be top-line growth, margins, or cash flow, but it’s very important to be clear on those upfront,” Desai said. “We get perspectives from our executive team and align with them on what is important.”

It’s also critical to understand what is top of mind for business leaders, whether they’re in sales, services, G&A, technology, or other departments. “We need to ensure we have scenarios that are relevant cross-functionally and not only within finance,” she said. “This really helps us incorporate multiple perspectives and inputs into what is important, and we know where that knowledge belongs.”

Alexander echoed Desai’s process of speaking to the C-suite to understand competitive threats, market forces, and developing factors, as well as key personnel who have a view of such areas as critical raw materials and supply chains. “So it really has to be a broad participation across all functions,” he said.

Identify key drivers of sustained value creation

Another key step is to perform analyses to pinpoint the relevance of important factors and focus on the ones that matter. “How much could they influence the outcome? We also get an understanding of which variables and outcomes can be controlled in a short timespan versus ones that will take longer to pivot,” Desai said. “We do not try to optimize every variable but just focus on the ones that matter incrementally, and then we bring them all together in our scenarios.”

Bring in external data where relevant

Finance should develop a perspective that is informed by outside data. “It could be from industry, our peers, customers, economic data,” Desai said. “And at Workday, we use our software called Workday Prism Analytics, and that helps us marry this external data to our internal data, which informs our scenarios.”

Evaluate the frequency of scenario planning and adjust accordingly

“Not all variables, as we know, change on a similar cadence. Some need weekly attention, some monthly, or some even daily,” she said. “And our finance organization combines this power of scenario planning and continuous planning, which allows us to move in an agile fashion.”

Desai added that while there are many variables that impact the business, not all of them have a material impact. For her team, the top six variables garnered most of their attention. “And then we spent all our time understanding how they were going to shift,” she said. “Now, no one has a crystal ball, but the best we could do was to determine how those six variables would move. And those were the big rocks for us that were going to change our outcomes, not the 15 others.”

Three elements to enable agility

Alexander’s approach emphasizes three elements: vision, recognition, and response—all of which are aided by scenario planning and lead to better business agility.

“Even in terms of the vision, it helps because you’re going to be identifying critical assumptions, and you’re going to consider alternative outcomes other than the primary plan,” he said. “And if you combine that with business intelligence, external outlooks, a focus on customers and competitors, that really helps.”

As a year of uncertainty has shown, organizations better able to adapt to rapidly changing environments are often more optimally positioned to withstand crises or uncertainty. In order to build organizational resiliency, scenario planning performed correctly can help the enterprise identify its key business factors, take into account critical cross-functional needs, and create the agility necessary not only to survive, but to succeed.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Financial Performance Management » Page 12

Filed Under: FP&A Done Right Tagged With: enterprise performance management, Financial Performance Management, FP&A, FP&A done right, FP&A leadership, modern finance, what-if analysis

Workday Adaptive Planning Tips & Tricks: Flexible Planning

September 8, 2021 by Revelwood Leave a Comment

Video

Do you know how flexible Workday Adaptive Planning is? One of the key elements to any enterprise planning system is usability by different users with different needs. Workday Adaptive Planning is particularly flexible and allows for a variety of views.

Watch this Quick Takes video on flexible planning in Adaptive Planning. You’ll see a demonstration of a typical forecasting sheet with actuals and the remaining year to forecast.

As you watch the demo, you’ll learn:

  • How to modify what you are seeing on the current screen
  • How to view multiple years either before or after your current year
  • Different options to use a breakback

Workday Adaptive Planning is flexible enough to give you the views you want and those that are most usable to do planning.

Visit Revelwood’s Knowledge Center for our Workday Adaptive Planning Tips & Tricks or sign up here to get our Workday Adaptive Planning Tips & Tricks delivered directly to your inbox. Not sure where to start? Our team here at Revelwood can help! Contact us info@revelwood.com for more information.

Home » Financial Performance Management » Page 12

Filed Under: Workday Adaptive Planning Tips & Tricks Tagged With: Financial Performance Management, Workday Adaptive Planning flexibility, Workday Adaptive Planning flexible

IBM Planning Analytics Tips & Tricks: PAW Lines vs Area for Multiple Elements

August 10, 2021 by Lee Lazarow Leave a Comment

Tips & Tricks

A line chart is typically used to show values over time. This type of chart is great to see trends with your data. An area chart is also used to show values over time and is sometimes referenced as a line chart with the area below the line filled. While this is the case in IBM Planning Analytics Workspace (PAW) for a chart that contains a single line, it is not the case for a chart with multiple lines.

Here is a simple line chart in PAW and the related area chart:

IBM Planning Analytics Tips & Tricks: PAW Line vs Area for Multiple Elements

In both situations, you can see the trend and you can also see the values.

Here are the same PAW charts with multiple lines (e.g., multiple companies):

IBM Planning Analytics Tips & Tricks: PAW Line vs Area for Multiple Elements

In both situations you can again see the trends in the data by looking at the flows from left to right. However, you do not see the same values in the two reports. You can see this by looking at the labels on the Y-axis. The line chart is designed to show a set of independent values and therefore allows you to see the values for each company. The area chart is designed to show the accumulation of the values, which makes it hard to determine values for anything except for the bottom element.

As you can see, the type of chart makes a difference when reviewing your data. So how do you decide which chart to use? The simple answer is to ask yourself what you are looking to see. Are you looking for separate values or accumulated values? As long as your picture answers that question, you can never go wrong!

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Scatter Charts vs Bubble Charts

IBM Planning Analytics Tips & Tricks: The Waterfall Chart

IBM Planning Analytics Tips & Tricks: PAW Chart Padding

Home » Financial Performance Management » Page 12

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: charts, enterprise performance management, enterprise planning, Financial Performance Management, IBM Planning Analytics, IBM Planning Analytics Workspace, IBM Planning Analytics Workspace charts

FP&A Done Right: Overcoming Obstacles to Collaboration in the Office of Finance

August 6, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, highlighting how to better improve collaboration in the Office of Finance.

As the role of CFO continues to become more strategic and collaborative, CFOs are expecting their teams to follow suit. As such, many finance leaders are requiring their teams to broaden their understanding of other functions and pushing them to communicate and collaborate more effectively, both internally and externally. According to our studies, collaborative work now consumes a significant portion of the finance team’s week.

The limitations of legacy tech

One of the primary obstacles to better collaboration is outdated technology. With many finance departments still relying on email and spreadsheets to drive their reporting process, collaboration is a time-consuming, frustrating task.

Think about this common scenario: A report identifies a variance and is emailed out to multiple stakeholders for review. This triggers a massive email chain of variance queries, change requests, and edits. Soon you have multiple versions of the spreadsheet existing on different computers. Which one is the right one? And if it’s not saved on the server, who can access it?

Of course, the other issue is accuracy. How does anyone know whether the numbers in the spreadsheet are correct in the first place? Manual-driven processes are susceptible to errors like entering data in the wrong cell, messing up a formula, or adding an extra digit by mistake. As stakeholders copy and paste information into spreadsheets and email them along, you lose the ability to easily track who is entering data or verify where that data originally came from.

The role of nonfinance managers in financial reporting

When some finance departments talk about collaboration, they think about ways of making it easier to collaborate within the department. While that’s important, true collaboration means making it just as easy for nonfinance managers to be able to access and make changes to a report.

Going back to spreadsheets, often the finance department works to get the report perfect before sending it off to an operational manager for review. If the operational manager adds a last-minute update, it can require a massive amount of work to incorporate, review, and verify.

While accurate data is obviously the top priority, something else to consider when collaborating with nonfinance managers is data visualization. Even after you have all the numbers together in a report, a spreadsheet can be difficult to interpret and understand. A report is only as good as the action your team can take from it; to improve collaboration, you must improve both access and understanding of the data.

The 3 steps to making reporting collaborative

If you wish to make your reporting a more collaborative process, here are three keys to keep in mind:

Step 1. Access
Instead of static spreadsheets and email, it’s critical to move your reporting process to the cloud using smart financial reporting software like Workday Adaptive Planning. Because it’s accessible through the web, all your stakeholders can work from the same set of numbers at the same time without confusion or delay. And since you can control and track at the user level who has access and who enters data, you can greatly increase transparency and accountability throughout the reporting process.

Step 2. Ownership
In addition, Workday Adaptive Planning can automatically import data from both your financial and nonfinancial systems. This not only saves time and reduces errors, but it also takes all your data out of departmental silos and brings it together to give your entire company a single source of truth to work from.

Step 3. Understanding
Once you’ve automated data collection, you can focus on delivering insights. Workday Adaptive Planning lets you easily distribute board reports, slice and dice management and financial reports for specific departments, and drill down into the details. Because it’s connected to all your systems, you can also easily create real-time, visually appealing dashboards that give nonfinancial managers instant insight into their department’s performance.

Collaboration is integral to today’s finance initiatives

The marriage of traditional accounting and analytic skills with interpersonal communication and collaboration skills reflects the changing face of today’s finance team and leaders. Data alone is not valuable to today’s organizations. But the ability to aggregate, align, and interpret company-wide data that guides corporate performance continues to separate the traditional from the modern CFO.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Financial Performance Management » Page 12

Filed Under: FP&A Done Right Tagged With: collaboration + finance, enterprise performance management, enterprise planning, Financial Performance Management, FP&A, FP&A done right, Office of Finance

IBM Planning Analytics Tips & Tricks: Depreciation

July 27, 2021 by Lee Lazarow Leave a Comment

P&L planning models consist of a variety of inputs, including revenue planning and various forms of expense planning.  In addition to these standards, we are often asked to develop other planning components. One of these components entails a depreciation process, which leads to the question: what is depreciation?

Depreciation is defined as “a reduction in the value of an asset due to wear and tear or obsolescence.” In business terms, this typically entails a calculation to determine your current asset’s value. 

There are various methods to calculate depreciation, all of which are taught in an Accounting 101 class. Most organizations, however, use a simple approach called “straight line” that spreads the reduction evenly over the course of a pre-defined asset life.

There are typically four components to a depreciation process:

  • Asset value – the original cost of the asset
  • Asset life – how long will it take for the asset to stop reducing its value
  • Salvage value – the amount you expect the asset to be worth at the end of the asset’s life (e.g., a resale value)
  • In service date – the time that you begin depreciating the asset, which is not always the same time as the purchase date

The calculation is relatively simple: subtract the salvage value from the asset value to determine the amount to be depreciated, then divide that amount by the asset life. Remember to ensure that the asset life uses the same level of time periods as your model … months, quarters, or years.

Once the depreciation calculation is performed you can easily view the original asset amount, the total allocated amount, and the current asset value. Want to learn more about depreciation details or recommended best practices? Contact us and we’ll help you.

IBM Planning Analytics, powered by TM1, is full of new features and functionality. Need advice? Our team here at Revelwood can help. Contact us for more information at info@revelwood.com. We post new Planning Analytics Tips & Tricks weekly in our Knowledge Center and in newsletters.

Read more IBM Planning Analytics Tips & Tricks:

IBM Planning Analytics Tips & Tricks: Scatter Chart vs Bubble Chart

IBM Planning Analytics Tips & Tricks: The Waterfall Chart

IBM Planning Analytics Tips & Tricks: 445

Home » Financial Performance Management » Page 12

Filed Under: IBM Planning Analytics Tips & Tricks Tagged With: Cognos TM1, depreciation, enterprise performance management, enterprise planning, Financial Performance Management, FP&A, IBM Planning Analytics, TM1

FP&A Done Right: 3 Ways to Improve Collaboration with Colleagues Outside of Finance

July 23, 2021 by Revelwood Leave a Comment

This is a guest blog post from our partner Workday Adaptive Planning, explaining how to improve collaboration between the Office of Finance and business managers.

Many companies suffer from poor communication and collaboration between financial and nonfinancial managers. Operating managers don’t have sufficient input or buy-in to the financial planning process, and they aren’t educated about how their decisions can influence overall profitability. For its part, finance isn’t able to offer real performance insights that might truly help managers improve their results.

Instead of working closely together to plan and forecast, finance and business resort to negotiations that can involve high levels of conflict. Why is this, and how can it be changed to strengthen collaboration between finance and the business—and therefore transform FP&A?

Drowning in metrics, measurements, and spreadsheets

First of all, companies sometimes flood managers with measurements and metrics, too few of which effectively help managers understand and improve their performance. Too much measuring can add cost and complexity to an organization.

Secondly, spreadsheets continue to dominate planning processes in most companies. While spreadsheets work well for individual productivity, they cause problems when it comes to sharing and aggregating. Finance gets bogged down in low-value-added work—such as formatting and troubleshooting spreadsheets—and can’t provide useful service to business managers.

Meanwhile, business managers waste time managing to budgets instead of managing their business. They often don’t get the information they need, when they need it, from finance. Instead, they’re deluged with data, metrics, and reports, much of which provides little value.

Furthermore, many planning systems are designed and implemented by finance and are seen as irrelevant by business managers. The result is lack of buy-in and enthusiasm.

Clearing the decks for useful analysis and true collaboration

Finance can make room for higher-value work for both themselves and managers by leading the way to less detail and complexity, simplifying internal systems, and reducing the amount of time managers spend producing counterproductive reports and analyzing too many measurements.

In so doing, finance can provide effective decision support and performance insight that can truly help managers improve their results, making finance a real partner rather than an adversary. Here are three best practices that will help you make these changes.

1. Continuous planning

First, replace detailed annual planning cycles, which take too long and result in a budget that is already out of date as soon as it is complete. A more effective planning system is a continuous process, focused on rolling views that look 12 to 18 months ahead. These continuous plans should enable managers to respond more rapidly to emerging events and trends and to changing business environments.

Replacing the annual budget with a rolling forecast can save huge amounts of work, freeing all managers to spend more time on value-added work. It will also improve the relationship between finance and business managers, as finance will have more time to provide better service.

2. Move from monthly variance reporting to KPIs and dashboards

Most companies manage through annual budgets and use monthly variance reporting as the primary feedback mechanism for managers. But monthly variance reporting is too slow and fails to reveal underlying causes of problems.

What is more effective is fast feedback of financial results, summarized and shown as trends and moving averages. KPIs should act as a management dashboard. They should provide managers with early warning signs when problems are brewing and action needs to be taken.

Defining measurements is just the first step. “The next step, and perhaps the hardest part, is to set in motion a cadence for the management team to know and really understand performance through KPIs so that they can use that knowledge to make the right decisions.

These KPIs should be few in number and appropriate to the level of management. A small number of key metrics should be reported daily and weekly. KPIs should provide a fast, high-level view of what is happening today and what is likely to happen in the short-term future. Moving to KPIs in this fashion will not only provide true value to managers but will also lighten the reporting load for the entire organization.

3. Deploy cloud technology that provides fast, relevant information, enabling collaboration

Finance can use technology to provide a performance management system that delivers what managers need—fast, relevant information. Avoid investing in complex IT systems that consume valuable time and money without providing reasonable value.

Instead, implement a dedicated system that employs cloud-based technology to enable unlimited numbers of managers to work together on driver-based forecasts, which are automatically aggregated at every level. This system should also have tight integration with data from other enterprise systems, so that it serves as the primary performance management system.

Why wait?

By implementing these three best practices, your finance team can transform itself and your company’s performance management practices. Your finance team can move beyond simply being effective at financial management and scorekeeping, and instead become a trusted and integral member of the strategic management team. And finance can offer real performance insights that can truly help your managers improve their results.

This blog post was originally published on the Workday Adaptive Planning blog.

Home » Financial Performance Management » Page 12

Filed Under: FP&A Done Right Tagged With: enterprise performance management, enterprise planning, Financial Performance Management, FP&A done right, Office of Finance, Rolling Forecasts, xP&A

  • « Go to Previous Page
  • Page 1
  • Interim pages omitted …
  • Page 10
  • Page 11
  • Page 12
  • Page 13
  • Page 14
  • Interim pages omitted …
  • Page 47
  • Go to Next Page »

Footer

Revelwood Overview

Revelwood helps finance organizations close, consolidate, plan, monitor and analyze business performance. As experts in solutions for the Office of Finance, we partner with best-in-breed software companies by applying best practices guidance and our pre-configured applications to help businesses achieve their full potential.

EXPERTISE

  • Workday Adaptive Planning
  • IBM Planning Analytics
  • BlackLine

ABOUT

  • Who We Are
  • What We Do
  • How We Help
  • How We Think
  • Privacy

CONNECT

World Headquarters

Florham Park, NJ | 201 984 3030

European Headquarters

London & Edinburgh | +44 (0)131 240 3866

Latin America Office

Miami, FL | 201 987 4198

Email
info@revelwood.com

Copyright © 2025 · Revelwood Inc. All rights reserved. Revelwood® and the Revelwood logo are registered marks of Revelwood Inc.