Scribd Logo
Upload

Welcome to Scribd!

  • 203 views

    Cash Budget Format

    Uploaded by

    Amit Dey
    The document contains schedules of cash collection from sales, payments to creditors for purchase of materials, payments of wages, payments of overheads, and a cash budget for July and August. It shows sales, collection amounts, purchase amounts, wage payments, overhead payments, cash receipts, cash disbursements, cash surplus/deficit, and ending balances for July and August.

    Copyright:

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

    Cash Budget Format

    Uploaded by

    Amit Dey
    203 views5 pages
    The document contains schedules of cash collection from sales, payments to creditors for purchase of materials, payments of wages, payments of overheads, and a cash budget for July and August. It shows sales, collection amounts, purchase amounts, wage payments, overhead payments, cash receipts, cash disbursements, cash surplus/deficit, and ending balances for July and August.

    Original Description:

    Accounts

    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 contains schedules of cash collection from sales, payments to creditors for purchase of materials, payments of wages, payments of overheads, and a cash budget for July and August. It shows sales, collection amounts, purchase amounts, wage payments, overhead payments, cash receipts, cash disbursements, cash surplus/deficit, and ending balances for July and August.

    Copyright:

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

    Cash Budget Format

    Uploaded by

    Amit Dey
    The document contains schedules of cash collection from sales, payments to creditors for purchase of materials, payments of wages, payments of overheads, and a cash budget for July and August. It shows sales, collection amounts, purchase amounts, wage payments, overhead payments, cash receipts, cash disbursements, cash surplus/deficit, and ending balances for July and August.

    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 5

    Schedule of Cash Collection From Sales

    May June
    Sales (Rs.) 45000 50000
    Collection
    Cash Sales-20% 9000 10000
    Credit Sales
    Same Month-40% 14400 16000
    Next Month-40% 14400
    Third Month-20%
    Total Collection

    Schedule of Payment to creditors for Purchase of Materials


    May June
    Purchase (Rs.) 26000 30000
    Payment Schedule
    After 2 Months-100%

    Schedule of Payment of Wages


    May June
    Wages(Rs.) 12,000 12,000
    Payment Schedule
    Same Month-75% 9000 9000
    next Month-25% 3000
    Total

    Schedule of Payment of Overheads


    May June
    Overheads (Rs.) 6,000 7,000
    Less: Depreciation 1,000 1,000
    Cash Overheads 5,000 6,000
    Payment Schedule
    Same Month-50% 2500 3000
    next Month-50% 2500
    Total

    Cash Budget
    For the Month ending
    July August
    Cash Receipts
    Cash Collection from Sales 51,800 56,800
    Dividend Income 12,000
    Sales proceed from old machinery 20,000
    Total Cash Available for Use 71,800 68,800
    Less: Cash Disbursements
    Payment to creditors 26,000 30,000
    Payment for wages 12,150 12,425
    Payment for Overheads 6,500 7,250
    Insurance 3,000
    Payment fro purchase of new
    10000 25,000
    machinery
    Total Disbursements 57,650 74,675
    Cash Surplus/(Deficit) 14,150 -5,875
    Add:Beginning Balance 8,000 22,150
    Ending Balnace 22,150 16,275
    From Sales
    July August September
    55000 60000 65000

    11000 12000 13000

    17600 19200 20800


    16000 17600 19200
    7200 8000 8800
    51800 56800 61800

    Purchase of Materials
    July August September
    32000 35000 38000

    26000 30000 32000

    f Wages
    July August September
    12,200 12,500 13,000

    9150 9375 9750


    3000 3050 3125
    12150 12425 12875

    Overheads
    July August September
    8,000 8,500 9,000
    1,000 1,000 1,000
    7,000 7,500 8,000

    3500 3750 4000


    3000 3500 3750
    6500 7250 7750

    September

    61,800

    61,800
    32,000
    12,875
    7,750

    52,625
    9,175
    16,275
    25,450

    You might also like