In: Finance
An equipment hire shop will cost $1,200,000 to open. Assuming annual sales of $1 million, variable costs of 35%, fixed costs of $300,000, depreciation of $100,000, and a tax rate of 28%, calculate the NPV of the project over a 10-year horizon with a 12% cost of capital (assume there is no inflation or salvage value). Conduct a sensitivity analysis by allowing first sales, then variable costs, and finally fixed costs to vary by ±10% from their original estimates. Show which variable appears to affect profitability the most and how this might affect your investment decision?