Question about Microsoft Excel for PC

# Quaterly IRR I am trying to calculate IRR on a big excel interactive database over a 20 year period. I plugged in the customized excel formula. the income and expense calculations are done on a quarterly basis. The IRR seems to be coming out very low. Do i multiply by 4 to cover for the fact that i am using quaterly data or there is another way?

Posted by on

• Level 1:

An expert who has achieved level 1.

Hot-Shot:

An expert who has answered 20 questions.

Corporal:

An expert that hasĀ over 10 points.

Mayor:

An expert whose answer gotĀ voted for 2 times.

• Contributor

If your analysis is based annually, yes. if it is based quarterly, then you have to raise the derived irr to the 4th power (4 consecutive quarters) to arrive at the annualized irr.

Posted on Nov 17, 2008

Hi,
a 6ya Technician can help you resolve that issue over the phone in a minute or two.
Best thing about this new service is that you are never placed on hold and get to talk to real repair professionals here in the US.
Goodluck!

Posted on Jan 02, 2017

×

my-video-file.mp4

×

## Related Questions:

### I invest 2000k in year 1, 2500k in year 2, 1500k in year 3 and 2000k in year 4. I received 10500k in return. What is my IRR and how do you calculate this?

https://www.mathsisfun.com/money/internal-rate-return.html
you have to guess what it is and I guess it to be 34.696 percent
From finance theory this is the finance formula
fv=pv(1+int)^n+pv2(1+int)^n2+pv3(1+int)^n3+pv4(1+int)^n4
10500=2000*(1.34696)^4+2500*(1.34696)^3+1500*(1.34696)^2+2000*(1.34696)^1
but I just used a spreadsheet and calculated the interest earned each year

So in cell c2 formula is =b2+(b2*\$b\$9/100) d2 you copy cell c2 to it and the interest rate will not alter its cell position
f6 formula is =sum(f1:f5)
then when you finish you just keep altering irr value to get 10500.

The reason for irr is to compare putting your money say in a bank account or in the government bonds market and comparing it to the IRR for your investment in question to see if it is worthwhile .
A true outlook would be to also factor in inflation over this time frame however the other investments are also affected by deflation so you are comparing like returns

Apr 11, 2017 | In Office Equipment & Supplies

### What is formula to find percentage of females in my workplace?

To get around this, you can calculate your numbers as percentages first. For example, if you type the formula =10/100 in cell A2, Excel will display the result as 0.1. If you then format that decimal as a percentage, the number will be displayed as 10%, as you 'd expect.Aug 2, 2011

### How to do percentages in Excel - Office Blogs

https://blogs.office.com/2011/08/02/how-to-do-percentages-in-excel/
Feedback

### How to Calculate Percentages in Excel

www.excelfunctions.net > Excel-Formulas
Two Percentage Calculation Types. Calculate a Percentage as a Proportion.Calculate Percentage Change. Displaying Percentages in Excel Cells ...

### Excel formula: Get percentage of total ' Exceljet

https://exceljet.net/formula/get-percentage-of-total
Excel simply divides the values in column C by the total in C11. For the formula shown, the result is the decimal number .63. Because the Percentage number format is applied to cell E6, Excel displays .63 as 63%.

Jan 19, 2016 | Computers & Internet

### Casio fx-991ES, how to calculate NPV and IRR

At a blank screen, enter your IRR formula in terms of the variables using ALPHA and ')' for variable X. For example: -1000 200/((1 X)^1) 200/((1 X)^2) ... rest of subsequent years. Then, press CALC. It will prompt you to enter values of your variable (X in this example). Don't worry if there's already a value displayed - this is just the most recent value that has been stored as that letter. Simply enter your value (in terms of your IRR guess) and then press [=]. You will have to repeat this for each IRR guess until you reach almost ZERO.

Feb 11, 2011 | Office Equipment & Supplies

### Excel 2007

The IRR function is provided by Excel so you can calculate an internal rate of return for a series of values. The IRR is the interest rate accrued on an investment consisting of payments and income that occur at the same regular periods. In the values provided to the function, you enter payments you make as negative values and income you receive as positive values.
For instance, let's say you are investing in your daughter's business, and she will make payments back to you annually over the course of four years. You are planning to invest \$50,000, and you expect to receive \$10,000 in the first year, \$17,500 in the second year, \$25,000 in the third, and \$30,000 in the fourth.
Since the \$50,000 is money you are paying out, it is entered in Excel as a negative value. The other values are entered as positive values. For instance, you could enter –50000 in cell D4, 10000 in cell D5, 17500 in cell D6, 25000 in cell D7, and 30000 in cell D8. To calculate the internal rate of return, you would use the following formula:
=IRR(D4:D8)
The function returns an IRR of 19.49%.
The ranges you use with the IRR function must include at least one payment and one receipt. If you get a #NUM error, and you have included payments and receipts in the range, then Excel needs more information to calculate the IRR. Specifically, you need to provide a "starting guess" for Excel to work with. For example:
=IRR(D4:D8, -5%)
This usage means that the IRR function starts calculating at –5%, and then recursively attempts to resolve the IRR based on the values in the range.

Jun 09, 2010 | Microsoft Office Professional 2007 Full...

### Formula for excel to calculate years of giving.

In AJ3 thru BT3 put a number. Doesn't matter what number. Then type the following formula into a cell and instead of pressing enter press and hold control, then press and hold shift, and then press enter, and then release all the keys.

=COUNT(IF(NOT(ISBLANK(AJ2:BT2)),AJ3:BT3)

Jun 03, 2009 | Haier Chest Freezer HNCM070E

### How can I calculate IRR in MS Excel

=IRR(H29:O30,H35)

Where H29:O30 is your range of cells and estimate is H35.

Apr 09, 2009 | On Hand Software Complete Finance (pda109)

### Computing IRR calculator goes blank and outs Error 7

I belive this will fix the problem i was sitting here having the same deal waiting and waiting..then bam error 7 then i fixed it so thought i would put what i did.

go into your CF and delete all the unused CO times..for instance if your using 3 periods...delete all CF05 and F05 the last one should be C04=0 and F04=0 make sure your NPV is the same after messing around..then try to compute IRR popped up in 2 seconds for me.

word hope this helps u all ***420*** :0

Nov 21, 2008 | Texas Instruments BA-II Plus Calculator

### EXCEL DATE RANGE FORMULA

Assuming birthdate is in cell B2:

=IF(B2<DATE(1997,5,1),"Too Young",IF(B2>DATE(1998,4,30),"Too Old","OK"))

Oct 26, 2007 | Oracle Database Enterprise Named User Plus

#### Related Topics:

159 people viewed this question

Level 3 Expert

Level 3 Expert