### Drawing Cash Flow Diagrams with a Spreadsheet.

periods rather than using an x axis with arrows at times 0, 1, 2 ...)

**FIGURE 2-8**Example of cash flow diagram in spreadsheets.

skip to main |
skip to sidebar
###
Drawing Cash Flow Diagrams with a Spreadsheet.

One simple way to draw cash flow diagrams with "arrows" proportional to the size of the cash flows is to use a spreadsheet to draw a stacked bar chart. The data for the cash flows is entered, as shown in the table part of Figure 2-8. Tomake a quick graph, select cells B1 to D8, which are the three columns of the cash flow.Then select the graph menu and choose column chart and select the stack option. Except for labeling axes (using the cells for year 0 to year 6), choosing the scale for the y axis, and adding titles, the cash flowdiagram is done. Refer to the appendix for a review of basic spreadsheet use. (Note: a bar chart labels

periods rather than using an x axis with arrows at times 0, 1, 2 ...)

**FIGURE 2-8 **Example of cash flow diagram in spreadsheets.
## Labels

periods rather than using an x axis with arrows at times 0, 1, 2 ...)

Interest Formulas
(24)
Interest and Equivalence
(20)
Cost Estimating
(19)
Uniform Series
(18)
Economic Decisions
(16)
Engineering Costs
(8)
Cash Flow
(6)
Costs
(3)
Economic Analysis
(3)
General
(3)
Arithmetic Gradient
(2)
Balance
(1)
Gradients
(1)
Interest
(1)
MARR
(1)
Time and Interest
(1)

ENGENIEERING ECONOMIC ANALYSIS. | Based on the Design by Tricks-Collection | Unlimited Entertainment like TV Shows and Movies collections

## 2 comments:

This post assisted me a lot. I wished I found it earlier.

## Post a Comment