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

Note to Verbose Commenters
If you can't fit everything you want to say in the comment below then you really should record a response show instead.

Note to Spammers
All comments are moderated. All links are checked by humans. We strip out all html. Feel free to
record a show about yourself, or your industry, or any other topic we may find interesting. We also check shows for spam :).

Provide feedback
Your Name/Handle:
Title:
Comment:
Anti Spam Question: What does the P in HPR stand for ?
Are you a spammer →
Who hosted this show →
What does HPR mean to you ?