Questions & Answers

Q: Just bought the Forecast and Budget Builder. We have a seasonal business with 4 retail locations, service and construction. I have revenue and expense history prepared by our accountant, broken down by cost centers. This is what I plan to achieve. Input 1 year of historical data - revenue and expenses (fixed and variable) cut spending by percentage in the variable area define labor costs to budget project growth location analysis for marketing etc. On the budget by month screen - how much of the input area is formulas? I can't see any of the formulas...should I be able to? How should I start this project. On the monthly budget page? Any help would be appreciated.

A: The Forecast and Budget Builder is a high level tool. On the input sheet there are broad categories and forecast inputs. This is where you start, with a few basic inputs you can develop a high level forecast for 3 years. Once you are happy with this you can adjust the revenue percentages in the Budget by Month Master. This allows you set set seasonality/monthly variations. On the Budget by Month sheet you can then refine this calculated budget further with the capacity to vary the value of each line item. Input cells are blue, most other cells include hidden formula (you should not change these and they are hidden). Many clients use this to build a forecast high level budget (ie it only has set line items) and then use the Budget Tool Business https://bizpep.com/BudgetTool.html to establish an item by item budget.

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

Q: I'm trying to update the "Budget by Month Master" sheet and it won't allow me to change the Jan-04 month to Jan-05 month for our 2005 forecast. What am I doing wrong?

A: On the Budget by Month Master sheet the cell D6 is the input for the first month of the budget. This cell is blue and is unprotected. You should be able to select it and input your month (in date format ie 1/1/05). Following month cells are then calculated from this initial input.

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

Q: Is it possible to expand the categories for variable and fixed costs. The categories provided are extremely limiting. I can easily envision the need to have several dozen categories to make this a useful tool?

A: The Forecast and Budget builder is specifically designed as a high level tool (ie with limited categories). This decreases the complexity and increases the ease of use. We do have a Budget Tool Business Excel https://bizpep.com/BudgetTool.html which allows you to freely add as many categories as you like to build a detailed budget. Many clients use the Forecast and Budget builder to develop a high level forecast and use the insight gained to then generate a detailed budget using the Budget Tool Business.

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

Q: I recently purchased a non-commercial license to use your Business Valuation Software in order to value several of my business interests. I was greatly impressed and am considering the possibility of using the software commercially. Can you please provide detail of the differences between the two products. for example, does the header "Business Valuation Model Excel 32" disappear in the commercial reports? Is it possible to upgrade to the commercial version and receive credit for what was paid recently?

A: Thank you for your feedback. You can upgrade from a Non-Commercial license to a Commercial license at https://bizpep.com/upgrade.html . This allows you to upgrade and receive a credit for existing licenses. Upon request with a Commercial license we can provide an unprotected software version allowing you to view the formula applied to enhance your knowledge of software operation (macros remain protected) and undertake minor refinements (ie headings etc). Please note that Bizpep retain full copyright and intellectual property rights at all times.

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

Q: Is your software suitable for a book of life insurance / mutual Fund business, in order to determine the selling price?

A: The design and methodology of the Business Valuation model makes it applicable to any business. Because it uses market indicators to develop a forecast and the valuation is based on the forecast it can be applied to any business. It is available free for 7 day evaluation so you can give it a test run from https://bizpep.com/businessvaluation.html .

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

<< < Page 291 292 293 294 295 296 297 298 299 300 > >>