Docstoc

sales chart

Document Sample
sales chart Powered By Docstoc
					                                        Dynamic Charting

                         Income Charts                                                      Forecast Charts


                    Balance Sheet Charts                                                       Ratio Charts


                                              Comprehensive Chart Analysis



This is where you can instantly produce any chart combination that is listed on the spreadsheet in both 3D col
Column/Line graph. There are thousands of possible combinations from the left and right dialog box lists.

You can change any of the "Chart of Accounts" descriptions to suit your accountant's nomenclature.

All charts produced can be copied and pasted into Office Applications. This one worksheet allows you to make
utilizing comparisons between the income statement and the balance sheet.

We advise not changing any of the workbook/worksheets structure. Almost any structure change will cripple th



                                        © Copyright, 2008, The Vickers Company, All Rights Reserved.




                                     © Copyright, 2009, JaxWorks, All Rights Reserved.



                           Please Note: There is No Support For Free Downloads
ting

      Forecast Charts


         Ratio Charts




he spreadsheet in both 3D columns and
and right dialog box lists.

tant's nomenclature.

 worksheet allows you to make charts


structure change will cripple the VBA code.



ghts Reserved.




eserved.



ee Downloads
Step 1

                                                        Master Data Entry Worksheet
                    "C" Corporation (Y/N)
                    If "Y" enter tax percentage
Step 2              Enter Years, Quarters, or Months (Y, Q, or M)
                    If Years enter "Start Year" of Financials


         Income Statement
                                                                                           Month          Month
         Sales & Cost of Sales                                                               1              2
                                 Gross Sales                                                 $25,000        $22,000
                                 Discounts/Allowances                                               $0             $0
                                 Net Sales                                                   $25,000        $22,000
                                 Direct Material Cost                                               $0             $0
                                 Direct Labor Cost                                                  $0             $0
                                 Other Direct Costs                                                 $0             $0
                                 Total Cost of Sales                                                $0             $0

                                                                            Gross Profit     $25,000        $22,000

         Expenses
                                 Fixed Expenses                                              1              2
                                 Executive Salaries                                                  $0             $0
                                 Advertising                                                         $0             $0
                                 Auto & Truck Expenses                                               $0             $0
                                 Depreciation                                                        $0             $0
                                 Employee Benefits                                                   $0             $0
                                 Home Office Business Expenses                                     $263             $0
                                 Insurance                                                       $2,500             $0
                                 Bank Charges                                                        $0             $0
                                 Legal & Professional Services                                       $0             $0
                                 Meals & Entertainment                                               $0             $0
                                 Office Expense                                                  $1,730           $570
                                 Retirement Plans                                                    $0             $0
                                 Rent - Equipment                                                    $0             $0
                                 Rent - Office & Business Property                                 $260           $450
                                 Repairs                                                             $0             $0
                                 Supplies                                                            $0             $0
                                 Taxes - Business & Payroll                                          $0             $0
                                 Travel                                                              $0             $0
                                 Utilities                                                           $0             $0
                                 Other Expenses                                                      $0             $0
                                 Total Fixed Expenses                                            $4,753         $1,020

                                 Variable Expenses                                           1              2
                                 Office salaries                                                 $1,000         $1,284
                                 Employee benefits                                                   $0             $0
                                 Payroll taxes                                                       $0             $0
                                 Sales and Marketing                                                 $0             $0
                                 Telephone and telegraph                                             $0             $0
                                 Stationary and office supplies                                      $0             $0
                                 Bad debts                                                           $0             $0
                                 Postage                                                             $0             $0
                                 Contributions                                                       $0             $0
                                 Add Item                                                            $0             $0
                                 Add Item                                                            $0             $0
                                 Add Item                                                            $0             $0
                                 Add Item                                                            $0             $0
                                 Add Item                                                            $0             $0
                                 Miscellaneous                                                       $0             $0
                                 Total Variable Expenses                                         $1,000         $1,284

                                                                                             1              2
                                 Operating expenses                                              $5,753         $2,304
                                 Interest                                                            $0             $0
                                 Depreciation                                                        $0             $0
                                 Amortization                                                        $0             $0
                                 Other                                                               $0             $0
                                                                       Total expenses            $5,753         $2,304

                                                                     Operating income        $19,247        $19,696

         Other income and expenses                                                           1              2




             © Copyright, 2007, The Vickers Company, All Rights Reserved.
                   Gain (loss) on sale of assets                                  $0        $0
                   Other (net)                                                    $0        $0
                                                                   Subtotal       $0        $0


                                                       Income before tax      $19,247   $19,696

                                                               Income taxes     $962      $985

                                                               Net income     $18,285   $18,711

                                                    Return On Ownership       $18,285   $18,711




