I have a very basic question as I'm- and I am embarrassed to ask people at work. Basically, some sample models I see show equity returns in an - i.e. using the rate function in excel, the purchase price equity and the exit . This takes into account, obviously, excess cash flow built.
This all makes sense to me - but can someone illuminate how this differs(IRR or XIRR function) of the cash flows (e.g. fcf each year which includes debt and interest payments, and selling price at the end)?
I'm sure I'm missing something very clear...I know how to do both but not quite sure why they differ.
Any help appreciated, interview soon. Thanks.