Billing Model

When billing structures are altered they impact on client numbers and in turn revenue and profit. 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. 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.

Billing Model

Download Billing Model

downloadzip file Download Billing Model - Compressed Zip file
billingmodel.zip

or

downloadexcel file Download Billing Model - .xlsx file
billingmodel.xlsx

This application is a spreadsheet developed in Microsoft Excel and will run on Microsoft Excel and most other spreadsheet applications. You can download Billing Model free of charge for evaluation. In evaluation mode some functionality is restricted. To license your application and fully enable all functions requires the purchase of an application license. If you have not already please consider buying a license to fully enable your application.

If you download the Compressed Zip file unzip/uncompress the downloaded file and save the content .xlsx application file. If you download the .xlsx file simply save the .xlsx file. Open the .xlsx file and follow the instructions. This application does not access or alter your system or system files in any way. To uninstall simply delete the saved files.

Application suitability must be independently assessed and use indicates acceptance of any and all associated risk.

Help Billing Model

Billing Model considers two billing structures, Current (1st) and Proposed (2nd). From basic billing and cost data break even points at revenue and profit will be calculated for the proposed billing structure. Break even 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 Break even your Revenue will decrease, if it is greater than the Profit Break even 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.

Input is required in the blue cells. Including billing structure identifiers, average fee per client and the current number of clients for each billing structure. If you currently only use one billing structure and are considering introducing a second (proposed) input the estimated average fee per client for the second structure i.e. if your are looking at a fee increase of 10% input your current fee plus 10% as the average fee per client for your second billing structure. Then provide your Fixed and Variable cost percentages. From this data break even points at revenue and profit will be calculated. To view result details select the required tab at the bottom of the window.

Billing Structure Identifier

Input an identifier for your two billing structures under consideration. For example Public and Private. The proposed (2nd) billing structure should be the one you are testing.

Client Numbers

Input the current number of clients for each billing structure. You can use any time frame you like month, year etc however it should reasonably reflect your normal business. If you currently have no clients for your second structure input 0 for that structure.

Average Billing Amount

Input the average amount billed for each billing structure. If you currently only use one structure you will need to provide an estimate of the average billing amount for your second billing structure.

Billing Amount

This is the calculated current billing from each structure for the time period used. It is Client Numbers X Average Billing Amount.

Fixed Costs as % of Total Billing Amount

Input your current Fixed Costs as a Percentage of Total Billing Amount. The Fixed Cost Amount (expense) calculated from this percentage will remain constant over the range of billing combinations.

By reducing your fixed coasts when using your new billing structure your profits will be further enhanced. If for example you are increasing billing fees and this will reduce client numbers you may also be able to decrease your fixed costs i.e. reduce administration, location costs etc.

Variable Costs as a % of Total Billing Amount

Input your current Variable Costs as a Percentage of Total Billing Amount. The Variable Cost Amount (expense) calculated from this percentage will change with the number of clients. However the Variable Cost Amount per Client will remain constant over the range of billing combinations.

Variable Cost Amount per Client

This amount is applied in calculating the variable cost and associated profit in the Calculation Table and for Profit Break even.

Profit as a % of Total Billing Amount

This is the calculated Profit (surplus) as a Percentage of Total Billing Amount after fixed and variable costs.

Revenue Break even is at ...

This is the Client Number Change Percentage at which there is no change in Revenue between your two billing structures. If the Client Number Change Percentage is greater than this revenue will decrease when you move to your second billing structure. If this percentage is negative it signifies a decrease in Client Numbers when you move to your second billing structure. The Client Number Change Percentage is the percentage of clients that will change their preference for your service (go to competitors if negative, come from competitors if positive) when your Billing structure is changed from your first billing structure to your second.

Profit Break even is at ...

This is the Client Number Change Percentage at which there is no change in Profit between your two billing structures. If the Client Number Change Percentage is greater than this profit will decrease when you move to your second billing structure. If this percentage is negative it signifies a decrease in Client Numbers when you move to your second billing structure. The Client Number Change Percentage is the percentage of clients that will change their preference for your service (go to competitors if negative, come from competitors if positive) when your Billing structure is changed from your first billing structure to your second.

Estimated Client Number Change % ...

Input your Estimated Client Number Change Percentage (how many clients will you gain (+) or lose (-) if you use your second billing structure). This is the percentage change in client numbers when your billing is changed from your first to your second structure. For each business this is influenced by the level of competition, differentiation of the business, client profiles, and type of service provided. If competition is high and your business provides basically the same service as competitors, your clients are price sensitive, and your service is elastic in demand (i.e. the percentage demand change is greater than the percentage change in price) your Client Number Change Percentage will be high and negative when the average fee for your second billing structure is greater than average fee for your first billing structure. This indicates a large percentage reduction in client numbers if you move to the second billing structure.

... billing Client Numbers are

This is the calculated Client Numbers when all your billing is based on your first / second billing structure and using your Estimated Client Number Change Percentage.

Revenue

This is the calculated Revenue when all your billing is based on your first / second billing structure and using your Estimated Client Number Change Percentage.

Profit

This is the calculated Profit when all your billing is based on your first / second billing structure and using your Estimated Client Number Change Percentage.