© Copyright, 2007, The Vickers Company, All Rights Reserved.
 Balance Sheet
 ASSETS                                                                                 Month        Month
 Current Assets                                                                           1            2
                           Cash and cash equivalents                                            $0           $0
                           Accounts receivable                                                  $0           $0
                           Notes receivable                                                     $0           $0
                           Inventory                                                            $0           $0
                           Other current assets                                                 $0           $0
                                                               Total Current Assets             $0           $0

 Fixed Assets                                                                             1            2
                           Land                                                                 $0           $0
                           Buildings                                                            $0           $0
                           Equipment                                                            $0           $0
                                                                             Subtotal           $0           $0
                           Less-accumulated depreciation                                        $0           $0
                                                                 Total Fixed Assets             $0           $0

 Intangible Assets                                                                        1            2
                           Cost                                                            $90,000           $0
                           Less-accumulated amortization                                        $0           $0
                                                            Total Intangible Assets        $90,000           $0

                                                                     Other assets              $0            $0
                                                                       Total Assets       $90,000            $0


                           LIABILITIES AND STOCKHOLDERS' EQUITY
                                                                                        Month        Month
 Current Liabilities                                                                      1            2
                           Accounts payable                                                     $0           $0
                           Notes payable                                                        $0           $0
                           Current portion of long-term debt                                    $0           $0
                           Income taxes                                                         $0           $0
                           Accrued expenses                                                     $0           $0
                           Other current liabilities                                            $0           $0
                                                           Total Current Liabilities            $0           $0

 Non-Current Liabilities                                                                  1            2
                           Long-term debt                                                       $0           $0
                           Deferred income                                                      $0           $0
                           Deferred income taxes                                                $0           $0
                           Other long-term liabilities                                          $0           $0

                                                                    Total Liabilities           $0           $0

 Stockholders' Equity                                                                     1            2
                           Capital stock issued                                                 $0           $0
                           Number of shares issued                                              $0           $0
                           Additional paid in capital                                           $0           $0
                           Retained earnings                                                    $0           $0
                                                          Total Stockholders' Equity            $0           $0

                                                         Total Liabilities and Equity           $0           $0

                           Amount sheet is out-of-balance                                 $90,000            $0

CASH FLOW DATA ENTRY SECTION
  BALANCE SHEET
  INCOME STATEMENT

                                                                                                                  © Copyright, 2009




     © Copyright, 2007, The Vickers Company, All Rights Reserved.
  Y
 5%
  M
2006



