valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Item is 10769
Questions & Answers
Q: How does one do income and expenses with a different percent for each item. For example I have electric and heating fuel, one increase at 8% and the other at12%; and so forth. The same would apply to my revenue side; various special events are increased at different percentages and at different times. I purchased the spreadsheet today and it is extremely complete so figured I was missing something.
A: You can either use an average percentage eg if the if you use the same value of electric and heating fuel then the average increase will be 10%, (8+12)/2. Or you can add them each as individual line items and adjust the line Change Value %. This is the yellow cell on the line in the year column Change Values. This cell by default is set as the Increase / Decrease percentage but can be overwritten by inputting a value eg for electric fuel 8% and heating fuel 12%. The same applies for income lines.
Question and Answer Item 10769 - Browse All Question and Answer Items