“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

I need an expert who can build an entire private equity/real estate waterfall sheet including IRR's, equity multipliers, etc.

Solved by D. W. in 21 mins

I need help matching a prepayment # with a table for IRR.

Solved by A. Q. in 19 mins

I need to calculate cash flows required for a spefiic irr.

Solved by M. L. in 30 mins

Need to solve a quaestion with IRR rate and cash flows.

Solved by F. H. in 24 mins

Internal Rate of Return (IRR) Calculator
I need a calculator to determine an Internal Rate of Return (IRR). calculates the IRR on an annual basis of an irregular stream of 15 payments.

Solved by M. E. in 25 mins

Need Business Calculation Experience; Need the Internal rate of return calculation. IRR(values,[guess]) I have an old calculation that just listed the formula as: =IRR(G15:G30) which is in an older version of excell and it worked but when I copy it over to my new spread sheet is doesn't work.

Solved by O. L. in 12 mins

Need Business Calculation Experience; Need the Internal rate of return calculation. IRR with compounding, have tried with two other experts that haven't been able to do this.

Solved by T. J. in 15 mins

help XIRR function. I have series of dates and cashflows. This does include for cashflow of zero. Can you assist to make the XIRR function work. Thanks

Solved by E. H. in 27 mins

I need to write out a formula on excel, but I can't seem to figure out how to just find a X value instead of XIRR and other options. I just need the X value which should then allow me to click on a box that signifies what X (____), and then a value after signifies. Please help.

Solved by O. J. in 16 mins