irr vs. xirr

mattajanke

New Member
Joined
Dec 2, 2005
Messages
26
Can anyone tell me the difference between the two?

for the irr formula we use irr=(Value range, .25/12 )*12
for the xirr formula we just use the standard formula.

Does anyone know why we would get two different answers?

Thanks for your help!
 

Some videos you may like

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Watch MrExcel Video

Forum statistics

Threads
1,109,049
Messages
5,526,488
Members
409,703
Latest member
nbkqsj7

This Week's Hot Topics

Top