| Titan Off Campus Shops |
| Profit and Loss Projections |
| January 1, 2017 to December 31, 2017 |
| Today's Date: |
| | January | February | March | April | May | June | July | August | September | October | November | December | Total |
| Income |
| Sales | 28444 | 32099 | 36198 | 35001 | 45690 | 44321 | 23894 | 38645 | 29411 | 38382 | 25401 | 31895 |
| Interest | 795 | 892 | 991 | 801 | 888 | 890 | 976 | 901 | 899 | 964 | 942 | 1021 |
| Total Income |
| Expenses |
| Product |
| Administrative |
| Sales Force |
| Rent & Utilities |
| Advertising |
| Bonuses |
| Total Expenses |
| Profit/Loss |
| Assumptions |
| Product | 20% |
| Administrative | 15% |
| Sales Force | 10% |
| Rent & Utilities | 15% |
| Advertising | 10% |
| Bonus % | 1% |
| Option 1: Advertising 15% |
| Total Expenses |
| Profit/Loss |
| Option 2: Sales Force 18% |
| Total Expenses |
| Profit/Loss |
phaoun
l3_titan_profit_loss_projections.xlsx
