Items selected where
Questions & Answers
Topic: Business Valuation
Q: I need to modify the valuation spreadsheet to better reflect our current situation - specifically with labelling / comments etc, but I am unable to. It says I have to unprotect the sheet but its password protected?
A: All of the blue shaded cell contents can be changed. This includes the labels on the Input sheet and all blue shaded cells elsewhere which are then carried through to all other sheets. As some of these include hyperlinks it is usually easier to tab into the cell than clicking it (as clicking takes you to the hyperlink). This allows you to refine descriptions to suit. If you want to completely modify to a specific layout / format you can create your own input workbook (ie new workbook) and build your own input interface sheet and simply link your inputs from this workbook to the corresponding input in the valuation workbook ie goto the valuation input cell and type = and then click the required cell in your own workbook input sheet. The same approach (in reverse) can be used to customise the outputs if needed.
Topic: Stock Share Price
Q: I couldn't find out how to put other exchanges onto the exchange list and so have uninstalled the program as available options are not relevant for me. Is there a way to include other markets?
A: You can modify the data validation on an Exchange cell to accept any google exchange symbol as an exchange. After adding your row select the Exchange cell in the row and then click Data, Data Validation and in the Criteria cell add the required google exchange code, and then Save. This will allow the added exchange to be selected. You can copy the modified Exchange cell to other rows to use the same criteria.
Q: Wondering if you are going to be offering STP facility with your software?
A: No plans for Single Touch Payroll (STP) sorry.
Q: I would like to learn more. What does the subscription give you? It seems that the valuation is free as it is just a spreadsheet, am I wrong? You provide valuation service, and financial analysis services? Anything else? Do business owners primarily use this? or do advisors as well?
A: Subscription fully enables the analysis software and allows use on multiple devices by the individual licensed email address holder for the 1 year duration of the license. In evaluation mode without a license some valuation inputs are locked. Business Valuation allows individuals or consultants to perform their own business valuation, it is an xlsx file developed with Microsoft Excel and will run on current versions of Microsoft Excel and most other spreadsheet applications. It does not include any macros or visual basic coding. Business Valuation is used by both individual business owners and advisers. Full help and additional detail is available at bizpep.com
Q: We have received our first import duty charges for an import. How do i add the full amount of gst we were charged along with other import fees, currently I can only see 10% of the gst charged, i need to have the full amount of gst included for our next quarter bas.
A: You can add a New Tax to set up a required gst charge. To do this click the up arrow after the Expense button, this displays the New Tax button, click New Tax and input details Name and Amount as a percentage. You can then set up a New Account using the new GST % tax. Alternatively break the fees and charges into components ie the bit that is gst related and any non gst components and enter these as individual items.