accounting sheets by huangyuarong

VIEWS: 13 PAGES: 9

									                                                                                                                                                     All in One Com
                                                                                                                                                               Balan

                                          30-Sep-09              31-Oct-09              30-Nov-09               31-Dec-09                31-Jan-10
Assets
Cash                                    5,973.41    54.68%      7,200.49 58.08%       8,669.10    60.69%      9,879.04    63.34% 10,695.33
Merchandise Inventory                     600.91     5.50%        657.68   5.31%        889.12     6.22%        942.52     6.04% 1,173.15
Supplies                                1,254.27    11.48%      1,442.41 11.64%       1,629.92    11.41%      1,678.82    10.76% 2,356.19
Furniture                                 709.50     6.49%        709.50   5.72%        709.50     4.97%        709.50     4.55%    709.50
Equipment                               2,386.99    21.85%      2,386.99 19.25%       2,386.99    16.71%      2,386.99    15.30% 2,386.99
Total Assets                           10,925.08   100.00%     12,397.07 100.00%     14,284.63   100.00%     15,596.87   100.00% 17,321.16

Liabilities
Bank Loan                              8,000.00       73.23%   7,200.00    58.08%    6,400.00       44.80%   5,600.00       35.90%   4,800.00
Accounts Payable                         900.00        8.24%     963.00     7.77%      991.89        6.94%   1,011.73        6.49%   1,042.08
Total Liabilities                       8,900.00      81.46%   8,163.00    65.85%     7,391.89      51.75%   6,611.73       42.39%    5,842.08

Partnership Equity
K. Bansal, Capital                       506.27        4.63%    1,058.52     8.54%    1,723.19      12.06%    2,246.29      14.40%   2,869.77
C. Bennett, Capital                      506.27        4.63%    1,058.52     8.54%    1,723.19      12.06%    2,246.29      14.40%   2,869.77
C. Maclntyre, Capital                    506.27        4.63%    1,058.52     8.54%    1,723.19      12.06%    2,246.29      14.40%   2,869.77
J. Wilson Capital                        506.27        4.63%    1,058.52     8.54%    1,723.19      12.06%    2,246.29      14.40%   2,869.77
Total Liabilities and Owners Equity    10,925.08   100.00%     12,397.07 100.00%     14,284.63   100.00%     15,596.87   100.00% 17,321.16




                                      Throughout the whole balance sheet, cash is more than 50% of the business total assets, which
                                       and same goes with the supplies. Furniture would be the same through the year unless it brea
                                      kit, printer, screws and other. We have taken a loan of 8000, which we plan to pay off within 10
                                      wholesalers and manufactures. Our business is a partnership and we have divided it up equally
                                                                                                      assets decrease due to no prof
 and same goes with the supplies. Furniture would be the same through the year unless it brea
kit, printer, screws and other. We have taken a loan of 8000, which we plan to pay off within 10
wholesalers and manufactures. Our business is a partnership and we have divided it up equally
                                                                assets decrease due to no prof
                 All in One Common Corner Store
                           Balance Sheet

     31-Jan-10             28-Feb-10                31-Mar-10               30-Apr-10               31-May-10              30-Jun-10               31-Jul-10

            61.75% 12,513.15       64.90%     14,026.77        66.97%    15,127.94    67.15%     16,804.78    67.75%   19,657.97    70.39%     18,889.97
             6.77% 1,244.65         6.46%      1,344.23         6.42%     1,455.30     6.46%      1,557.18     6.28%    1,712.89     6.13%      1,712.89
            13.60% 2,426.88        12.59%      2,476.99        11.83%     2,848.54    12.64%      3,346.25    13.49%    3,460.40    12.39%      3,460.40
             4.10%    709.50        3.68%        709.50         3.39%       709.50     3.15%        709.50     2.86%      709.50     2.54%        709.50
            13.78% 2,386.99        12.38%      2,386.99        11.40%     2,386.99    10.60%      2,386.99     9.62%    2,386.99     8.55%      2,386.99
           100.00% 19,281.17      100.00%     20,944.48       100.00%    22,528.27   100.00%     24,804.69   100.00%   27,927.75   100.00%     27,159.75



             27.71%    4,000.00    20.75%         3,200.00      15.28%   2,400.00       10.65%   1,600.00      6.45%     800.00        2.86%        -
              6.02%    1,062.92     5.51%         1,094.81       5.23%   1,116.71        4.96%   1,150.21      4.64%   1,184.71        4.24%   1,184.71
             33.73%    5,062.92    26.26%          4,294.81     20.51%   3,516.71       15.61%    2,750.21    11.09%   1,984.71        7.11%    1,184.71


             16.57%    3,554.56    18.44%         4,162.42      19.87%    4,752.89      21.10%    5,513.62    22.23%    6,485.76    23.22%      6,493.76
             16.57%    3,554.56    18.44%         4,162.42      19.87%    4,752.89      21.10%    5,513.62    22.23%    6,485.76    23.22%      6,493.76
             16.57%    3,554.56    18.44%         4,162.42      19.87%    4,752.89      21.10%    5,513.62    22.23%    6,485.76    23.22%      6,493.76
             16.57%    3,554.56    18.44%         4,162.42      19.87%    4,752.89      21.10%    5,513.62    22.23%    6,485.76    23.22%      6,493.76

           100.00% 19,281.17      100.00%     20,944.48       100.00%    22,528.27   100.00%     24,804.69   100.00%   27,927.75   100.00%     27,159.75




