LyX ⇒ Cash Flow Timeline in LyX

[Ben85]

Hello all!
Thank you for a nice forum.

I had been doing some Finance lately which requires the use of timeline.
However, I still draw them in PPt og that like...

Hmm, so I hope you guys can help me out.

A timeline with cashflows, and the possibility to draw arrows to show pv, fv and so on.

WBR
Benjamin

[localghost]

[…] A timeline with cashflows, and the possibility to draw arrows to show pv, fv and so on.[…]

Can you translate that into a common language so everybody who is not familiar with these acronyms can understand it? If I would talk about AES, MBE and XPS you wouldn't understand, too. And by the way it would be helpful if can give a visual example of such a time line.


Best regards and welcome to the board
Thorsten

[Ben85]

Ofcourse, that was foolish of mé to assume that you knew.

And example look at http://www.calcblog.com/business-financ ... nuity-due/

So a cash flow timeline is an ordinary horisontal timeline that shows numbers at different time. Cash in or cash out.

The mission is with the interest to be able to compare allings over time, by calculating the value of the cash flow to the same point in time.

It is common to show by arrows which amounts that has ben discounted back in time or forth, by showing a bendes arror from that amount back to the relant time.

I hope Thisted cleared some.

Thank you.

Wbr Benjamin

[d60pmp]

I don't know if there's any good software for doing specifically this, but for drawing simple diagrams there are MUCH better drawing programs than powerpoint!

I suggest Inkscape http://inkscape.org/, although it may be overkill for what you need.

[localghost]

I don't know if there's any good software for doing specifically this […]

Oh yes, there is. The pgf/tikZ package is doing a great job here (see attachment).

Code: Select all

Code, edit and compile here:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
\documentclass{standalone}
\usepackage{siunitx}
\usepackage{tikz}
\usetikzlibrary{calc,matrix}
\sisetup{%
  group-digits=true,
  group-four-digits=true,
  group-separator={,},
  output-decimal-marker={.}
}
\begin{document}
  \begin{tikzpicture}[>=stealth,ultra thick]
    \draw[->] (0,0) -- (10,0);
    \draw (-1,0) node[below] {n} (-1,0.5) node[above] {PMT};
    \foreach \x/\n in {1/0,3/1,5/2,7/3,9/4}
      \draw (\x,0) node(\n)[below] {\n} -- (\x,0.5);
    \foreach \x/\n in {1/0,3/1,5/2,7/3}
      \draw (\x,0.5) node[above] {\num{5000}};
    \matrix (calc) [matrix of math nodes,matrix anchor=north west,nodes={anchor=east}] at (9,-1) {%
      \$ \num{5300.00} & = & \num{5000}\times (\num{1.06})^1 \\
      \$ \num{5618.00} & = & \num{5000}\times (\num{1.06})^2 \\
      \$ \num{5955.08} & = & \num{5000}\times (\num{1.06})^3 \\
      \$ \num{6312.38} & = & \num{5000}\times (\num{1.06})^4 \\
      \$ \num{23185.46} \\
    };
    \draw[thick] (calc-5-1.north west) -- (calc-5-1.north east);
    \foreach \n/\l in {0/4,1/3,2/2,3/1}
      \draw[->,gray!50] (\n) |- ($(calc-\l-1.west)+(-0.5,0)$);
  \end{tikzpicture}
\end{document}
 
 
הההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההההה
XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX

Run LaTeX here

The only disfigurement is a misplaced equal sign in the equation system and I don't know why. I'm thinking about doing this in a different way but the matrix is easier for the arrow connections.

I'm sure this can be done similarly in PSTricks, but pgf/tikZ appeared easier to me. And since I don't use LyX, I have no idea how to incorporate this solution into a LyX document.

[Ben85]

Thank you for this solution!

Wbr Benjamin