Free Tools

Sharing is caring. Get free tools, no registration required. In case of questions or if you want to provide feedback, please contact us at excel-tools@treamo.com.

Project Calculator

This tool is mainly designed for e.g. projects where one might have cash flows in different (foreign) currencies, but it can be used for the simple calculation of forward rates based on linear interpolation as well.

The idea is to capture all expected flows in one table and to create a cash forecast by curreny. E.g. budget rates can be used as benchmarks in order to find out whether a forward rate is below or above the benchmark rate and therefore potentially generates a profit or a loss (if rates remain at the same level).

Please note that this currently is just a prototype, feedback is always welcome.

Edit August 12, 2015 - Issues with decimal separator '.' fixed.

Edit January 16, 2017 - BYR replaced by BYN (Belarus Ruble).

FX Rates

Follow up to 15 FX rates against a freely selectable base currency. Market rates are provided via a web service and updated every 60 minutes.

The calculation of cross rates is supported as well as the option to set individual alarms (limits, deviation in %).

Populating a spreadsheet with FX rates for sure is not rocket science. However, together with the market data this can be a useful option for colleagues not having direct access to market data or colleagues in subsidiaries abroad, who can select their functional currency and will get the respective rates (based on EUR rates).

Edit August 12, 2015 - Issues with decimal separator '.' fixed, inverted rates added.

Edit January 16, 2017 - BYR replaced by BYN (Belarus Ruble)

FX Rates with AutoUpdate

Follow up to 45 different FX rates against a freely selectable base currency. Market rates are provided via a web service and updated every 60 minutes.

This tool offers an automated update feature, rates presented in the tool are (optionally) automatically updated every five minutes.

Again, nothing special with regards to the FX rates, however, some nice functionality embedded and probably useful for people not having direct access to market data.

Edit August 12, 2015 - Issues with decimal separator '.' fixed.

Edit January 16, 2017 - BYR replaced by BYN (Belarus Ruble).

Excel® is a registered trademark of Microsoft Corporation.