Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    Project Cash Flow Template: Enter Month 1 Beginning Balance, Only

    Uploaded by

    Mlungisi Ncube Mnikwa
    This document is a cash flow template for tracking a company's projected cash flow over a 12 month period. It includes sections for beginning cash balance, cash receipts from various sources like client payments and loans, cash payments like materials, equipment, payroll, and a net cash change calculation. The template allows entering projected figures for each month to track the expected monthly and total cash position over the fiscal year.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Project Cash Flow Template: Enter Month 1 Beginning Balance, Only

    Uploaded by

    Mlungisi Ncube Mnikwa
    48 views2 pages
    This document is a cash flow template for tracking a company's projected cash flow over a 12 month period. It includes sections for beginning cash balance, cash receipts from various sources like client payments and loans, cash payments like materials, equipment, payroll, and a net cash change calculation. The template allows entering projected figures for each month to track the expected monthly and total cash position over the fiscal year.

    Original Title

    IC-Project-Cash-Flow-10924.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document is a cash flow template for tracking a company's projected cash flow over a 12 month period. It includes sections for beginning cash balance, cash receipts from various sources like client payments and loans, cash payments like materials, equipment, payroll, and a net cash change calculation. The template allows entering projected figures for each month to track the expected monthly and total cash position over the fiscal year.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    48 views2 pages

    Project Cash Flow Template: Enter Month 1 Beginning Balance, Only

    Uploaded by

    Mlungisi Ncube Mnikwa
    This document is a cash flow template for tracking a company's projected cash flow over a 12 month period. It includes sections for beginning cash balance, cash receipts from various sources like client payments and loans, cash payments like materials, equipment, payroll, and a net cash change calculation. The template allows entering projected figures for each month to track the expected monthly and total cash position over the fiscal year.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 2

    PROJECT CASH FLOW TEMPLATE

    COMPANY NAME START DATE END DATE DATE OF LAST UPDATE

    FISCAL YR
    Enter Month 1 Beginning Balance, only. MONTH 1 MONTH 2 MONTH 3 MONTH 4 MONTH 5 MONTH 6 MONTH 7 MONTH 8 MONTH 9 MONTH 10 MONTH 11 MONTH 12
    TOTALS

    BEGINNING BALANCE | CASH ON HAND $ 10,000.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00

    ( + ) CASH RECEIPTS
    CLIENT PAYMENTS $ 1,200.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,200.00

    OTHER CASH RECEIPTS $ 500.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 500.00

    LOAN PROCEEDS $ 1,000.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,000.00

    OWNER INVESTMENT $ 750.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 750.00

    OTHER $ 2,000.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 2,000.00

    TOTAL CASH RECEIPTS $ 5,450.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 5,450.00

    ( – ) CASH PAYMENTS
    PAYMENTS FOR MATERIALS $ 200.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 200.00

    PAYMENTS TO SUBCONTRACTORS $ 700.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 700.00

    PURCHASE OF PROJECT EQUIPMENT $ 390.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 390.00

    RENTAL OF EQUIPMENT $ 1,500.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,500.00

    PAYROLL FOR ADDITIONAL PROJECT STAFF $ 800.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 800.00

    OTHER PROJECT EXPENSES $ 150.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 150.00

    TOTAL CASH PAYMENTS $ 3,740.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 3,740.00

    NET CASH CHANGE


    $ 1,710.00 $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ - $ 1,710.00
    CASH RECEIPTS – CASH PAYMENTS

    MONTH ENDING CASH POSITION $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00 $ 11,710.00
    BEGINNING BALANCE + NET CASH CHANGE
    Any articles, templates, or information provided by Smartsheet on the website are for reference
    only. While we strive to keep the information up to date and correct, we make no
    representations or warranties of any kind, express or implied, about the completeness,
    accuracy, reliability, suitability, or availability with respect to the website or the information,
    articles, templates, or related graphics contained on the website. Any reliance you place on
    such information is therefore strictly at your own risk.

    You might also like