+ Reply to Thread
Results 1 to 2 of 2

Projection of sales and income below the breakeven point and two above it

  1. #1
    Registered User
    Join Date
    07-09-2009
    Location
    North Carolina USA
    MS-Off Ver
    Excel 2003
    Posts
    1

    Projection of sales and income below the breakeven point and two above it

    Hi, can someone please help doing this excel spreadsheet?
    I need to a Projection of sales and income below the breakeven point and two above it. How can I do that. I already have my assumptions and framework to do the pro forma, But i can't go any further than that - I don't know how to do the rest.

    Can someone please guide me? I have attached the file.
    Please help me! I am new with excel thanx!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    08-31-2007
    Location
    SW Ireland
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20068) 32-bit
    Posts
    523

    Re: Projection of sales and income below the breakeven point and two above it

    The attached is probably what you're looking for.

    To change the 'above or below' breakeven points (50% of breakeven or 200% of breakeven etc) just enter new values in the appropriate cells in row 28.

    FYI- I first ensured that the formulae for Net profit, sales revenue etc were entered. Then I focussed on the breakeven column. I used the 'Tools |Goal seek...' menu item to calculate breakeven sales. I set the value of profit (cell D41) to 0 by changing cell D30 in order to calculate the breakeven point. Then I simply entered formulae in cells C30, E30 and F30 to calcualte units sold relative to the breakeven unit sales.
    Attached Files Attached Files
    Excel 365 user. To unblock a downloaded macro-enabled workbook, go to your "Downloads" folder > right click on the workbook name > click 'Properties' > check the 'Unblock' checkbox. You can now open the workbook.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1