Docstoc

2009 Profit and Loss Statement

Document Sample
2009 Profit and Loss Statement Powered By Docstoc
					                                                             Jan 10      Feb 10      Mar 10      Apr 10

  INN AND SPA AT PARKSIDE PROJECTIONS                                                    $192        $192
                                                                                        41.0%       41.0%
                                        2009 Results
                                              Room Rev       37,755.60   35,652.00   26,076.15   26,190.90
                                            Spa Revenue      31,109.04   33,964.00   30,367.25   28,194.75
Ordinary Income/Expense                                      68,864.64   69,616.00   56,443.40   54,385.65
          Income
                         Room Revenue                        28,348.10   28,933.15   26,000.00   26,000.00
                         Spa Revenue                         28,429.00   32,195.25   27,000.00   27,000.00
          Total Income                                       56,777.10   61,128.40   53,000.00   53,000.00
          Cost of Goods Sold
                         Spa Cost of Goods Sold               2,194.56     563.74     1,000.00    1,000.00
          Total COGS                                          2,194.56     563.74     1,000.00    1,000.00
  Gross Profit                                               54,582.54   60,564.66   52,000.00   52,000.00
          Expense
                         Advertising                         10,983.41   10,027.84    6,000.00    6,000.00
                         Advertising and Promotion            1,400.00    1,400.00    1,000.00    1,000.00
                         Bank Charges                          973.31      111.36     1,400.00    1,400.00
                         Bank Service Charges                  280.00       -26.00     100.00      100.00
                         Business Licenses and Permits            0.00        0.00     200.00      200.00
                         Commissions                              0.00        0.00    7,000.00    7,000.00
                         Computer and Internet Expenses         88.85      292.85      100.00      100.00
                         Credit Card Interest                  308.41      300.24     1,000.00    1,000.00
                         Debt Service                        15,943.71   15,943.71   17,450.00   17,450.00
                         Dues & Subscriptions                   81.88       64.38      100.00      100.00
                         Electronics                              0.00        0.00        0.00        0.00
                         Food - B&B
                                        Wine Expense              0.00    1,711.31     600.00      600.00
                                        Food - B&B - Other    2,005.78    2,267.41    1,500.00    1,500.00
                         Total Food - B&B                     2,005.78    3,978.72    2,100.00    2,100.00
                         Furniture                                0.00     479.54         0.00        0.00
                         Insurance-Medical                     307.18     1,240.18    1,300.00    1,300.00
                         Insurance - Property                  809.00      807.00      700.00      700.00
                         Insurance - Spa                          0.00        0.00        0.00        0.00
                         Insurance - Workers Comp              697.92      697.91      700.00      700.00
                         Landscaping and Groundskeeping        130.00      130.00      300.00      300.00
                         Legal & Professional Services            0.00        0.00        0.00        0.00
                         Mortgage Interest Expense                0.00        0.00        0.00        0.00
                         Office Services                          0.00      75.00         0.00        0.00
                         Office Supplies                       394.80      124.82      500.00      500.00
                         Payroll Expenses                     7,767.50    8,144.20    7,700.00    7,700.00
                         Permits & Licenses                       0.00     219.00       50.00       50.00
                         Repairs & Maintenance                 168.87     1,230.58     600.00      600.00
                         Spa Contract Labor                  10,846.00   11,165.00    8,640.00    8,640.00
                         Supplies                             2,358.53    1,872.55    2,000.00    2,000.00
                         Taxes - Business           200.00      180.73         0.00       800.00
                         Taxes - Employment         907.90      943.36       925.00       925.00
                         Taxes - Property              0.00    4,891.28    2,500.00     2,500.00
                         Telephone Expense          620.68      604.74       700.00       700.00
                         Travel & Entertainment      35.19      100.82        50.00        50.00
                         Utilities                 1,746.16    3,183.53    2,700.00     2,700.00
             Total Expense                        59,055.08   68,183.34   65,815.00    66,615.00
Net Ordinary Income                               -4,472.54   -7,618.68   -13,815.00   -14,615.00
Net Income                                        -4,472.54   -7,618.68   -13,815.00   -14,615.00
May 10      Jun 10      Jul 10      Aug 10      Sep 10      Oct 10      Nov 10      Dec 10

    $192        $192        $192        $192        $192        $192        $192        $192
   41.0%       41.0%       41.0%       41.0%       41.0%       39.7%       41.0%       39.7%


