Site Map - skip to main content - dyslexic font - mobile - text - print

Hacker Public Radio

Your ideas, projects, opinions - podcasted.

New episodes Monday through Friday.


hpr1525 :: 30 - LibreOffice Calc - A Savings Model

LibreOffice, Calc, Spreadsheet, models, what-if analysis, savings

<< First, < Previous, Latest >>

Host Image
Hosted by Ahuka on 2014-06-06 is flagged as Clean and is released under a CC-BY-SA license.
Listen in ogg, spx, or mp3 format. | Comments (0)

Part of the series: LibreOffice

In this in-depth series on LibreOffice we examine Writer, Calc and Impress

In the previous tutorial we discussed the fundamental ideas of building models and doing “What-If?” analysis. Now we need to take these ideas and put them into practice so you can see how this works. To do this I will create a simple model of savings over time. Now, I do want to be clear that this is a very over-simplified model and should not be taken as a good predictor of actual results. The idea is to illustrate the techniques involved in building a model and doing “What-If?” analysis.

So. what are the variables, parameters, assumptions, etc. that we need? I have identified these in my model:

  • An initial amount of money already saved. This is the starting amount you have.
  • An amount of money you add to your savings each year.
  • The rate of return on your savings

For the remainder of the show notes please see http://www.ahuka.com/?page_id=761

A copy of the spreadsheet created for this program can be found at http://www.ahuka.com/?attachment_id=763


Comments

Subscribe to the comments RSS feed.

Leave Comment

Powered by Comment Script