Month          Month          Month             Month             Month              Month             Month        Month        Month
  3              4              5                 6                 7                  8                 9           10           11
  $20,000        $25,000        $30,000             $25,000           $30,000           $22,000                $0           $0           $0
         $0             $0             $0                 $0                $0                $0               $0           $0           $0
  $20,000        $25,000        $30,000             $25,000           $30,000           $22,000                $0           $0           $0
         $0             $0             $0                 $0                $0                $0               $0           $0           $0
         $0             $0             $0                 $0                $0                $0               $0           $0           $0
         $0             $0             $0                 $0                $0                $0               $0           $0           $0
         $0             $0             $0                 $0                $0                $0               $0           $0           $0

  $20,000        $25,000        $30,000             $25,000           $30,000           $22,000                $0           $0           $0


  3              4              5                  6                 7                 8                 9           10           11
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0            $42                 $0               $340                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
        $756            $0            $20                 $0             $7,203            $3,384              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
        $450          $450           $450               $450               $450              $450              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0           $164                 $0               $541                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
          $0            $0             $0                 $0                 $0                $0              $0           $0           $0
      $1,206          $450           $676               $450             $8,534            $3,834              $0           $0           $0

  3              4              5                  6                 7                 8                 9           10           11
      $2,325         $2,370         $2,370             $2,370            $2,370            $2,340              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0           $312                $15               $37               $21              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0               $36                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
          $0             $0             $0                 $0                $0                $0              $0           $0           $0
      $2,325         $2,370         $2,682             $2,385            $2,443            $2,361              $0           $0           $0

  3              4              5                  6                 7                 8                 9           10           11
      $3,531         $2,820         $3,358             $2,835         $10,977              $6,195              $0           $0           $0
          $0             $0             $0                 $0              $0                  $0              $0           $0           $0
          $0             $0             $0                 $0              $0                  $0              $0           $0           $0
          $0             $0             $0                 $0              $0                  $0              $0           $0           $0
          $0             $0             $0                 $0              $0                  $0              $0           $0           $0
      $3,531         $2,820         $3,358             $2,835         $10,977              $6,195              $0           $0           $0

  $16,469        $22,180        $26,642             $22,165           $19,023           $15,805                $0           $0           $0

  3              4              5                  6                 7                 8                 9           10           11




                                        © Copyright, 2007, The Vickers Company, All Rights Reserved.
    $0        $0        $0                $0                $0                $0        $0   $0   $0
    $0        $0        $0                $0                $0                $0        $0   $0   $0
    $0        $0        $0                $0                $0                $0        $0   $0   $0


$16,469   $22,180   $26,642          $22,165           $19,023           $15,805        $0   $0   $0

  $823     $1,109    $1,332           $1,108              $951              $790        $0   $0   $0

$15,646   $21,071   $25,310          $21,057           $18,072           $15,015        $0   $0   $0

$15,646   $21,071   $25,310          $21,057           $18,072           $15,015        $0   $0   $0




                         © Copyright, 2007, The Vickers Company, All Rights Reserved.
Month             Month             Month             Month             Month              Month             Month        Month        Month
  3                 4                 5                 6                 7                  8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

  3                 4                  5                 6                 7                 8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

  3                 4                  5                 6                 7                 8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0



Month             Month             Month             Month             Month              Month             Month        Month        Month
  3                 4                 5                 6                 7                  8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

  3                 4                  5                 6                 7                 8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

        $0                $0                 $0                $0                $0                $0                $0           $0           $0

  3                 4                  5                 6                 7                 8                 9           10           11
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0
        $0                $0                 $0                $0                $0                $0                $0           $0           $0

        $0                $0                 $0                $0                $0                $0                $0           $0           $0

        $0                $0                 $0                $0                $0                $0                $0           $0           $0




© Copyright, 2009, JaxWorks, All Rights Reserved.




                                              © Copyright, 2007, The Vickers Company, All Rights Reserved.
             BE Chart 1                                                          Sales         Fixed      F+V        Total Cost   BE Chart 2
             Sales $                      $25,000              0                     #REF!       $4,753         $0       $4,753   Sales $
             Fixed $                       $4,753              1                    $2,083       $4,753    #REF!         #REF!    Fixed $
             Total Variable $                 $0               2                    $4,167       $4,753    #REF!         #REF!    Total Variable $
                                                              12                   $25,000       $4,753    #REF!         #REF!



Month
 12
        $0
        $0
        $0
        $0
        $0
        $0
        $0

        $0


 12
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0

 12
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0
        $0

 12
        $0
        $0
        $0
        $0
        $0
        $0

        $0

 12




                                © Copyright, 2007, The Vickers Company, All Rights Reserved.
$0
$0
$0


$0

$0

$0

$0




     © Copyright, 2007, The Vickers Company, All Rights Reserved.
Month
 12
        $0   0
        $0
        $0
        $0
        $0
        $0

 12
        $0
        $0
        $0
        $0
        $0
        $0

 12
        $0
        $0
        $0

        $0
        $0



Month
 12
        $0
        $0
        $0
        $0
        $0
        $0
        $0

 12
        $0
        $0
        $0
        $0

        $0

 12
        $0
        $0
        $0
        $0
        $0

        $0

        $0




                 © Copyright, 2007, The Vickers Company, All Rights Reserved.