29,435.05   30,434.25   24,199.60   25,046.00   25,456.50   29,726.35   21,731.28   23,984.11
33,372.57   25,949.95   21,866.72   23,305.00   29,108.82   23,609.04   30,324.00   23,293.50
62,807.62   56,384.20   46,066.32   48,351.00   54,565.32   53,335.39   52,055.28   47,277.61


26,000.00   26,000.00   26,000.00   26,000.00   26,000.00   26,000.00   26,000.00   26,000.00
27,000.00   27,000.00   27,000.00   27,000.00   27,000.00   27,000.00   27,000.00   27,000.00
53,000.00   53,000.00   53,000.00   53,000.00   53,000.00   53,000.00   53,000.00   53,000.00


 1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00
 1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00
52,000.00   52,000.00   52,000.00   52,000.00   52,000.00   52,000.00   52,000.00   52,000.00


 6,000.00    6,000.00    6,000.00    6,000.00    6,000.00    6,000.00    6,000.00    6,000.00
 1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00    1,000.00
 1,400.00    1,400.00    1,400.00    1,400.00    1,400.00    1,400.00    1,400.00    1,400.00
  100.00      100.00      100.00      100.00      100.00      100.00      100.00      100.00
  200.00      200.00      200.00      200.00      200.00      200.00      200.00      200.00
 2,000.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00
  100.00      100.00      100.00      100.00      100.00      100.00      100.00      100.00
  700.00      700.00      700.00      700.00      700.00      500.00      500.00      500.00
17,450.00   17,450.00   17,450.00   17,450.00   17,450.00   17,450.00   17,450.00   17,450.00
  100.00      100.00      100.00      100.00      100.00      100.00      100.00      100.00
     0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00


  600.00      600.00      600.00      600.00      600.00      600.00      600.00      600.00
 1,500.00    1,500.00    1,500.00    1,500.00    1,500.00    1,500.00    1,500.00    1,500.00
 2,100.00    2,100.00    2,100.00    2,100.00    2,100.00    2,100.00    2,100.00    2,100.00
     0.00                    0.00        0.00        0.00        0.00        0.00        0.00
 1,300.00    1,300.00    1,300.00    1,300.00    1,300.00    1,300.00    1,300.00    1,300.00
  700.00      700.00      700.00      700.00      700.00      700.00      700.00      700.00
     0.00     500.00         0.00        0.00        0.00        0.00        0.00        0.00
  700.00      700.00      700.00      700.00      700.00      700.00      700.00      700.00
  300.00      300.00      300.00      300.00      300.00      300.00      300.00      300.00
     0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00
     0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00
     0.00                    0.00        0.00        0.00        0.00        0.00        0.00
  500.00      500.00      500.00      500.00      500.00      500.00      500.00      500.00
 7,700.00    7,700.00    7,700.00    7,700.00    7,700.00    7,700.00    7,700.00    7,700.00
   50.00       50.00       50.00       50.00       50.00       50.00       50.00       50.00
  600.00      600.00      600.00      600.00      600.00      600.00      600.00      600.00
 8,640.00    8,640.00    8,640.00    8,640.00    8,640.00    8,640.00    8,640.00    8,640.00
 2,000.00    2,000.00    2,000.00    2,000.00    2,000.00    2,000.00    2,000.00    2,000.00
  512.20            0.00          0.00        0.00        0.00       475.00         0.00        0.00
  925.00         925.00        925.00      925.00      925.00        925.00      925.00      925.00
 2,500.00       2,500.00      2,500.00    2,500.00    2,500.00      2,500.00    2,500.00    2,500.00
  700.00         700.00        700.00      700.00      700.00        700.00      700.00      700.00
   50.00          50.00         50.00       50.00       50.00         50.00       50.00       50.00
 2,700.00       2,700.00      2,700.00    2,700.00    2,700.00      2,700.00    2,700.00    2,700.00
61,027.20      59,015.00     58,515.00   58,515.00   58,515.00     58,790.00   58,315.00   58,315.00
-9,027.20 ##   -7,015.00 #   -6,515.00   -6,515.00   -6,515.00 #   -6,790.00   -6,315.00   -6,315.00
-9,027.20      -7,015.00     -6,515.00   -6,515.00   -6,515.00     -6,790.00   -6,315.00   -6,315.00
 Tot 10




335,687.79
334,464.64
670,152.43


