Rate vs. IRR

P

Phin Lars

Hi,

I'm building an LBO model and I don't understand the difference
between using an IRR function (over a stream of cash flows) and the
rate function (equity returns, using ending equity and beginning
purchase price). Any help would be appreciated.

Thanks.
 
J

JoeU2004

Phin Lars said:
I don't understand the difference between using an
IRR function (over a stream of cash flows) and the
rate function

Generally, use RATE when all cash flows are the same and they occur at
regular time intervals. Use IRR when cash flow amounts vary, but they occur
at regular intervals. Use XIRR when cash flow amounts vary and they occur
at irregular intervals.

Caveat: The Excel XIRR function always returns an annualized compounded
rate, whereas the RATE and IRR functions return periodic rates. It is
debatable how to annualize rates: compound periodically, or simply multiply
by the number of periods per year. To some degree, it depends on the
application and applicable regulations; for example, the US Truth in Lending
regulation requires simple multiplication.


----- original message -----
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top