Scribd Logo
Upload

Welcome to Scribd!

  • 14 views

    PALONG

    Uploaded by

    Amirul Amri
    The document provides a cash budget for Palong Great for December through July showing cash receipts, cash disbursements, and the net cash balance each month. Cash receipts include sales revenue with 20% collected immediately and 50% and 30% collected in subsequent months. Cash disbursements include purchases that are 60% of sales, with 50% paid each month after purchase. Other expenses include wages, rent, selling expenses, taxes, interest, and machinery. The net cash balance is calculated each month along with any surplus or deficit.

    Copyright:

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

    PALONG

    Uploaded by

    Amirul Amri
    14 views3 pages
    The document provides a cash budget for Palong Great for December through July showing cash receipts, cash disbursements, and the net cash balance each month. Cash receipts include sales revenue with 20% collected immediately and 50% and 30% collected in subsequent months. Cash disbursements include purchases that are 60% of sales, with 50% paid each month after purchase. Other expenses include wages, rent, selling expenses, taxes, interest, and machinery. The net cash balance is calculated each month along with any surplus or deficit.

    Original Title

    PALONG_ (1)

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document provides a cash budget for Palong Great for December through July showing cash receipts, cash disbursements, and the net cash balance each month. Cash receipts include sales revenue with 20% collected immediately and 50% and 30% collected in subsequent months. Cash disbursements include purchases that are 60% of sales, with 50% paid each month after purchase. Other expenses include wages, rent, selling expenses, taxes, interest, and machinery. The net cash balance is calculated each month along with any surplus or deficit.

    Copyright:

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

    PALONG

    Uploaded by

    Amirul Amri
    The document provides a cash budget for Palong Great for December through July showing cash receipts, cash disbursements, and the net cash balance each month. Cash receipts include sales revenue with 20% collected immediately and 50% and 30% collected in subsequent months. Cash disbursements include purchases that are 60% of sales, with 50% paid each month after purchase. Other expenses include wages, rent, selling expenses, taxes, interest, and machinery. The net cash balance is calculated each month along with any surplus or deficit.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    CASH BUDGET PALONG GREAT

    DEC
    CASH RECEIPTS (INFLOWS) JAN
    SALES 2500000
    Collection of Sales :
    Cash 20% 500000
    50% collected 1 month after
    30% collected 2nd month after
    TOTAL CASH INFLOWS

    CASH DISBURSEMENT (OUTFLOWS) Dec Jan


    PURCHASES: ( 60% of Sales) 1500000 1560000
    Payment of purchases:
    50% 1 month after 750000
    50% in the 2nd month
    TOTAL PURCHASES

    OTHER EXPENSES:
    Wages
    Rent and other admin expenses
    Selling expenses
    Tax
    Machine
    Interest

    TOTAL OUTFLOW

    NET CASH BALANCE ( INFLOW-OUTFLOW)


    Beginning cash (+)
    ENDING CASH BALANCE
    Minimum Cash (-)
    SURPLUS/ DEFICIT
    2ND QTR
    FEB MAC APRIL MAY JUNE JULY
    2600000 2650000 3630000 3850000 3780000 3900000

    520000 530000 726000 770000 756000 780000 *


    1250000 1300000 1325000 1815000 1925000 1890000 *
    750000 780000 795000 1089000 1155000 *
    2831000 3380000 3770000

    feb mac apr may june


    1590000 2178000 2310000 2268000 2340000 0

    780000 795000 1089000 1155000 1134000 1170000 *


    750000 780000 795000 1089000 1155000 1134000 *
    1884000 2244000 2289000

    35000 35000 35000


    20000 20000 20000
    40000 40000 40000
    30000
    70000
    15000

    2024000 2409000 2384000

    807000 971000 1386000


    80000 887000 1858000
    887000 1858000 3244000
    20000 20000 20000
    867000 1838000 3224000
    0

    You might also like