317,281.25
330,624.25
647,905.50


 12,758.30
 12,758.30
635,147.20


 81,011.25
 12,800.00
 15,084.67
  1,254.00
  2,000.00
 16,000.00
  1,381.70
  7,608.65
206,387.42
  1,146.26
      0.00
      0.00
  7,711.31
 19,273.19
 26,984.50
   479.54
 14,547.36
  8,616.00
   500.00
  8,395.83
  3,260.00
      0.00
      0.00
     75.00
  5,519.62
 92,911.70
   719.00
  7,399.45
108,411.00
 24,231.08
  2,167.93
 11,101.26
 29,891.28
  8,225.42
   636.01
 31,929.69
730,675.62
-95,528.42
-95,528.42
INN AT PARKSIDE OCCUPANCY And ADR FOR 2009 and First two Months of 2010

        Month of        Avg Dollar Rate   Occupancy
                         Per Room         Percentage

 2010   Feb               $209.66           41.1%
        Jan               $192.84           39.5%
                                                        NOTE for NOVEMBER
 2009   Dec               $184.49           35.0%
        Nov               $156.34           42.1%          We had a special with Spa where spa was free with room.
        Oct               $196.86           44.3%          It made sense to book full spa and low room for local tax payments.
        Sept              $183.14           42.1%
        Aug               $186.91           39.3%
        July              $198.36           35.8%
        June              $193.85           47.6%
        May               $191.14           45.2%
        Apr               $176.97           44.8%
        Mar               $184.95           41.3%
        Feb               $216.07           53.6%
        Jan               $195.62           56.6%
l tax payments.
MY WINES DIRECT BALANCE SHEET as of 12/31/2009


                                                                                    Dec 31, 09

ASSETS
            Current Assets
                           Checking/Savings
                                         Wells Fargo Checking                         263,699.56
                                         Wells Fargo Merchant Account                  -3,368.11
                           Total Checking/Savings                                     260,331.45
                           Other Current Assets
                                         Cash                                            -851.34
                                         Inventory                                      1,250.00
                           Total Other Current Assets                                     398.66
            Total Current Assets                                                      260,730.11
            Fixed Assets
                           Accumulated Depreciation                                   -73,813.00
                           Appliance Fixed Assets
                                         Appliances Cost                                5,826.33
                           Total Appliance Fixed Assets                                 5,826.33
                           Buildings and Improvements                                  10,929.37
                           Furniture and Equipment                                    450,000.00
            Total Fixed Assets                                                        392,942.70
            Other Assets
                           Accumulated Amortization                                   -33,117.00
                           Closing Costs                                               43,505.50
                           Deposits                                                     1,800.00
                           Goodwill                                                   950,000.00
            Total Other Assets                                                        962,188.50
TOTAL ASSETS                                                                        1,615,861.31

LIABILITIES & EQUITY
            Liabilities
                           Current Liabilities
                                         Credit Cards
                                                        Advanta Credit Card            16,328.46
                                                        Best Buy Credit Card            3,028.64
                                                        Cost Plus World Market            276.01
                                                        GE Money Bank Credit Card         255.60
                                                        Home Depot                      1,534.23
                                                        Sears                             110.01
                                                        Target Credit Card                545.68
                                                        Wells Fargo CR Card           344,424.06
                                         Total Credit Cards                           366,502.69
                                         Other Current Liabilities
                                                        Accrued property taxes         18,708.99
                                                        Gift Cards Liability           47,732.48
                                                                                  1,047,211.65
                                                        Note payable-Resource Capital
                                                        TOT Tax Payable       -12,942.09
                                          Total Other Current Liabilities   1,100,711.03
                          Total Current Liabilities                         1,467,213.72
                          Long Term Liabilities
                                          Shareholder Loan-Gorker            192,974.38
                                          Shareholder Loan-Sedlock           138,394.29
                          Total Long Term Liabilities                        331,368.67
           Total Liabilities                                                1,798,582.39
           Equity
                          Capital Stock                                          500.00
                          Paid in capital                                     55,981.28
                          Retained Earnings                                  -155,411.33
                          Net Income                                          -83,791.03
           Total Equity                                                      -182,721.08
TOTAL LIABILITIES & EQUITY                                                  1,615,861.31
                                                               INN AND
                                         2009 Profit & Loss Statement    SPA AT PARKSIDE

                                                               Jan 09         Feb 09       Mar 09      Apr 09      May 09      Jun 09      Jul 09      Aug 09      Sep 09      Oct 09      Nov 09      Dec 09      TOTAL

