This activity will enable you to demonstrate the following skills:

Writing skills to:

oprepare explanatory notes to accompany financial information

Technology skills to:

ouse accounting software packages

Answer the activity in as much detail as possible, considering your organisational requirements.

1.You are required to complete Lead Caf Profit and Loss statement (Excel Sheet) for the year ending 30^th June 2019.

Useful information

You have been provided with the Income Statement / Profit or Loss Statement for Lead Cafe.

Some key figures have been provided to you already.

Income tax is to be calculated at a flat rate of 30%

Your Task

Is to perform some basic calculations to complete income statement/ Profit or Loss Statement and then write the formula you used to get the findings. You are required to calculate the following:

1.Gross Profit

2.After Labour Profit

3.Total of all the operating expenses

4.Profit before Tax

5.Income Tax (to be calculated at a flat rate of 30%)

6.Profit after Tax

7.Calculate the percentages for

a.Cost of Sales

b.Gross Profit

c.Total of the Less operating expenses

d.Profit before Tax

e.Profit after Tax

2.Using your technological skills, create graph comparing the cash flow for two months of business activity (cash flow provided). You can create graph on any software, as long as it permitted for use by your organisation.

Useful information

You have been provided with Monthly Cash Flow statement for Lead Cafe.

April figures have been provided to you already.

Assuming that all cash receipts are decreased by 10% and Cash Payments increased by 15%.

Your Task

calculate the cash flow for the month of May 2019

Create graph comparing the cash flow statement for these two months