jagomart
digital resources
picture1_Cost Sheet Format In Excel 32715 | Trading Summary Template


 250x       Filetype XLS       File size 0.02 MB       Source: www.businessballs.com


File: Cost Sheet Format In Excel 32715 | Trading Summary Template
trading summary example profit and loss account templatetool for selfemployedsmall business enterprise a free resource from businessballscom apr may jun jul aug sep oct nov dec jan feb mar total ...

icon picture XLS Filetype Excel XLS | Posted on 09 Aug 2022 | 3 years ago
Partial file snippet.
     Trading Summary (Example Profit and Loss Account Template/Tool) for self-employed/small business enterprise - a free resource from Businessballs.com
                                                                Apr         May         Jun          Jul         Aug         Sep         Oct         Nov          Dec         Jan         Feb         Mar         Total
         volume/quantity of product/service sold                    120         120         120         120          120         120         120         120          120         120         120          120       1,440
         unit price of product/service sold                      135.00      135.00      135.00       135.00      135.00      135.00      135.00       135.00      135.00      135.00      135.00       135.00       1,620
       s total sales                                          16,200.00   16,200.00   16,200.00    16,200.00   16,200.00   16,200.00   16,200.00    16,200.00   16,200.00   16,200.00    16,200.00   16,200.00     194,400
       e
       l unit cost of product or materials sold or used           60.00       60.00       60.00        60.00       60.00       60.00       60.00        60.00       60.00       60.00        60.00       60.00         720
       a
       S
         Costs of sales (COS - cost of products used/sold)      7200.00     7200.00     7200.00     7200.00      7200.00     7200.00     7200.00     7200.00      7200.00     7200.00     7200.00      7200.00      86,400
         Gross profit (sales minus cost of sales)               9000.00     9000.00     9000.00     9000.00      9000.00     9000.00     9000.00     9000.00      9000.00     9000.00     9000.00      9000.00     108,000
         Percentage gross profit                                   56%         56%         56%          56%         56%         56%         56%          56%         56%         56%          56%         56%         56%
         Employee costs (salaries and nat. ins.)                6000.00     6000.00     6000.00     6000.00      6000.00     6000.00     6000.00     6000.00      6000.00     6000.00     6000.00      6000.00      72,000
         Premises costs                                          400.00      400.00      400.00       400.00      400.00      400.00      400.00       400.00      400.00      400.00      400.00       400.00       4,800
         Rates, heating, lighting, water, services               400.00      400.00      400.00       400.00      400.00      400.00      400.00       400.00      400.00      400.00      400.00       400.00       4,800
         Repairs                                                  30.00       30.00       30.00        30.00       30.00       30.00       30.00        30.00       30.00       30.00        30.00       30.00         360
         Phone                                                    50.00       50.00       50.00        50.00       50.00       50.00       50.00        50.00       50.00       50.00        50.00       50.00         600
         Post                                                     25.00       25.00       25.00        25.00       25.00       25.00       25.00        25.00       25.00       25.00        25.00       25.00         300
       ) Stationery                                               25.00       25.00       25.00        25.00       25.00       25.00       25.00        25.00       25.00       25.00        25.00       25.00         300
       s
       d Computer and internet charges                            30.00       30.00       30.00        30.00       30.00       30.00       30.00        30.00       30.00       30.00        30.00       30.00         360
       a
       e Samples and sundries                                     15.00       15.00       15.00        15.00       15.00       15.00       15.00        15.00       15.00       15.00        15.00       15.00         180
       h
       r
       e Motor expenses inc fuel                                 100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00       1,200
       v
       O
       (
         Travel and parking                                       10.00       10.00       10.00        10.00       10.00       10.00       10.00        10.00       10.00       10.00        10.00       10.00         120
       s
       t
       s Subsistence and accommodation                            20.00       20.00       20.00        20.00       20.00       20.00       20.00        20.00       20.00       20.00        20.00       20.00         240
       o
       C
         Advertising and promotion                               300.00      300.00      300.00       300.00      300.00      300.00      300.00       300.00      300.00      300.00      300.00       300.00       3,600
       d
       e
       x Legal and professional                                  100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00       1,200
       i
       F
         Insurance                                               100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00      100.00      100.00      100.00       100.00       1,200
         Bad debts                                                                                                                                                                                                       0
         Interest and other finance charges                                                                                                                                                                              0
         Depreciation (write-down of assets)                                                                                                                                                                             0
         Other expenses                                                                                                                                                                                                  0
         Total Fixed Costs (Overheads)                          7605.00     7605.00     7605.00     7605.00      7605.00     7605.00     7605.00     7605.00      7605.00     7605.00     7605.00      7605.00      91,260
         Profit before tax                                      1395.00     1395.00     1395.00     1395.00      1395.00     1395.00     1395.00     1395.00      1395.00     1395.00     1395.00      1395.00      16,740
     © alan chapman 2006, from www.businessballs.com, not to be sold or published. Alan Chapman accepts no liability. Adapt                      free personal and organizational resources from www.businessballs.com
     this plan to suit your purposes. Beware of over-writing cells contain formulae.
The words contained in this file might help you see if this file matches what you are looking for:

...Trading summary example profit and loss account templatetool for selfemployedsmall business enterprise a free resource from businessballscom apr may jun jul aug sep oct nov dec jan feb mar total volumequantity of productservice sold unit price s sales e l cost product or materials used costs cos products usedsold gross minus percentage employee salaries nat ins premises rates heating lighting water services repairs phone post stationery d computer internet charges samples sundries h r motor expenses inc fuel v o travel parking t subsistence accommodation c advertising promotion x legal professional i f insurance bad debts interest other finance depreciation writedown assets fixed overheads before tax alan chapman wwwbusinessballscom not to be published accepts no liability adapt personal organizational resources this plan suit your purposes beware overwriting cells contain formulae...

no reviews yet
Please Login to review.