More coursework: 1 - A | B | C | D | E | F | G | H | I - J | K - L | M | N - O | P - S | T | U - Y

Projected profits

Met North Energy Corporation

4 Year Net Profit Projections

The current budget figures for the four year period 1996 - 1999 show a steady decrease in profits eventually resulting in a loss during the fourth year. The graph shows the decrease in net profit while gross profit remains virtually static and expenses increase. After an initial loss during the first year the figures indicate a healthy profit at the end of the period.

The figures in this graph from the spreadsheet clearly show the long term benefits gained by the additional $50,000 when it is added to the 1996 advertising budget.

Despite a loss of $10,000 in the first year the projected profit for the 4 year period is $160,500.

The results of the spreadsheet showing both budget options can be reduced to just one simple graph. This supported by market research would convince management as to which option to choose.

Met North Energy Corporation

Net Profit Projections

Year 1996 1997 1998 1999

Sales $450,000 $455,000 $455,000 $460,000

Projected Sales $450,000 $523,250 $523,250 $529,000

Cost of Goods Sold $180,000 $185,000 $180,000 $185,000

Projected Cost $180,000 $203,500 $198,000 $203,500

Gross Profit $270,000 $270,000 $275,000 $275,000

Projected Gross Profit $270,000 $319,750 $325,250 $325,500

Less Expenses:

Salaries $80,000 $90,000 $100,000 $110,000

Advertising $50,000 $50,000 $50,000 $50,000

Increase in Advertising / 1996 $100,000 $50,000 $50,000 $50,000

Interest $60,000 $60,000 $60,000 $60,000

Depreciation $40,000 $50,000 $55,000 $65,000

Total Expenses $230,000 $250,000 $265,000 $285,000

Projected Expenses $280,000 $250,000 $265,000 $285,000

Net Profit $40,000 $20,000 $10,000 -$10,000

Projected Net Profit -$10,000 $69,750 $60,250 $40,500

Increase in profit $160,500

Source: Essay UK - http://www.essay.uk.com/coursework/projected-profits.php



About this resource

This coursework was submitted to us by a student in order to help you with your studies.


Search our content:


  • Download this page
  • Print this page
  • Search again

  • Word count:

    This page has approximately words.


    Share:


    Cite:

    If you use part of this page in your own work, you need to provide a citation, as follows:

    Essay UK, Projected Profits. Available from: <https://www.essay.uk.com/coursework/projected-profits.php> [26-05-20].


    More information:

    If you are the original author of this content and no longer wish to have it published on our website then please click on the link below to request removal: