SAMPLE form for Projected Cash Flow _cash-expense budget_

Document Sample
SAMPLE form for Projected Cash Flow _cash-expense budget_ Powered By Docstoc
					                       SAMPLE COMPLETED FORM: Projected Cash Flow
                                    (Use for Reference Only)
                 SAMPLE CASH FLOW REPORT: EXCEL SPREADSHEET                                                       Schedule 2
                              PROJECTED CASH FLOW


                                                                              For the Year BEG. _1/1/2011_ END. _12/31/2011_

A.   Line 22 from Schedule 1, Column 3 NET INCOME (LOSS)                                                                $9,425

        Add

B.   Items in Operations not Requiring Cash:
     1. Depreciation (line 16 schedule 1)
     2. Others: ________________________________________

C.   Cash Provided From:
     1. Proceeds from FmHA loan/grant (Balance FmHA Interest Acct)
     2. Proceeds from Others
     3. Increase (decrease) in Accounts Payable etc.
     4. Decrease (increase) in Accounts Receiveable, etc.
     5. Other: _________________________________________
     6. _______________________________________________

D.   Total all A,B,C Items                                                                                              $9,425

E.   Less: Cash Expended for:
     1. Construction, Equipment, New Capital (loan & grant funds)
     2. Replacement and additions to existing property, plant, equipt.
     3. Principal Payment FmHA Loan (Included Line 15)
     4. Principal Payment Other Loans (Included Line 14)
     5. Other: _________________________________________
     6. Total E1 through 5                                                                                                 $0

     Add

F.   Beginning Cash Balances                                                                    $                      100,550
G.   Ending Cash Balances (Total of D minus E6 Plus F)                                          $                      109,975

                                                                     (Current Year)                    (Budget Year)
     Item G Cash Balances Composed of:                                    2010                             2011

                 Construction Account
                 Revenue Account                                         $    14,500            $                       23,925
                 Debt Service (Reserve)                                  $    23,050            $                       23,050
                 O&M Account                                             $    22,500            $                       22,500
                 Reserve (Depreciation)                                  $    28,000            $                       28,000
                 Other:__Meter Deposit Account__                         $    12,500            $                       12,500

     Total       (Agrees with Item G)                                    $   100,550            $                      109,975

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:3
posted:5/19/2012
language:
pages:1
fanzhongqing fanzhongqing http://
About