Get instant live Excel expert help with IRR,MIRR,XIRR Function

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

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

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