siness total assets, which increases around 15%. Merchandise is around 6% of the total assets and increases depending on t
h the year unless it breaks, as we only need a shelf, a desk, chairs and a cash register. Equipment needed to run is a comput
 plan to pay off within 10 months, and we need to pay companies for the supplies and equipment, which we mostly bought
ave divided it up equally (25% each). The first month we are not doing so well but later on, our condition improves. The last
decrease due to no profit being made but we still had to pay our expenses.
h the year unless it breaks, as we only need a shelf, a desk, chairs and a cash register. Equipment needed to run is a comput
plan to pay off within 10 months, and we need to pay companies for the supplies and equipment, which we mostly bought
ave divided it up equally (25% each). The first month we are not doing so well but later on, our condition improves. The last
decrease due to no profit being made but we still had to pay our expenses.
     31-Jul-10               31-Aug-10

             69.55%       18,109.97    68.65%
              6.31%        1,712.89     6.49%
             12.74%        3,460.40    13.12%
              2.61%          709.50     2.69%
              8.79%        2,386.99     9.05%
            100.00%       26,379.75   100.00%



                  0.00%        -         0.00%
                  4.36%   1,184.71       4.49%
                  4.36%   1,184.71       4.49%


                 23.91%    6,298.76    23.88%
                 23.91%    6,298.76    23.88%
                 23.91%    6,298.76    23.88%
                 23.91%    6,298.76    23.88%

            100.00%       26,379.75   100.00%




es depending on the profit made
 o run is a computer, laptop tool
we mostly bought, from retailers,
mproves. The last 2 months, our
 o run is a computer, laptop tool
we mostly bought, from retailers,
mproves. The last 2 months, our
                                                                                                                                                                                         All in One Common Corner Store
                                                                                                                                                                                                 Income Statements

                              End of Month September 30, 2009   End of Month October 31, 2009     End of Month November 30, 2009   End of Month December 31, 2009   End of Month January 31, 2010    End of Month February 28, 2010   End of Month March 31, 2010   End of Month April 30, 2010   End of Month May 31, 2010   End of Month June 30, 2010    End of Month July 31, 2010   End of Month August 31, 2010
Revenue
Laptop Accessories Sales             524.33           11.23%          566.28             11.23%            611.58         11.23%            489.26         11.23%           587.12         11.23%             616.47         11.23%         554.82        11.23%           577.02       11.23%          663.57      11.23%             729.93      11.23%            0.00        -                 0.00        -
Laptop Repairs Service             3,000.00           64.27%        3,240.00             64.27%          3,499.20         64.27%          2,799.36         64.27%         3,359.23         64.27%           3,527.19         64.27%       3,174.47        64.27%         3,301.45       64.27%        3,796.67      64.27%           4,176.34      64.27%            0.00        -                 0.00        -
Software Assistance Service        1,000.00           21.42%        1,080.00             21.42%          1,166.40         21.42%            933.12         21.42%         1,119.74         21.42%           1,175.73         21.42%       1,058.16        21.42%         1,100.48       21.42%        1,265.56      21.42%           1,392.11      21.42%            0.00        -                 0.00        -
Printing Service                     143.75            3.08%          155.25              3.08%            167.67          3.08%            134.14          3.08%           160.96          3.08%             169.01          3.08%         152.11         3.08%           158.19        3.08%          181.92       3.08%             200.12       3.08%            0.00        -                 0.00        -
Total Revenue                      4,668.08          100.00%        5,041.53            100.00%          5,444.85        100.00%          4,355.88        100.00%         5,227.05        100.00%           5,488.41        100.00%       4,939.57       100.00%         5,137.15      100.00%        5,907.72     100.00%           6,498.49     100.00%            0.00        -                 0.00        -

