IRR

Coaching 852 views 5 replies

juzar

diversified

181 Points Joined January 2009

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

94 Points Joined August 2009

IRR is 6.63%. The excel sheet is attached

Devendra

Chartered Accountant

4780 Points Joined March 2009

PLEASE FIND ATTACHED HEREWITH THE .XLS FILE.

REGARDS,

DEVENDRA KULKARNI

juzar

diversified

181 Points Joined January 2009

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

181 Points Joined January 2009

Dear Friend Devendra

please file excel file

Poornima Y

94 Points Joined August 2009

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%.