Questions & Answers

Q: Is there a way I can have more input tabs? I would like to have it so I can have a roster for team leaders, managers and so on. We will only need 1 of these to work the shift however we will need 5 other members during the shift.

A: The input template is not required with the newer version as all staff / shifts can be added directly to the roster matrix on the input sheet. To have a roster for team leaders simply save your roster file with a new name ie ShiftLeaders and you will have a template you can set up with team leaders instead of staff ie you will have 2 files one setup for staff and one setup for leaders.

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

Q: Is there any way to change the layout of the format print?

A: You cannot change the generated Format Print structure however the Format Print sheet is not protected and all formatting can be adjusted as required. You can also copy and save the Format Print sheet in a new Excel workbook or link parts of it to a new workbook. This allows you to freely adjust it to suit your needs.

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

Q: Firstly love the product... Think this will be what we will be using in our company, however I was hoping you might be able to help me with a few things. We have staff who cannot work some days. Is there anyway I can exclude days for staff members?

A: Thanks. To force a staff member to must not work input a "N" in the staff shift cell, to work a specific shift input a "Y" in the staff/shift cell. So you can just input a N for the days/shifts they cannot work on the Input sheet. Also the software version you are using has been superseded you can access and downland the current software version from https://bizpep.com/shiftscheduler.html the Help file for this version is at https://bizpep.com/shiftscheduler.html .

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

Q: Is there a discounted cash flow model available to analyze a potential acquisition?

A: For a time frame of 3 years Net Present Value provides little additional benefit and results in negligible change, as the time frame increases it becomes increasingly relevant. However applying Net Present Value increases the complexity of calculations and tends to make them less intuitive. Therefore base valuations are calculated using the average forecast returns without discounting future cash flows. FYI we have released a browser based valuation model that applies discounted cash flow to determine NPV over extended time frames it is based on the same methodology as the Business Valuation Model and can be assessed from https://bizpep.com/businessanalysis.html . Additional detail on Discounted Cash Flow and Net Present Value can be found at https://bizpep.com/businessanalysis.html .

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

Q: I would like to know the formula for the Other Investment in Business. My Owner Cash Flow is $3.3mil and the other investment in business value is at $9.9mil. Where is the operating capital and goodwill coming from? Thanks!

A: The Total Investment in the business and calculated Expected Valuation is the sum of Replacement Value of Business Assets, Market Value of Property, and Other Investment in Business. Or conversely the Other Investment in Business = Expected Valuation (as calculated based on return and required return on investment %) less Replacement Value of Assets less Value of Property. Basically this is saying that at the Expected Valuation there is an amount paid that is not covered by hard assets ie goodwill and other capital investment and this is the other investment in business. This value is automatically adjusted in line with the valuation. This is outlined in the mouseover comments for the the Other Investment cell. Hope this helps.

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

<< < Page 41 42 43 44 45 46 47 48 49 50 > >>