IRR

IRR is 6.63%. The excel sheet is attached

PLEASE FIND ATTACHED HEREWITH THE .XLS FILE.

REGARDS,

DEVENDRA KULKARNI

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

Dear Friend Devendra

please file excel file

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