Billing and Profit Chart

Plots Billing and Profit by Client Billing Structure %.

Client Numbers Chart

Plots Client Numbers by Client Billing Structure %.

Calculation Table

Calculations by Client Billing Structure.

License Billing Model

Please consider supporting application development. Licensing your application will fully enable all functions.

License your application now
  $39.95 USD per year

Secure online transaction processing is provided via PayPal. License details are sent by email as soon as your transaction is processed and will fully enable your application.

Application suitability must be independently assessed and use indicates acceptance of any and all associated risk.

Billing Model
-

I am very impressed with the functionality of your Business Valuation Model, the lay out and the user friendliness. Your purchasing and registration procedure is also excellent.Robert de Rooy ... thank you for a brilliant and easy to use tax system, you have literally saved me hours and hours of work with simple clicks and drag from my accounting software to BAS-I.C my bas is done.Lisa Groundwater Thank you for this great software!Cedric Franklin This is the best model I have seen in a few decades.Darren Stevenson ...a resounding '1' for excellence. I am pleased with the performance of the software, the ease of use and the overall service. I am glad that I went ahead and ordered it. I plan to make heavy use of it during the rest of my MBA program and in my work life. No doubt I will be purchasing other programs from you. You have what I need.Judy Bottita the software has really simplified my tax and therefore my life! Thanks so much!Gail Tagarro Thanks very much for putting the BAS-I-C software 'out there' - so far it seems terrific and perfect for what I need.Chris Hargreaves I just down loaded the excel version...awesome....thanks so muchEdward M. Rouse great model for small biz and start up!Russell Smith I have my own accounting firm and I must admit that I am very impressed ... IT IS OUTSTANDING.Robert B. Wester, Jr Excellent software program. I have already referred several folks to your site to download the demo. Hopefully, they will turn into sales for you. Good Luck!Anthony Beebe Wow...you're good. Thanks for your help...and the rapid response was greatly appreciated. I think you have a great product; I've been doing 'if/then' scenarios on future options for my company, and it is quite fascinating using your program...You guys were great...exactly what I was looking for...I was very impressed with your customer service...great follow-up and execution. The software is easy to use, as was your web site. Thanks for your software; if I need any business software, I would be happy to look at you guys first. Keep up the good work.Kevin O'Keefe Thanks your program it was great for me starting out in my small business, definitely recommend it for startups.Jayne Bachelor I was greatly impressed...Michelle Lamont Great Software...Art Vedner I'm just starting to use this system for BAS reporting and am enjoying the simplicity and ease of use....I give you guys 5 stars.Jodie Maurer I am very impressed with the model.Jozua Fokker I think you have an excellent product and I look forward to trying some more of your software. I am very pleased!Rod Butler ...the system works great.Lyslei Chirico ...works perfectly.Hendry Buter You have excellent products that have saved me several hours of time. Ease of purchase is excellent. Keep up the good work and keep coming up with improved business models. You are absolutely on the right track.Denis Cowley Now to begin my third year with your excellent system ... How lucky I am to have bought your software. Thank youZoe Harrison Now that I have purchased the program, I honestly believe the price is ridiculously low for the power, utility and results generated by the program.Martin Caplan Just started playing with your software and I like it!Roger Loweth I just purchased your software - it's wonderful.Roger Varner I have been very happy with software purchase and was going to purchase another app... Thanks again for the great software!Frank Brown The Business Valuation software that runs in Excel saved my company a lot of time in evaluating an acquisition candidate. The instructions are clear and straightforward, and the program worked flawlessly.Tom Sweet I have loved your BAS Business Accounts Software and think it's ideal for sole traders (which was the reason I purchased it).Nicole Cornish Great piece of software. It has been a real winner in presentations here already. I have more to explore with it, too.Chad Haight ...I am in the midst (or shall we say was in the midst) of selling my company for a much lower amount...your software is working wonderfully...i think i shall send you a bottle of your favorite...Sean Hawley Love this application! It certainly can improve one's comfort level, especially the small business owner, when talking to the financial people. Seems to me like you can get a quick budget snapshot as well as the business valuation. Thanks again!Stan Shaw I am impressed with your business valuation model.Peter Davies Am really enjoying working with this programme, I am sure within the next week I will be putting an order in. I have found it so easy to use, wish I had known about it years ago, life would have been much easier.Lyn Laycock This spreadsheet has really made my life easy and I have recommended it to my colleagues.Moses Mwanjirah We are very pleased with your Business Valuation Model.Steve Geringer ...very easy to use.Karl Hayes Just purchased your great spreadsheet.Terje Larsen I think it is a very useful spreadsheet and I'm using it and I haven't found anything better and have stopped looking.Antoine Matarasso I am very happy with the Excel valuation model supplied. I think it constitutes good value for money and has been of great help to me in my work.Graham Ireson Well done. It proved very useful for me already.Roland Mechler The program is quite easy to use.Jackquie Grant I still love the software.Jim Dickey Received and working great... Excellent service.Kevin Long ...very user friendly...Abel Acuna I recently purchased a copy of this package and have found it to be extremely helpful as a quick valuation tool...This is a great piece of software...Jim Wendler