Navigation: » No topics above this level «

Cash flow projections

In this screen you can enter cash flow projections of a project per cost category. Open screen in browser Open Form

Using these projections you can calculate the present net value of the project on the basis of cash flow projections. The calculation is done in two steps:

1.Calculating: determines the size of each flow, start and end dates and distribution method.

2.Dividing: allocates the cash flow to the days of the calendar.

The two steps allow you to manually adjust the calculated cash flows if desired.

Cash Flow Projections Screen

The meaning of the entry fields is:

Project	The project which the latest estimate is part of.
Start of Projection	The starting date of the cash flow projection.
Cash Flow Method	The way cash flows are allocated to a period.
Include Explanation in Flows	When checked, the explanation will be included in the calculation of the cash flow.
Include Explanation in Daily Flows	When checked, the explanation will be included in the calculation of the daily cash flows.
Explanation	An informative explanation such as a reason why the 'Cash Flow Method' in question was chosen.
Net Present Value
NPV Rate (%)	The percentage by which the present value (net value) of projected cash flows is calculated.
NPV Rate Settled Posts (%)	The percentage by which the present value of already paid/received amounts is calculated.
Include interest in NPV	The interest paid on loans is included in the NPV calculation if this option is checked.
Calculate
Recalculate	The cash flow will be recalculated in the future when this option is checked.
Distribute Cash Flow	The cash flow will be allocated to the period starting with ‘Cash Flow Date’ and ends with ‘Cash Flow End Date’ if this option is checked.
Both Calculate and Distribute	The cash flow will be recalculated and distributed in the future if this option is checked.
Cash Flows
Cash Flow Date	Shows the date the cash flow starts.
Cash Flow End Date	Displays the date when the cash flow ends.
Invoice Flow Date	Shows the date the invoice flow begins.
Invoice Flow End Date	Displays the date the invoice flow ends.
Original Difference between Cash Flows (days)	The initial difference in days between the invoice and the expected cash flow.
Distribution Method	The method by which the cash flow is distributed over the period.
Cost Type	The cost category on which is the cash flow is registered.
Contract	The contract ID to which the cash flow is related.
Type	Indicates what caused the cash flow. For example, this could be a contract, an invoice line, a budget, etc..
Deviating Amount	Here you can enter a deviating amount. For the NPV calculation this amount will be included in stead of the ‘Calculated Amount’.
Explanation Deviating Cash Flow	A possible explanation of the deviating cash flow.
Settled	Indicates that the cash flow already took place in the form of a receipt and/or a payment if the box is checked.
Cash Flow Daily Details
Cash Flow Date	Shows the date the cash flow starts.
Amount	The cash flow amount from which the daily cash flow is derived.
Amount of Cash Flow Detail	The amount of the cash flow details per day or per period.
Rounding	The amount that will be added to the daily cash flow to compensate for rounding errors.
Explanation	An informative explanation for the daily cash flow amount.

The meaning of the other fields:

Project	The project which the latest estimate is part of.
Start of Projection	The starting date of the cash flow projection.
Net Present Value
Net Present Value	The net present value calculated using the shared cash flow and the interest on the cash flow including the already settled contracts.
Net Present Value Excluding Settled Posts	De netto huidige waarde berekend met behulp van de verdeelde kasstroom en de rente op de kasstromen, exclusief de al afgewikkelde contracten.
Total Settled Posts	Total amount of the up to now settled contracts.
Values at Last Calculation
Budget	The project budget.
Deviation	The difference between the project budget and the project prognosis.
Prognosis	The project prognosis.
Costs	The costs of a project.
Revenues	The revenues of the project.
Project Result	The revenues minus the costs.
Taken Result	Amount at this moment is already booked as loss or profit.
Software Version used in last Calculation	The software version that was used for the final calculation of the cash flow amount or its distribution. If a new software version is installed it is possible that the equation with old cash flow amounts and its distributions is polluted.
Calculate
Date of last Recalculation	Date when the last recalculation took place.
Date Last Distribution	Date when the last distribution took place.
Cash Flows
Calculated Amount	The cash flow amount.

The cash flows per date provide an overview of the historical and projected cash flows:

Cash Flows in time Screen

The cash flows are split into cash flow details. In the bottom part of the screen the cash flow details are shown. Each cash flow is supported with an explanation of the calculation:

Cash Flow Details Screen

In the example above a cost budget of EUR 615,424 was expected. Meanwhile EUR 610,000 is invoiced and paid. According to the expected maturity of the budget, the remaining budget of Eur 5,424 will be used between August 1, 2009 and June 1, 2012.

Important Safety and Usage Information

Intended Use and Limitations: This software, developed by Invantive, is designed to support a variety of business and information technology data processing functions, such as accounting, financial reporting an sales reporting. It is important to note that this software is not designed, tested, or approved for use in environments where malfunction or failure could lead to life-threatening situations or severe physical or environmental damage. This includes, but is not limited to:

Nuclear facilities: The software should not be used for operations or functions related to the control, maintenance, or operation of nuclear facilities.
Defense and Military Applications: This software is not suitable for use in defense-related applications, including but not limited to weaponry control, military strategy planning, or any other aspects of national defense.
Aviation: The software is not intended for use in the operation, navigation, or communication systems of any aircraft or air traffic control environments.
Healthcare and Medicine Production: This software should not be utilized for medical device operation, patient data analysis for critical health decisions, pharmaceutical production, or medical research where its failure or malfunction could impact patient health.
Chemical and Hazardous Material Handling: This software is not intended for the management, control, or operational aspects of chemical plants or hazardous material handling facilities. Any malfunction in software used in these settings could result in dangerous chemical spills, explosions, or environmental disasters.
Transportation and Traffic Control Systems: The software should not be used for the control, operation, or management of transportation systems, including railway signal controls, subway systems, or traffic light management. Malfunctions in such critical systems could lead to severe accidents and endanger public safety.
Energy Grid and Utility Control Systems: This software is not designed for the control or operation of energy grid systems, including electrical substations, renewable energy control systems, or water utility control systems. The failure of software in these areas could lead to significant power outages, water supply disruptions, or other public utility failures, potentially endangering communities and causing extensive damage.
Other High-Risk Environments: Any other critical infrastructure and environments where a failure of the software could result in significant harm to individuals or the environment.

User Responsibility: Users must ensure that they understand the intended use of the software and refrain from deploying it in any setting that falls outside of its designed purpose. It is the responsibility of the user to assess the suitability of the software for their intended application, especially in any scenarios that might pose a risk to life, health, or the environment.

Disclaimer of Liability: Invantive disclaims any responsibility for damage, injury, or legal consequences resulting from the use or misuse of this software in prohibited or unintended applications.

Please enable JavaScript to view this site.

Invantive Estate

Cash flow projections

Important Safety and Usage Information