28 cash flow projection

Upload: vasant-kumar-varma

Post on 04-Jun-2018

216 views

Category:

Documents


0 download

TRANSCRIPT

  • 8/13/2019 28 Cash Flow Projection

    1/14

    ABC, Inc.

    Jan Feb Mar AprInitial 2009 2009 2009 2009

    0 0 0 0 0

    0 0 0 0

    0 0 0 0

    0 0 0 0

    0 0 0 0

    0 0 0 0

    Cash on hand beginning of the month)

    Cash sales

    Returns and allowances

    Cash receipts

    Outside services

    Supplies (office and operating)

    Repairs and maintenance

    Advertising

    Collections on accounts receivable

    Interest, other income

    Loan proceeds

    Reserve and/or escrow

    Owner's withdrawal

    Subtotal

    Total cash receipts Owner contributions

    Cash paid out

    Interest

    Other expenses 1

    Other expenses 2

    Loan principle payment

    Capital purchases

    Other start-up costs

    Auto, delivery and travel

    Total cash available before cash out)

    Purchases (Merchandise)

    Gross wages (exludes withdrawals)

    Payroll expenses (taxes etc.)

    CASH FLOW PR

    ABC, In

    Accounting and legal

    Rent

    Telephone

    Utilities

    Insurance

    Taxes (real estate, etc.)

    Other expenses 3

    Miscellaneous (unspecified)

    Cash on hand at the end of the month) Total cash paid out

  • 8/13/2019 28 Cash Flow Projection

    2/14

    Accounts payable (end of the month) Depreciation

    Sales volume (dollars)

    Accounts receivable (end of the month)

    Bad debt (end of the month)

    Inventory on hand (end of the month)

    Essential Operating Data

  • 8/13/2019 28 Cash Flow Projection

    3/14

    May Jun Jul Aug Sep Oct Nov Dec2009 2009 2009 2009 2009 2009 2009 2009 Total

    0 0 0 0 0 0 0 0 0

    0

    0

    0

    0

    0

    0

    0 0 0 0 0 0 0 0 0

    0 0 0 0 0 0 0 0 0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    0

    00 0 0 0 0 0 0 0 0

    0

    0

    0

    0

    0

    0 0 0 0 0 0 0 0 0

    0 0 0 0 0 0 0 0 0

    JECTION

    .

    0%

    10%

    20%

    30%

    40%

    50%

    60%

    70%

    80%

    90%100%

    Pu

    0

    0.1

    0.2

    0.3

    0.4

    0.5

    0.6

    0.7

    0.8

    0.9

    1

    Initial

  • 8/13/2019 28 Cash Flow Projection

    4/14

    0

    0

    0

    0

    00

  • 8/13/2019 28 Cash Flow Projection

    5/14

    rchases Purchases Purchases Purchases Purchases Others

    Pareto Analysis of Largest 5 Expenditures

    Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec

    Inflow

    Outflo

    Ava.C

  • 8/13/2019 28 Cash Flow Projection

    6/14

  • 8/13/2019 28 Cash Flow Projection

    7/14

    0 Purch 0 Purch 0 Purch 0 Purch 0 Purchases

    0 Wage 0 Wage 0 Wage 0 Wage 0 Wages

    0 Payrol 0 Payrol 0 Payrol 0 Payrol 0 Payroll

    0 Outsi 0 Outsi 0 Outsi 0 Outsi 0 Outside Serv.

    0 Suppli 0 Suppli 0 Suppli 0 Suppli 0 Supplies

    0 Repai 0 Repai 0 Repai 0 Repai 0 Repairs

    0 Adver 0 Adver 0 Adver 0 Adver 0 Advertising

    0 Auto, 0 Auto, 0 Auto, 0 Auto, 0 Auto,

    0 Accou 0 Accou 0 Accou 0 Accou 0 Accounting

    0 Rent 0 Rent 0 Rent 0 Rent 0 Rent

    0 Telep 0 Telep 0 Telep 0 Telep 0 Telephone

    0 Utiliti 0 Utiliti 0 Utiliti 0 Utiliti 0 Utilities

    0 Insura 0 Insura 0 Insura 0 Insura 0 Insurance

    0 Taxes 0 Taxes 0 Taxes 0 Taxes 0 Taxes

    0 Intere 0 Intere 0 Intere 0 Intere 0 Interest

    0 Other 0 Other 0 Other 0 Other 0 Other 1

    0 Other 0 Other 0 Other 0 Other 0 Other 2

    0 Other 0 Other 0 Other 0 Other 0 Other 3

    0 Misc. 0 Misc. 0 Misc. 0 Misc. 0 Misc.0 Subto 0 Subto 0 Subto 0 Subto 0 Subtotal

    0 Loan 0 Loan 0 Loan 0 Loan 0 Loan

    0 Cap.P 0 Cap.P 0 Cap.P 0 Cap.P 0 Cap.Purch.

    0 Other 0 Other 0 Other 0 Other 0 Other start-up

    0 Reser 0 Reser 0 Reser 0 Reser 0 Reserve

    0 Withd 0 Withd 0 Withd 0 Withd 0 Withdrawal

    s

    w

    sh

  • 8/13/2019 28 Cash Flow Projection

    8/14

  • 8/13/2019 28 Cash Flow Projection

    9/14

    Purch#### ##### 0

    Purch#### ##### 0

    Purch#### ##### 0 InitialJan Feb Mar Apr May Jun Jul Aug Sep

    Purch#### ##### 0Inflo 0 0 0 0 0 0 0 0 0 0

    Purch#### ##### 0Outfl 0 0 0 0 0 0 0 0 0 0

    Othe #### ##### 0 Ava. 0 0 0 0 0 0 0 0 0 0

    . 0 0 0 0 0 0 0 0 0 0

  • 8/13/2019 28 Cash Flow Projection

    10/14

  • 8/13/2019 28 Cash Flow Projection

    11/14

    Oct Nov Dec

    0 0 0

    0 0 0

    0 0 0

    0 0 0

  • 8/13/2019 28 Cash Flow Projection

    12/14

    1) Type the name of your company:

    2) Type the fiscal year of projection:

    3) Select the beginning month of your fiscal year:

    4) Type the initial available cash amount:

    Copyright (c) 2009 Pagos, Inc. http://www.pagos.com/

    Follow the steps to enable your online Cash Flow Projection file.

    ABC, Inc.

    2009

    Jan

  • 8/13/2019 28 Cash Flow Projection

    13/14

    Fiscal Year

    2009 Jan 1/1/2009

    1 Jan 1 2009

    2 Feb 2 2009

    3 Mar 3 2009

    4 Apr 4 2009

    5 May 5 2009

    6 Jun 6 2009

    7 Jul 7 2009

    8 Aug 8 2009

    9 Sep 9 2009

    10 Oct 10 2009

    11 Nov 11 2009

    12 Dec 12 2009

    Company name

    /2009

  • 8/13/2019 28 Cash Flow Projection

    14/14

    1 Jan

    2 Feb

    3 Mar

    4 Apr

    5 May

    6 Jun

    7 Jul

    8 Aug

    9 Sep

    10 Oct

    11 Nov

    12 Dec