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
Menu
IRR
Replies (5)
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%.
Recent Topic
- While e filing otp not generating
- INCOME FROM CLOSING OF NSS -1992 -EXEMPT UNDER W
- GPF AND COMMUTED PENSION RECEIVED
- How do I choose the correct trademark class? Can I
- Error in totalling salary amount in AIS
- Client consent under DPDPA: Is client sharing PAN,
- TDS MISMATCH
- Rebate on other income even if LTCG is above my 12
- Need CA to certify shareholding pattern.
- Ltcg savings
Related Topics
CAclubindia
