Irr

L

lazzarox

New Member
Joined
Jul 15, 2008
Messages
33
Hi
I have the following case:
At T0 I invest 200,000 usd
At T1 I receive 71,262
At T2 I receive 220,259
At T3 I receive 220,259
At T4 I receive 316,055
At T5 I receive 316,055

What is my IRR? How you type in the formula?

Many Thanks!!
 

Excel Facts

How can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
I would suggest using matrices.. instead of excel.
mostly because I have no idea how to do it on excel.
Anybody on this forum who could help?
 
Upvote 0
This is not my expertise, but I looked up the function in the help file and Google.

Is this what you want?

Excel Workbook
AB
1-20000077%
271262
3220259
4316055
5316055
Sheet1
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Question Question
SumIf Returning Wrong Values
Replies
6
Views
208
Joe4
Joe4
E
  • Question Question
Can I eliminate this "File Now Available" -- Read-Write error message?
Replies
9
Views
277
Alex Blakenburg
A
U
  • Question Question
Imported CSV time-usage format conversion to TIME query - help!
Replies
3
Views
67
Fluff
Fluff
R
  • Solved
Working Hours Taken to Complete a Task
Replies
6
Views
263
AhoyNC
A
K
  • Solved
Using a dropdown to format cells, but retain entered values
Replies
5
Views
118
Kingsof82
K

Forum statistics

Threads
1,224,518
Messages
6,179,258
Members
452,901
Latest member
LisaGo

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top