Restaurant Balance Sheet Forecast

VIEWS: 2,300 PAGES: 6

More Info
									[RESTAURANT NAME]
                                                                   Balance Sheet Forecast
         TIP: SHEET 2 BELOW HAS A
         FILLED OUT EXAMPLE                                              [DATE]

         TIP: HOVER OVER EACH CELL
         FOR MORE INSTRUCTIONS
                                     Current          Forecast
                                     [Current Date]   [Forecast Date]

ASSETS

Current Assets
Checking Account                      -                -
Petty Cash                            -                -
Accounts Receivables                  -                -
Temporary Investments                 -                -
Prepaid Insurance                     -                -
Employee Advances                     -                -
Food Inventory                        -                -
Bar Inventory                         -                -
Total Current Assets                 $          -     $           -

Fixed Assets
Furniture and Equipment               -                -
Computer Equipment                    -                -
Vehicles                              -                -
Buildings                             -                -
Land                                  -                -
Total Fixed Assets                   $          -     $           -

Other Assets
Trademarks                            -                -
Patents                               -                -
Security Deposits                     -                -
Other Assets
Total Other Assets                   $          -     $           -



TOTAL ASSETS                         $          -     $           -
AURANT NAME]
e Sheet Forecast




                                        Current              Forecast
                                        [Current Date]       [Forecast Date]

          LIABILITIES

          Current Liabilities
          Accounts Payable               $-                   $-
          Business Credit Cards          -                    -
          Employee Tips Payable          -                    -
          Sales Tax Payable              -                    -
          Payroll Liabilities            -                    -
          Other Liabilities              -                    -
          Total Current Liabilities     $                -   $                 -

          Long-Term Liabilities
          Car Loan Payable               -                    -
          Business Loan                  -                    -
          Shareholder's Loan             -                    -
          Total Long-Term Liabilities   $                -   $                 -

          EQUITY
          Opening Balance Equity         -                    -
          Capital Stock                  -                    -
          Dividends Paid                 -                    -
          Owners Draw                    -                    -
          Retained Earnings              -                    -
          Total Equity                  $                -   $                 -




          TOTAL LIABILITIES & EQUITY    $                -   $                 -
                          1) Balance Sheets are an important financial document that shows the financial bala
                          company. Financial balance achieved when the company's total assets equal the tot
                          and equity. Often called a "snapshot of a company's finances", a balance sheet sho
                          frequently updated to ensure the company is growing and remains financially balanc

                          2) The example shown consists of a fictional restaurant named "Lucy's Steakhouse".

                          3) Lucy's started out $51,000 business loan that they forecast to pay down to $45,00
                          year.

                          4) Lucy's had an opening balance equity of $12,000 that they expect to keep the sa
                          year.

                          5) The company's capital stock value is expected to increase by a healthy $14,000 b

                          6) Lucy's expects to pay down its business loan, shareholders loan, and car loan by

                          7) In addition, Lucy's expects that its trademark and patents will increase by next y
                                                                                   Lucy's Steakhouse
                                                                                 Balance Sheet Forecast
                                                                                     April 25, 2014

                                             Current                  Forecast
                                            25-Apr-14                25-Apr-15

ASSETS

Current Assets
Checking Account                        $     12,000.00          $     17,000.00
Petty Cash                              $      1,000.00          $      2,000.00
Accounts Receivables                    $      1,500.00          $      1,750.00
Temporary Investments                   $      1,000.00          $      2,250.00
Prepaid Insurance                       $      2,000.00          $      1,000.00
Employee Advances                       $      1,400.00          $      1,200.00
Food Inventory                          $      4,500.00          $      5,000.00
Bar Inventory                           $      1,000.00          $      1,500.00
Total Current Assets                    $     24,400.00          $     31,700.00

Fixed Assets
Furniture and Equipment                 $     50,000.00          $     45,000.00
Computer Equipment                      $      2,500.00          $      2,000.00
Vehicles                                $     10,000.00          $      8,000.00
Buildings                               $     12,000.00          $     14,000.00
Land                                    $     61,000.00          $     68,000.00
Total Fixed Assets                      $    135,500.00          $    137,000.00

Other Assets
Trademarks           $     2,200.00   $     2,500.00
Patents              $     2,200.00   $     3,500.00
Security Deposits    $     2,500.00   $     2,500.00
Other Assets         $     1,200.00   $     1,200.00
Total Other Assets   $     8,100.00   $     9,700.00



TOTAL ASSETS         $   168,000.00   $   178,400.00
t that shows the financial balance of a
ny's total assets equal the total liabilities
 inances", a balance sheet should be
  and remains financially balanced.

nt named "Lucy's Steakhouse".

orecast to pay down to $45,000 by next


at they expect to keep the same by next


crease by a healthy $14,000 by next year.

holders loan, and car loan by next year.

atents will increase by next year.
Lucy's Steakhouse
 lance Sheet Forecast
   April 25, 2014

                                                     Current            Forecast
                                                    25-Apr-14          25-Apr-15

           LIABILITIES

           Current Liabilities
           Accounts Payable                     $       5,000.00   $       7,000.00
           Business Credit Cards                $      15,000.00   $      12,000.00
           Employee Tips Payable                $       8,500.00   $      10,000.00
           Sales Tax Payable                    $       1,200.00   $       1,500.00
           Payroll Liabilities                  $       9,000.00   $      12,000.00
           Other Liabilities                    $       1,500.00   $       2,000.00
           Total Current Liabilities            $      40,200.00   $      44,500.00

           Long-Term Liabilities
           Car Loan Payable                     $       9,000.00   $       8,000.00
           Business Loan                        $      51,000.00   $      45,000.00
           Shareholder's Loan                   $       2,000.00   $         500.00
           Total Long-Term Liabilities          $      62,000.00   $      53,500.00

           EQUITY
           Opening Balance Equity               $      12,000.00   $      12,000.00
           Capital Stock                        $      41,800.00   $      56,500.00
           Dividends Paid                       $       5,000.00   $       5,000.00
           Owners Draw                          $       2,000.00   $       4,500.00
Retained Earnings            $     5,000.00   $     2,400.00
Total Equity                 $    65,800.00   $    80,400.00




TOTAL LIABILITIES & EQUITY   $   168,000.00   $   178,400.00
								
To top