W
Walker
Can you use the IRR function to calculate the break-even point? If not, what
is the break-even function?
is the break-even function?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
N
NHarkawat
IRR is the break even rate at which cash inflows equals to cash outflows as
at today.
What is the "point" that you are mentioning?
at today.
What is the "point" that you are mentioning?
T
Tushar Mehta
The breakeven point is the point when the total revenues equal the
total costs based on the typical assumption that in a project costs >
revenues in the beginning and costs < revenues in later stages.
This point can be expressed either in time units or in production
quantity or ???
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
total costs based on the typical assumption that in a project costs >
revenues in the beginning and costs < revenues in later stages.
This point can be expressed either in time units or in production
quantity or ???
--
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
W
Walker
I need to know if there is a function in excel that calculates the break-even
point.
point.
H
Harlan Grove
Walker said:I need to know if there is a function in excel that calculates the
break-even point.
Maybe
=SUMIF(CashflowRange,"<0")
If not, what do you mean by the break-even point? If you don't define what
you mean, you may not get much help.