home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload / ShartewareOverload.cdr / finance / solvedoc.zip / BUDGET.RPT < prev    next >
Text File  |  1991-02-10  |  9KB  |  187 lines
  1.  
  2.  
  3.  
  4.  
  5.  
  6.  
  7.  
  8.  
  9.                  ==================================================
  10.                                        BUDGET
  11.  
  12.                       For:                Robert Smith, Jr.
  13.                       Initial Cash Balance:        2,000.00
  14.                       As of:                        2/10/91
  15.                  ==================================================
  16.  
  17.  
  18.  
  19.  
  20.               (** This is a sample with just the month of February **)
  21.                  (** We put these comments here with an editor **)
  22.           (** Remember, YOU can change the description of any category **)
  23.        (** When printed within SOLVEIT!, budget fits on ONE PAGE per MONTH **)
  24.  
  25.  
  26.  
  27.  
  28.  
  29.  
  30.  
  31.  
  32.  
  33.  
  34.  
  35.  
  36.  
  37.  
  38.  
  39.  
  40.  
  41.  
  42.                  Prepared By :                        I.M. Smart
  43.                             BUDGET FOR THE MONTH OF FEB 
  44.  
  45.      INCOME/RECEIPTS              BUDGETED    % INC         ACTUAL    % BUD
  46.      _______________              ________    _____         ______    _____
  47.        Salaries:                  4,500.00     89.1       5,000.00    111.1
  48.        Pensions, Allowances:          0.00      0.0           0.00      0.0
  49.        Interest Income:             300.00      5.9         300.00    100.0
  50.        Real Estate Income:          250.00      5.0         200.00     80.0
  51.        Other Income:                  0.00      0.0           0.00      0.0
  52.        Loan Advances:                 0.00      0.0           0.00      0.0
  53.      MONTHLY INCOME:              5,050.00    100.0       5,500.00    108.9
  54.      ======================================================================
  55.  
  56.      EXPENSES/PAYMENTS            BUDGETED    % INC         ACTUAL    % BUD
  57.     _________________            ________    _____         ______    _____
  58.        Mortgage/Rent Payment:       750.00     14.9         750.00    100.0
  59.        House Taxes:                   0.00      0.0           0.00      0.0
  60.        House Insurance:             345.00      6.8         345.00    100.0
  61.        Electric, Gas & Water:       115.00      2.3         145.00    126.1
  62.        Telephone:                    65.00      1.3          75.00    115.4
  63.        Home Maintenance:            300.00      5.9         225.00     75.0
  64.        Furniture, Appliances:         0.00      0.0         135.00    ***.*
  65.      Shelter:                     1,575.00     31.2       1,675.00    106.3
  66.  
  67.        Car Payments:                350.00      6.9         350.00    100.0
  68.        Gas & Oil:                    75.00      1.5          65.00     86.7
  69.        Car Ins., Lic., Etc.:         85.00      1.7           0.00      0.0
  70.        Repairs & Maintenance:        75.00      1.5           0.00      0.0
  71.        Bus, Taxi, Park, Etc.:         0.00      0.0           0.00      0.0
  72.      Transportation:                585.00     11.6         415.00     70.9
  73.  
  74.        Health Insurance:              0.00      0.0           0.00      0.0
  75.        Medicine, Glasses Etc:        50.00      1.0          65.00    130.0
  76.        Doctor, Dentist Fees:         50.00      1.0          45.00     90.0
  77.        Personal Grooming:            35.00      0.7          40.00    114.3
  78.      Health/Personal Care:          135.00      2.7         150.00    111.1
  79.  
  80.        Groceries:                   350.00      6.9         375.00    107.1
  81.        Restaurant Meals:             75.00      1.5          70.00     93.3
  82.        Clothing/Laundry:             50.00      1.0          50.00    100.0
  83.      Food & Clothing:               475.00      9.4         495.00    104.2
  84.  
  85.        Vacation & Travel:           125.00      2.5         125.00    100.0
  86.        Club Membership Fees:         20.00      0.4           0.00      0.0
  87.        Movie/Show/Sport Etc.:        30.00      0.6          27.00     90.0
  88.        Entertaining:                 40.00      0.8          50.00    125.0
  89.        Education, Books:             25.00      0.5          30.00    120.0
  90.        Babysitting & Care:           30.00      0.6          25.00     83.3
  91.      Recreation/Education:          270.00      5.3         257.00     95.2
  92.  
  93.        Life Insurance:               30.00      0.6           0.00      0.0
  94.        Loan Payments:               300.00      5.9         275.00     91.7
  95.        Charitable Gifts:             35.00      0.7          35.00    100.0
  96.        Liquor & Cigarettes:           0.00      0.0           0.00      0.0
  97.        Miscellaneous:                50.00      1.0          50.00    100.0
  98.        Savings, I.R.A.'s Etc:       150.00      3.0         150.00    100.0
  99.      Other Expenses:                565.00     11.2         510.00     90.3
  100.      MONTHLY EXPENSES:            3,605.00     71.4       3,502.00     97.1
  101.      ======================================================================
  102.      SURPLUS/DEFICIT (-)          1,445.00                1,998.00
  103.      ======================================================================
  104.  
  105.  
  106.  
  107.                            B U D G E T   S U M M A R Y
  108.                            INCOME AND EXPENSE ANALYSIS
  109.  
  110.  
  111.                                                                      Actual vs
  112.      INCOME (excluding loan advances)   Projected          Actual    Projected
  113.      Salaries:                           4,500.00        5,000.00         111%
  114.      Pensions, Allowances:                   0.00            0.00           0
  115.      Interest Income:                      300.00          300.00         100
  116.      Real Estate Income:                   250.00          200.00          80
  117.      Other Income:                           0.00            0.00           0
  118.      TOTAL INCOME:                       5,050.00        5,500.00         109
  119.  
  120.  
  121.                                                                      Actual vs
  122.      EXPENSES (excluding savings)       Projected          Actual    Projected
  123.      Shelter:                            1,575.00        1,675.00         106
  124.      Transportation:                       585.00          415.00         104
  125.      Health/Personal Care:                 135.00          150.00         111
  126.      Food & Clothing:                      475.00          495.00          71
  127.      Recreation/Education:                 270.00          257.00          95
  128.      Other Expenses:                       415.00          360.00          87
  129.      TOTAL EXPENSES:                     3,455.00        3,352.00          97
  130.  
  131.  
  132.  
  133.  
  134.                           PROJECTED CASH FLOW ANALYSIS
  135.  
  136.  
  137.                      Cash           Cash           Monthly                   
  138.      Month         Inflows        Outflows       Difference          Balance 
  139.                                            Initial Balance:         2,000.00
  140.        FEB        5,050.00        3,605.00         1,445.00         3,445.00
  141.        MAR            0.00            0.00             0.00         3,445.00
  142.        APR            0.00            0.00             0.00         3,445.00
  143.        MAY            0.00            0.00             0.00         3,445.00
  144.       JUNE            0.00            0.00             0.00         3,445.00
  145.       JULY            0.00            0.00             0.00         3,445.00
  146.        AUG            0.00            0.00             0.00         3,445.00
  147.        SEP            0.00            0.00             0.00         3,445.00
  148.        OCT            0.00            0.00             0.00         3,445.00
  149.        NOV            0.00            0.00             0.00         3,445.00
  150.        DEC            0.00            0.00             0.00         3,445.00
  151.        JAN            0.00            0.00             0.00         3,445.00
  152.  
  153.  
  154.  
  155.  
  156.                            ACTUAL CASH FLOW ANALYSIS
  157.  
  158.  
  159.                      Cash           Cash           Monthly                   
  160.      Month         Inflows        Outflows       Difference          Balance 
  161.                                            Initial Balance:         2,000.00
  162.        FEB        5,500.00        3,502.00         1,998.00         3,998.00
  163.        MAR            0.00            0.00             0.00         3,998.00
  164.        APR            0.00            0.00             0.00         3,998.00
  165.        MAY            0.00            0.00             0.00         3,998.00
  166.       JUNE            0.00            0.00             0.00         3,998.00
  167.       JULY            0.00            0.00             0.00         3,998.00
  168.        AUG            0.00            0.00             0.00         3,998.00
  169.        SEP            0.00            0.00             0.00         3,998.00
  170.        OCT            0.00            0.00             0.00         3,998.00
  171.        NOV            0.00            0.00             0.00         3,998.00
  172.        DEC            0.00            0.00             0.00         3,998.00
  173.        JAN            0.00            0.00             0.00         3,998.00
  174.  
  175.  
  176.  
  177.  
  178.  
  179.                             SAVINGS AND LOAN SUMMARY
  180.  
  181.  
  182.                   Actual Regular Savings:                150.00
  183.                   Actual Loan Advances:                    0.00
  184.                   Projected Regular Savings:             300.00
  185.                   Projected Loan Advances:                 0.00
  186.  
  187.