valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1
Browse All Question and Answer Items
Items selected where Question includes valuation or Answer includes valuation
<< < Page 1 2 3 4 5 6 7 8 9 10 > >>
Questions & Answers
Q: I am looking for an investment analysis tool that I can use for justifying an investment in a new business outside the US. I have a simplistic dcf / payback analysis that is typically used for capital expenditure justification. I am looking at your "Business Valuation Model" but this doesn't seem to take into account initial and recurring capital expenditures required. Do you have a different model or models you can suggest?
A: The valuation model provides both an interest expense which reflects the cost of capital and a Depreciation Allowance which is a capital allownace based on the value of Business Assets and Asset life. So if you have operational capital requirements you can determine the cost of capital ie the interest rate appliacable if the capital was fully financed and apply this as a fixed Interest expense. If the capital relates to depreciaing assests then then it should be reflected as Depreciation (related to Assets and Asset life inputs). If you prefer you can also simply add a recurring capital requirement as an Other expense item. If the required capital varys with sales then enter it as a Varible Other item, if the required capital tends to be a fix overhead amount included it as a Fixed Other item. FYI we have just released a browser based valuation model that applies discounted cash flow to determine NPV it is based on the same methodology as the Business Valuation Model and Business Analysis Modules. It can be assessed from https://bizpep.com/businessanalysis.html re ..
Question and Answer Item 2058157 - Browse All Question and Answer Items
Q: Can the wages section of the spreadsheet be set up to allow different classification of staff to have different penalty rates set up for same day I.e Waiter weekend penalties different to Cleaner penalties on the same day?
A: Yes. You can set up a a Waiter Classification and a Cleaner Classification and set the rates according to the classification. As previously mentioned you can download and give Wage Calculator Excel a test run in evaluation mode to see if it suits your needs https://bizpep.com/WageCalculator.html#download .
Question and Answer Item 2058144 - Browse All Question and Answer Items
Q: Is it possible to set it up to use with different penalty rates for different classifications? i.e i have 3 different types of awards each with different penalty rates?
A: Yes, on the Wages sheet you add Classifications each classification can have up to six variations to the by setting additional Wage Periods and Loadings for the Classification. This allows you to set different awards as classifications and then add variations to the base award to cover penalty rates or you can make set specific penalty rates as an independent classification. See the Help file for more detail https://bizpep.com/Helpwce.html , you can also download and give Wage Calculator Excel a test run in evaluation mode to see if it suits your needs https://bizpep.com/WageCalculator.html#download .
Question and Answer Item 2058139 - Browse All Question and Answer Items
Q: Do you offer students copy of all your excel spreadsheets? I would love to be able to play with them for my various classes. I was looking for some Excel tools and wanted to work with yours if you offer students a free version.
A: Our software is available free in evaluation mode. Simply download from the Software and Models folder at http:// bizpep.com . We do not provide free full versions (otherwise we would not be able to fund software development).
Question and Answer Item 2058133 - Browse All Question and Answer Items
Q: Was trying to buy online. Price in excel file was 30us and price at site was 69. Which is it?
A: This is a very old software version and price (no longer available). The current software can be downloaded and registered from https://bizpep.com/businessvaluation.html . The PayPal payment of $69 gives you a current version license and is the correct price. If possible can you let me know where you found the old version (site/url) so I can attempt to have it updated.
Question and Answer Item 2058119 - Browse All Question and Answer Items