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 $100,000 $50,000 $50,000 $50,000 / 1996 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
