Excel Profit and Loss Statement - Im _ Associates Accountancy by zhouwenjuan

VIEWS: 28 PAGES: 2

									_______________________
Profit & Loss Statement 손익 계산서
_______________________


                                     Example 보기      1   2   3   4   5   6   7   8   9   10   11   12       Total 합계

Gross sales                          $ 200,000.00                                                       $          -
   (Less: returns and allowance)        (1,500.00)                                                                 -
Net gross sales                        198,500.00                                                                  -    -
    (Less: sales tax)                  (15,550.69)                                                                 -
Net sales                              182,949.31                                                                  -    -

Cost of goods sold
    Inventory, beginning of year        15,000.00                                                                  -

    Purchases                           40,000.00                                                                  -
    Cost of goods for personal use
    Cost of labor                       30,000.00                                                                  -
    Material & supplies                 10,000.00                                                                  -
    Other cost______________             5,000.00                                                                  -
    Other cost______________             5,000.00                                                                  -

    Inventory, end of year              14,000.00                                                                  -
Cost of goods sold                      91,000.00                                                                  -    -
Gross profit                            91,949.31                                                                  -    -

Operating expenses:
    Accounting                           5,000.00                                                                  -
    Advertising                          2,500.00                                                                  -
    Bad debts                              500.00                                                                  -
         Automobile expenses:
         Year, Make, Model               N/A
         Total mileage used
         Business mileage used
         Gas                               800.00                                                                  -
         Insurance                       1,000.00                                                                  -
         DMV registeration                 500.00                                                                  -
         Parking & tolls                   600.00                                                                  -
         Repairs & maintenance             800.00                                                                  -
         Others                            200.00                                                                  -
    Automobile expenses                  3,900.00                                                                  -    -
    Bank service charges                   150.00                                                                  -
    Commissions and fees                      -                                                                    -
    Contract labor                            -                                                                    -
    Delivery and freight                      -                                                                    -
    Dues and subscriptions                 200.00                                                                  -
    Employee benefits                      500.00                                                                  -

                                                                                                                  Steve S.Y. Im, CPA
                                                                                                                       Im Associates
_______________________
Profit & Loss Statement 손익 계산서
_______________________


                                       Example 보기      1   2   3   4   5   6   7   8   9   10   11   12       Total 합계

    Equipment rental/lease                    600.00                                                                 -
    Insurance - others                      2,500.00                                                                 -
    Interest - Mortgage                       300.00                                                                 -
    Janitorial                                300.00                                                                 -
    Laundry and cleaning                      250.00                                                                 -
    Legal and professional                  1,000.00                                                                 -
    License & fees                            150.00                                                                 -
    Meal & entertainment                      900.00                                                                 -
    Miscellaneous                             300.00                                                                 -
    Office expenses                           600.00                                                                 -
    Outside services                          400.00                                                                 -
    Pension and profit sharing plans             -                                                                   -
    Postage                                   200.00                                                                 -
    Printing                                  100.00                                                                 -
    Rent                                   12,000.00                                                                 -
    Repairs & maintenance                     650.00                                                                 -
    Supplies                                  600.00                                                                 -
    Taxes - payroll taxes                        -                                                                   -
    Taxes - property taxes                       -                                                                   -
    Taxes - real estate                          -                                                                   -
    Telephone                                 450.00                                                                 -
    Tools                                        -                                                                   -
    Uniform                                   200.00                                                                 -
    Utilities                                 500.00                                                                 -
    Wages                                        -                                                                   -
    Other expense ____________                   -                                                                   -
    Other expense ____________                   -                                                                   -
    Other expense ____________                   -                                                                   -
    Other expense ____________                   -                                                                   -
Operating expenses                         34,750.00                                                                 -    -
Operating profit (loss)                    57,199.31                                                                 -    -

Other income (expenses)                     1,000.00                                                                 -

Net profit (loss)                      $   58,199.31                                                      $          -    -




                                                                                                                    Steve S.Y. Im, CPA
                                                                                                                         Im Associates

								
To top