rolling calculating formula?

  • Thread starter Thread starter Thrava
  • Start date Start date
T

Thrava

Hello Group,

Need help with a way to perform this breakeven calculation.

say we have

2004 2005 2006 2007 2008
Revenue $20,000 $66,000 $74,000 $45,000 $88,000
Expense $80,000 $95,000 $25,000 $1,000

I need to calculate at what year we'll have a breakeven..
i.e the sum of revenues is equal to sum of expenses and
the answer be given in number of years.

How can I do this?
 
Don't need a calculation for this one. If your expense's
are less than $84,000 for 2008 then your break even point
is 2008.

I am not an accountant but what I think you need to do is
annualize your Revenue and Expense over a period of time
(say 12 years). That's a Revenue of $33,833.33 a year and
an expense of $16,750.00 a year. Still the break even
point is 2008.

Charlie O'Neill
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Formula Help Needed 1
Average Calculations 11
calculation within datatable question 6
calculate net income i.e. revenues (-) expenses in a pivot table 1
named ranges 4
Rolling Calculations 2
Total Not Summing Correctly on Calculated Fields in Pivot Table 0
Rolling YTD/YTD Dynamic Function 2

Back
Top