BE Chart 2                  Sales      Fixed      F+V        Total Cost          BE Chart 3                            Sales      Fixed      F+V        Total Cost
             $22,000   0      #REF!      $1,020         $0       $1,020         Sales $            $20,000   0           #REF!      $1,206         $0       $1,206
              $1,020   1      $1,833     $1,020    #REF!         #REF!          Fixed $             $1,206   1           $1,667     $1,206    #REF!         #REF!
                 $0    2      $3,667     $1,020    #REF!         #REF!          Total Variable $       $0    2           $3,333     $1,206    #REF!         #REF!
                       12    $22,000     $1,020    #REF!         #REF!                                       12         $20,000     $1,206    #REF!         #REF!




                                                        © Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
BE Chart 4                        Sales      Fixed        F+V        Total Cost         BE Chart 5                        Sales      Fixed     F+V        Total Cost
Sales $            $25,000   0      #REF!       $450            $0         $450         Sales $            $30,000   0      #REF!       $676         $0         $676
Fixed $              $450    1      $2,083      $450         #REF!       #REF!          Fixed $              $676    1      $2,500      $676    #REF!         #REF!
Total Variable $       $0    2      $4,167      $450         #REF!       #REF!          Total Variable $       $0    2      $5,000      $676    #REF!         #REF!
                             12    $25,000      $450         #REF!       #REF!                                       12    $30,000      $676    #REF!         #REF!




                                                     © Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
BE Chart 6                        Sales        Fixed      F+V        Total Cost         BE Chart 7                        Sales      Fixed      F+V
Sales $            $25,000   0      #REF!          $450         $0         $450         Sales $            $30,000   0      #REF!      $8,534         $0
Fixed $              $450    1      $2,083         $450      #REF!       #REF!          Fixed $             $8,534   1      $2,500     $8,534    #REF!
Total Variable $       $0    2      $4,167         $450      #REF!       #REF!          Total Variable $       $0    2      $5,000     $8,534    #REF!
                             12    $25,000         $450      #REF!       #REF!                                       12    $30,000     $8,534    #REF!




                                          © Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
Total Cost   BE Chart 8                             Sales      Fixed      F+V        Total Cost         BE Chart 9                   Sales        Fixed
    $8,534   Sales $            $22,000   0            #REF!     $3,834         $0       $3,834         Sales $            $0   0      #REF!              $0
    #REF!    Fixed $             $3,834   1           $1,833     $3,834      #REF!       #REF!          Fixed $            $0   1            $0           $0
    #REF!    Total Variable $       $0    2           $3,667     $3,834      #REF!       #REF!          Total Variable $   $0   2            $0           $0
    #REF!                                 12         $22,000     $3,834      #REF!       #REF!                                  12           $0           $0




                                               © Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
F+V        Total Cost   BE Chart 10                        Sales        Fixed        F+V        Total Cost   BE Chart 11                  Sales
      $0           $0   Sales $            $0     0           #REF!             $0         $0           $0   Sales $            $0   0      #REF!
 #REF!         #REF!    Fixed $            $0     1                $0           $0    #REF!         #REF!    Fixed $            $0   1            $0
 #REF!         #REF!    Total Variable $   $0     2                $0           $0    #REF!         #REF!    Total Variable $   $0   2            $0
 #REF!         #REF!                              12               $0           $0    #REF!         #REF!                            12           $0




                                           © Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
© Copyright, 2007, The Vickers Company, All Rights Reserved.
Fixed        F+V        Total Cost           BE Chart 12                        Sales         Fixed        F+V        Total Cost
        $0         $0           $0          Sales $            $0      0          #REF!               $0         $0           $0
        $0    #REF!         #REF!           Fixed $            $0      1                $0            $0    #REF!         #REF!
        $0    #REF!         #REF!           Total Variable $   $0      2                $0            $0    #REF!         #REF!
        $0    #REF!         #REF!                                      12               $0            $0    #REF!         #REF!




                               © Copyright, 2007, The Vickers Company, All Rights Reserved.
Dynamic Income Statement Charts
    Dynamic Charts Index

                            Sales and Gross Profit
      30,000

      25,000

      20,000

      15,000

      10,000

       5,000

            0
                 1     2    3    4     5      6     7      8     9   10   11   12

                        Sales                       Gross Profit




