Featured Book

LaTeX Beginners Guide

Who is online

In total there are 8 users online :: 0 registered, 0 hidden and 8 guests (based on users active over the past 5 minutes)
Most users ever online was 1327 on Tue Nov 05, 2013 7:11 pm

Users browsing this forum: No registered users and 8 guests

Partner Sites

TeXwelt - Fragen und Antworten goLaTeX
TeXblog
TeXnicCenter
TeXample

Cash Flow Timeline in LyX

Add tags Information and discussion about LyX, a WYSIWYM editor, available for Linux, Windows and Mac OS X systems.

Cash Flow Timeline in LyX

Postby Ben85 on Tue Mar 1st, 2011

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
Ben85
 
Posts: 6
Joined: Tue Nov 2nd, 2010

Re: Cash Flow Timeline in LyX

Postby localghost on Wed Mar 2nd, 2011

Ben85 wrote:[…] 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
LaTeX Community Moderator
How to make a "Minimal Example"
Board Rules
Avoidable Mistakes


¹ System: openSUSE 13.1 (Linux 3.11.10), TeX Live 2013 (vanilla), TeXworks 0.5 (r1351)
² Posting stopped indefinitely due to offenses
User avatar
localghost
Site Moderator
 
Posts: 9219
Joined: Fri Feb 2nd, 2007
Location: Braunschweig, Germany

Re: Cash Flow Timeline in LyX

Postby Ben85 on Wed Mar 2nd, 2011

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
Ben85
 
Posts: 6
Joined: Tue Nov 2nd, 2010

Re: Cash Flow Timeline in LyX

Postby d60pmp on Wed Mar 9th, 2011

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.
d60pmp
 
Posts: 17
Joined: Wed Mar 9th, 2011

Re: Cash Flow Timeline in LyX

Postby localghost on Wed Mar 9th, 2011

d60pmp wrote: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  •  Open in writeLaTeX
\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
}

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.
Attachments
financial-timeline.png
The result of the given code.
financial-timeline.png (14.26 KiB) Viewed 2392 times
LaTeX Community Moderator
How to make a "Minimal Example"
Board Rules
Avoidable Mistakes


¹ System: openSUSE 13.1 (Linux 3.11.10), TeX Live 2013 (vanilla), TeXworks 0.5 (r1351)
² Posting stopped indefinitely due to offenses
User avatar
localghost
Site Moderator
 
Posts: 9219
Joined: Fri Feb 2nd, 2007
Location: Braunschweig, Germany

Re: Cash Flow Timeline in LyX

Postby Ben85 on Fri Apr 29th, 2011

Thank you for this solution!

Wbr Benjamin
Ben85
 
Posts: 6
Joined: Tue Nov 2nd, 2010


Return to LyX

Who is online

Users browsing this forum: No registered users and 8 guests