ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Formulae to work out break even point? (https://www.excelbanter.com/excel-worksheet-functions/109517-formulae-work-out-break-even-point.html)

Imran

Formulae to work out break even point?
 
Is there any formulae to work out break even point

Toppers

Formulae to work out break even point?
 
..... more information please. Describe the problem.

"Imran" wrote:

Is there any formulae to work out break even point


Imran

Formulae to work out break even point?
 
We have years 1, 2 and 3 where the revenues are 100, 350 and 700 with costs
of 200, 400 and 600 respectively. Therefore, the profits are started to flow
from year 3.

I need to find out the formula which could calculate the fraction of the
year in which the costs will equal to reveues.

"Toppers" wrote:

.... more information please. Describe the problem.

"Imran" wrote:

Is there any formulae to work out break even point


Toppers

Formulae to work out break even point?
 
Your overall costs (1200) exceed your overall revenue(1150) so you are still
in a loss situation.

If you plot this data and add predicted data for year 4 you will see when
real profit occurs. For example, if costs for year 4 are 800 and revenue is
1200., overall profit is reached about February of Year 4.

Adding the trendlines/equations for both cost & revenue will help.

"Imran" wrote:

We have years 1, 2 and 3 where the revenues are 100, 350 and 700 with costs
of 200, 400 and 600 respectively. Therefore, the profits are started to flow
from year 3.

I need to find out the formula which could calculate the fraction of the
year in which the costs will equal to reveues.

"Toppers" wrote:

.... more information please. Describe the problem.

"Imran" wrote:

Is there any formulae to work out break even point



All times are GMT +1. The time now is 08:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com