From Financial Statement             1                  2            3              4        5
Sales                                25,000             22,000       20,000         25,000   30,000
Discounts/Allowances                      0                  0            0              0        0
Net Sales                            25,000             22,000       20,000         25,000   30,000
Direct Material Cost                      0                  0            0              0        0
Direct Labor Cost                         0                  0            0              0        0
Other Direct Costs                        0                  0            0              0        0
Total Cost of Sales                       0                  0            0              0        0
Gross Profit                         25,000             22,000       20,000         25,000   30,000
Total Fixed Expenses                  4,753              1,020        1,206            450      676
Total Variable Expenses               1,000              1,284        2,325          2,370    2,682
Total Expenses                        5,753              2,304        3,531          2,820    3,358
Operating income                     19,247             19,696       16,469         22,180   26,642
Income Before Tax                    19,247             19,696       16,469         22,180   26,642
Income Taxes                            962                985          823          1,109    1,332
Net Income                           18,285             18,711       15,646         21,071   25,310

© Copyright, 2009, JaxWorks, All Rights Reserved.




                     © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.
6        7            8            9           10           11        12
25,000   30,000       22,000            0           0             0        0
     0        0            0            0           0             0        0
25,000   30,000       22,000            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
25,000   30,000       22,000            0           0             0        0
   450    8,534        3,834            0           0             0        0
 2,385    2,443        2,361            0           0             0        0
 2,835   10,977        6,195            0           0             0        0
22,165   19,023       15,805            0           0             0        0
22,165   19,023       15,805            0           0             0        0
 1,108      951          790            0           0             0        0
21,057   18,072       15,015            0           0             0        0




         © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Dynamic Balance Sheet Charts
    Dynamic Charts Index

           Total Current Assets and Total Current Liabilities
          1                                                                            1
          1                                                                            1
          1                                                                            1
          1                                                                            1
          1                                                                            1
          1                                                                            1
          0                                                                            0
          0                                                                            0
          0                                                                            0
          0                                                                            0
          0                                                                            0
                1      2     3    4    5    6   7   8       9   10   11       12

                    Total Current Assets            Total Current Liabilities




From Financial Statement                   1            2                 3                4       5
Total Current Assets                            0               0                  0           0       0
Total Fixed Assets                              0               0                  0           0       0
Total Intangible Assets                    90,000               0                  0           0       0
Other assets                                    0               0                  0           0       0
Total Assets                               90,000               0                  0           0       0
Total Current Liabilities                       0               0                  0           0       0
Non-Current Liabilities                         0               0                  0           0       0
Total Liabilities                               0               0                  0           0       0
Total Stockholders' Equity                      0               0                  0           0       0
Total Liabilities and Equity                    0               0                  0           0       0

© Copyright, 2009, JaxWorks, All Rights Reserved.




                       © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.
6        7           8            9           10           11        12
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0
    0        0            0            0           0             0        0




        © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
© Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Dynamic Projected Forecast Charts
   Dynamic Charts Index

                        Sales and Total Cost of Sales
      25,000


      20,000


      15,000


      10,000


       5,000


            0
                 1      2     3   4    5       6       7      8     9    10   11   12

                      Sales                        Total Cost of Sales




From Financial Statement              1                    2              3          4        5
Sales                                 25,000               22,000        20,000     25,000   22,500
Discounts/Allowances                       0                    0             0          0        0
Net Sales                             25,000               22,000        20,000     25,000   22,500
Direct Material Cost                       0                    0             0          0        0
Direct Labor Cost                          0                    0             0          0        0
Other Direct Costs                         0                    0             0          0        0
Total Cost of Sales                        0                    0             0          0        0
Gross Profit                          25,000               22,000        20,000     25,000   22,500
Total Fixed Expenses                   4,753                1,020         1,206        450   (1,324)
Total Variable Expenses                1,000                1,284         2,325      2,370    3,033
Total Expenses                         5,753                2,304         3,531      2,820    1,709
Operating income                      19,247               19,696        16,469     22,180   20,791
Income Before Tax                     19,247               19,696        16,469     22,180   20,791
Income Taxes                             962                  985           823      1,109    1,040
Net Income                            18,285               18,711        15,646     21,071   19,751

© Copyright, 2009, JaxWorks, All Rights Reserved.




                     © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
 6        7           8            9            10           11          12
