Scribd Logo
Upload

Welcome to Scribd!

  • 19 views

    Cash Flow2A

    Uploaded by

    Furquan Khan
    This cash flow forecast outlines projected monthly sales, receipts, payments and net cash flow for a new business called Munchy over a 12 month period. Key details include: - Start up costs of £3080 are required in month 1. - Sales are projected to steadily increase each month from £1750 in month 1 to £5145 in month 12. - Rent from flats provides a steady monthly income of £738.48. - Payments include purchases, supplier costs, owner drawings, rent and loan repayments. - The net cash flow increases each month from £840 in month 1 to £4194 in month 12. - The closing bank balance is projected to grow from

    Copyright:

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

    Cash Flow2A

    Uploaded by

    Furquan Khan
    19 views1 page
    This cash flow forecast outlines projected monthly sales, receipts, payments and net cash flow for a new business called Munchy over a 12 month period. Key details include: - Start up costs of £3080 are required in month 1. - Sales are projected to steadily increase each month from £1750 in month 1 to £5145 in month 12. - Rent from flats provides a steady monthly income of £738.48. - Payments include purchases, supplier costs, owner drawings, rent and loan repayments. - The net cash flow increases each month from £840 in month 1 to £4194 in month 12. - The closing bank balance is projected to grow from

    Original Title

    Cash Flow2A.xls

    Copyright

    © © All Rights Reserved

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This cash flow forecast outlines projected monthly sales, receipts, payments and net cash flow for a new business called Munchy over a 12 month period. Key details include: - Start up costs of £3080 are required in month 1. - Sales are projected to steadily increase each month from £1750 in month 1 to £5145 in month 12. - Rent from flats provides a steady monthly income of £738.48. - Payments include purchases, supplier costs, owner drawings, rent and loan repayments. - The net cash flow increases each month from £840 in month 1 to £4194 in month 12. - The closing bank balance is projected to grow from

    Copyright:

    © All Rights Reserved
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    19 views1 page

    Cash Flow2A

    Uploaded by

    Furquan Khan
    This cash flow forecast outlines projected monthly sales, receipts, payments and net cash flow for a new business called Munchy over a 12 month period. Key details include: - Start up costs of £3080 are required in month 1. - Sales are projected to steadily increase each month from £1750 in month 1 to £5145 in month 12. - Rent from flats provides a steady monthly income of £738.48. - Payments include purchases, supplier costs, owner drawings, rent and loan repayments. - The net cash flow increases each month from £840 in month 1 to £4194 in month 12. - The closing bank balance is projected to grow from

    Copyright:

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

    Best estimate of cashflow based on info available

    CASH FLOW FORECAST


    NAME: C Biant T/A Munchy Appendix 2A
    VAT NOT INCLUDED
    Start Up Cost 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

    SALES/RECEIPTS

    0
    SALE 1750 1944 2160 2400 2640 2904 3194 3514 3865 4252 4677 5145 38444
    INSOLES 180 198 218 240 264 290 319 351 386 424 467 514 3849
    LOANS RECEIVED 10000 10000
    BANK LOAN 3000 3000
    RENT FROM FLATS 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 738.48 9600

    SALES TOTAL A 13738 2668 2880 3116 3378 3642 3932 4252 4603 4990 5415 5882 6397 64894

    PAYMENTS

    PURCHASES 500 50 50 50 50 50 750 250


    INSOLE SUPPLIER 27 30 33 36 40 43 48 53 58 64 70 500
    OWNERS DRAWINGS 400 400 400 400 400 400 400 400 400 400 4000
    RENT 3375 1125 1125 1125 1125 1125 1125 1125 1125 1125 1125 1125 1125 16875 16375
    RATES/COUNCIL TAX/RENT 73 73 73 73 73 73 73 73 73 73 73 73 876
    START UP COSTS 3080 3080 770
    LOAN REPAYMENTS/HP 255 255 255 255 255 255 255 255 255 255 2550
    LIGHT/HEAT 120 120 120 120 120 120 120 120 120 120 120 120 1440
    ADVERTISING/Agency 400 50 50 50 50 50 50 50 50 50 50 50 950
    REPAIRS & RENEWALS 25 25 25 25 25 25 25 25 25 25 25 25 300
    TELEPHONE 50 50 50 50 50 50 50 50 50 50 50 50 600
    SUNDRY 25 25 25 25 25 25 25 25 25 25 25 25 300
    POST/PRINTING 10 10 10 10 10 10 10 10 10 10 10 10 120
    PAYMENTS TOTAL B 6955 1828 1505 2213 2166 2219 2173 2226 2181 2236 2191 2247 2203 32341

    NET CASHFLOW (A-B) 6783 840 1375 904 1212 1423 1760 2025 2422 2754 3224 3636 4194 32552

    OPENING BANK BAL 0 6783 7624 8999 9903 11115 12538 14298 16323 18745 21499 24723 28359

    CLOSING BANK BAL 6783 7624 8999 9903 11115 12538 14298 16323 18745 21499 24723 28359 32552 32552

    You might also like