Questions & Answers

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

Q: I am using your free 7 days Business Valuation Model. and I can't change the forecast year to 5 years. How do I do that?

A: The Business Valuation Model Excel forecast years are set at 3 and cannot be changed. We do have a web based Business Valuation Analysis Module at https://bizpep.com/ that allows upto a 10 year Forecast. You can access it from https://bizpep.com/ and set the number of Forecast years to suit.

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

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