Questions & Answers

Q: I am trying to forecast for a new business for years 1-3, I have inputted total values on the input page for the forecasted figures for the first year but that does not give me the correct monthly figures on the budget by month master. How do I input my opening monthly figures so they appear on the budget by month master?

A: The base figures input on the input sheet are for the current year, on the Budget by Month Master these are displayed in the Current Year column (column C). If you want these figures to apply to Year 1 set the Relative Indicators on the input sheet for Year 1 to 100% (Level of Competition to Fixed Cost Efficiency) this means that there is no change from the current to year 1 values. The Percentage Contributor on the Budget by Month Master determines the spread of the Year values across months by adjusting these you will adjust the percentage annual revenue allocated to each month. Following years are forecast based on the Relative Indicator used for each year. Hope this helps. FYI the Budget Tool Business https://bizpep.com/BudgetTool.html is an alternative budgeting tool that does not apply Relative Indicators to generate forecasts.

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

Q: Can i expand the forecast to 5 or 10 years?

A: Not with the Excel version but you can with the web based version at https://bizpep.com/

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

Q: We are looking for a Financial budgeting & forecasting tool which is in Excel format and could be imported into Quickbooks. So, we could input the information/data into Excel and import into Quickbooks or export information from QB into Excel. Will the Budget Compiler Quickbooks Excel allow us to do this?

A: Yes, you can download and give it a test run from https://bizpep.com/budgetbusiness.html

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

Q: What is the definition of Mark-up Equivalent in your Expected Results? How did you arrive at 61.3% in the current year?

A: Mark Up is the percentage variable costs are increased (marked up) to determine the selling price (or revenue). In the Forecast example Revenue is 500,000 Variable costs are 310,000 310,000 * 1.613 = 500,000 ie Revenue is based on variable costs increased by 61.3%. Formula are outlined at https://bizpep.com/businessanalysis.html This is the web based Forecast and Valuation model which applies the same basic methodology as the Excel version.

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

Q: I recently downloaded the forecasting software and don't know where to go next. All I see is a sheet with tabs at the bottom. How can I input my data, etc.?

A: It sounds like you need to enable Macros. Whhen macros are enabled you will be presented with an Input sheet for data input. If you are not presented with an option to enable macros when you open the Excel software you may need to adjust your macro security levels. To adjust macro security levels from Excel go Tools, Macro, Security, Security Level. It is recommended that you select Security Level as Medium. When you open software with macros and Security Level is set as Medium you are presented with a message advising that the software contains macros with a prompt to Disable or Enable Macros. Once you have made your adjustment close Excel and reopen, then when prompted click Enable Macros. Additional detail on macros is available at https://bizpep.com/qac.php?topic=Bizpep%20FAQ&page=3 . If you are using Excel 2007 please refer to https://bizpep.com/qac.php?item=11008 .

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

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