All calculations must be done in Excel

a) Suppose Gumede Investments considering the following project, where all of the dollar figures are in thousands of Kwachas. In year 0, the project requires $275 000 investment in plant and equipment, is depreciated using the straight-line method over seven years, and there is a salvage value of $59 000 in year 7. The project is forecast to generate sales of 5,400 units in year 1, rising to 25,000 units in year 5, declining to 7,000 units in year 7, and dropping to 100 in year 8. The inflation rate is forecast to be 2.5% in year 1, rising to 4% in year 5, and then leveling off. The real cost of capital is forecast to be 9% in year 1, rising to 12.5% in year 7. The tax rate is forecast to be a constant 37.5%. Sales revenue per unit is forecast to be $153 in year 1 and then grow with inflation. Variable cost per unit is forecast to be $92 in year 1 and then grow with inflation. Cash fixed costs are forecast to be $80000 in year 1 and then grow with inflation. What is the project NPV?

b) Consider the same project as problem a), but modify it as follows. Suppose that Direct Labor, Materials, Selling Expenses, and Other Variable Costs are forecast to be $52, $37, $23, and $8, respectively, in year 1 and then grow with inflation. Lease Payment, Property Taxes, Administration, Advertising, and Other cash fixed costs are forecast to be $41000, $7300, $6800, $11200, and $7300, respectively, in year 1 and then grow with inflation. What is the Total Variable Cost / Unit and the Total Cash Fixed Costs?

c) Consider the same project as problem b), but modify it as follows. Suppose we add that the project will require working capital in the amount of $12.3 in year 0 for every unit of next year's forecasted sales and this amount will grow with inflation going forward. What is the project NPV?

d) Consider the same project as problem c). Assume that the product life-cycle of seven years is viewed as a safe bet, but that the scale of demand for the product is highly uncertain. Analyze the sensitivity of the project NPV to the units' sales scale factor and to the cost of capital.