Calculating the liability on a property that was created from a sequence of Splits, Merges and Recons can be very complicated, time consuming and it is quite easy to make a mistake in one stage which is then carried forward to all subsequent stages.
For example, if you need to calculate the liability on a property with an RV of 15,000 but that property was created by the merge of two other properties, and one of those properties was created by the merge of three other properties, which themselves had been created by the split of one property, you would have to perform several “R x J / S” Calculations which can be quite complicated.
The Calcurate Multi-Recon feature makes light work of the most complicated calculations.
In the example above all we need to do is identify the sequence of events and enter the details into Calcurate Multi-Recon
Step One: Draw a diagram (see below)
Step Two: Give each property a number (see below)
Step Three: For each new (or “child”) property, identify which of the other properties were its “parent” (see below)
Step Four: Enter the information into Multi-Recon and click the “Calculate” button
That’s it! – Liability will be calculated on each new property up to the end of the list or the end date you’ve entered.
The 2017 Multi-Recon also shows the R x J / S calculation for each new property in the creation year.
Multi Recon is included with Calcurate 2010 and 2017
The 2017 Multi-Recon has a few of the feature buttons found elsewhere in Calcurate. Click the image below for a close look.
2017 Calcurate – Opens the 2017 Calculator
Unprotect/Protect – Protects or Unprotects the sheet
Clear All – Clear input and results
Calculate – Actions the calculation
Help – Guidance notes
Load Sample Data – Some sample input to illustrate how to use the Multi-Recon calculator
Clear Results – Clears the results but not the input
R x J / S Detail – Gives the R x J/S figures in the creation year for each new property, and the Base Liability to be used in the following year. Ideal for checking or challenging a business rates account.
Delete these Buttons – Deletes the buttons
Copy and Save – Creates a two page (i.e. the property details and the R x J/S details) copy of the Multi-Recon calculator and saves it in the Saved Calculations Folder.
Folder Icon – Open the Saved Calculations Folder
Close – Closes the Multi-Recon Calculator