---
title: Step up with these 5 Forecasting features
description: Don’t forget, Spotlight Forecasting is infinitely powerful and there’s lots under the hood that you may have not discovered.
image: https://blog.spotlightreporting.com/hubfs/forecasting-2.jpg
---
[](https://www.spotlightreporting.com/)
- [Solutions](https://spotlightreporting.com/our-solutions/)
- [Product](http://spotlightreporting.com/product/)
- [Pricing](http://spotlightreporting.com/pricing/)
- [Resources](http://spotlightreporting.com/resources/)
- [Our team](http://spotlightreporting.com/our-team/)
- [Blog](http://blog.spotlightreporting.com)
- [Free trial](http://go.spotlightreporting.com/Member/Signup)
[Login](https://go.spotlightreporting.com/Member/Login?ReturnUrl=%2f)
# Blog
Keep up to date with all industry news, special events and thought leadership
# Step up with these 5 Forecasting features
Posted by [Paul Gray](http://blog.spotlightreporting.com/author/paul-gray) on 07 Apr 2020
- [Tweet](https://twitter.com/share)
For those of us who use [Spotlight Forecasting](https://spotlightreporting.com/product/forecasting/) (why wouldn’t you be?!), it’s easy to get into a routine of always using the same features over and over again. But don’t forget, Spotlight Forecasting is infinitely powerful and there’s lots under the hood that you may not have uncovered yet.
From using the time-saving Loan Amortisation Rule, to performing a reality check with Comparison Pages, here are five features that will help you produce targeted, and relevant forecasts for your clients or business.
## **1. Loan Amortisation Rule: Secure funding and optimise repayments**
Recording loans in your forecast is essential for preparing accurate and meaningful cash forecasts, however, it can be a time-consuming exercise and prone to error. With the Loan Amortisation Rule, simply enter the loan details and Spotlight Forecasting will perform the calculations and record all the relevant information in the forecast for you.
.gif?width=600&name=ezgif.com-video-to-gif%20(2).gif)
The Loan Amortisation Rule is a deceptively straightforward solution that will impress your clients, help them achieve better outcomes, and save you time. For more on the Loan Amortisation Rule, check out the [help guide](https://help.spotlightreporting.com/forecasting/add-and-edit-the-loan-amortisation-rule) or [blog article](http://blog.spotlightreporting.com/more-flexibility-with-loan-amortisation-rules).
## **2. Dynamic Rules: One rule, dynamic change**
Dynamic Rules calculate the value of an account based on another account or formula. As the figures in the base account changes, the Dynamic Rule will automatically update the values in linked accounts.
Let’s look at a quick example. Say product costs are 10% of revenue, create a Dynamic Rule using the intuitive formula builder and now as revenue changes, you’ll notice product costs updating automatically—too easy.
For more on Dynamic Rules, check out the [help guide](https://help.spotlightreporting.com/forecasting/adjust-account-values-dynamic-rules).
## **3. KPIs & Covenants: Measure what matters**
This one is very new! We introduced KPIs & Covenants in Spotlight Forecasting to strengthen your forecasting capabilities. Now you can quickly surface key performance indicators and loan covenants in one place to help monitor these metrics and to assist with decision making.
So, how would you use this? Let’s look at an example:
Debt to Equity Ratio and Interest Coverage Ratio are two metrics that businesses need to monitor. Use the drag and drop formula builder in Spotlight Forecasting to quickly create these ratios and produce a ready-to-share report for your client or Board. A quick glance at the covenants will show all actual and forecasted values for the specified time period. You’ll see how the business in question is tracking against these covenants and also the projected position based on forecast data.
For more on KPIs & Covenants, check out the [help guide](https://help.spotlightreporting.com/forecasting/add-and-edit-kpis-and-covenants) or [blog article](http://blog.spotlightreporting.com/kpis-covenants).
## **4. Driver-Based Forecasting: Connect the Dots from Driver to Success**
Using Spotlight Forecasting and the power of Drivers and Dynamic Rules, it’s easy to build forecasts based on key business drivers. You choose the inputs that drive business activity—from price and quantity, through to billable hours, head-count, or even days worked. Use these drivers as the building blocks to forecast revenue, costs and the success of the business.
Pricing change? More staff to hire? Updating drivers is simple. Manage your Drivers within Spotlight and any changes you make will automatically flow through to your forecasts and scenarios, and best of all there’s no need for spreadsheets.
For more on Driver-Based Forecasting, check out the [help guide](https://help.spotlightreporting.com/forecasting/add-and-edit-drivers) or [blog article](http://blog.spotlightreporting.com/driver-based-forecasting).
## **5. Comparison Pages: Perform a reality check**
Visibility and analysis are helpful when discussing the future with clients. Comparison Pages allow you to add pages to the Cashflow forecast report so you can compare actuals to forecast as well as comparing various ‘what if’ scenarios.
.gif?width=600&name=Comparisonpages%20(1).gif)
For more on Comparison Pages, check out the [help guide](https://help.spotlightreporting.com/forecasting/comparison-pages).
---
[](https://cta-redirect.hubspot.com/cta/redirect/1756382/f5577c38-ccd7-4ed8-bd58-ff1bd89c32fb)
### Recent Posts
---
### Posts by Month
- [August 2020 (4)](http://blog.spotlightreporting.com/archive/2020/08)
- [July 2020 (7)](http://blog.spotlightreporting.com/archive/2020/07)
- [June 2020 (7)](http://blog.spotlightreporting.com/archive/2020/06)
- [May 2020 (4)](http://blog.spotlightreporting.com/archive/2020/05)
- [April 2020 (11)](http://blog.spotlightreporting.com/archive/2020/04)
- [March 2020 (12)](http://blog.spotlightreporting.com/archive/2020/03)
- [January 2020 (3)](http://blog.spotlightreporting.com/archive/2020/01)
- [December 2019 (5)](http://blog.spotlightreporting.com/archive/2019/12)
- [November 2019 (4)](http://blog.spotlightreporting.com/archive/2019/11)
- [October 2019 (4)](http://blog.spotlightreporting.com/archive/2019/10)
- [September 2019 (5)](http://blog.spotlightreporting.com/archive/2019/09)
- [August 2019 (4)](http://blog.spotlightreporting.com/archive/2019/08)
- [July 2019 (1)](http://blog.spotlightreporting.com/archive/2019/07)
- [June 2019 (3)](http://blog.spotlightreporting.com/archive/2019/06)
- [May 2019 (4)](http://blog.spotlightreporting.com/archive/2019/05)
- [April 2019 (1)](http://blog.spotlightreporting.com/archive/2019/04)
- [March 2019 (2)](http://blog.spotlightreporting.com/archive/2019/03)
- [January 2019 (2)](http://blog.spotlightreporting.com/archive/2019/01)
- [December 2018 (1)](http://blog.spotlightreporting.com/archive/2018/12)
- [November 2018 (1)](http://blog.spotlightreporting.com/archive/2018/11)
- [October 2018 (1)](http://blog.spotlightreporting.com/archive/2018/10)
- [September 2018 (3)](http://blog.spotlightreporting.com/archive/2018/09)
- [July 2018 (3)](http://blog.spotlightreporting.com/archive/2018/07)
- [June 2018 (2)](http://blog.spotlightreporting.com/archive/2018/06)
- [May 2018 (4)](http://blog.spotlightreporting.com/archive/2018/05)
- [March 2018 (1)](http://blog.spotlightreporting.com/archive/2018/03)
- [January 2018 (4)](http://blog.spotlightreporting.com/archive/2018/01)
- [November 2017 (2)](http://blog.spotlightreporting.com/archive/2017/11)
- [October 2017 (2)](http://blog.spotlightreporting.com/archive/2017/10)
- [September 2017 (3)](http://blog.spotlightreporting.com/archive/2017/09)
- [August 2017 (2)](http://blog.spotlightreporting.com/archive/2017/08)
- [July 2017 (1)](http://blog.spotlightreporting.com/archive/2017/07)
- [June 2017 (4)](http://blog.spotlightreporting.com/archive/2017/06)
- [May 2017 (1)](http://blog.spotlightreporting.com/archive/2017/05)
- [April 2017 (3)](http://blog.spotlightreporting.com/archive/2017/04)
- [March 2017 (4)](http://blog.spotlightreporting.com/archive/2017/03)
- [January 2017 (3)](http://blog.spotlightreporting.com/archive/2017/01)
- [December 2016 (2)](http://blog.spotlightreporting.com/archive/2016/12)
- [November 2016 (4)](http://blog.spotlightreporting.com/archive/2016/11)
- [October 2016 (2)](http://blog.spotlightreporting.com/archive/2016/10)
- [September 2016 (3)](http://blog.spotlightreporting.com/archive/2016/09)
- [August 2016 (5)](http://blog.spotlightreporting.com/archive/2016/08)
- [July 2016 (3)](http://blog.spotlightreporting.com/archive/2016/07)
- [June 2016 (5)](http://blog.spotlightreporting.com/archive/2016/06)
- [April 2016 (1)](http://blog.spotlightreporting.com/archive/2016/04)
- [March 2016 (1)](http://blog.spotlightreporting.com/archive/2016/03)
- [January 2016 (4)](http://blog.spotlightreporting.com/archive/2016/01)
- [December 2015 (2)](http://blog.spotlightreporting.com/archive/2015/12)
- [November 2015 (3)](http://blog.spotlightreporting.com/archive/2015/11)
- [October 2015 (1)](http://blog.spotlightreporting.com/archive/2015/10)
- [September 2015 (1)](http://blog.spotlightreporting.com/archive/2015/09)
- [August 2015 (5)](http://blog.spotlightreporting.com/archive/2015/08)
- [July 2015 (2)](http://blog.spotlightreporting.com/archive/2015/07)
- [June 2015 (3)](http://blog.spotlightreporting.com/archive/2015/06)
- [May 2015 (4)](http://blog.spotlightreporting.com/archive/2015/05)
- [April 2015 (6)](http://blog.spotlightreporting.com/archive/2015/04)
- [March 2015 (4)](http://blog.spotlightreporting.com/archive/2015/03)
- [February 2015 (2)](http://blog.spotlightreporting.com/archive/2015/02)
- [January 2015 (3)](http://blog.spotlightreporting.com/archive/2015/01)
- [December 2014 (1)](http://blog.spotlightreporting.com/archive/2014/12)
- [November 2014 (1)](http://blog.spotlightreporting.com/archive/2014/11)
- [October 2014 (2)](http://blog.spotlightreporting.com/archive/2014/10)
- [August 2014 (5)](http://blog.spotlightreporting.com/archive/2014/08)
see all
### Subscribe for Email Updates
[](https://www.spotlightreporting.com/)
- Our Company
- [Our Team](https://www.spotlightreporting.com/our-team/)
- [Careers](https://www.spotlightreporting.com/careers/)
- Solutions
- [Advisor](https://www.spotlightreporting.com/our-solutions/#advisor)
- [Owner & CFO](https://www.spotlightreporting.com/our-solutions/#owner-cfo)
- [Franchise](https://www.spotlightreporting.com/our-solutions/#franchise)
- [Not for Profit](https://www.spotlightreporting.com/our-solutions/#not-for-profit)
- Resources
- [Special Events](https://www.spotlightreporting.com/resources/#special-events)
- [Partner Success Centre](https://psc.spotlightreporting.com)
- [Webinars](https://www.spotlightreporting.com/resources/#webinars)
- [Help Centre](https://www.spotlightreporting.com/resources/#help-centre)
- [Blog](https://blog.spotlightreporting.com/)
- [White paper](https://www.spotlightreporting.com/resources/#white-paper)
- Plans
- [Basic](https://www.spotlightreporting.com/pricing/)
- [Super VCFO](https://www.spotlightreporting.com/pricing/)
- [Owners & CFOs](https://www.spotlightreporting.com/business-plans/)
- [Franchise](https://www.spotlightreporting.com/business-plans/)
- [Not For Profit](https://www.spotlightreporting.com/business-plans/)
- [LinkedIn Created with Sketch. LinkedIn](https://www.linkedin.com/company/spotlight-reporting-limited)
- [Facebook Created with Sketch. Facebook](https://www.facebook.com/Spotlight-Reporting-380174365420847/?fref=ts)
- [Twitter Created with Sketch. Twitter](https://twitter.com/spotlightrep?ref_src=twsrc%5Egoogle%7Ctwcamp%5Eserp%7Ctwgr%5Eauthor)
- [Vimeo Created with Sketch. Vimeo](https://vimeo.com/spotlightreporting)
© Spotlight Reporting 2018
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"contentUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/spotlight%20forecasting%20hero%20video%20v05.mp4",
"dateModified" : "2022-05-23T23:22:20.266Z",
"duration" : "PT1M30S",
"height" : 1080,
"name" : "spotlight forecasting hero video v05",
"thumbnailUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/spotlight%20forecasting%20hero%20video%20v05.mp4/medium.jpg",
"uploadDate" : "2020-03-30T04:45:20.655Z",
"width" : 1920
}
```
```json
{
"@context" : "https://schema.org",
"@type" : "VideoObject",
"contentUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Product%20Release_Driver%20Based%20Forecasting%20Video.mp4",
"dateModified" : "2022-05-23T23:21:41.309Z",
"description" : "Using Spotlight and the power of Drivers and Dynamic Rules, it’s easy to build forecasts based on key business drivers. You choose the inputs that drive business activity – from price and quantity, through to billable hours, head-count, or even days worked. Use these drivers as the building blocks to forecast revenue, costs and the success of your clients’ businesses.",
"duration" : "PT1M",
"height" : 1080,
"name" : "Driver-Based Forecasting",
"thumbnailUrl" : "https://1756382.fs1.hubspotusercontent-na1.net/hubfs/1756382/Product%20Release_Driver%20Based%20Forecasting%20Video.mp4/medium.jpg",
"uploadDate" : "2019-06-18T01:00:04.553Z",
"width" : 1920
}
```