practical management science - excel
AADUARTEM
Sh02_35.xlsxModel
| Software project | ||||||||
| Inputs | ||||||||
| Fixed cost of new version | ||||||||
| Unit selling price | ||||||||
| Unit variable cost | ||||||||
| Current market size | ||||||||
| Growth of market | ||||||||
| For each of first 5 years | ||||||||
| For each of next 5 years | ||||||||
| English version market share | ||||||||
| Market share with new version | ||||||||
| Profit model | Without French version | With French version | ||||||
| Year | Market size | Units sold | Variable cost | Revenue | Units sold | Variable cost | Revenue | |
| Discount rate (trial value) | ||||||||
| NPV without French version | ||||||||
| NPV with French version | ||||||||
| Difference | ||||||||