22,300    22,100      21,900       21,700       21,500       21,300      21,100
     0         0           0            0             0            0           0
22,300    22,100      21,900       21,700       21,500       21,300      21,100
     0         0           0            0             0            0           0
     0         0           0            0             0            0           0
     0         0           0            0             0            0           0
     0         0           0            0             0            0           0
22,300    22,100      21,900       21,700       21,500       21,300      21,100
(2,596)   (3,868)     (5,140)      (6,413)       (7,685)      (8,957)   (10,230)
 3,548     4,063       4,578        5,093         5,608        6,123       6,638
   952       195        (563)      (1,320)       (2,077)      (2,834)     (3,591)
21,348    21,905      22,463       23,020       23,577       24,134      24,691
21,348    21,905      22,463       23,020       23,577       24,134      24,691
 1,067     1,095       1,123        1,151         1,179        1,207       1,235
20,281    20,810      21,339       21,869       22,398       22,927      23,457




          © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Dynamic Ratios Charts
   Dynamic Charts Index


                     Current Ratio and Equity Ratio
 1.000                                                                       100.00%
 0.900                                                                       90.00%
 0.800                                                                       80.00%
 0.700                                                                       70.00%
 0.600                                                                       60.00%
 0.500                                                                       50.00%
 0.400                                                                       40.00%
 0.300                                                                       30.00%
 0.200                                                                       20.00%
 0.100                                                                       10.00%
 0.000                                                                       0.00%
          1    2     3       4   5       6   7   8   9     10    11     12

                         Current Ratio                   Equity Ratio




Ratios                                 1           2              3            4           5
Gross Profit Margin                   100.00%     100.00%        100.00%      100.00%     100.00%
Net Profit Margin                      73.14%      85.05%         78.23%       84.28%      84.37%
Return on Assets (ROA)                 21.39%    #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Return on Equity (ROE)               #DIV/0!     #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Current Ratio                        #DIV/0!     #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Quick Ratio                          #DIV/0!     #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Debt Ratio                              0.00%    #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Equity Ratio                            0.00%    #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
Earnings/Share (EPS) Ratio           #DIV/0!     #DIV/0!        #DIV/0!      #DIV/0!     #DIV/0!
From Financial Statement               1           2              3            4           5
Number of shares issued                      0           0              0            0           0
Inventory                                    0           0              0            0           0
Sales                                  25,000      22,000         20,000       25,000      30,000
Total Cost of Sales                          0           0              0            0           0
Income Before Tax                      19,247      19,696         16,469       22,180      26,642
Net Income                             18,285      18,711         15,646       21,071      25,310
Total Assets                           90,000            0              0            0           0
Total Current Assets                         0           0              0            0           0
Total Assets                           90,000            0              0            0           0
Total Current Liabilities                    0           0              0            0           0
Total Liabilities                            0           0              0            0           0



                   © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Total Stockholders' Equity                0            0            0         0   0

© Copyright, 2009, JaxWorks, All Rights Reserved.




                     © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
  6           7           8           9             10            11            12
 100.00%     100.00%     100.00%    #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
  84.23%      60.24%      68.25%    #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
#DIV/0!     #DIV/0!     #DIV/0!     #DIV/0!       #DIV/0!       #DIV/0!       #DIV/0!
  6           7           8           9             10            11            12
        0           0           0             0             0             0             0
        0           0           0             0             0             0             0
  25,000      30,000      22,000              0             0             0             0
        0           0           0             0             0             0             0
  22,165      19,023      15,805              0             0             0             0
  21,057      18,072      15,015              0             0             0             0
        0           0           0             0             0             0             0
        0           0           0             0             0             0             0
        0           0           0             0             0             0             0
        0           0           0             0             0             0             0
        0           0           0             0             0             0             0



             © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
0        0            0            0           0             0   0




    © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Dynamic Comprehensive Chart Analysis
   Dynamic Charts Index


                  Net income and Retained earnings
    30,000                                                                1
                                                                          1
    25,000                                                                1
    20,000                                                                1
                                                                          1
    15,000                                                                1
                                                                          0
    10,000                                                                0
     5,000                                                                0
                                                                          0
         0                                                                0
              1   2    3    4   5    6   7   8      9     10   11    12

                   Net income                    Retained earnings




