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

Trying to figure out equation dor IRR for each of three years with each year having different interest rate. See screen shot.
Solved by Z. F. in 30 mins
We are looking for good help today. Specifically, we need help on irr calculator using our spreadsheet data and ensuring we have the proper IRR formula.
Solved by A. A. in 15 mins
I am trying to create a sensitivity table for IRR that takes years as one of my points of comparison however my resulted table does not change with different years of comparison.
Solved by C. F. in 24 mins
expert999 WS Q46 Assuming an initial investment of $2,500 on 12/31/13, what is the IRR assuming all cash flows occur at the end of each period?
Solved by O. J. in 28 mins
I need a solution in excel, I have attached my request. I need to find a solution where the cash flows compensate for the constuction period so that the IRR is not effected
Solved by G. H. in 18 mins
I want to calculate quarterly and monthly compounded irr excel.
Solved by K. D. in 16 mins
Suppose you are consultant for a farmer who owns 100 acres of usable land. She wants to plant some combination of corn and wheat on the land. She wants you to build a spreadsheet that will calculate NPV and IRR based on her estimates for costs and revenues related to this project. Create an NPV analysis template that the farmer can use to make the optimal investment decision. Use the following template. Excel HW #4 - template.xlsxPreview the document "Assumptions" Tab Insert placeholder data of your choosing into yellow input cells Create dynamic calculations for all non-input cells "Worksheet" tab Create dynamic calculations using data from assumptions tab "ROI" Tab Create dynamic cash flow calculations for each year using data from the other tabs Use excel formulas to calculate NPV and IRR based on the net cash flow data Use conditional formatting to indicate when the NPV and IRR indicate a good investment "Scenarios" Tab Answer the questions relating to each scenario using your completed spreadsheet as the calculator Seek help from classmates and/or TAs as necessary. Upload your completed file to Canvas prior to the due date
Solved by B. B. in 28 mins
I am trying to calculate IRR for a deal where the sign changes - below are the example cash flows: 7/17/2012 - (40,984) 8/15/2013 - 33,925 6/30/2014 - (6,341) 12/22/2014 - 3,047 12/31/2017 (Terminal Value) - 0 The XIRR formula is telling me the value is -24.46%, but it does not make intuitive sense to me that this number could be right given its over 4 years and 80% of the value has been recovered. Could you please advise on if the formula works in this type of scenario where signs change, or if there is something else you need to consider in this scenario?
Solved by X. H. in 11 mins
How do I calculate the NPV and IRR of future MONTHLY cash flows using an annual rate? How do I convert to monthly rate?
Solved by M. J. in 22 mins
Do the NPV and IRR function excel take into account monthly compounding if only given an annual rate?
Solved by A. F. in 21 mins