Docstoc

Quarterly Cash Flow Projection The ABC Corporation

Document Sample
Quarterly Cash Flow Projection The ABC Corporation Powered By Docstoc
					                                        Quarterly Cash Flow Projection
                                                                The ABC Corporation
                                                                 First Quarter, 2006
                                                  JANUARY                                    FEBRUARY                                 MARCH
            Cash Received             Estimate     Actual     Variance          Estimate       Actual       Variance      Estimate    Actual     Variance
Beginning Cash Balance                  $52,552     $54,530     ($1,978)          $36,247       $42,762       ($6,515)      $33,469    $38,955     ($5,486)
Cash Sales                               23,821      25,485       (1,664)          23,819        26,468         (2,649)      25,443     26,780       (1,337)
Collections                              59,014      61,001       (1,987)          62,394        63,666         (1,272)      73,702     69,487        4,215
Loans                                    15,121      18,452       (3,331)          12,329        19,109         (6,780)      14,513     19,452       (4,939)
               Total Cash Available    $150,508    $159,468     ($8,960)         $134,789      $152,005      ($17,216)     $147,127   $154,674     ($7,547)
           Cash Disbursed
Salaries and Wages                      $14,752     $15,855      ($1,103)          $12,890       $13,659        ($769)      $15,042    $14,150        $892
Lease/Mortgage                            1,659       1,659            0             1,422         1,776         (354)        1,589      1,778        (189)
Insurance                                 1,041       1,085          (44)              956         1,175         (219)          980      1,328        (348)
Office Supplies                           5,404       3,505        1,899             4,646         3,911          735         5,395      4,676         719
Utilities                                 7,316       7,105          211             8,212         7,190        1,022         6,837      7,535        (698)
Repairs and Maintenance                   4,378       4,155          223             4,161         3,694          467         4,766      4,330         436
Operating Supplies                        2,805       3,950       (1,145)            3,114         4,538       (1,424)        3,247      5,170      (1,923)
Professional Fees                         3,437       1,575        1,862             3,097         1,630        1,467         3,245      1,514       1,731
Commissions                              13,716      15,850       (2,134)           12,293        17,303       (5,010)       11,060     19,577      (8,517)
Travel and Entertainment                  3,734       4,580         (846)            4,061         4,509         (448)        4,546      4,923        (377)
Purchases                                 4,140       4,500         (360)            4,830         4,783           47         4,161      5,129        (968)
Advertising                               1,957       2,850         (893)            1,841         3,205       (1,364)        1,700      3,499      (1,799)
Transportation                           14,776      13,505        1,271            12,681        12,838         (157)       10,522     14,371      (3,849)
Other                                    12,352      11,318        1,034            12,794        12,410          384        10,630     13,920      (3,290)
              Total Disbursements       $91,467     $91,492         ($25)          $86,998       $92,621      ($5,623)      $83,720   $101,900    ($18,180)
            Cash Position
Loan Payment with Interest               $8,214      $8,214           $0            $7,318        $8,665      ($1,347)       $6,353     $8,278     ($1,925)
Capital Purchases                         2,080       1,500          580             2,004         1,764          240         2,348      1,493         855
Owner's Withdrawal                       12,500      15,500       (3,000)            5,000        10,000       (5,000)       15,000     10,000       5,000
                Total Cash Paid Out    $114,261    $116,706      ($2,445)         $101,320      $113,050     ($11,730)     $107,421   $121,671    ($14,250)
                      End Of Month      $36,247     $42,762      ($6,515)          $33,469       $38,955      ($5,486)      $39,706    $33,003      $6,703




                                                        © Copyright, 2006, 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

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:486
posted:1/6/2008
language:English
pages:3