From Financial Statement            1            2              3             4        5
Sales                               25,000       22,000         20,000        25,000   30,000
Discounts/Allowances                     0            0              0             0        0
Net Sales                           25,000       22,000         20,000        25,000   30,000
Direct Material Cost                     0            0              0             0        0
Direct Labor Cost                        0            0              0             0        0
Other Direct Costs                       0            0              0             0        0
Total Cost of Sales                      0            0              0             0        0
Gross Profit                        25,000       22,000         20,000        25,000   30,000
Executive Salaries                       0            0              0             0        0
Advertising                              0            0              0             0        0
Auto & Truck Expenses                    0            0              0             0        0
Depreciation                             0            0              0             0        0
Employee Benefits                        0            0              0             0       42
Home Office Business Expenses          263            0              0             0        0
Insurance                            2,500            0              0             0        0
Bank Charges                             0            0              0             0        0
Legal & Professional Services            0            0              0             0        0
Meals & Entertainment                    0            0              0             0        0
Office Expense                       1,730          570            756             0       20
Retirement Plans                         0            0              0             0        0
Rent - Equipment                         0            0              0             0        0



                  © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Rent - Office & Business Property      260          450         450             450      450
Repairs                                  0            0           0               0        0
Supplies                                 0            0           0               0        0
Taxes - Business & Payroll               0            0           0               0        0
Travel                                   0            0           0               0      164
Utilities                                0            0           0               0        0
Other Expenses                           0            0           0               0        0
Add Item                                 0            0           0               0        0
Add Item                                 0            0           0               0        0
Miscellaneous                            0            0           0               0        0
Total Fixed Expenses                 4,753        1,020       1,206             450      676
Office salaries                      1,000        1,284       2,325           2,370    2,370
Employee benefits                        0            0           0               0        0
Payroll taxes                            0            0           0               0        0
Sales and Marketing                      0            0           0               0        0
Telephone and telegraph                  0            0           0               0        0
Stationary and office supplies           0            0           0               0      312
Bad debts                                0            0           0               0        0
Postage                                  0            0           0               0        0
Contributions                            0            0           0               0        0
Add Item                                 0            0           0               0        0
Add Item                                 0            0           0               0        0
Add Item                                 0            0           0               0        0
Add Item                                 0            0           0               0        0
Add Item                                 0            0           0               0        0
Miscellaneous                            0            0           0               0        0
Total Variable Expenses              1,000        1,284       2,325           2,370    2,682
Operating expenses                   5,753        2,304       3,531           2,820    3,358
Interest                                 0            0           0               0        0
Depreciation                             0            0           0               0        0
Amortization                             0            0           0               0        0
Other                                    0            0           0               0        0
Total expenses                       5,753        2,304       3,531           2,820    3,358
Operating income                    19,247       19,696      16,469          22,180   26,642
Gain (loss) on sale of assets            0            0           0               0        0
Other (net)                              0            0           0               0        0
Subtotal                                 0            0           0               0        0
Income before tax                   19,247       19,696      16,469          22,180   26,642
Income taxes                           962          985         823           1,109    1,332
Net income                          18,285       18,711      15,646          21,071   25,310
Cash and cash equivalents                0            0           0               0        0
Accounts receivable                      0            0           0               0        0
Notes receivable                         0            0           0               0        0
Inventory                                0            0           0               0        0
Other current assets                     0            0           0               0        0
Total Current Assets                     0            0           0               0        0
Land                                     0            0           0               0        0
Buildings                                0            0           0               0        0
Equipment                                0            0           0               0        0
Subtotal                                 0            0           0               0        0
Less-accumulated depreciation            0            0           0               0        0
Total Fixed Assets                       0            0           0               0        0


                    © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Cost                                 90,000            0           0          0   0
