Easy Office

Error while calculating irr in excel

This query is : Open 
Profile Image

Profile Image

(Querist)
15 October 2017 While calculating IRR in excel, an error is coming "num Error". Please guide how to rectify the error

Regards
Umesh
Profile Image

K Srinivas, CMA CS

Profile Image

K Srinivas, CMA CS (Expert)
15 October 2017 Pls check whether the cash outflow figure is entered in negative or in brackets. If not, this error may come
Profile Image

Chaitanyaa

Profile Image

Chaitanyaa (Querist)
15 October 2017 Sir, let me tell the case. There is a cash inlow of Rs450000 in the first year, cash outflow of Rs50000 per year for next 9year and at last cash inflow of Rs450000 in 12th year. I have assigned negative sign for outflows.




You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now

CAclubindia's WhatsApp Groups Link


Similar Resolved Queries


loading


Unanswered Queries


Easy Office

Trending Online Classes

view all classess
CCI Pro


Answer Query



Quick Links