We can work on Excel sheet Template

123, Round House

Suite 5, Tower 6

Company City, Area 51

987 654 1234

Email: [email protected]

Profit and Loss Statement

Month
Apr-20
May-20
Jun-20
Jul-20
Aug-20
Sep-20
Oct-20
Nov-20
Dec-20
Jan-21
Feb-21
Mar-21

Income

Revenue
  67,000.00
  88,000.00
  43,000.00
  23,000.00
  85,000.00

Cost of Goods Sold
  26,500.00
  35,000.00
  14,650.00
   8,000.00
  32,000.00

investment
salvage
difference
period
yearly
monthly

Gross Profit
  40,500.00
  53,000.00
  28,350.00
  15,000.00
  53,000.00
        –
        –
        –
        –
        –
        –
        –

 £      250,000.00
 £   25,000.00
 £      225,000.00
10
 £      22,500.00
 £     1,875.00

Expenses

Salaries, Benefits & Wages
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00
   4,500.00

Salary
Main
3000
assistant
1500

Utilities
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00
     800.00

Utilities
Water
450
electricity
300

Internet
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00
      40.00

Internet
40

Generator
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00
     150.00

generator
150

Depreciation & Amortization
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00
   1,875.00

Miscellaneous
   1,500.00
   1,750.00
   1,650.00
   1,800.00
   2,000.00
   1,550.00
   1,650.00
   1,600.00
   1,900.00
   1,700.00
   1,500.00
   1,400.00

Total Expenses
   8,865.00
   9,115.00
   9,015.00
   9,165.00
   9,365.00
   8,915.00
   9,015.00
   8,965.00
   9,265.00
   9,065.00
   8,865.00
   8,765.00

Earnings Before Tax
  31,635.00
  43,885.00
  19,335.00
   5,835.00
  43,635.00
  (8,915.00)
  (9,015.00)
  (8,965.00)
  (9,265.00)
  (9,065.00)
  (8,865.00)
  (8,765.00)

Taxes
        –
        –
        –
        –
        –
        –
        –
        –
        –
        –
        –
        –

Net Earnings
  31,635.00
  43,885.00
  19,335.00
   5,835.00
  43,635.00
  (8,915.00)
  (9,015.00)
  (8,965.00)
  (9,265.00)
  (9,065.00)
  (8,865.00)
  (8,765.00)

Profits
Ahmad
  20,250.00
  26,500.00
  17,010.00
   9,000.00
  26,500.00
        –
        –
        –
        –
        –
        –
        –

Muha
  20,250.00
  26,500.00
  11,340.00
   6,000.00
  26,500.00
        –
        –
        –
        –
        –
        –
        –

Is this question part of your assignment?

Place order