valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 2058140
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