Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default Formulae to work out break even point?

Is there any formulae to work out break even point
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 15
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4,339
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hyperlinks - Move file to local drive, all links break Shawn McGowen Excel Discussion (Misc queries) 1 March 9th 06 12:52 AM
IF it will work? jolver Excel Worksheet Functions 3 January 16th 06 02:41 AM
VBA Code Cell Mate Excel Discussion (Misc queries) 4 January 9th 06 08:52 PM
Can't delete a page break Suhail Excel Discussion (Misc queries) 4 July 7th 05 06:49 PM
decimal point override does not work Sam Brauen Excel Discussion (Misc queries) 0 January 6th 05 05:29 PM


All times are GMT +1. The time now is 11:14 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"