| Maxi's Grocery Mart |
| Pro Forma Income Statement |
| Year # | 0 | 1 | 2 | 3 | 4 | 5 |
| | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
| Sales |
| Deli |
| Dairy |
| Canned Goods |
| Frozen Foods |
| Meats |
| Produce |
| Dry Goods |
| DVD Rentals |
| Total Sales |
| Cost of Goods Sold |
| Deli |
| Dairy |
| Canned Goods |
| Frozen Foods |
| Meats |
| Produce |
| Dry Goods |
| DVD Rentals |
| Total Cost of Goods Sold |
| Gross Profit |
| Operating Expenses |
| Sales and Marketing |
| General and Administrative |
| Depreciation |
| Wages |
| Common Costs |
| Total Operating Expenses |
| Income Before Taxes |
| Income Taxes |
| Net Income |
| Assumptions |
| | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
| Base Period Sales |
| Annual Sales Growth Rates | n/a |
| Store Items | % of Sales | CGS | | Rates |
| Deli | | | | Tax |
| Dairy |
| Canned Goods |
| Frozen Foods |
| Meats |
| Produce |
| Dry Goods |
| DVD Rentals |
| | 100.00% | | Salaries |
| Operating Expenses | | | Leroy |
| Sales and Marketing | | | Manager |
| General and Administrative | | | Asst. Manager |
| Depreciation Expense |
| Wages | | | No. of Employees |
SJBRANA
ExcelCase2StarterFileSu21.xlsx
