The Online Calculators are an important part of the ValueBridge.net toolkit. They perform the same math as the Excel templates, but they cannot be altered (broken) through human error. Consider using the Online Calculators to occasionally spot-check your Excel models. Certainly do so before significant events, like including results in a Private Placement Memorandum or an Investment Committee Memo.
To check your work, start with a similar ValueBridge.net Module and select the appropriate parameters. Copy only the “independent variables” from the Excel file to the Online Calculator. This saves time because the Excel model’s 60-80 numbers are mostly dependent variables, but only the 8-10 independent variables must be plugged into the Online Calculator. Choose either the Derivative Model or Logarithmic Model from the drop-down to view results.
Make sure that Excel model and Online Calculator provide the same answers. If there is any discrepancy greater than 1-2%, start working backwards through the Online Calculator’s calculated dependent variables to find the source of the error. Consider using the “PRINT” button to make a hard copy and “check-off” the correct variables as you search for the wrong ones.
Please log in access additional content. Not a subscriber? Sign-up today!.