Advanta Bhd. is a medium-sized manufacturing company that plans to increase capacity by purchasing new machinery at an initial basic price of RM1.5 million. The shipping costs will be RM27,000 and an additional cost of RM73,000 to modify it for special use by the firm. It will depreciate to zero over the five-year useful life using the straight-line method, but it is expected to be sold for RM65,000.

The investment is expected to increase annual sales by 6,000 units. Financial data on the additional units to be sold is as follows:

 Selling price per unit    RM 500

Direct material costs per unit 80

Direct labour costs per unit 130

Variable production overhead costs per unit 120

Fixed cost per year 250,000

After the first year, the sales price and variable costs will increase at the inflation rate of 3% per annum.

Working capital is 15% of sales (year prior to the anticipated sales) and will be fully recovered at the end of the project life.

The beta factor of this investment is 1.0. The company targeted capital structure is 60% equity and 40% debt. The cost of debt after tax is 9%. The market rate of return is 14% and the risk-free is 4%. An average-risk project has a coefficient of variation of NPV between 0.8 and 1.2.

The tax rate is 26%.

1. Required:

Develop a spreadsheet model and use it to find the project’s NPV, IRR and payback period.

Conduct sensitivity analysis to determine the sensitivity of NPV to changes in the sales price, material costs per unit, labour costs per unit and the number of units sold. Set these variables’ values at 10% and 20% above and below their base-case values. Include a graph in your analysis.

Given the following information, conduct a scenario analysis. What is the coefficient f variation?

Based on the information derived, would you recommend that the project be accepted?

Solve in detail