Docstoc

Projected Balance Sheet and Income Statement with Guide

Document Sample
Projected Balance Sheet and Income Statement with Guide Powered By Docstoc
					Projected Balance Sheet
         This template spreadsheet is designed to provide the user with the fundamental
         elements of a projected balance sheet. A Projected Balance Sheet is a
         forecasted statement of the total assets and liabilities of an organization at a
         particular date (monthly, yearly, or any period as preferred by the business
         owner). The estimated entries are then substituted with the actual values as they
         happen.

         When used properly, this should allow the user to identify the following:
          - total assets of the company (monetary and material)
          - risk of bankruptcy
          - if the business is generating income
          - feasibility of business expansion

         This template consist of two tabs: Income Statement and the actual Balance
         Sheet.

         The Income Statement defines how much a business has actually earned. It is
         the difference between the money received from the sale of products/services
         and the total expenses of the company. (Net Income = Revenue – Expenses)

         Note: For instructions on how to utilize the template, refer to the Income
         Statement and Balance Sheet tabs.




© Copyright 2013 Docstoc Inc.
                  [JOHN DOE ADVERTISING COMPANY]
                           INCOME STATEMENT
                    For the Month Ended [Januay 31, 2011]

Advertising Fees                                 $   4,400.00                  << This section contains the money received as payment for the sale of products or for certain
Art Fees                                               400.00                  services. Add as many payment entries as needed.
            Gross Income                                        $   4,800.00   << This section contains the total amount (sum) of all the received payments.

Less: Operating Expenses
          Salaries                                   1,380.00                  << This section lists all operating expenses (amount of money spent) for the company. Add the
          Art and Office Supplies Expense              700.00                  necessary rows/entries as needed.
          Rent Expense                                 400.00
          Utility Expense                              100.00
          Telephone                                     70.00
          Depreciation                                 120.00
          Insurance                                     40.00
                                                                $   2,810.00   << This section contains the total amount (sum) of all operating expenses.
                                                                               << This section contains the difference between the gross income and the total operating expenses.
Net Income                                                      $   1,990.00




© Copyright 2011 Docstoc Inc.
                    [JOHN DOE ADVERTISING COMPANY]
                            BALANCE SHEET
                                [1/31/2011]

                                  CURRENT ASSETS

Cash                                               $    1,720.00                   << This section contains all monetary assets. This may be cash-on-hand or any amount that is
Accounts Receivable                                     2,800.00                   about to be received by the company. Modify/add as many entries as needed.
Accrued Fees Receivables                                  200.00
Inventories: Art and Office Supplies                    1,900.00
Pre-paid Insurance                                        440.00
Pre-paid Rent                                             400.00
                                                                   $    7,460.00   << This section contains the total amount (sum) of all the monetary assets.

Properties and Equipment
           Art Equipment                           $    4,200.00                   << This section contains a list of equipment with its monetary value less the corresponding
           Less: Accumulated Depreciation                  70.00                   accumulated depreciation. Modify/add as many entries as needed.
                                                        4,130.00

              Office Equipment                     $    3,000.00
              Less: Accumulated Depreciation               50.00
                                                                                   << The total amount (sum) of material assets (properties and equipment) with all depreciations
                                                        2,950.00 $      7,080.00   accounted for (subtracted).
Total Assets                                                     $     14,540.00   << The total amount (sum) of all monetary and material assets.

                           LIABILITIES AND NETWORTH

Liabilities
              Accounts Payable                     $    3,170.00                   << This section contains all of the company's liabilities. It should list all payables and payments
              Wages Payable                               180.00                   received in advance (where no service or product has been given to the customer).
              Unearned Art Fees                           600.00
                                                                   $    3,950.00   << The total amount (sum) of all the liability entries.

Net Worth
              Capital                              $   10,000.00                   << The company's capital less any withdrawals made.
              Less: Withdrawal                          1,400.00
              Net Capital                               8,600.00                   << This section contains the difference between the capital and the withdrawal.

                                                                                   << The net income as defined in the income statement (G38).
           Add: Net Income                         $    1,990.00 $     10,590.00   << This section contains the sum of the net capital and net income (I38).
Total Liabilities and Net Worth                                  $     14,540.00   << This section contains the total amount of the liabilities and net worth.

                                                                                   Note: The amount of total assets should be equal to the amount of total liabilites and net worth.




© Copyright 2011 Docstoc Inc.
				
DOCUMENT INFO
Shared By:
Tags:
Stats:
views:651
posted:11/3/2011
language:English
pages:3
Description: This template spreadsheet provides companies with a projected balance sheet and income statement. A Projected Balance Sheet is a forecasted statement of the total assets and liabilities of an organization at a particular point in time. An income statement, also known as a profit and loss statement, is a financial statement that summarizes a company's revenues and expenses over a specified period of time. An income statement allows managers to see a company's net income (the bottom line) once costs, expenses, and taxes have been taken out of revenues (top line). Both financial statements contain instructions, helping users indentify the values that should be entered into each worksheet.
This document is also part of a package Small Business Essential Documents 36 Documents Included