valuationbreak evenprofitcontributionforecastshiftqueuingbusiness analysis
accountbasbudgetBAS-I.Cshare valueshort salesinvestment
site mapform1

Browse All Question and Answer Items

Items selected where Item is 2058206

Questions & Answers

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.

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