Strictly using Excel Solve the Problem

Sheer ICT Ltd is considering an investment of Kes 1,000,000.00 in new technology. The new equipment would have a useful life of 4 years with a scrap value of Kes 100,000.00. The company can claim capital allowances at 25% on reducing balance method. The company pays tax one year in arrears. The tax rate is 30%. The company uses a discount rate of 13% for such projects.

Additional information

1. A license fee of Kes 104,000.00 is payable at the end of year l and will increase at 3% per year in each subsequent year.

2. The new technology will reduce operating costs by Kes 6.00 per unit in current price term before taking account of inflation at 4% per year.

3. Sheer will finance the purchase of new equipment with a four (4) year loan paying

interest at 10% before tax per year.

4. Forecast production over the life of the equipment;

Year	2011	2012	2013	2014
Production (units per year)	60,000	75,000	95,000	80,000

Required

(i) Evaluate the above project in nominal terms (10 Points)

(ii)Graphically, what is the Net Present Value of the Project? (5 Points)

(ii) Using scenario manager find the net present value at the following cost of equipment, Kes 500,000. Kes 700,000. Kes 900,000. Kes 1,200,000, What assumption did you make? (5 Points)