ExcelAssignment1Template1.xlsx

Sheet1

Projected Profits Worksheet
Projected Increase Assumptions Table
-
Gross Sales
Rental Income
Wages
Contract Labor
Cost of Goods Sold
Advertising
2021
Income:
Gross Sales 200,000.00
Sales Incentives 5,000.00
Rental Income 50,000.00
Total income
Expenses:
Wages 65,000.00
Contract Labor 20,000.00
Cost of Goods Sold 8,900.00
Supplies 21,000.00
Advertising 2,750.00
Total expenses
Net profit

Sheet2

Sheet3