Gallery
Time & Money v2
Share
Explore

icon picker
Cash Flow Rules

Nimbulus
results summary:

Total revenues:
$1,183,804
| Net cash flow:
$166,599
| Net present value:
$59,909
| IRR:
45.54%
This section is where the lines in the cash flow are programmatically defined. Select the rule that defines a cash flow in the "Cash flow rule" column. Change the numerical parameters that the rule uses in the "Amount," "Base," and "Growth Factor" columns. The values that will appear in the cash flow based on the rule and parameters selected are shown in the "Periodic Value" column. This table is only a sampling of what could be done with rule-based cash flow definitions.
Item
Section
Schedule Link
Cash flow rule
Amount
Growth Rate
Periodic Value
1
1 Widget sales
Revenues
Production
Amount with growth factor
$95,000
4.80%
$95,000
2
1 Overhead
Expenses
Overall
Amount every period
$10,000
2.50%
-$10,000
3
2 Bus. planning
Expenses
Setup
Amount spread evenly
$17,000
2.50%
-$5,667
4
3 Design
Expenses
Product development
Amount spread evenly
$40,000
2.50%
-$6,667
5
4 Development
Expenses
Product development
Amount spread evenly
$80,000
2.50%
-$13,333
6
5 Pre-marketing
Expenses
Pre-production
Amount every period
$60,000
2.50%
-$60,000
7
6 Manufacturing
Expenses
Production
Amount every period
$25,000
2.50%
-$25,000
8
7 Marketing
Expenses
Production
Amount every period
$8,000
2.50%
-$8,000
There are no rows in this table

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.