IRR

1016 views

Save Share

juzar

diversified

112 Points Posted on 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

Replies (5)

Poornima Y

68 Points Posted on 05 April 2011

IRR is 6.63%. The excel sheet is attached

Devendra

Chartered Accountant

3769 Points Posted on 05 April 2011

PLEASE FIND ATTACHED HEREWITH THE .XLS FILE.

REGARDS,

DEVENDRA KULKARNI

juzar

diversified

112 Points Posted on 06 April 2011

Dear Friend Devendra

I am attaching two files one is excel where i have calculated IRR and the answer is 15.45%, but i have attached PDF file of "Solved Answer Cost & F.M. CA Pcc & Ipcc May. 2010", if you see Qn 7(a), the answer is "13.35%", please help me to judge ----- > whatever the reply, please advice.

my Email : - parajf @ gmail.com, i will be available in gtalk with mentioned ID.

regards

juzar para

juzar

diversified

112 Points Posted on 06 April 2011

Dear Friend Devendra

please file excel file

Poornima Y

68 Points Posted on 07 April 2011

Oops I missed considering depreciation while calculating tax. The correct answer is 15.4 % only.

In the 'Solved Answer Cost & F.M. CA Pcc & Ipcc May. 2010,' the formula should be 14% + ..... instead of 12%+... since the numerator shows the difference between the cost of machine and 1035074 where 1035074 is the PV of 14% . so the answer arrives to nearly 15.4%.