Fill Table 2 according to the given Information in Table 1:

Table 1:

Projected Growth Per Month	%
Wedding Invitations	5.85%
Birthday Party Invitations	8.34%
Business Party Invitations	5.47%
Advertising	6.36%
Legal Fees	3.49%
Shipping	5.88%
December Increase Goal	18.57%

Table 2:

REVENUE	August	September	October	November	December
Wedding Invitations	4507
Birthday Party Invitations	3841
Business Party Invitations	2652
Total Sales Revenue	11000
EXPENSES
Printing Costs	4,400
Salaries	3,500
Administration	550
Advertising	1,544
Legal Fees	788
Shipping	928
Total Expenses	11,710
Net Income before Taxes	-710
Taxes	0
Net Profit (loss)	-710

Please give the whole table of empty boxes filled out. Also, please give EXCEL functions that can be used to calculate this projected growth per month. August is the base year.

1. Sales revenue from wedding invitations, birthday party invitations and business party invitations will grow at A%, B% and C% per month, respectively.
2. Printing costs are calculated as 40% of Sales Revenue for the month, and Administration expenses are calculated as 5% of the Sales Revenue for the month.
3. Salaries are fixed for the period. Please create an assumption table.
4. The other expense items will grow at the following rates (per month): Advertising will grow at D% per month, Legal Fees will grow at E% per month, and Shipping will grow at F% per month.
5. The tax rate is 28% on profits for the month. Assume that taxes are calculated and paid each month. Note that when the company loses money, it does not pay taxes.
6. Conditional Formatting. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is greater than 0, then the font for that cell should be green. If any of the numbers for Net Income before Taxes, Taxes and Net Profit (loss) is less than 0, then the font for that cell should be red; otherwise, the font for that cell should be orange.

Note: The letter percentages are associated with the first table.