A	B	C	D
1	PROFIT AND LOSS STATEMENT FOR ABC GROUP OF COMPANIES
2	Sales			100000
3	Cost Of Purchase	35% OF SALES		XXX
4	Gross Profit (GP)			XXX
5	Expenses
6	Advertisement	18% OF GP	XXX
7	Salaries		22000
8	Electricity		2000
9	Telephone		5780
10	Misc		2100
11	Total Expenses		XXX
12	Profit			XXX
13	Income Tax On Profit	35% OF PROFIT		XXX
14	Net Profit			XXX

Question

v Calculate Costs of Purchases as 35% of Sales.

v Calculate Gross profit as Gross Profit=Sales - Cost of Purchase.

v Calculate Advertisement as 18% of Gross profit.

v Calculate Total Expenses as Advertisement + Salaries + Elec. + Telephone + Misc.

v Calculate Profit as Profit = Gross Profit - Total Expenses.

v Calculate Income Tax as 35 % of Profit.

v Calculate Net Profit as Net Profit = Profit - Income Tax.

Solution

1)   Cost of Purchase: -           =D3*35%

2)   Gross Profit: -                    =D3-D4

3)   Advertisement: -              =D5*18%

4)   Total Expenses: -              =C6+C7+C8+C9+C10

5)   Profit: -                                 =D4-D11

6)   Income Tax on Profit: - =D12*35%

7)   Net Profit: -                         =D12-D13