Browse All Question and Answer Items

Items selected where Topic includes business valuation

<<   <   Page  1  2  3  4  5  6  7  8  9  10   >   >>

Q: Can this software be used for the valuation insurance companies? what amendments would need to be made?

A: Yes, it is designed for small business but can be applied to any business as it simply applies a return on investment approach which is applicable in all cases. No amendments are required.

This Question and Answer Item relates to Business Valuation Model Excel from www.bizpeponline.com.

Q: My question is related to ROI: I'm trying to use your model to help me develop an ROI figure based on current expenses and income plus a \$200,000 investment in the business with a pessimistic retrun of 10%, expected return of %15 and optimistic return of %20. Can you tell me how to enter my data so I can obtain the ROI model?

A: I am not entirely sure what your require as if the income/expenses are set then the ROI% determines the Investment ie your \$200,000? The sensitivity analysis built in to the model allows you to consider changes in your inputs to determine how sensitive the outcome is to errors. However if what I think you are trying to achieve is correct the following may help. Input the values for your business on the input sheet. On the valuation sheet set the Required Return on Investment (blue cell) at 15% the calculated Current Expected Valuation in the yellow cell below this is the valuation at 10% ROI ie if you invested this amount in the business the return would be 15%. Change the Required Return on Investment value to 10% and 20% to see your pessimistic and optimistic values. The valuation will decrease as the % is increased ie to achieve a higher return on the same profit the investment in the business must be less. Hope that helps.

This Question and Answer Item relates to Business Valuation Model Excel from www.bizpeponline.com.

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 www.bizpeponline.com . 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.

This Question and Answer Item relates to Business Valuation Model Excel from www.bizpeponline.com.

Q: I am just now seeing that you have an online version also. Can you print out the reports when you subscribe to that one?

A: Yes, at the top of each module is a Print control. You can give it a test print if you want, you do not need to subscribe to print. Depending on your browser you can also use your standard browser Print control, for most browsers go File, Print Preview. As it is web based the formatting is not as extensive as Excel or Word.

This Question and Answer Item relates to Business Valuation Model Excel from www.bizpeponline.com.

Q: What is the definition of Mark-up Equivalent in your Expected Results? How did you arrive at 61.3% in the current year?

A: Mark Up is the percentage variable costs are increased (marked up) to determine the selling price (or revenue). In the Forecast example Revenue is 500,000 Variable costs are 310,000 310,000 * 1.613 = 500,000 ie Revenue is based on variable costs increased by 61.3%. Formula are outlined at www.businessperformanceanalysis.com This is the web based Forecast and Valuation model which applies the same basic methodology as the Excel version.

This Question and Answer Item relates to Business Valuation Model Excel from www.bizpeponline.com.

<<   <   Page  1  2  3  4  5  6  7  8  9  10   >   >>

<