In the first year, Buon Uomo ’s net sales were $500,000, operating expenses were at 42%, and the profit was 5%. Mr. Ptolemy was pleased with his venture. The second year, sales grew to $540,000, and...

In the first year,
Buon Uomo’s net sales were $500,000, operating expenses were at 42%, and the profit was 5%. Mr. Ptolemy was pleased with his venture. The second year, sales grew to $540,000, and his operating profit increased to 5.5%, with expenses totaling $226,800. He felt he was moving in the right direction.

Now, his goal is to increase sales by 7% next year (which is the third year), with expenses estimated to reach 42.5% while maintaining the 5.5% operating profit. In addition, Mr. Ptolemy predicts that there will be an opening of a new mini-mall near his trading area.  Therefore, as he does his projections for the fourth year, he recognizes that the increased competition could decrease the rate of sales growth to 6%, yet he wishes to maintain a 5.5% operating profit and decrease expenses to 42%.

ASSIGNMENT:

1. Using the facts and figures from the case above, prepare a spreadsheet in
   Microsoft Excel
   
   that shows Mr. Ptolemy’s P/L skeletons for the first two years of performance and Year 3 and Year 4 projections. In order to do that, you need to set a spreadsheet that looks like the following chart and complete all missing cells (e., the shaded cells in the chart) by entering numbers given in the above case in their corresponding cells and complete the remaining cells using formulas