Questions & Answers

Q: We are a community non for profit organisation in Australia, are we able to change the terminology and use sub headings to suit our business information needs .eg different types of income and expenditure.

A: We you purchase a Commercial license we can upon request provide an unprotected version which you can access and change cell values. However Forecast and Budget Builder Excel is a high level forecast tool and is driven by basic inputs and formula. If you are looking for a more detailed budget you our Budget Tool Business https://bizpep.com/BudgetTool.html maybe of interest. Many clients use the Forecast and Budget Builder Excel to build a high level forecast and then the Budget Tool Business to refine this and include detailed line items.

Question and Answer Item 10521 - Browse All Question and Answer Items

Q: I am in the process of evaluating the trial version of the Business Valuation Model Excel. I am not sure how taxation is dealt with or where it is incorporated into the model. Please clarify whether the model looks at pre-tax or post-tax profits. If taxation is not considered how can changes be made to look at after tax returns.

A: The model is pre-tax. Taxation is not a consideration and is not a componet of the valuation. Taxation depends upon individual circumstances and as with any investment valuation it should be judged on its merit (ie not for tax reasons). Were applicable the impact of taxation can then be considered.

Question and Answer Item 10500 - Browse All Question and Answer Items

Q: We are a non-profit and have 5 years of budget actual history. I am looking for a product in Excel (or standalone) that will analyze that information and try and trend/forecast future budgets. Do you sell (or know of) any such product?

A: The Budget Tool Business allows you to build a budget based on variations to previous performance however it does not analyse existing data to determine what tends/variations exist. See https://bizpep.com/BudgetTool.html for details. I am not aware of any software that performs a historical analysis and builds a forecast from the analysis.

Question and Answer Item 10456 - Browse All Question and Answer Items

Q: I have seen and worked a bit on your BEP template. It is good software to calculate BEP and profits however I can only calculate for one product only. You perfectly know companies produce and sells several products or even categories. Also what is more important producers, companies are more interested now in BEP calculations for an Accounts or Channels (to develop profitable Channel Management Strategy).

A: You may want to look at our Profit Contribution Breakdown software at https://bizpep.com/profitcontribution.html . This allows you to determine the surplus generated by different components of a business ie products, channels, business units etc. You can also run individual breakeven analysis by allocating a component of fixed costs to a product line or channel and doing a breakeven analysis (with the Pricing and Breakeven Analysis software) for each.

Question and Answer Item 10410 - Browse All Question and Answer Items

Q: Hi. I am enjoying trialling your model which is very clear and extremelyhelpful. Before I purchase, I just want to be sure that I am using theappropriate model for my purpose, which is to work out break-even andpricing for our service. Our organisation is a not-for-profit charitabletrust delivering a service to disabled individuals. The service is fundedby a government ministry on an hourly rate which they set.

A: Yes, this model is suitable for any product (good or service).

Question and Answer Item 10343 - Browse All Question and Answer Items

<< < Page 1 2 3 4 5 6 7 8 9 10 > >>