Question

Please show the formula from excel if you can. Thanks

Question 1 :

A company has the opportunity to expand its business operations by acquiring new plant and equipment. The plant and equipment will cost $80,000 and have a useful life of 6 years. At the end of the period the plant and equipment will have a salvage value of $10,000. The Tax Office allows the company to depreciate this equipment at 25% per annum using the prime cost method (straight line). The tax rate is 30%, and is paid in the year of income. An additional working capital investment of $20,000 is also required and will be recouped in the final year of the project. Additional gross operating revenues from the investment are expected to be: Year 1 = $20,000; Year 2 = $38,000; Year 3 = $44,000; Year 4 = $36,000; Year 5 = $26,000; and Year 6 = $14,000. The company requires a rate of return on their investments of 12%.

Required: What is the Net Present Value of this investment opportunity?

Question 2:

Gormley Products Pty Ltd is considering the introduction of a new product to add to its existing product line. The company expects a reasonable level of sales for the next 5 years after this period the product sales are expected to be zero. Specialised equipment will need to be purchased to produce the new product at a cost of $110,000. Additional working capital of $17,600 will need to be introduced over the life of the product. Working capital will be recovered at the end of the product's life. Salvage value of the equipment at the end of Year 5 is $11,000.

Year	1	2	3	4	5
Pre Tax Net CASH Flows	$20,000	$24,000	$37,000	$59,000	$81,000

Additional information:

The tax office allows depreciation of the prime cost at a rate of 25% (Straight Line).

The tax rate is 30%.

The company uses an after-tax cost of capital of 12.5%.

Required:

After determining the Annual Net After-Tax Cash Flows, calculate the INTERNAL RATE OF RETURN (IRR) for this project.

Answer 1