Error while calculating irr in excel
This query is : Resolved
Chaitanyaa
(Querist)
15 October 2017
While calculating IRR in excel, an error is coming "num Error". Please guide how to rectify the error
Regards
Umesh
Regards
Umesh
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
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.
21 July 2024
The cash flows described are divided into three years: Year 0 (initial year), Year 1 to Year 9, and Year 12 (final year). To calculate the net cash flows for each year, sum up the inflows and outflows. The net present value (NPV) of these cash flows can be calculated by discounting them to their present values using a discount rate, such as a required rate of return or cost of capital.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GST on reimbursement of expenses
- Query on effect of registration of property
- Due date for filing return for the partner in partnership subjected to Tax Audit
- Visiting card purchase
- Number of years as per AS amortisation of Goodwill
- Wrong CMPo8 file
- Equity Share Sale and Purchase
- Whether output tax is taken credit by purchaser
- Additional trade name
- Goodwill transfer of deceased father’s firm – ICAI applying a 27.04.2026 cut-off to the 3 year limit
- Foriegn assets disclosure
- Classification of income of P Ltd company as business or profession
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
