Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Formulae to work out break even point?
Is there any formulae to work out break even point
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlinks - Move file to local drive, all links break | Excel Discussion (Misc queries) | |||
IF it will work? | Excel Worksheet Functions | |||
VBA Code | Excel Discussion (Misc queries) | |||
Can't delete a page break | Excel Discussion (Misc queries) | |||
decimal point override does not work | Excel Discussion (Misc queries) |