Sign in to follow this  
Followers 0

HPR - HPR1525: 30 - LibreOffice Calc - A Savings Model

1 post in this topic

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

A copy of the spreadsheet created for this program can be found at

Go to this episode


Share this post

Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  
Followers 0