Filetype Excel XLSX | Posted on 18 Aug 2022 | 3 years ago
Authentication
digital resources
167x Filetype XLSX File size 1.86 MB Source: www.techsoup.net.nz
Sheet 1: Content page
| Presented by Vanessa Bamford | ||||||||
| Please feel free to email your questions and feedback to | ||||||||
| vanessa@vbbusiness.com.au | ||||||||
| PARTICPANTS WORKBOOK INCLUDES: | ||||||||
| 1. Break Even Calcuation Worksheet | ||||||||
| 2. Your Business Dashboard Template | ||||||||
| 3. SMART Goal Worksheet | ||||||||
| 2. Breakeven Calculation Worksheet | ||
| Ideally to be calculated on a monthly basis | ||
| Annually | ||
| All calculations do not include GST | Not including GST | |
| Step #1: | Identify Your Gross Margin (from Gross Margin Calc) | 100% |
| Step #2: | Add Up Your Overhead Costs (per year) | |
| Examples include: | ||
| Accounting & Audit Fees | 10000 | |
| Accounting software | 960 | |
| Bank Fees | 120 | |
| Business Insurance | 3000 | |
| Computer Support & IT Costs | 15000 | |
| Council Rates | 5000 | |
| Electricity | 4000 | |
| Internet | 2000 | |
| Marketing | 10000 | |
| Phone | 3600 | |
| Rent | 30000 | |
| Staff Amenities | 6000 | |
| Superannuation - Admin Staff | 19950 | |
| Wages - Admin Staff | 210000 | |
| Water | 2000 | |
| Website hosting and updating | 3000 | |
| Program costs | 18000 | |
| Step #2: | TOTAL | 342630 |
| Step #3: | Add Up your Balance Sheet Payments (per year) | |
| Debt Repayments | 30000 | |
| Capital Items to allow For (for 12 months) | 10000 | |
| Excess or suprlus funds savings per year | 10000 | |
| #3a. | Total Balance Sheet Payments | 50000 |
| Step #3: | TOTAL BALANCE SHEET PAYMENTS | 50,000.00 |
| Step #4: | TOTAL COSTS TO COVER (Step 2 + Step 3) | 392,630.00 |
| Step #5: | Breakeven Point | |
| Total Costs to cover (Step #4) /Gross Margin (Step #1) | ||
| Step #5: | BREAKEVEN POINT - SALES NEEDED - Total Costs to cover (Step #4) /Gross Margin (Step #1) | 392,630.00 |
no reviews yet
Please Login to review.
