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: 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: How will this model work for a startup company with projected revenues of $9m in year 1, $25M in year 2, $35M in year 3 and $48M in year 4.

A: It is designed to build a forecast (revenue and costs) based on relative indicators. As it appears you already have a revenue forecast you can use it in 2 ways. Forget your other forecast and build a forecast using the relative indicators (to verify or support..or not..you other forecast?) or if you are very confident with your other forecast and understand its basis adjust the appropriate relative indicators (considering their relationship to surplus and your knowledge of the basis of your other forecast) so that the Valuation Model forecast revenues are in line with your original forecast. This can then be used as the basis of a valuation. Hope this makes sense.

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

Q: I cannot determine whether to buy the Budget Tool or the Forecast Budget Builder. How do you suggest I work out which one would suit? Does the Budget Tool perform any forecasting? I already use an Excel workbook for my budget. I do need forecasting capability, and there seems to be more charts in the Forecast Builder that would be very useful. Would I be wrong in saying that the FBBE is more advanced than the BTBE?

A: They are really providing different benefits. The Forecast and Budget Builder is a high level tool that provides a forecast and a very high level budgeting capacity (not itemized lines). The Budgeting Tool allows you to add any line items you like but does not really provide a high level forecast. Many clients use both together, the Forecast and Budget Builder to generate a forecast and get a high level feel of revenue and costs. They then use this as a frame work from which they develop a more detailed budget using the Budget Tool (if you already have a budget spreadsheet this could possibly be used for the detailed budget).

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

Q: I find this software to be quite user friendly. However, there isno explanation on the ways and method used in arriving at thevaluation. Can you email me any notes?

A: Thanks for the feedback. The only notes are those in the Help fileand included within the software. From these you ca see therelationship between different variables and results ie for theRelative Indicator Level of Competition we see that this "...indicatorhas an inverse relationship to forecast Business Revenue. All thingsbeing equal as the level of competition increases Business Revenuedecreases.". This is the relationship applied.

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

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