Charge Out Formula Calculator

The Consultants' Consultant Essential Templates 1. The Magic Charge Out Formula Calculator Fill out this spreadsheet first - Fill in the yellow boxes only For an explanation for the cost categories, see the Australian Consultant's Guidebook (www.consultantsconsultant.com.au) Category Totals A. Yearly Salary costs for me $ Billing calculations B. Other peoples’ yearly salary costs $ C. Office and Office Set up $ D. Ongoing Overheads for office and equipment $ E. Professional Services and Fees F. Other operating costs G. Total costs $ $ $ Total costs for year Total working days $ $ Minimum daily rate Working day information H1 Total days in year H2 Total weekend days H3 Public Holidays H5 Total working days I1 Annual leave I2 Sick leave I3 Other time off J1 Marketing and Admin days J2 Training days K Total days available to work 251 - 365 104 10 251 Enter your specific costs for the year in the yellow boxes The spreadsheet will automatically calculate the totals. Cost category A1 Salary A2 Superannuation A3 Workers Comp A4 Other insurances A5 Professional Indemnity A6 Public Liability A. Yearly Salary costs for me B1 Salary B2 Superannuation B3 Workers Comp B4 Other insurances B5 Professional Indemnity B6 Public Liability B. Other peoples’ yearly salary costs C1 Office set up C2 Fax machine C3 Modem C4 Telephone – new line & handset C5 Computer purchase C6 Printer purchase Yearly costs 251 $ - Now you have completed the yearly calculations, Go to the Monthly Billing days Required Calculator to examine your cash flow across the year, Or go to the Five Year Billing Calculator to see how your billing rate can change as your business grows $ - Page 1 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates C7 Mobile phone handset C8 Other equipment – filing cabinets, shelving C9 Software C. Office and Office Set up $ D1 Office rent D2 Electricity D3 Office telephone D4 Mobile phone usage D5 Fax D. Ongoing Overheads for office and equipment $ E1 Secretarial Services E2 Accountancy fees and ASC annual return E3 Legal fees E4 Incorporating E5 Staff Training E6 Professional Memberships E7 Internet charges E8 Office cleaning E9 Graphic Design E. Professional Services and Fees $ F1 Business Cards F2 Letterhead F3 Other stationery F4 Stamps and postage F5 Car F6 Parking and Tolls F7 Courier F8 Taxis F9 Interstate marketing trips F10 Books, magazines and periodicals F11 Photocopying F. Other operating costs $ - - - - Page 2 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates 2. The Monthly Billing Days Required Calculator n.b. Fill in the Magic Charge Out Formula Before you do this spreadsheet - the numbers will carry forward Fill in the yellow boxes only Daily rate you will charge (use the magic charge out formula and your understanding of the market to determine this) Yrly total J $ $ $ $ $ $ $ $ $ $ $ $ $ $ F $ $ $ $ $ $ $ M $ $ $ $ $ $ $ A $ $ $ $ $ $ $ M $ $ $ $ $ $ $ Expenses across the year J $ $ $ $ $ $ $ J $ $ $ $ $ $ $ A $ $ $ $ $ $ $ S $ $ $ $ $ $ $ O $ $ $ $ $ $ $ N $ $ $ $ $ $ $ D - Summary Box A. Yearly Salary costs for me B. Other peoples’ yearly salary costs C. Office and Office Set up D. Ongoing Overheads for office and equipment E. Professional Services and Fees F. Other operating costs G. Total costs P. no days needed Q.no working days in month R. no days I'm available S. when I'll need to work T. when I plan to bill U. days booked $ $ $ $ $ $ $ - - - - - - - - - - - - Monthly costs allocated across the months A1 Salary A2 Superannuation A3 Workers Comp A4 Other insurances A5 Professional Indemnity A6 Public Liability A. Yearly Salary costs for me B1 Salary B2 Superannuation B3 Workers Comp B4 Other insurances B5 Professional Indemnity B6 Public Liability B. Other peoples’ yearly salary costs C1 Office set up C2 Fax machine C3 Modem C4 Telephone – new line & handset C5 Computer purchase C6 Printer purchase C7 Mobile phone handset C8 Other equipment – filing cabinets, shelving C9 Software C. Office and Office Set up D1 Office rent D2 Electricity D3 Office telephone D4 Mobile phone usage D5 Fax D. Ongoing Overheads for office and equipment E1 Secretarial Services E2 Accountancy fees and ASC annual return E3 Legal fees E4 Incorporating E5 Staff Training E6 Professional Memberships E7 Internet charges E8 Office cleaning E9 Graphic Design E. Professional Services and Fees F1 Business Cards F2 Letterhead Yrly total $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Checking column - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Page 3 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates Yrly total F3 Other stationery F4 Stamps and postage F5 Car F6 Parking and Tolls F7 Courier F8 Taxis F9 Interstate marketing trips F10 Books, magazines and periodicals F11 Photocopying F. Other operating costs $ $ $ $ $ $ $ $ $ $ - J F M A M J J A S O N D $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Page 4 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates 3. The Five Year Billing Calculator Fill out the Magic Charge out Formula Spreadsheet first. The numbers will carry forward. Use this spreadsheet to forecast your requirements over a longer period Only fill in the yellow boxes Year 1 Year 2 $ $ 251 365 104 10 251 $ $ Year 3 251 365 104 10 251 $ $ Year 4 251 365 104 10 251 $ $ Year 5 251 365 104 10 251 Summary Box Total costs for year Total working days Minimum daily rate Totals for the year A. Yearly Salary costs for me B. Other peoples’ yearly salary costs C. Office and Office Set up D. Ongoing Overheads for office and equipment E. Professional Services and Fees F. Other operating costs G. Total costs $ $ 251 365 104 10 251 251 $ $ $ $ $ - $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Working days calculations H1 Total days in year H2 Total weekend days H3 Public Holidays H5 Total working days I1 Annual leave I2 Sick leave I3 Other time off J1 Marketing and Admin days J2 Training days K Total days available to work 251 251 251 251 Breakdown of total costs A1 Salary A2 Superannuation A3 Workers Comp A4 Other insurances A5 Professional Indemnity Page 5 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates A6 Public Liability A. Yearly Salary costs for me B1 Salary B2 Superannuation B3 Workers Comp B4 Other insurances B5 Professional Indemnity B6 Public Liability B. Other peoples’ yearly salary costs C1 Office set up C2 Fax machine C3 Modem C4 Telephone – new line & handset C5 Computer purchase C6 Printer purchase C7 Mobile phone handset C8 Other equipment – filing cabinets, shelving C9 Software C. Office and Office Set up D1 Office rent D2 Electricity D3 Office telephone D4 Mobile phone usage D5 Fax D. Ongoing Overheads for office and equipment E1 Secretarial Services E2 Accountancy fees and ASC annual return E3 Legal fees E4 Incorporating E5 Staff Training E6 Professional Memberships E7 Internet charges E8 Office cleaning E9 Graphic Design E. Professional Services and Fees $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Year 1 - Year 2 $ $ Year 3 $ Year 4 $ Year 5 - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - Page 6 of 7 www.consultantsconsultant.com.au The Consultants' Consultant Essential Templates F1 Business Cards F2 Letterhead F3 Other stationery F4 Stamps and postage F5 Car F6 Parking and Tolls F7 Courier F8 Taxis F9 Interstate marketing trips F10 Books, magazines and periodicals F11 Photocopying F. Other operating costs $ $ $ $ $ $ $ $ $ $ $ $ Year 1 - Year 2 Year 3 Year 4 Year 5 $ - $ - $ - $ - Page 7 of 7 www.consultantsconsultant.com.au