Tools

The truth is in the cash flow

On this page is a selection of the tools developed by Pro Veritate to help you understand the truth about your business cash flow. These are simplified versions of some of the tools that we use. They are intended to show you their flexibility and usefulness. Please do download them and explore their functionality.

These models were built using Excel 2010 (Annual Forecast Model, Inventory Optimisation Model and Investment Evaluation Model) and in Excel 2016 (Currency Calculator) and will work best with that version of the software.  Whichever version you download, you will need to ensure your Excel programme is using the Analysis Tookpak Add-In.

Each model has detailed instructions incorporated into the file but if you are having trouble understanding those instructions, or getting them to work, then please Contact Us.

Annual Forecast Model

The Annual Forecast Model is used to turn your business plans into financial forecasts, show you the impact of taking on a new, large customer or acquiring another business, stress testing compliance with bank financial covenants, updating forecasts for real world changes in real time, etc.

Annual Forecast Model Excel 2010 Version (192KB)

Inventory Optimisation Model

The Inventory Optimisation Model is used to determine the optimal inventory order quantity, taking into account discounts and delivery costs, and trading off against holding costs.

Inventory Optimisation Model Excel 2010 Version (586KB)

Investment Evaluation Model

The Investment Evaluation Model is used to help compare investments in capital appreciating assets (such as land and buildings) to determine which is the best investment from a cash flow perspective. This model allows you to compare investments of different amount and time frame on a consistent basis.

Investment Evaluation Tool Excel 2010 Version (614KB)

Currency Calculator

The Currency Calculator is used to help you understand whether the Forward Exchange Rate should be higher or lower than the spot rate (ie: whether the Forward Points are trading at a premium or discount to spot). It is intended to identify Base and Quote Currency, and the margin being loaded into the AUD Interest Rate to arrive at the forward rate quoted by your currency provider. The objective is to increase transparency and help business owners challenge their providers for a fair deal.

Currency Calculator