Less-accumulated amortization             0            0           0          0   0
Total Intangible Assets              90,000            0           0          0   0
Other assets                              0            0           0          0   0
Total Assets                         90,000            0           0          0   0
Accounts payable                          0            0           0          0   0
Notes payable                             0            0           0          0   0
Current portion of long-term debt         0            0           0          0   0
Income taxes                              0            0           0          0   0
Accrued expenses                          0            0           0          0   0
Other current liabilities                 0            0           0          0   0
Total Current Liabilities                 0            0           0          0   0
Long-term debt                            0            0           0          0   0
Deferred income                           0            0           0          0   0
Deferred income taxes                     0            0           0          0   0
Other long-term liabilities               0            0           0          0   0
Total Liabilities                         0            0           0          0   0
Capital stock issued                      0            0           0          0   0
Number of shares issued                   0            0           0          0   0
Additional paid in capital                0            0           0          0   0
Retained earnings                         0            0           0          0   0
Total Stockholders' Equity                0            0           0          0   0
Total Liabilities and Equity              0            0           0          0   0

© Copyright, 2009, JaxWorks, All Rights Reserved.




                     © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
6        7            8            9           10           11        12
25,000   30,000       22,000            0           0             0        0
     0        0            0            0           0             0        0
25,000   30,000       22,000            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
25,000   30,000       22,000            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0      340            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0
     0    7,203        3,384            0           0             0        0
     0        0            0            0           0             0        0
     0        0            0            0           0             0        0



         © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
   450      450          450            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0      541            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
   450    8,534        3,834            0           0             0   0
 2,370    2,370        2,340            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
    15       37           21            0           0             0   0
     0        0            0            0           0             0   0
     0       36            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
 2,385    2,443        2,361            0           0             0   0
 2,835   10,977        6,195            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
 2,835   10,977        6,195            0           0             0   0
22,165   19,023       15,805            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
22,165   19,023       15,805            0           0             0   0
 1,108      951          790            0           0             0   0
21,057   18,072       15,015            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0
     0        0            0            0           0             0   0


         © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0
0        0            0            0           0             0   0




    © Copyright, 1996-2004, JaxWorks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass
documents, that cover a number of financial, accounting and sales functions. These are invalua

Also included Free are:
   - business plan tools, including spreadsheets and excellent instructions
   - Excel functions glossary and guide;
   - free training courses for most Microsoft Office applications. These guides are in
     PDF format and rival commercial books!
   - comprehensive list of acronyms, ratios and formulas in customer financial
     analysis, and financial terms;
   - suite of online calculators, including, breakeven analysis, productivity analysis,
     business evaluation;
   - Altman Z-Score (covering publicly and privately held firms, and small
     businesses);
   - and payroll analysis.

If you are involved in financial analysis at any level, or want to learn more about MS Excel and o
suite this site is invaluable.




                                              JaxWorks Small Business Spreadsheet Factory
 preadsheets, and associated MS Word, PDF and HTML
ons. These are invaluable small business tools.




ides are in



 analysis,




 about MS Excel and other applications in the Office




sheet Factory
                                                                   Copyright Notice
© 2009, JaxWorks
All rights reserved.
Specifications are subject to change without notice.

The Consultant ™ is a registered trademark of The Vickers Company and affiliated companies. All other brands or products are trademarks or registere
their respective holders and should be treated as such.


NOTICES REGARDING SOFTWARE, DOCUMENTS AND SERVICES.

IN NO EVENT SHALL THE VICKERS COMPANY BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
WHATSOEVER RESULTING FROM LOSS OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TO
ACTION, ARISING OUT OF OR IN CONNECTION WITH THE USE OR PERFORMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILU
PROVIDE SERVICES, OR INFORMATION AVAILABLE FROM THIS PROGRAM.




      © Copyright, 2007, The Vickers Company, All Rights Reserved.
                         Copyright Notice


 t notice.

k of The Vickers Company and affiliated companies. All other brands or products are trademarks or registered trademarks of
 ed as such.


CUMENTS AND SERVICES.

MPANY BE LIABLE FOR ANY SPECIAL, INDIRECT OR CONSEQUENTIAL DAMAGES OR ANY DAMAGES
S OF USE, DATA OR PROFITS, WHETHER IN AN ACTION OF CONTRACT, NEGLIGENCE OR OTHER TORTIOUS
ECTION WITH THE USE OR PERFORMANCE OF SOFTWARE, DOCUMENTS, PROVISION OF OR FAILURE TO
 AVAILABLE FROM THIS PROGRAM.




                                                                © Copyright, 2007, The Vickers Company, All Rights Reserved.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:15
posted:6/7/2012
language:English
pages:51