Cost of Goods
Cost of Laptop Accessories           332.90             7.13%         359.53              7.13%            388.29          7.13%           310.64           7.13%           372.76          7.13%             391.40          7.13%         352.26          7.13%          366.35        7.13%          421.30        7.13%            463.43       7.13%            0.00        -                 0.00        -

Gross Profit                       4,335.18            92.87%       4,681.99             92.87%          5,056.55         92.87%          4,045.24         92.87%         4,854.29         92.87%           5,097.01         92.87%       4,587.31         92.87%        4,770.80       92.87%        5,486.42      92.87%           6,035.06      92.87%            0.00        -                 0.00        -

Expenses
Utilities Expense                    175.00             3.75%         180.00              3.57%            175.00          3.21%            105.00          2.41%           160.00          3.06%             155.00          2.82%         140.00          2.83%          175.00        3.41%          180.00       3.05%             140.00       2.15%           50.00        -                50.00        -
Phone Bill Expense                    25.00             0.54%          25.00              0.50%             25.00          0.46%             25.00          0.57%            25.00     #DIV/0!                 25.00          0.46%          25.00          0.51%           25.00        0.49%           25.00       0.42%              25.00       0.38%           25.00        -                25.00        -
Wages and Salaries                 1,768.00            37.87%       1,188.00             23.56%          1,134.00         20.83%            756.00         17.36%         1,080.00         20.66%           1,080.00         19.68%         864.00         17.49%        1,080.00       21.02%        1,080.00      18.28%             810.00      12.46%            0.00        -                 0.00        -
Advertising Expense                   75.00             1.61%          75.00              1.49%             75.00          1.38%             75.00          1.72%            75.00          1.43%              75.00          1.37%          75.00          1.52%           75.00        1.46%           75.00       1.27%              75.00       1.15%           75.00        -                75.00        -
General Expenses                   1,700.00            36.42%       1,742.00             34.55%          1,760.00         32.32%          1,772.00         40.68%         1,790.00         34.24%           1,802.00         32.83%       1,820.00         36.85%        1,832.00       35.66%        1,850.00      31.31%           1,862.00      28.65%          618.00        -               630.00        -
Total Expenses                     3,743.00            80.18%       3,210.00             63.67%          3,169.00         58.20%          2,733.00         62.74%         3,130.00         59.88%           3,137.00         57.16%       2,924.00         59.20%        3,187.00       62.04%        3,210.00      54.34%           2,912.00      44.81%          768.00        -               780.00        -

Net Income/Loss                      925.08            19.82%       1,471.99             29.20%          1,887.55         34.67%          1,312.24         30.13%         1,724.29         32.99%           1,960.01         35.71%       1,663.31         33.67%        1,583.80       30.83%        2,276.42      38.53%           3,123.06      48.06%         -768.00        -              -780.00        -




                              We estimated that 35 students will come each day from the three quarter of the student will come because only the 2009-10 students will have in school repairing done by MDG. We also offer software assistance as a lot student suffer from software problems and they do not know what
                              to do like getting rid of viruses or fixing system errors; we have estimated that in the first month, 11 customer a day will come for software assistance. Our business provides printing services as many student think the printing cost in the library is expensive so we offer color for 35 cents
                               and black & white for 7 cents; there will be increase around of 8% each month. Students are going to go crazy for our services for our low priced services. We also sell laptop accessories, which the sales are going to increase 8% each month. We need to pay the employees a reasonable
                                                                                price of nine dollars since our customer is mainly paying for the service. We need to get the word out about our products using ads and we are going to get professional help with the advertising.
                                                                    All in One Common Corner Store
                                                                              Balance Sheet

                                             31-Aug-10                 31-Aug-11               31-Aug-12               31-Aug-13               31-Aug-14
Assets
Cash                                  18,109.97         68.65% 33,993.36        73.87% 50,447.35       76.25%     70,734.24     77.21% 95,972.87         77.94%
Merchandise Inventory                  1,712.89          6.49% 3,014.69          6.55% 4,250.94         6.43%      5,992.24      6.54%   7,490.29         6.08%
Supplies                               3,460.40         13.12% 6,116.25         13.29% 8,562.75        12.94%     11,987.84     13.09% 16,782.98         13.63%
Furniture                                 709.5          2.69%    509.50         1.11%    509.50        0.77%        509.50      0.56%     509.50         0.41%
Equipment                              2,386.99          9.05% 2,386.99          5.19% 2,386.99         3.61%      2,386.99      2.61%   2,386.99         1.94%
Total Assets                          26,379.75        100.00% 46,020.79       100.00% 66,157.52      100.00%     91,610.81    100.00% 123,142.64       100.00%