Ordinary Income/Expense
           Income
                          Room Revenue                         37,755.60       35,652.00   26,078.40   26,190.90   29,435.06   30,434.25   24,199.60   25,046.00   25,456.50   29,726.35   21,731.28   23,984.11   335,690.05
                          Spa Revenue                          31,109.04       33,964.00   30,366.65   28,194.25   33,372.57   25,949.95   21,901.22   23,305.00   29,108.82   23,609.04   30,324.00   23,293.50   334,498.04
           Total Income                                        68,864.64       69,616.00   56,445.05   54,385.15   62,807.63   56,384.20   46,100.82   48,351.00   54,565.32   53,335.39   52,055.28   47,277.61   670,188.09
           Cost of Goods Sold
                          Spa Cost of Goods Sold                1,868.91         473.33      683.82      858.33      617.03     1,616.94    1,646.36     831.33      340.36     1,366.81     845.26     1,055.63    12,204.11
           Total COGS                                           1,868.91         473.33      683.82      858.33      617.03     1,616.94    1,646.36     831.33      340.36     1,366.81     845.26     1,055.63    12,204.11
       Gross Profit                                            66,995.73       69,142.67   55,761.23   53,526.82   62,190.60   54,767.26   44,454.46   47,519.67   54,224.96   51,968.58   51,210.02   46,221.98   657,983.98
           Expense
                          Advertising                          10,439.95        9,296.82    7,945.04    6,898.52    6,150.72    5,022.47    7,233.71    8,013.71    7,053.02   10,529.58   10,340.37   11,133.04   100,056.95
                          Advertising and Promotion             3,423.53        1,041.00     534.24     3,796.62    1,969.62    7,328.15     385.37     1,510.38    1,510.34    2,024.00    2,109.00    1,839.00    27,471.25
                          Bank Charges                              0.00        1,704.76    1,715.83    1,447.89    1,467.43    1,762.96    1,716.15    1,525.39    1,401.92    1,494.94    1,682.00    2,094.83    18,014.10
                          Bank Service Charges                  1,749.39          58.00       42.00       20.00       20.00       20.00       20.00      129.03       10.00         0.00        0.00        0.00     2,068.42
                          Business Licenses and Permits             0.00            0.00        0.00        0.00        0.00     591.00         0.00        0.00        0.00        0.00        0.00        0.00      591.00
                          Commissions                              65.60            0.00        0.00        0.00        0.00        0.00      35.80         0.00        0.00        0.00        0.00        0.00      101.40
                          Computer and Internet Expenses          109.95         106.98       54.95       70.16       88.85      357.95       88.85       88.85       88.85       88.85       88.85       88.85      1,321.94
                          Credit Card Interest                    490.67            0.00        0.00        0.00        0.00        0.00        0.00      62.34      326.92      319.58      278.57      334.10      1,812.18
                          Debt Service                         26,097.34       20,097.34   32,580.14        0.00   18,905.64    7,643.66    7,764.74   11,389.52        0.00   20,685.11   11,790.07   15,943.71   172,897.27
                          Dues & Subscriptions                     45.13          45.13       28.88       58.29       58.29       64.38       64.38       80.63      145.01       80.63       80.63       80.63       832.01
                          Electronics                              67.86            0.00        0.00        0.00        0.00        0.00        0.00      32.61         0.00        0.00        0.00        0.00      100.47
                          Equipment Lease                           0.00            0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00     497.24         0.00        0.00      497.24
                          Food - B&B
                                         Wine Expense             682.75         734.41     2,252.30     181.59      377.80      131.62     2,371.61     729.76         0.00    1,895.07        0.00     419.00      9,775.91
                                         Food - B&B - Other     3,268.85        2,084.23     986.43     2,533.15    1,095.64    1,607.43    1,044.35    1,461.99    1,829.84    1,845.85    2,078.56    1,876.02    21,712.34
                          Total Food - B&B                      3,951.60        2,818.64    3,238.73    2,714.74    1,473.44    1,739.05    3,415.96    2,191.75    1,829.84    3,740.92    2,078.56    2,295.02    31,488.25
                          Furniture                               140.05            0.00        0.00        0.00        0.00     691.44         0.00        0.00     370.94         1.79        0.00        0.00     1,204.22
                          Insurance-Medical                     2,238.94        2,124.50    2,570.46    2,146.90    1,723.34    1,605.92    1,645.90     933.00     1,222.56    1,082.16    1,100.18    1,060.20    19,454.06
                          Insurance - Property                      0.00            0.00        0.00    1,618.00        0.00     809.00     1,598.00     809.00      809.00      809.00      809.00      809.00      8,070.00
                          Insurance - Spa                         357.68            0.00     715.36         0.00        0.00        0.00     500.00         0.00        0.00        0.00        0.00        0.00     1,573.04
                          Insurance - Workers Comp              2,452.55            0.00        0.00    2,452.55        0.00     162.35     1,793.66     697.91     1,415.84        0.00     697.93      697.92     10,370.71
                          Landscaping and Groundskeeping          180.46         130.00      260.00         0.00     260.00         0.00     130.00      130.00      260.00         0.00     130.00      130.00      1,610.46
                          Legal & Professional Services           431.25          39.00         0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00      55.00         0.00      525.25
                          Mortgage Interest Expense                 0.00            0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00        0.00         0.00
                          Office Services                           0.00            0.00        0.00        0.00        0.00        0.00      67.25         0.00        0.00        0.00        0.00        0.00        67.25
                          Office Supplies                         656.08            0.00     308.79      374.68      443.94         0.00     349.18      208.45      528.93      211.12      178.21      118.68      3,378.06
                          Payroll Expenses                     11,067.37       10,190.77    7,866.01   10,072.90    8,918.40    9,512.95    8,302.20    9,506.07    7,854.10    8,038.74    7,719.75    7,508.75   106,558.01
                          Permits & Licenses            0.00         0.00        0.00         0.00        0.00      40.00         0.00      40.00       40.00         1.75      180.00         0.00       301.75
                          Professional Fees             0.00         0.00        0.00         0.00        0.00        0.00        0.00        0.00        0.00        0.00         0.00    1,600.00      1,600.00
                          Repairs & Maintenance       432.00      796.83        62.50      670.00      506.00      302.00      824.99      840.18      373.88     1,616.04       55.60         0.00      6,480.02
                          Spa Contract Labor       10,805.00    13,028.60    9,060.75    10,555.00    8,848.50    7,627.50    9,837.50    8,652.25    7,993.00    9,210.75    10,941.50    6,749.00    113,309.35
                          Supplies                  1,738.12     2,374.83    1,686.82     2,235.43     608.10     2,109.36    2,702.19    1,974.38    1,960.45    2,315.46     2,568.83    1,620.48     23,894.45
                          Taxes - Business              0.00      460.58         0.00      800.00      512.20         0.00        0.00     341.33         0.00      334.00      956.28         0.00      3,404.39
                          Taxes - Employment        1,303.04     1,187.79      917.81     1,052.10     874.16      882.56      672.44      761.38      587.28       601.97      577.97       561.81      9,980.31
                          Taxes - Property              0.00         0.00        0.00         0.00        0.00        0.00        0.00        0.00    8,774.71        0.00         0.00   19,388.73     28,163.44
                          Telephone Expense           713.82      750.46       788.71      798.17      789.65      777.45      785.74      706.77      722.97       547.62      548.17       549.23      8,478.76
                          Travel & Entertainment      129.75       96.45         0.00       42.77         0.00        0.00        0.00      93.38         0.00      200.80      200.00       273.63      1,036.78
                          Utilities                 2,076.45     2,448.75    3,387.27     2,980.32    2,090.08    3,440.65    2,633.92    2,812.52    4,216.70    3,391.36     2,769.01    2,815.19     35,062.22
              Total Expense                        81,163.58    68,797.23   73,764.29    50,805.04   55,708.36   52,490.80   52,567.93   53,530.83   49,496.26   67,823.41    57,935.48   77,691.80    741,775.01
  Net Ordinary Income                              -14,167.85     345.44    -18,003.06    2,721.78    6,482.24    2,276.46   -8,113.47   -6,011.16    4,728.70   -15,854.83   -6,725.46   -31,469.82   -83,791.03
Net Income                                         -14,167.85     345.44    -18,003.06    2,721.78    6,482.24    2,276.46   -8,113.47   -6,011.16    4,728.70   -15,854.83   -6,725.46   -31,469.82   -83,791.03

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:68
posted:7/18/2011
language:English
pages:12