I want to know how to do IRR. So if my capital flows are the following:
Jan 1 Year 1 -15,208,000 (principal investment)
Dec 31, Year 1 - -30,531 loss
Dec 31 Year 2 11,335,135 profit
Dec 31 Year 3, 20,696,722 Profit
The question I have is in excel should the the first square only -15,208,000 or should I add -30,531 or should they be separated because the -15,208,000 is the principal investment and -30,531 is the initial loss in year 1.
Solved by Z. H. in 17 mins