---
title: Cashflow Forecasting for Client Financing
description: Here’s the top five benefits for an accounting firm using our new Spotlight Forecasting loan amortisation rule.
image: https://blog.spotlightreporting.com/hubfs/Loan%20Amortisation.png
---

[![Return to homepage](https://blog.spotlightreporting.com/hubfs/Brand_attributes/spotlight%20reporting%20logo.svg "Return to homepage")](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](https://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

# Cashflow Forecasting for Client Financing

Posted by [Julie Francis](https://blog.spotlightreporting.com/author/julie-francis) on 04 May 2018

- [Tweet](https://twitter.com/share)

If you are preparing a cash flow forecast to help your client obtain financing, use Spotlight Forecasting and in particular the new loan rule to prepare a full 3 way forecast.

The organisation lending the funds will always want to see that the funds can be repaid and that the repayment plan is realistic and manageable. Use our scenarios within Spotlight Forecasting to show the impact of varying levels of loan repayments or different loan terms. Help your client achieve an optimal outcome.

Here are the top five benefits when using our new Spotlight Forecasting loan [amortisation rule](https://vimeo.com/267503449);

## Save Time

Using the loan rule will save you a lot of time (estimate up to 30 mins per loan) as the rule will calculate the interest and principal repayments and then journal these to the profit & loss, balance sheet and cashflow forecast. The new loan rule will also make it easy for users to edit loan details if required.

## Accuracy

Once you enter the parameters of the loan, the rule will calculate the interest and principal repayments and then journal these to the profit & loss, balance sheet and cashflow forecast.  

This eliminates data entry errors that may otherwise occur. The rule ensures that journals covering the profit & loss, balance sheet and [cashflow forecast](https://blog.spotlightreporting.com/forecasting-update-new-rules-display-options-and-more) are all posted correctly.

## Visibility

The rule will clearly show what loan parameters have been entered along with the loan schedule which can be downloaded in Excel or PDF format. As long as the loan parameters have been entered correctly, the loan outputs will allow you to verify the calculations to statements from the bank/lender.

Clients receiving the reports can also be given a summary of the loans that have been recorded.

## Better Decision Making

Since the new rule allows you to quickly and accurately record loans, you can then try different loan configurations (e.g. smaller/larger loan amounts, shorter repayment periods, additional repayments, increased/decreased interest rates) in the forecast and see the financial impact of these.

The ability to create different loan scenarios [to present to your client](https://blog.spotlightreporting.com/embedding-cash-flow-advisory-services) will ensure that the optimal borrowing conditions are achieved.

## Highly Visual Outputs

Combining Spotlight Forecasting reports with your insight and advice can lead to better conversations with your client.  We believe that every business deserves a cashflow forecast. Be your clients trusted advisor by making Spotlight Forecasting the cornerstone of your [advisory services](https://blog.spotlightreporting.com/the-yellow-brick-road-towards-advisory).

*To see our loan rule in action [click here](https://vimeo.com/264919955/7b74d60077), then start a [28-day trial](https://go.spotlightreporting.com/Member/Signup)*

 

[![Loan-Amortisation-02](https://blog.spotlightreporting.com/hs-fs/hubfs/Loan-Amortisation-02.jpg?width=700&height=173&name=Loan-Amortisation-02.jpg)](https://info.spotlightreporting.com/post-release-webinar-loan-amortisation-rules)

### Recent Posts

---

### Posts by Month

- [August 2020 (4)](https://blog.spotlightreporting.com/archive/2020/08)
- [July 2020 (7)](https://blog.spotlightreporting.com/archive/2020/07)
- [June 2020 (7)](https://blog.spotlightreporting.com/archive/2020/06)
- [May 2020 (4)](https://blog.spotlightreporting.com/archive/2020/05)
- [April 2020 (11)](https://blog.spotlightreporting.com/archive/2020/04)
- [March 2020 (12)](https://blog.spotlightreporting.com/archive/2020/03)
- [January 2020 (3)](https://blog.spotlightreporting.com/archive/2020/01)
- [December 2019 (5)](https://blog.spotlightreporting.com/archive/2019/12)
- [November 2019 (4)](https://blog.spotlightreporting.com/archive/2019/11)
- [October 2019 (4)](https://blog.spotlightreporting.com/archive/2019/10)
- [September 2019 (5)](https://blog.spotlightreporting.com/archive/2019/09)
- [August 2019 (4)](https://blog.spotlightreporting.com/archive/2019/08)
- [July 2019 (1)](https://blog.spotlightreporting.com/archive/2019/07)
- [June 2019 (3)](https://blog.spotlightreporting.com/archive/2019/06)
- [May 2019 (4)](https://blog.spotlightreporting.com/archive/2019/05)
- [April 2019 (1)](https://blog.spotlightreporting.com/archive/2019/04)
- [March 2019 (2)](https://blog.spotlightreporting.com/archive/2019/03)
- [January 2019 (2)](https://blog.spotlightreporting.com/archive/2019/01)
- [December 2018 (1)](https://blog.spotlightreporting.com/archive/2018/12)
- [November 2018 (1)](https://blog.spotlightreporting.com/archive/2018/11)
- [October 2018 (1)](https://blog.spotlightreporting.com/archive/2018/10)
- [September 2018 (3)](https://blog.spotlightreporting.com/archive/2018/09)
- [July 2018 (3)](https://blog.spotlightreporting.com/archive/2018/07)
- [June 2018 (2)](https://blog.spotlightreporting.com/archive/2018/06)
- [May 2018 (4)](https://blog.spotlightreporting.com/archive/2018/05)
- [March 2018 (1)](https://blog.spotlightreporting.com/archive/2018/03)
- [January 2018 (4)](https://blog.spotlightreporting.com/archive/2018/01)
- [November 2017 (2)](https://blog.spotlightreporting.com/archive/2017/11)
- [October 2017 (2)](https://blog.spotlightreporting.com/archive/2017/10)
- [September 2017 (3)](https://blog.spotlightreporting.com/archive/2017/09)
- [August 2017 (2)](https://blog.spotlightreporting.com/archive/2017/08)
- [July 2017 (1)](https://blog.spotlightreporting.com/archive/2017/07)
- [June 2017 (4)](https://blog.spotlightreporting.com/archive/2017/06)
- [May 2017 (1)](https://blog.spotlightreporting.com/archive/2017/05)
- [April 2017 (3)](https://blog.spotlightreporting.com/archive/2017/04)
- [March 2017 (4)](https://blog.spotlightreporting.com/archive/2017/03)
- [January 2017 (3)](https://blog.spotlightreporting.com/archive/2017/01)
- [December 2016 (2)](https://blog.spotlightreporting.com/archive/2016/12)
- [November 2016 (4)](https://blog.spotlightreporting.com/archive/2016/11)
- [October 2016 (2)](https://blog.spotlightreporting.com/archive/2016/10)
- [September 2016 (3)](https://blog.spotlightreporting.com/archive/2016/09)
- [August 2016 (5)](https://blog.spotlightreporting.com/archive/2016/08)
- [July 2016 (3)](https://blog.spotlightreporting.com/archive/2016/07)
- [June 2016 (5)](https://blog.spotlightreporting.com/archive/2016/06)
- [April 2016 (1)](https://blog.spotlightreporting.com/archive/2016/04)
- [March 2016 (1)](https://blog.spotlightreporting.com/archive/2016/03)
- [January 2016 (4)](https://blog.spotlightreporting.com/archive/2016/01)
- [December 2015 (2)](https://blog.spotlightreporting.com/archive/2015/12)
- [November 2015 (3)](https://blog.spotlightreporting.com/archive/2015/11)
- [October 2015 (1)](https://blog.spotlightreporting.com/archive/2015/10)
- [September 2015 (1)](https://blog.spotlightreporting.com/archive/2015/09)
- [August 2015 (5)](https://blog.spotlightreporting.com/archive/2015/08)
- [July 2015 (2)](https://blog.spotlightreporting.com/archive/2015/07)
- [June 2015 (3)](https://blog.spotlightreporting.com/archive/2015/06)
- [May 2015 (4)](https://blog.spotlightreporting.com/archive/2015/05)
- [April 2015 (6)](https://blog.spotlightreporting.com/archive/2015/04)
- [March 2015 (4)](https://blog.spotlightreporting.com/archive/2015/03)
- [February 2015 (2)](https://blog.spotlightreporting.com/archive/2015/02)
- [January 2015 (3)](https://blog.spotlightreporting.com/archive/2015/01)
- [December 2014 (1)](https://blog.spotlightreporting.com/archive/2014/12)
- [November 2014 (1)](https://blog.spotlightreporting.com/archive/2014/11)
- [October 2014 (2)](https://blog.spotlightreporting.com/archive/2014/10)
- [August 2014 (5)](https://blog.spotlightreporting.com/archive/2014/08)

see all

### Subscribe for Email Updates

[![Return to homepage](https://blog.spotlightreporting.com/hubfs/Brand_attributes/spotlight%20reporting%20logo.svg "Return to homepage")](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