Break-even Analysis
Calculate the revenue required from either the sale of goods or services to break even. Features include –
- Enter gross profit ratio and fixed costs to an expandable table to calculate sales or fees required to break even;
- Enter the average sale amount to calculate the number of sales required to break even;
- Enter the average hourly charge-out rate to calculate the number of hours to charge to break even;
- Enter desired profit to calculate revenue and the number of sales or billed hours to achieve that profit; and
- Enter notes about your calculations.
Calculations/Budgets & Projections/Break-even Analysis
Vary Quarterly PAYG Instalment for an Individual
Estimate the quarterly PAYG instalment amount or rate for a variation for an individual. Prepare up to 4 variations for a client and retain a full record of their PAYG instalment variations in the one file. Features include –
- Estimate gross income and deductions related thereto for each category of income.
- Account for reconciliation items on the return to convert profit to taxable income.
- Enter details of student debts (HELP, TSL, SFSS) for automatic calculation of repayments.
- Estimate income tax, medicare levy and medicare levy surcharge on taxable income and account for tax offsets and other credits.
- Automatic calculation of PAYG withholding on wages entered.
- Separate “Projections” worksheet to allow estimates of income and expenses for any category of income.
Calculations/2018/PAYGI – Vary Individual Quarterly
Apportion by Date
This handy calculator will allow you to enter a date range and compare excluded periods within that range with the full period, giving total days, excluded days and percentage thereof and enter an amount for apportionment. Examples of how this workbook could be used include –
- Calculate days that a rental property was used for private purposes to apportion expenses;
- Calculate days that a company vehicle was available for private use by an employee for FBT purposes;
- Calculate days a main residence was used for income producing purposes for CGT calculations; and
- Calculate days travelling on business to apportion expenses between business and private.
Calculations/Financial Calculations/Apportion by Date
Fringe Benefits Tax 2018
Fringe benefits tax calculations, letters and forms for 2018 are now available on our site.
Retirement Planner
Use this workbook to help your clients plan for their retirement by projecting growth in their investments and superannuation balances to determine whether the accumulated funds will provide them with a comfortable retirement. See more information at the workbook page and Calculations/About Each Workbook.
Calculations/Budgets & Projections/Retirement Planner
ATO Small Business Benchmarks
The 2017 version of this calculation (now shown under Calculations/2017) has been updated to include the latest benchmarks released by the ATO on 21 February 2018 from 2016 returns.
Calculations/2017/Benchmarks (or Small Business Benchmarks)
Profit Manager
Analyse your client’s Trading/Profit & Loss Statement and explore the various options for improving their bottom line. Enter changes (up or down) to the following performance indicators for clients with either trading or services income (or both) and view the effect on their profit –
- Average sale or fee amount
- Repeat business
- Turnover or productivity
- Sales prices or charge-out rates
- Cost of sales
- Direct costs
- Operating expenses
It will only take a few minutes to enter the summarised data from your client’s most recent financial report and you can then consider the various options in a meeting with your client.
Calculations/Budgets & Projections/Profit Manager
Fee Schedule
Use our new schedule of fees template (in Microsoft Word) to set up a schedule for your practice. Providing new or existing clients with this information is a good way to manage their expectations in relation to the fees you charge for your services.
Forms/Fee Schedule
Tax Planning
Two separate tax planning workbooks (for companies and non-companies) for 2018 are now available to project annual profit, estimate taxable income & tax payable and devise ways to defer or save tax.
PAYG Withholding – Pay Estimate – Fortnightly Wages
Calculate fortnightly gross wages and PAYGW based on variable net wages of business owners.