IRR

juzar (diversified) (176 Points)

05 April 2011  

The management of P Limited is considering to purchase Machine. The company's cost of capital is 12 percent and corporate tax rate for the company is 30 percent. Details of
the machine are as follows :

Cost of machine 10,00,000
Expected life 5 years
Annual income before tax and depreciation 3,45,000

Calculate internal rate of return

Please upload working in excel - please help