… and one more Model!

 

RE_Model

To complement our existing range of financial models we just released a new model: Quick Real Estate (RE) Development Model. The Model performs back-of-the-envelope funding and returns calculation for a new real estate development.

The best part, it is free and you can re-run your inputs off-line as many times as you like. For a modest fee, you can buy a full version with additional functionality to apply inflation and debt leverage as well as to analyse pre- and post-tax returns. The new model can be found in the Tools area of our site.

And for those who missed it – our Quick IRR Model has a free version too! Our catalogue now boasts five financial models to satisfy a wide range of modelling needs. Come on in and give it a try!

New Model Released

fourjets2Dear Users and Guests!

We are pleased to announce that FinRobot has released its fourth model. Sibling of Base Model, TopLine Model provides more functionality and flexibility on the top line: you can choose to model sales based on customer acquisitions and retentions or via traditional sales volume and pricing.

The new Model allows up to ten product lines or user groups and you can assign up to five COGS drivers for each line/group. Being part of our Core Library range TopLine Model comes equipped with Financial Statements, Annual Summary and Valuation Tools.

To celebrate our latest release we are offering our new Model at 50% discount to our regular price. * Offer ends May 31, 2014.

We hope you like our new product. Come on in and give it a try!

Kind regards, FinRobot Team

Helpful Tips and Add-ons: Credit Ratios module

useful_tipsWe are frequently asked if our models are suitable for commercial lending modelling. Resolutely “Yes”. Lenders normally look for clearly presented and sound business cases. And our models are fit for this task. Nevertheless, in response to popular request we are introducing the new Credit Ratios module.

The module captures data from financial statements and calculates several commonly used credit ratios. Although we cannot guarantee your bank would apply absolutely identical modelling framework and credit scoring the ratios suggested in the module are very likely to be at core of any commercial lending analysis.

Model users can expand on the example provided and build their own set of credit ratios with ease. The Model will take care of the rest. You can download the Credit Ratios Module here free (requires registration). Alternatively, you can always browse FinRobot add-ons’ library located in your user Account.

It should not take more than 5 minutes to merge the Module  into the live Model: download an add-on xls file and follow the instructions to import the code into your Base Model. 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!

New Flexible Calendar Feature

TimelineDear Users

We are pleased to advise that effective immediately Base, Case Builder and Quick IRR Models are upgraded with a new feature: change of a model’s start date will instantly recalculate model’s dates for all forecast periods. Applying a change to one input cell will shift the whole model’s timeline accordingly. For example, if your starting point is no longer March 1st but June 1st or any other future date you can type in the new date into one cell, and the Model would do the rest. The new feature further enhances flexibility and time saving properties of our models’ design. Same model can be easily refreshed for a reforecast or used for a different project with a different timeline. Our on-line manuals and downloadable pdf copies are updated accordingly.

Enjoy!

Helpful Tips and Add-ons: Property Tax module

useful_tipsStandard cost drivers are commonly modelled by % revenue or by growth rate. However, it may not be ideal for all input costs. For example, depending on tax regime for your business a property tax may be levied on all or some commercial assets and is a cost of doing business. Property Tax Module with detailed instructions inside the xls file allows integrating property tax calculations in few minutes.

The Module is designed to demonstrate that our transparent model architecture makes it easy to replace any standard cost driver with a bespoke assumption. Model users can expand on the example provided and build their own complex rules with ease. The Model will take care of the rest. You can download the Property Tax Module here free (requires registration). Alternatively, you can always browse FinRobot add-ons’ library located in your user Account .

It should not take more than 10 minutes to merge the Module  into the live Model: download an add-on xls file and follow the instructions to import the code into your Base Model. 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!

Next Page »« Previous Page