irr

<tbody> </tbody> Trying to calculate an IRR on a piece of buy and hold real estate. Using the XIRR function I am coming up with a 5% IRR. Would someone be kind enough to run the formula and verify my calculation? Thanks in advance for Your help. Dates Cash Out/In 5/28/15 -44766.72...

Hi, First time poster here hoping someone can help. I have a set of scenarios (about 500) each with 10 variables that all feed a financial model on another tab - currently with a vlookup. I would like to create a macro or use another function to return the output of the model (it happens to be...

Hi all, I've been trying to calculate the overall investment performance of my investment portfolio over a given time period. The portfolio has been funded via regular monthly amounts. My ultimate aim is to be able to compare the investment performance of any given portfolio over a set period...

I am trying to automate calculation of IRR for a range of scenarios. I have a bunch of problems with this: 1. On a full cycle basis, the project start dates are not equal which means that in certain scenarios I get 0% return as the first cash flow is zero. 2. On a point forward basis...

This is my first post here so I hope I am inside the rules. I cannot find the solution to this problem anywhere. I have a spreadsheet with the price of a stock in one column and projected future earnings in another. Projected future earnings runs for 300 years (the reason is not important -- it...

Hello folks! I'm working on a lease accounting template, particularly the interest calculation for the capital lease liability, and am having trouble with circular references. There is an early access period during which interest expense increases the liability. Once payments commence, they...

I understand that if you wish to convert an annual IRR to monthly you need to employ the formula (1+IRR)^(1/12)-1. The reasoning (as I understand it) is that this formula will account for the reinvestment effect which is why you don't simply divide the annual IRR by 12. What my simple mind...

I have been preparing business plans recently using the MIRR formula in Excel 2007. The results of the MIRR function will increase initially then begin to decrease as time continues. We use the assumption of an initial investment(no other investments going forward) and while the cash flows are...

Hi - I have a series of cashflows & dates going out to 2050. I have a target IRR of 10%. Going out to 2050 with my casfhlows definitely covers the 10% and more. I am trying to find a formula, or a way to be able to solve for how far out I need to go to hit my target IRR of 10%. Any thoughts...

I am working on calculating IRR for a project we are considering. Here is the projected cash flow: <colgroup><col span="12"><col><col span="26"><col><col><col><col><col span="10"></colgroup><tbody> ($1,354,953) ($989,464) ($462,155) ($462,155) $2,474,935 ($462,155) ($657,155) ($1,104,155)...

I'm able to fairly successfully calculate a future payoff required to achieve a targeted return (say 12%), on an annual basis, with the following formula =-NPV(12%,cash flows)*(1+12%)^COUNTA(Periods) However, I'm trying to adapt this formula for cash flows that are compounded quarterly. For...

Team, I'm trying to calculate the ROI where there are many outflows & inflows. Since inflows > outflows; the investor makes $$ The return is 31% if the Cost of Capital is Zero. The ROI is that Cost of Capital which yields Zero for the Net Return. To solve this I need a column (or many...

I'm trying to create a formula that will determine when incorrectly ordered inventory should be held in stock (with the hope of selling it in the future), verses returned with a restocking fee. I believe it will be a function of the original purchase price, the restock fee, IRR, and time? Does...

Hello, So, i have the following cash flows in a financial model im creating for work. The large negative number you see is where an $8 MM loan is paid off. The -$6.35 MM is the original investment, not including the additional $8 MM reflected in column F. Is this correct? I have never had to...

Long time reader, first time poster :) I need to calculate gross xIRR for several companies in one fund. Each company has two columns (one for values and one for dates) How do I write the XIRR formula to combine multiple sets of columns? EX:Company A (Column A Values, Column B Investment...

I have an IRR function issue that I need your help! I am dealing with wildly gyrating cash flow that results some time in great losses or great profits, it looks to me that once it hits a -100% loss it errors out with a #Value error. I am aware of the general limitations with IRR that sometimes...

Hi there. I am trying to understand how/why the IRR calculation is different than I would inherently assume. Let me explain. You can also view the simple file I created here on dropbox. https://dl.dropbox.com/u/83120324/IRR%20Calc.xlsx Assume an investor required a 10% internal rate of...

Hoping you folks can help me simplify ... My application has a series of positive outlays over a number of years as well as a specified payoff amount for each year, also expressed as a positive number. (premium payments and death benefit, respectively) We can't know ahead of time which year the...

Hello all - I have a set of cash flows that occur annually over 20 years (listed below). When I use the IRR function, it returns an IRR of ~20%. However, if I push the large payment in year 9 out one year, so that it occurs in year 10, the IRR jumps all the way up to ~63%. While I understand...

Would like assistance finalizing a waterfall tab in an excel model. Model already includes tabs to define cash flow, debt payments, etc. Need help working a contract's waterfall description into excel. Have a good start, but need assistance finalizing. Let me know if you can help.. Thanks.