Billing Model

Download Now - free evaluation.

This model was originally designed to test changes in billing structures for a Medical Practice (Public versus Private Billing), however it is equally suited to any professional practice and can be used to test the impact of fee changes.

When billing structures are altered they impact on client numbers and in turn revenue and profit. The Billing Model allows you to forecast what this impact will be. It does this using a Client Number Change Percentage. This is the percentage change in client numbers when your billing structure is changed. For each business this is influenced by the level of competition, differentiation of the business, client profiles, and type of service provided. An estimate of this percentage combined with basic data on average billing fees and cost percentages allow revenue, profit and client numbers to be forecast for the range of billing fee combinations.

The model considers two billing structures, Current (1st) and Proposed (2nd). From basic billing and cost data breakeven points at revenue and profit will be calculated for the proposed billing structure. Breakeven points tell you the Client Number Change Percentage at which your current and proposed billing structures provide the same Revenue or Profit. If you change billing structures and the Client Number Change Percentage is greater than the Revenue Breakeven your Revenue will decrease, if it is greater than the Profit Breakeven your Profit will decrease. You can input an Estimated Client Number Change Percentage to forecast the Revenue, Profit and Client Numbers for your business for the full range of current and proposed billing structure combinations. Full results are displayed in easy to interpret Charts and Table format. Details displayed include Revenue, Profit, and Client Numbers.

Software is available free for 7 day evaluation. You can also Order Now for immediate online delivery with full functionality and receive a 30 day money back guarantee.

Download Billing Model Excel 10
167k - bme10.exe, Self-Extracting SetUp file.

or

Download Billing Model Excel 10
119k - bme.zip, Compressed Zip file.

For full functionality and a 30 day money back guarantee you can also...

Only US$29.00 for a Single User Non-Commercial License, plus a 30% discount for Multi User Licenses at just US$20.30. Additional pricing options are provided when you click the Order Now button.

The download package includes an Excel .xls file suitable for Excel 2007 and Excel 97-2003. Install the download package and open the Excel file. Macros must be enabled for this software to function. If you cannot access the input sheet macros are not enabled. In this case please refer to the Enable Macros information below.

Enable Macros using Excel 2007 to open a .xls file - When you open the .xls Excel file with Excel 2007 a 'Security Warning some active content has been disabled' message maybe displayed. This indicates that Excel has disabled macros. To enable Macros click Options, select Enable this Content and then click OK. This will enable macros and allow the software to function. If a save Compatibility message is displayed you can use the Save As function to either save the .xls file as an Excel Macro-enabled Workbook which has a . xlsm extension or unselect the check file compatibility option and keep the file as an Excel 97-2003 Workbook with a .xls extension. Either option is suitable.

Enable Macros using Excel 93-2003 to open a .xls file - If when you open the Excel software you are not presented with an option to enable macros you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros.

You can download this software free of charge for evaluation. Software is in Microsoft Excel format and Excel is required for use. To register software you must purchase the appropriate license using the Order Now button above or by selecting the required software from our Purchase Online page.

If software is downloaded as a Self-Extracting SetUp file (.exe) when you run the SetUp file it will extract and install the program. If software is downloaded as a standard Compressed Zip file (.zip) it requires unzipping for use. Trial Zip software is available free from Winzip or a simple freeware zip utility is available from JustZIPit.

The specific suitability of this software must be independently assessed. Software is provided as is, use is entirely at the users risk, and use acknowledges that Bizpep and all associated parties are held harmless from any claims or losses relating to software provided.