FinRobot Team would like to thank thank all our customers, colleagues and friends for all support and wish everyone the very best for the New Year!
Helpful Tips and Add-ons: Pro Forma Funding module
We continue our series of helpful tips and add-ons with Pro Forma Funding module. The Module automates manipulation of capital structure for any forecast balance sheet date. An add-on Sources & Uses summary allows setting assumptions for retiring of any existing financial liabilities with proceeds from new equity or debt issue. If no debt is retired, all proceeds will accrue to cash position at the issue date.
We find this add-on helpful when a capital raising exercise is being planned but its date is not certain. Likewise, the Module helps to analyse various funding options without re-wiring the main model. Without the Module any changes to capital structure are manual, time consuming and are prone to errors. The Module is designed to address these issues: there is one single Pro Forma Date input; when the date is changed, the Module instantly runs changes through the Model.
You can download the Pro Forma Funding Module here free (requires registration). Alternatively, there is ‘Add-ons’ button at the top right of the user Account page. You can always browse FinRobot add-ons’ library as we will upload more in the nearest future. Download an add-on and follow the instructions in the file to import code into your Base Model.
How difficult is it to import the code? If you follow the instructions provided in the file, it should not take longer than 10-20 minutes of your time. No advance knowledge of Microsoft Excel is required. It is a simple copy-paste operation. Remember to keep a separate copy of your Model prior to changes to revert to if you make a mistake.
Enjoy!
Week-end Fun with Excel
Our development team at FinRobot takes particular pride in our advanced knowledge of Excel, at least anything financials related, we would be the go to people. But this news really entertained us and is worthy for a repost as week-end humour.
Tatsuo Horiuchi, a 73-year old retiree from Japan, told Japanese website PC Online that he finds Excel a lot more capable and easy to use for creating art than a specialized paint programme. The retiree said that he did not use Excel at his job, but before he retired from his company, he felt like he wanted to do something new, bought a computer, and started using Excel.
Would not have been that amazing save for the fact that in the last ten years Horiuchi has established himself as a digital artist, showing his work in exhibitions. Enjoy!
Helpful Tips and Add-ons: CapEx Advances Module
We are pleased to announce that we start publishing a series of helpful tips and add-ons. The first in the series is CapEx Advances Module. You can download it here free (requires registration). Alternatively, there is a new button ‘Add-ons’ at the top right of the user Account page. You can always browse FinRobot add-ons’ library as we will upload more in the nearest future. Download an add-on and follow the instructions in the file to import code into your Base Model.
Do you need this Module? From modelling perspective, it is easy to shift payment profile if you have one single investment. Just book required adjustment into other current assets and unwind the same amount at the time of item’s install date. However, if your business constantly prepays for various types of equipment, manual adjustments become tedious and messy. Various terms and amounts tend to overlap, creating a risk of phantom or not-existing accruals or negative balance sheet positions. The Module is designed to address these issues.
What does the Module do? The Module calculates working capital and cash flow impact from advances paid to suppliers of long term assets. Add-on CapEx Advances Account tracks all prepayments added and unwound during each forecast period. It allows to manipulate % of down payment and lead-time from payment to procurement / install date for each asset class. As your assumption or terms may change the Module would recalculate timing of cash outflows based on few input parameters.
How difficult is it to import the code? If you follow the instructions provided in the file, it should not take longer than 10-20 minutes of your time. No advance knowledge of Microsoft Excel is required. It is a simple copy-paste operation. Remember to keep a separate copy of your Model prior to changes to revert to if you make a mistake.
Finally, note that you need to have some understanding of basic accounting principles for accruals of advances. Do not import the module if you feel uncomfortable with its logic or feel it is not suited for circumstances of your business.
Enjoy!
Blast Off
Dear guests,
Today FinRobot site is officially launched. We would like to say thank you to everyone involved in the project for all hard work for the past seven months. We are committed to releasing more models in the nearest future and to publishing helpful modelling tips regularly.
Stay tuned!
FinRobot Team