Cash
Projection Summary |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
The Cash
Projection Summary Section |
|
|
|
|
|
summarizes
the results of all the detailed schedules, |
|
|
|
|
|
calculations,
analysis, and assumptions used in developing |
|
|
|
|
|
your
Cash Forecast. |
|
|
|
|
|
|
|
|
|
|
|
Cash
Projection Summary |
|
Totals |
Month 1 |
Month 2 |
Month 3 |
Enter
Beginning Cash Amount |
This line is
used to enter the Beginning Cash |
|
|
|
|
Beginning Cash |
Balance which is
then used to automatically calculate |
|
|
|
|
|
the Beginning Cash Balance for
future periods based. |
|
|
|
|
|
on the Cash Collections and Cash Payments made in |
|
|
|
|
|
each period. |
|
|
|
|
|
|
|
|
|
|
Plus: |
|
|
|
|
|
Cash Collections |
This section is used to summarize and identify |
|
|
|
|
|
the sources of your estimated cash inflows (receipts). |
|
|
|
|
|
|
|
|
|
|
Accounts
Receivable-Collections Prior Period |
This line summarizes and identifies the collections |
|
|
|
|
|
from your prior year's customer balances that were |
|
|
|
|
|
not collected as of the end of the year or beginning |
|
|
|
|
|
of your Cash Forecast. The balance is brought |
|
|
|
|
|
forward from the Accounts Receivable Prior Period
Schedule. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Accounts
Receivable-Collections Current Periods |
This line summarizes the estimated collections |
|
|
|
|
|
by month that are calculated and brought forward |
|
|
|
|
|
from the calculation section called |
|
|
|
|
|
Current Year
Accounts Receivable Collections. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash
Sales |
This line summarizes and brings forward the estimated |
|
|
|
|
|
"cash" sales a business anticipates from the
calculation |
|
|
|
|
|
section named Current Year Cash Sales . |
|
|
|
|
|
|
|
|
|
|
Sale Of
Equipment |
This line summarizes your estimated receipts resulting |
|
|
|
|
|
from the sale of any equipment. The amounts are |
|
|
|
|
|
brought forward from the Other Cash Receipts Section. |
|
|
|
|
|
|
|
|
|
|
Loans |
This line summarizes your estimated receipts resulting |
|
|
|
|
|
from any needed or planned loans during the |
|
|
|
|
|
periods estimated. The amounts are brought forward |
|
|
|
|
|
from the Other Cash Receipts Section. |
|
|
|
|
|
|
|
|
|
|
Owner's
Investments / Stock Sales |
This line summarizes your estimated receipts resulting |
|
|
|
|
|
from any owner contributions or sale of stock |
|
|
|
|
|
planned for during the periods estimated. The amounts |
|
|
|
|
|
are brought forward from the Other Cash Receipts Section. |
|
|
|
|
|
|
|
|
|
|
Other
Receipts and Collections |
This line summarizes any other collections that your |
|
|
|
|
|
business anticipates will occur during the periods
estimated. |
|
|
|
|
|
The amounts are brought forward from the |
|
|
|
|
|
Other Cash Receipts Section. |
|
|
|
|
|
|
|
|
|
|
Total Cash Collections |
This line just totals up and provides the total estimated |
|
|
|
|
|
Cash Collections for the estimated periods. |
|
|
|
|
|
|
|
|
|
|
Less: |
|
|
|
|
|
Cash Payments |
This section is used to summarize and identify |
|
|
|
|
|
what you will have to pay out (cash outflow) during |
|
|
|
|
|
the periods estimated and what the payment was for. |
|
|
|
|
|
|
|
|
|
|
Accounts
Payable Payments-Prior Periods |
This line summarizes and identifies the payments |
|
|
|
|
|
on amounts owed to your suppliers that were not paid |
|
|
|
|
|
as of the end of the year or beginning of your forecast. |
|
|
|
|
|
The amounts are brought forward from the Accounts
Payable |
|
|
|
|
|
Prior Periods Payments Section. |
|
|
|
|
|
|
|
|
|
|
Other
Amounts Owed Prior Period |
This line summarizes and identifies the payments |
|
|
|
|
|
on other amounts owed
and not paid as of the end of the |
|
|
|
|
|
year or beginning of your forecast period. The amounts |
|
|
|
|
|
are brought forward from the Other Amounts Owed |
|
|
|
|
|
Prior Period Payments Section. |
|
|
|
|
|
|
|
|
|
|
Accounts
Payable Payments-Current Periods |
This line summarizes the estimated payments |
|
|
|
|
|
made for purchases made on credit during your |
|
|
|
|
|
forecast periods. The amounts are brought forward from |
|
|
|
|
|
the Accounts Payable Payments Current Periods Section |
|
|
|
|
|
|
|
|
|
|
Cash
Purchases |
This line summarizes and brings forward the estimated |
|
|
|
|
|
cash purchases a business anticipates from the
calculation |
|
|
|
|
|
section named Cash Purchases Current Periods. |
|
|
|
|
|
|
|
|
|
|
Payroll
Expenses |
This line summarizes your estimated payments needed for |
|
|
|
|
|
your payroll expenses including payroll taxes and |
|
|
|
|
|
fringe benefits. A total of your payroll expenses is |
|
|
|
|
|
automatically calculated that sums your estimated |
|
|
|
|
|
salaries and wages,employee benefits, social |
|
|
|
|
|
security and medicare taxes, and federal and state |
|
|
|
|
|
unemployment. The calculated amounts are brought |
|
|
|
|
|
forward from the section named Cash Operating |
|
|
|
|
|
Expense Payments. |
|
|
|
|
|
|
|
|
|
|
Operating
Expense Payments |
This line summarizes your estimated payments needed for |
|
|
|
|
|
your operating expenses excluding payroll expenses. |
|
|
|
|
|
These amounts are totalled and brought forward |
|
|
|
|
|
from the Cash Operating Payments Section |
|
|
|
|
|
based on the amounts that you estimated by |
|
|
|
|
|
period for each type of expense. |
|
|
|
|
|
|
|
|
|
|
Sales
Tax |
This line summarizes the estimated payments |
|
|
|
|
|
that you need to pay during the periods estimated |
|
|
|
|
|
based on your estimated sales and sales tax rate. |
|
|
|
|
|
These amounts are calculated and brought forward from |
|
|
|
|
|
Sales Tax Payments Section. |
|
|
|
|
|
|
|
|
|
|
Note
Payments |
This line summarizes the estimated payments |
|
|
|
|
|
needed by period to pay any current and / or |
|
|
|
|
|
additional notes that you planned on obtaining |
|
|
|
|
|
during any of the forecast periods. The amounts |
|
|
|
|
|
include principal and interest. These amounts are brought |
|
|
|
|
|
forward from Other Payments Section. |
|
|
|
|
|
|
|
|
|
|
Equipment
Purchases |
This line summarizes the estimated payments |
|
|
|
|
|
needed by period to pay for any planned equipment |
|
|
|
|
|
purchases. These amounts are brought forward |
|
|
|
|
|
from the Other Payments Section. |
|
|
|
|
|
|
|
|
|
|
Owner's
Draws / Dividends |
This line summarizes the estimated payments |
|
|
|
|
|
needed by period to pay for owner draws or dividends |
|
|
|
|
|
paid to shareholders. These amounts are brought forward |
|
|
|
|
|
from the Other Payments Section. |
|
|
|
|
|
|
|
|
|
|
Income
and Other Taxes |
This line summarizes the estimated payments |
|
|
|
|
|
needed by period to pay for income and other |
|
|
|
|
|
business taxes. These amounts are brought forward |
|
|
|
|
|
from the Other Payments Section. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Other
Miscellaneous Payments |
This line summarizes any other estimated payments |
|
|
|
|
|
your business anticipates will occur during the |
|
|
|
|
|
periods estimated.These amounts are summarized and |
|
|
|
|
|
brought forward from the Other Miscellaneous |
|
|
|
|
|
Payments Section. |
|
|
|
|
|
|
|
|
|
|
Total Cash Payments |
This line just totals up and provides the total estimated |
|
|
|
|
|
Cash Payments for the estimated periods. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Ending
Cash |
This line is calculated by adding the Beginning Cash |
|
|
|
|
|
Balance plus the Total Cash Collections and subtracting |
|
|
|
|
|
the Total Cash Payments. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Increase
/ <Decrease> For Period |
This line is calculated by subtracting the |
|
|
|
|
|
Total Cash Payments from the Total Cash Collections. |
|
|
|
|
|
A positive amount indicates an increase in the Cash |
|
|
|
|
|
Balance for a period while a negative amount indicates |
|
|
|
|
|
a decrease in the Cash Balance for a period. |
|
|
|
|
|
|
|
|
|
|
Additional
Cash Needed |
|
|
|
|
|
|
|
|
|
|
|
Supplied By: |
|
|
|
|
|
Short
Term Borrowing Needs |
This line is automatically calculated if any future |
|
|
|
|
|
period's calculated cash balance is negative. |
|
|
|
|
|
|
|
|
|
|
Short Term Repayments |
This line is automatically calculated if any future |
|
|
|
|
|
borrowings were needed in prior periods and |
|
|
|
|
|
an open balance still remains. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Current
Loan Balance |
This line is automatically calculated and |
|
|
|
|
|
is the current balance of your short tem borrowings. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Cash
Including Short Term Loans |
This line is automatically calculated and |
|
|
|
|
|
is the balance of your cash plus any current |
|
|
|
|
|
loan balance outstanding. |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|