Scribd Logo
Upload

Welcome to Scribd!

  • 253 views

    Projected Cash Flow Keffi Flour Mills Limited

    Uploaded by

    Hrh Saddiquah
    This document is a cash flow statement for Keffi Flour Mills Limited over a 2 year period from months 1 to 36. It shows the company's cash inflows and outflows on a monthly basis. Key points: - Cash inflows come from initial capital/loans, sales proceeds from maize flour and by-products, and interest drawbacks. - Cash outflows include loan repayments, expenditures on fixed assets to set up the mill, and ongoing operating expenses like materials, salaries, maintenance. - Most months show a cash surplus, with the balance carried over to the next month. - Loans taken are gradually repaid over the period, reducing the outstanding loan balance each

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd

    Projected Cash Flow Keffi Flour Mills Limited

    Uploaded by

    Hrh Saddiquah
    253 views3 pages
    This document is a cash flow statement for Keffi Flour Mills Limited over a 2 year period from months 1 to 36. It shows the company's cash inflows and outflows on a monthly basis. Key points: - Cash inflows come from initial capital/loans, sales proceeds from maize flour and by-products, and interest drawbacks. - Cash outflows include loan repayments, expenditures on fixed assets to set up the mill, and ongoing operating expenses like materials, salaries, maintenance. - Most months show a cash surplus, with the balance carried over to the next month. - Loans taken are gradually repaid over the period, reducing the outstanding loan balance each

    Original Description:

    cash flow

    Original Title

    Copy of Projected Cash Flow Keffi Flour Mills Limited (3)

    Copyright

    © Attribution Non-Commercial (BY-NC)

    Available Formats

    XLS, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document is a cash flow statement for Keffi Flour Mills Limited over a 2 year period from months 1 to 36. It shows the company's cash inflows and outflows on a monthly basis. Key points: - Cash inflows come from initial capital/loans, sales proceeds from maize flour and by-products, and interest drawbacks. - Cash outflows include loan repayments, expenditures on fixed assets to set up the mill, and ongoing operating expenses like materials, salaries, maintenance. - Most months show a cash surplus, with the balance carried over to the next month. - Loans taken are gradually repaid over the period, reducing the outstanding loan balance each

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    253 views3 pages

    Projected Cash Flow Keffi Flour Mills Limited

    Uploaded by

    Hrh Saddiquah
    This document is a cash flow statement for Keffi Flour Mills Limited over a 2 year period from months 1 to 36. It shows the company's cash inflows and outflows on a monthly basis. Key points: - Cash inflows come from initial capital/loans, sales proceeds from maize flour and by-products, and interest drawbacks. - Cash outflows include loan repayments, expenditures on fixed assets to set up the mill, and ongoing operating expenses like materials, salaries, maintenance. - Most months show a cash surplus, with the balance carried over to the next month. - Loans taken are gradually repaid over the period, reducing the outstanding loan balance each

    Copyright:

    Attribution Non-Commercial (BY-NC)
    Download as XLS, PDF, TXT or read online from Scribd
    Download as xls, pdf, or txt
    of 3
    At a glance
    Powered by AI
    The document outlines the monthly cash flow statement for Keffi Flour Mills Limited over a 36 month period. It tracks income, expenses, and the opening and closing bank balances on a monthly basis.

    The document is a statement of cash flow, showing the cash generated and spent each month. It tracks the sources and uses of cash but does not show profit/loss.

    The main sources of income are sales proceeds from maize flour, equity/capital introduced, and sales proceeds from byproducts like bran. Interest income is also included.

    Page

    Name of Customer
    KEFFI FLOUR MILLS LIMITED
    N.B This is a statement of Cash generated and spent. It is not a statement of Profit and Loss
    period Month 1 to Month 12
    MONTH
    1
    2
    3

    10

    (N'000)

    10

    11

    12

    CASH INCOME
    1. Capitaland/or Loan Introduced

    73,451

    2. Equity

    48,549
    5,600

    5,600

    3. Sales Proceeds From Maize Flour


    4. Sales Proceeds From Overs
    5. Interest drawback 40%

    24,948
    554
    2,222

    24,948
    554

    24,948
    554

    24,948
    554
    2,562

    24,948
    554

    24,948
    554

    24,948
    554
    2,477

    24,948
    554

    24,948
    554

    27,724

    25,502

    25,502

    28,064

    25,502

    25,502

    27,979

    25,502

    25,502

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    6. Other sources of income


    (A)

    73,451

    54,149

    5,600

    CASH EXPENDITURE
    6. Loan Repayment
    7. On Fixed Assets
    a. Cost of Construction Work
    b. Cost of Machinery & Equipments
    c. Cost of Grain Handling Equipments

    18,503
    15,760
    20,248

    6,453

    d. Cost of Installation Works/Services


    e. Cost of Furniture & Office Equipments

    12,336

    3,682

    8. Operating Expenses:-

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    500
    250
    60

    2,135

    2,135

    2,135

    2,135

    2,135

    2,135

    2,064

    1,993

    1,921

    1,850

    1,779

    74,841

    56,132

    2,945

    21,467

    21,467

    21,467

    25,534

    25,463

    25,392

    25,320

    25,249

    25,178

    Closing Bank Balance

    73,451
    74,841
    (1,390)
    3,000
    1,610

    54,149
    56,132
    (1,983)
    1,610
    (373)

    5,600
    2,945
    2,655
    (373)
    2,282

    25,502
    21,467
    4,035
    8,539
    12,574

    25,502
    21,467
    4,035
    12,574
    16,609

    28,064
    25,534
    2,530
    16,609
    19,139

    25,502
    25,463
    39
    19,139
    19,178

    25,502
    25,392
    110
    19,178
    19,288

    27,979
    25,320
    2,658
    19,288
    21,946

    25,502
    25,249
    253
    21,946
    22,199

    25,502
    25,178
    324
    22,199
    22,523

    Loan Balance

    73,451

    122,000

    122,000

    122,000

    117,933

    113,866

    109,799

    105,732

    101,665

    (i). Stocks (trade concern maize)


    (ii). Cost of crushing/milling/packaging materials

    13,860
    693

    32,760
    1,638

    500
    250
    60

    500
    250
    60

    1,285

    (iii). Storage expenses


    (iv) Admin. Expenses/Salaries
    (v) Transport, Fuel/Lubricants
    (xi). Factory maintenance
    (xii). Admin. Expenses/Salaries
    (xiii). Miscellaneous Expenses
    (xiv). Interest at 21%
    (xv) NAIC nsurance
    (B)
    9. Summary
    Cash Income (A)
    Cash Expenditure (B)
    Monthly Cash Surplus/Shortage
    Opening Bank Balance

    122,000

    122,000

    27,724
    21,467
    6,257
    2,282
    8,539
    122,000

    Page
    Name of Customer
    KEFFI FLOUR MILLS LIMITED
    N.B This is a statement of Cash generated and spent. It is not a statement of Profit and Loss
    period Month 13 to Month 24
    MONTH
    1
    2
    3

    10

    (N'000)

    10

    11

    12

    CASH INCOME
    1. Capitaland/or Loan Introduced
    1. Capitaland/or Loan Introduced
    2. Equity
    3. Sales Proceeds From Maize Flour
    4. Sales Proceeds From Overs

    31,752
    706
    2,220

    31,752
    706

    31,752
    706

    31,752
    706
    1,964

    31,752
    706

    31,752
    706

    31,752
    706
    1,708

    31,752
    706

    31,752
    706

    31,752
    706
    1,452

    31,752
    706

    31,752
    706

    34,678

    32,458

    32,458

    34,422

    32,458

    32,458

    34,166

    32,458

    32,458

    33,910

    32,458

    32,458

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    1,708

    1,637

    1,566

    1,494

    1,423

    1,352

    1,281

    1,210

    1,139

    1,067

    996

    925

    25,845

    25,774

    25,703

    25,631

    25,560

    25,489

    25,418

    25,347

    25,276

    25,204

    25,133

    25,062

    34,678
    25,845
    8,833
    22,523
    31,356

    32,458
    25,774
    6,684
    31,356
    38,041

    32,458
    25,703
    6,755
    38,041
    44,796

    34,422
    25,631
    8,791
    44,796
    53,587

    32,458
    25,560
    6,898
    53,587
    60,484

    32,458
    25,489
    6,969
    60,484
    67,453

    34,166
    25,418
    8,748
    67,453
    76,201

    32,458
    25,347
    7,111
    76,201
    83,313

    32,458
    25,276
    7,182
    83,313
    90,495

    33,910
    25,204
    8,705
    90,495
    99,200

    32,458
    25,133
    7,325
    99,200
    106,525

    32,458
    25,062
    7,396
    106,525
    113,921

    97,598

    93,531

    89,464

    85,397

    81,330

    77,263

    73,196

    69,129

    65,062

    60,995

    5. Interest drawback 40%


    6. Other sources of income
    CASH EXPENDITURE
    6. Loan Repayment
    7. On Fixed Assets
    a. Cost of Construction Work
    b. Cost of Machinery & Equipments
    c. Cost of Grain Handling Equipments
    d. Cost of Installation Works/Services
    e. Cost of Furniture & Office Equipments
    8. Operating Expenses:(i). Stocks (trade concern maize)
    (ii). Cost of crushing/milling/packaging materials
    (iii). Storage expenses
    (iv) Admin. Expenses/Salaries
    (v) Transport, Fuel/Lubricants
    (xi). Factory maintenance
    (xii). Admin. Expenses/Salaries
    (xiii). Miscellaneous Expenses
    (xiv). Interest at 21%
    (xv) NAIC nsurance
    (B)
    9. Summary
    Cash Income (A)
    Cash Expenditure (B)
    Monthly Cash Surplus/Shortage
    Opening Bank Balance
    Closing Bank Balance

    Loan Balance

    56,928

    52,861

    Page
    Name of Customer
    KEFFI FLOUR MILLS LIMITED
    N.B This is a statement of Cash generated and spent. It is not a statement of Profit and Loss
    period Month 25 to Month 36
    MONTH
    1
    2
    3

    10

    (N'000)

    10

    11

    12

    CASH INCOME
    1. Capitaland/or Loan Introduced
    2. Equity
    3. Sales Proceeds From Maize Flour
    4. Sales Proceeds From Overs
    5. Interest drawback 40%

    31,752
    706
    1,195

    31,752
    706

    31,752
    706

    31,752
    706
    939

    31,752
    706

    31,752
    706

    31,752
    706
    683

    31,752
    706

    31,752
    706

    31,752
    706
    427

    31,752
    706

    31,752
    706

    33,653

    32,458

    32,458

    33,397

    32,458

    32,458

    33,141

    32,458

    32,458

    32,885

    32,458

    32,458

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,067

    4,057

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    17,640
    882

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    930
    558
    60

    854

    783

    712

    640

    569

    498

    427

    356

    285

    213

    142

    71

    94,991

    24,920

    24,849

    24,777

    24,706

    24,635

    24,564

    24,493

    24,422

    24,350

    24,279

    24,198

    33,653
    94,991
    (61,337)
    113,921
    52,584

    32,458
    24,920
    7,538
    52,584
    60,122

    32,458
    24,849
    7,609
    60,122
    67,731

    33,397
    24,777
    8,620
    67,731
    76,351

    32,458
    24,706
    7,752
    76,351
    84,103

    32,458
    24,635
    7,823
    84,103
    91,926

    33,141
    24,564
    8,577
    91,926
    100,503

    32,458
    24,493
    7,965
    100,503
    108,468

    32,458
    24,422
    8,036
    108,468
    116,505

    32,885
    24,350
    8,534
    116,505
    125,039

    32,458
    24,279
    8,179
    125,039
    133,218

    32,458
    24,198
    8,260
    133,218
    141,478

    44,727

    40,660

    36,593

    32,526

    28,459

    6. Other sources of income


    (A)
    CASH EXPENDITURE
    6. Loan Repayment
    7. On Fixed Assets
    a. Cost of Delivery Van

    70,000

    b. Cost of Machinery & Equipments


    c. Cost of Grain Handling Equipments
    d. Cost of Installation Works/Services
    e. Cost of Furniture & Office Equipments
    8. Operating Expenses:(i). Stocks (trade concern maize)
    (ii). Cost of crushing/milling/packaging materials
    (iii). Storage expenses
    (iv) Admin. Expenses/Salaries
    (v) Transport, Fuel/Lubricants
    (xi). Factory maintenance
    (xii). Admin. Expenses/Salaries
    (xiii). Miscellaneous Expenses
    (xiv). Interest at 21%
    (xv) NAIC nsurance
    (B)
    9. Summary
    Cash Income (A)
    Cash Expenditure (B)
    Monthly Cash Surplus/Shortage
    Opening Bank Balance
    Closing Bank Balance

    Loan Balance

    48,794

    24,392

    20,325

    16,258

    12,191

    8,124

    4,057

    You might also like