Liabilities
Bank Loan                                    -            0.00%        0.00      0.00%        0.00       0.00%         0.00        0.00%        0.00       0.00%
Accounts Payable                        1,184.71          4.49%    1,611.21      3.50%    2,255.69       3.41%     3,203.08        3.50%    4,612.43       3.75%
Total Liabilities                       1,184.71          4.49%    1,611.21      3.50%    2,255.69       3.41%     3,203.08        3.50%    4,612.43       3.75%

Partnership Equity
K. Bansal, Capital                      6,298.76         23.88%   11,102.40     24.12%   15,975.46      24.15%    22,101.93     24.13%     29,632.55     24.06%
C. Bennett, Capital                     6,298.76         23.88%   11,102.40     24.12%   15,975.46      24.15%    22,101.93     24.13%     29,632.55     24.06%
C. Maclntyre, Capital                   6,298.76         23.88%   11,102.40     24.12%   15,975.46      24.15%    22,101.93     24.13%     29,632.55     24.06%
J. Wilson Capital                       6,298.76         23.88%   11,102.40     24.12%   15,975.46      24.15%    22,101.93     24.13%     29,632.55     24.06%
Total Liabilities and Owners Equity   26,379.75        100.00% 46,020.79       100.00% 66,157.52      100.00%     91,610.81    100.00% 123,142.64       100.00%




                                       Cash, inventory and supplies will increase around 40% but during the second year, there is a jump due to the grade 12
                                        not having any warranty on their laptop so they will come to us because we offer good service for cheap prices that
                                      students can afford. There is no bank loan since we paid it off on the first year but our accounts payable increase due to
                                                                           buy more supplies and inventory being bought.
                                                                              All in One Common Corner Store
                                                                                      Income Statements

                                End of year August 31, 2010      End of year August 31, 2011     End of year August 31, 2012      End of year August 31, 2013      End of year August 31, 2014
Revenue
Laptop Accessories Sales              5,920.37         11.23%        7,282.06          11.89%         8,374.36          12.11%          10,886.67        12.99%       14,152.67          13.91%
Laptop Repairs Service               33,873.92         64.27%       39,632.49          64.72%        45,181.03          65.36%          55,120.86        65.77%       67,247.45          66.08%
Software Assistance Service          11,291.31         21.42%       12,420.44          20.28%        13,289.87          19.23%          15,017.56        17.92%       16,969.84          16.68%
Printing Service                      1,623.13          3.08%        1,899.06           3.10%         2,278.87           3.30%           2,780.23         3.32%        3,391.88           3.33%
Total Revenue                        52,708.73        100.00%       61,234.04         100.00%        69,124.14         100.00%          83,805.32       100.00%      101,761.84         100.00%

Cost of Goods
Cost of Laptop Accessories            3,758.88           7.13%        4,134.77           6.75%         4,548.24          6.58%            5,003.07        5.97%         5,503.38          5.41%

Gross Profit                         48,949.85         92.87%       57,099.28          93.25%        64,575.90          93.42%          78,802.25        94.03%       96,258.46          94.59%

Expenses
Utilities Expense                     1,685.00          3.20%        1,752.40           2.86%         1,822.50           2.64%           1,895.40         2.26%        1,971.21           1.94%
Phone Bill Expense                        300           0.57%          300.00           0.49%           300.00           0.43%             300.00         0.36%          300.00           0.29%
Wages and Salaries                   10,840.00         20.57%        9,922.00          16.20%         9,922.00          14.35%           9,922.00        11.84%        9,922.00           9.75%
Advertising Expense                       900           1.71%          936.00           1.53%           973.44           1.41%           1,012.38         1.21%        1,052.87           1.03%
General Expenses                     19,178.00         36.38%       24,547.84          40.09%        31,421.24          45.46%          40,219.18        47.99%       51,480.55          50.59%
Total Expenses                       32,903.00         62.42%       37,458.24          61.17%        44,439.17          64.29%          53,348.95        63.66%       64,726.64          63.61%

Net Income/Loss                      16,379.75         31.08%       19,641.04          32.08%        20,136.73          29.13%          25,453.29        30.37%       31,531.83          30.99%




                              The first year turned out pretty good considering we were doing so poorly during the first month. Then there was an increase in the second year as the grade 12
                              of that year had lost their warranty finding an alternative solution, meaning our business. The third year was a slow but it picked up later on. Laptop accessories
                               are increasing at a good speed of 25%. Laptop repair's average increases around 15-19% and the average of software assistance is increasing by 11%. Printing
                                   service is also increasing around 19%. Expenses are increasing at a quick rate like general expenses, which consist of account payable and other things.

								
To top