Billing Model Excel Icon

Billing Model Excel

Forecast the impact of billing fee changes on Revenue, Profit and Clients.

Billing Model ExcelOverview

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.

NEW

Macro free operation for Microsoft Excel Windows or Mac, Open Office Spreadsheet.

Billing Model ExcelInformation

Version
40
Date
10.04.10
License
Demo
Language
English
File Size
0.12 MB
Developer
Category
Operating Systems
Linux,Mac OS X,Mac Other,Win2000,Win7 x32,Win7 x64,Win98,WinOther,WinServer,WinVista,WinVista x64,WinXP
System Requirements
Microsoft Excel Windows or Mac, Open Office Spreadsheet.

Billing Model ExcelPrevious Versions

Pricing and Breakeven Analysis Icon
Test price changes, determine optimum pricing, and break even for your business.
Demo
Business Valuation Icon
Perform business valuation, 3 year forecast, calculated valuation and investment return.
Demo
BAS Business Accounts Software Icon
Perform various business accounting tasks.
Demo
Decision Assistant Model Excel Icon
Decision support for planning, budgeting, operational, and investment decisions
Demo
Pricing and Breakeven Analysis Excel Icon
Test price changes, determine optimum pricing and breakeven for your business.
Demo
PL Compiler MYOB Excel Icon
Format monthly MYOB Profit and Loss data, flexible review, automate budgeting.
Demo
Product and Supplier Profitability Excel Icon
Identify the true costs and profit associated with your products and suppliers.
Demo
Queuing Model Excel Icon
Calculate the number of service staff to minimize service and waiting costs.
Demo
More
Tally.ERP 9 Icon
Manage your accounting and compliance, while you focus to grow your business.
Demo
Microsoft Office Accounting Professional Icon
Office Accounting Professional 2009 is a complete accounting solution.
Trial
ezCheckPrinting Icon
Design, write, and print personalized checks with logo from laser printer on blank check paper.
Demo
atACC ERP Icon
Set up accounting and inventory management for your small or mid-sized company.
Demo
Creating an Automated Stock Trading System in Excel Icon
Create an automated stock trading system using Microsoft Excel.
Free
BS1 Accounting Icon
Manage your business accounting and inventory, bill customers, and pay vendors.
Free
Textile ERP Software Icon
Capable of storing, updating, searching, facility for client's requirements.
Free
Free Weighbridge Software Icon
Manage and track the critical information created at the time of weighing a product.
Free
More