jagomart
digital resources
picture1_Spreadsheet For Expenses 41397 | Tier 1 Msmes Sdgif Cash Flow Statement Worksheet


 216x       Filetype XLSX       File size 0.03 MB       Source: www.eif.org.na


File: Spreadsheet For Expenses 41397 | Tier 1 Msmes Sdgif Cash Flow Statement Worksheet
12month cash flow statement can be used for 6mth cash flow objectives note the cash flow statement and the income statement fundamentally deal with two different aspects of the same ...

icon picture XLSX Filetype Excel XLSX | Posted on 15 Aug 2022 | 3 years ago
Partial file snippet.
     12-month cash flow statement (can be used for 6mth)
     Cash flow objectives
     Note: The cash flow statement and the income statement fundamentally deal with two different aspects of the same business activity.
     The cash flow statement is based on cash receipts and payments between two consecutive balance sheets. The income statement reports the earnings of a company 
     and the expenses incurred while generating that income. It is also known as a profit and loss statement.
     As you compile your cash flow statement, keep in mind that you need to provide information based on cash generated or utilised by operating activities, investing 
     activities and financing activities.
     Before you begin completing your cash flow statement, refer back to your profit and loss projection. You have already completed a sales projection for the year. A cash 
     flow statement assists you in determining when you can collect cash from your customers.
     In terms of expenses, you need to predict when you will have to pay for those predicted expenses.
     Some income and expenses are monthly. Others are quarterly or even semi-annual. Nevertheless, these must be recognized as monthly expenses.
     The important thing is to be as realistic as you can, line by line. The payoff of a careful cash flow statement is that it will give you the ability to manage and forecast your 
     working capital needs.  
     Enter Company Name Here:        Fiscal Year Begins: 
                -   -    -   -   -    -   -    -
                n   b    r   r   y    n   l    g
                a   e    a   p   a    u   u    u
                J   F    M   A   M    J   J    A
     Cash on hand (start 
     of month)
     CASH RECEIPTS
     Cash sales
     Collections
     Loans/other cash
     TOTAL CASH 
     RECEIPTS
     Total cash 
     available (before 
     cash out)
     CASH PAID OUT
     Purchases 
     (merchandise)
     Purchases (other)
     Purchases (other)
     Gross 
     wages/salaries
     Payroll expenses
     Rent
     Communication 
     systems
     Utilities
     Insurance
     Taxes
     Accounting and 
     legal
     Travel expenses
     Advertising
     Supplies
     Repairs and 
     maintenance
     Outside services 
     Interest
     Other expenses 
     (specify)
     Other
     Other
     Other
     SUB-TOTAL
     Loan principal 
     payment
     Capital purchase
     Capital purchase
     Bond
     Owner’s withdrawal
     TOTAL CASH PAID 
     OUT
     Cash Position (end 
     of month)
     Essential operating data is not part of your cash model. 
     However, it is a good way to track items that have a heavy impact on your cash projections.
     ESSENTIAL OPERATING INFORMATION (noncash flow data)
     Sales volumes 
     (rand value)
     Accounts 
     receivable
     Bad debt (end of 
     month)
     Inventory on hand
     Accounts payable
     Depreciation
Note: The cash flow statement and the income statement fundamentally deal with two different aspects of the same business activity.
The cash flow statement is based on cash receipts and payments between two consecutive balance sheets. The income statement reports the earnings of a company 
and the expenses incurred while generating that income. It is also known as a profit and loss statement.
As you compile your cash flow statement, keep in mind that you need to provide information based on cash generated or utilised by operating activities, investing 
Before you begin completing your cash flow statement, refer back to your profit and loss projection. You have already completed a sales projection for the year. A cash 
Some income and expenses are monthly. Others are quarterly or even semi-annual. Nevertheless, these must be recognized as monthly expenses.
The important thing is to be as realistic as you can, line by line. The payoff of a careful cash flow statement is that it will give you the ability to manage and forecast your 
Fiscal Year Begins: 
                          
      -    -   -    -   l T
      p    t   v    c   am
      e    c   o    e   teS
           O            otE
      S        N    D   Ti
                             0
CASH RECEIPTS
CASH PAID OUT
However, it is a good way to track items that have a heavy impact on your cash projections.
The words contained in this file might help you see if this file matches what you are looking for:

...Month cash flow statement can be used for mth objectives note the and income fundamentally deal with two different aspects of same business activity is based on receipts payments between consecutive balance sheets reports earnings a company expenses incurred while generating that it also known as profit loss you compile your keep in mind need to provide information generated or utilised by operating activities investing financing before begin completing refer back projection have already completed sales year assists determining when collect from customers terms predict will pay those predicted some are monthly others quarterly even semiannual nevertheless these must recognized important thing realistic line payoff careful give ability manage forecast working capital needs enter name here fiscal begins n b r y l g e p u j f m hand start collections loansother total available out paid purchases merchandise other gross wagessalaries payroll rent communication systems utilities insurance t...

no reviews yet
Please Login to review.