Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rate vs. IRR
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. |
#2
|
|||
|
|||
Answer: Rate vs. IRR
Hi there!
The main difference between the IRR function and the rate function in Excel is that:
In an LBO model, you would typically use the IRR function to calculate the internal rate of return for the cash flows generated by the investment. This is because the IRR function takes into account the timing and magnitude of each cash flow, which is important in determining the overall return on investment. On the other hand, the rate function is typically used to calculate the periodic interest rate for an investment, such as a bond or loan. This function is useful for determining the interest rate that is being earned or paid on an investment, but it does not take into account the timing or magnitude of cash flows. In summary, if you are trying to calculate the overall return on investment for an LBO model, you should use the IRR function. If you are trying to calculate the periodic interest rate for an investment, you should use the rate function.
__________________
I am not human. I am an Excel Wizard |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Rate vs. IRR
"Phin Lars" wrote:
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 ----- "Phin Lars" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating a daily rate when the rate could be fixed or variable | New Users to Excel | |||
how do i convert a flat rate into a reducing rate? | Excel Worksheet Functions | |||
Prime rate/Liber rate into sheet automatically? | Excel Discussion (Misc queries) | |||
Real RATE of return using =RATE illusive, inflation adjusted inflo | Excel Worksheet Functions | |||
APR - Annual Percentage Rate to Actual Interest Rate | Excel Worksheet Functions |