{"id":292,"date":"2008-10-07T20:17:17","date_gmt":"2008-10-07T19:17:17","guid":{"rendered":"http:\/\/cyberelk.net\/tim\/?p=292"},"modified":"2014-05-20T09:09:12","modified_gmt":"2014-05-20T08:09:12","slug":"expendable-tutorial","status":"publish","type":"post","link":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/","title":{"rendered":"Expendable tutorial (offset mortgage calculator)"},"content":{"rendered":"<p>This is a quick guide to using <a href=\"https:\/\/cyberelk.net\/tim\/2008\/09\/11\/modelling-home-finances\/trackback\/\">Expendable<\/a> for modelling home finances.\u00a0 If you want to be able to predict how much time or interest can be saved on a mortgage by using an offset facility, or want to see the effects of using a cash ISA or regular saver account, or any other type of savings account, this might be for you.<\/p>\n<p><!--more--><\/p>\n<p>Start off by installing it.\u00a0 On Fedora 9 you can do this by  selecting System \u2192 Administration \u2192 Add\/Remove Software from the menu and searching for &#8220;expendable&#8221;.\u00a0 If you are using Fedora 8, select Applications \u2192 Add\/Remove Software.<\/p>\n<p>After installing it, you can run the program by selecting Applications \u2192 Office \u2192 Expendable from the main menu.\u00a0 You should see something like this (click for a close-up):<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"341\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable13\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13.png\" data-orig-size=\"887,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Start-up window\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13.png\" class=\"alignnone size-medium wp-image-341\" title=\"Start-up window\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png\" alt=\"\" width=\"450\" height=\"324\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13.png 887w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<h3>A straightforward mortgage<\/h3>\n<p>This example data shows how the program can be used straight away.\u00a0 Let&#8217;s say we have a mortgage with Nationwide, with an outstanding balance of \u00a380,500 and 12 years 3 months left to run. (These figures will be on your most recent mortgage statement.)<\/p>\n<p>Click on &#8216;My Mortgage&#8217; in the account name field on the left hand side, about half-way down the screen, and replace that text with &#8220;Nationwide Mortgage&#8221;.\u00a0 Let&#8217;s say the interest rate is 6.5% APR: use the up-arrow button next to the interest rate field to set that.\u00a0 You&#8217;ll notice the graph changing as you do this.\u00a0 Now adjust the loan amount to \u00a380,500 (you&#8217;ll have to type in &#8220;80500&#8221;, as the up\/down arrows make changes in increments of \u00a31,000).\u00a0 Now use the arrow buttons on the next line down to adjust the term to 12 years and 3 months.\u00a0 Your window should now look like this:<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"343\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable22\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Straightforward mortgage\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22.png\" class=\"alignnone size-medium wp-image-343\" title=\"Straightforward mortgage\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable22.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>As you can see, the graph has been updated to reflect the details we just entered.\u00a0 The horizontal axis shows time moving forward, with 5-year intervals marked.\u00a0 The red line shows the outstanding mortgage balance over time, decreasing more quickly when the loan is nearly repaid.\u00a0 The green line shows the total amount of interest paid.<\/p>\n<p>Below the graph are some figures illustrating this.\u00a0 The &#8220;overview&#8221; part shows the total amount of interest paid.\u00a0 Click on the &#8220;Nationwide Mortgage&#8221; part to see more details about the mortgage:<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"345\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable32\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32.png\" data-orig-size=\"503,123\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Mortgage details\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32.png\" class=\"alignnone size-medium wp-image-345\" title=\"Mortgage details\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32-450x110.png\" alt=\"\" width=\"450\" height=\"110\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32-450x110.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable32.png 503w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<h3>Using an offset facility<\/h3>\n<p>So much for the mortgage; now let&#8217;s try something interesting.\u00a0 We can find out the effect on the mortgage if we are able to overpay each month by, say, \u00a320.\u00a0 To do this, click on &#8216;Monthly overpayment&#8217; in the box on the left hand side.\u00a0 Below the box, adjust the &#8216;amount each month&#8217; field to 20.\u00a0 Now there is a blue line on the graph, and this illustrates the amount in the offset facility of the mortgage.<\/p>\n<p>Paying an extra \u00a320 each month into a mortgage that has an offset facility increases the amount in the offset by that much.\u00a0 It is effectively a savings account, but rather than paying interest on the amount in the offset account, the amount of interest charged on the mortgage is reduced as though the loan amount were smaller.<\/p>\n<p>As you can see, the loan term has now shortened by 5 months, to 11 years and 10 months.\u00a0 This is a saving in mortgage interest of over \u00a31,500.\u00a0 When the blue line (the offset account) hits the red line (the outstanding loan amount), they both drop to zero &#8212; at that point, the loan has been repaid.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"346\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable42\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Using an offset\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42.png\" class=\"alignnone size-medium wp-image-346\" title=\"Using an offset\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable42.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>You can save this model by selecting File \u2192 Save As&#8230; from the menu.<\/p>\n<h3>Savings account with fixed term deposit<\/h3>\n<p>Now let&#8217;s try an example using a savings account as the main focus.\u00a0 This time, we have \u00a310,000 in a savings account paying 6.5% AER, but we want to put half of it into a high-interest fixed term deposit.\u00a0 The FTD pays 10% AER but locks away the money for a year.<\/p>\n<p>To set this up, select File \u2192 New from the menu, choose Savings Account, and click OK.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable52.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"347\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable52\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable52.png\" data-orig-size=\"424,191\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Choosing an account type\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable52.png\" class=\"alignnone size-medium wp-image-347\" title=\"Choosing an account type\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable52.png\" alt=\"\" width=\"424\" height=\"191\" \/><\/a><\/p>\n<p>Name this account &#8220;Savings&#8221; and set the rate and balance.\u00a0 Leave the tax rate at 20% &#8212; this means that our savings interest is taxed at the basic rate.\u00a0 The graph is drawn showing an ever-increasing balance.\u00a0 By default, the first 30 years are modelled, and for this example we only want to see the first year.\u00a0 Adjust the &#8216;Limit&#8217; fields at the top left of the window, below the &#8216;Run model&#8217; checkbox, to &#8220;1 yrs 0 mths&#8221;.\u00a0 Notice that below the graph, the final balance of the savings account is shown in the &#8220;Savings&#8221; tab: \u00a310,516.97.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"348\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable62\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Savings account\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62.png\" class=\"alignnone size-medium wp-image-348\" title=\"Savings account\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable62.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>Now we want to add a fixed term deposit.\u00a0 Select Edit \u2192 Add Account from the menu and choose Fixed Term Deposit, then click OK.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"349\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable71\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71.png\" data-orig-size=\"492,316\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Adding a fixed term deposit\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71.png\" class=\"alignnone size-medium wp-image-349\" title=\"Adding a fixed term deposit\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71-450x289.png\" alt=\"\" width=\"450\" height=\"289\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71-450x289.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable71.png 492w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>Name this account &#8220;FTD&#8221; and set the rate to 10.\u00a0 Now adjust the amount up to 5000.\u00a0 The final balance in the savings account after 1 year is now shown as \u00a310,677.67, and by flipping between the &#8220;Savings&#8221; and &#8220;FTD&#8221; tabs below the graph we can see that this is due to \u00a3281.20 in interest from the savings account and \u00a3396.47 from the fixed term deposit.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"350\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable82\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Savings account with fixed term deposit\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82.png\" class=\"alignnone size-medium wp-image-350\" title=\"Savings account with fixed term deposit\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable82.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>This example shows a bit more about how the accounts tree works.\u00a0 The fixed term deposit account takes its initial balance from its &#8220;parent&#8221; account, the savings account.\u00a0 When the term is up, it pays back into its parent account.\u00a0 This sort of thing works for mortgages too.\u00a0 You can set up quite complicated arrangements if you wish, for example a mortgage which will be paid off by a savings account, which in turn has several linked fixed term deposits.\u00a0 The example data file shown when you first start the program gives a good starting point for experimentation.<\/p>\n<p>You can also use this example to see the effect of waiting 6 months before setting up the fixed term deposit, as follows.\u00a0 First, increase the limit to 2 years.\u00a0 Next, find the &#8220;Start: 0 mths late&#8221; part and adjust it to &#8220;6 mths late&#8221;.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"351\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable91\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Delayed fixed term deposit\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91.png\" class=\"alignnone size-medium wp-image-351\" title=\"Delayed fixed term deposit\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable91.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<h3>Savings account with regular saver<\/h3>\n<p>Here&#8217;s another example using a savings account.\u00a0 In this case, we&#8217;ll be &#8220;drip-feeding&#8221; a regular saver account from a savings account.\u00a0 A regular saver account is similar to a fixed term deposit, but rather than setting it up from one lump sum at the beginning, monthly contributions are made.\u00a0 Typically these last for a year and the maximum monthly contribution is \u00a3250.\u00a0 The money is locked away for that time.\u00a0 For our example, the savings account pays 6.5% AER, we have \u00a310,000 in it, and the regular saver pays 10% AER and we want to pay \u00a3250 into it each month.<\/p>\n<p><a href=\"http:\/\/www.moneysavingexpert.com\/\">Martin Lewis&#8217;s web site<\/a> has a <a href=\"http:\/\/www.moneysavingexpert.com\/savings\/best-regular-savings-accounts#savingscalc\">calculator<\/a> for modelling just this type of situation.<\/p>\n<p>So, here&#8217;s how we&#8217;ll set it up: first, select File \u2192 New from the menu and choose to create a savings account.\u00a0 Give it a name, and set the rate to 6.5 and balance to 10000.\u00a0 Now select Edit \u2192 Add Account and add in a Regular Saver.\u00a0 Give that a name and set the rate to 10, and the monthly amount to 250.\u00a0 Set the limit to 1 year to see the result: the total interest earned in the first year is \u00a3542.44, with \u00a3434.92 of that coming from the normal savings account and \u00a3107.52 from the regular saver.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"352\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable101\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Regular saver\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101.png\" class=\"alignnone size-medium wp-image-352\" title=\"Regular saver\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable101.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<h3>Using up savings<\/h3>\n<p>Finally, let&#8217;s try an example in which we have savings, but are spending them.\u00a0 The questions we need to know the answers to are: how much can we overspend by each month, and how long can that last before the savings run out?<\/p>\n<p>We&#8217;ll use the same data as in the previous example, but we&#8217;d better make sure we set the &#8220;minimum amount&#8221; for the regular saver.\u00a0 If there is not enough money to contribute the monthly amount (\u00a3250), the minimum amount will be contributed.\u00a0 Let&#8217;s say that in this example, there is no flexibility at all: the minimum is \u00a3250 as well.<\/p>\n<p>To simulate spending with abandon, add another account, this time of type &#8220;spending&#8221;.\u00a0 Now, click on the up-arrow next to &#8220;amount each month&#8221; until the amount stops changing.<\/p>\n<p><a href=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112.png\"><img loading=\"lazy\" decoding=\"async\" data-attachment-id=\"353\" data-permalink=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/expendable112\/\" data-orig-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112.png\" data-orig-size=\"889,639\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;}\" data-image-title=\"Spending too much\" data-image-description=\"\" data-image-caption=\"\" data-large-file=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112.png\" class=\"alignnone size-medium wp-image-353\" title=\"Spending too much\" src=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112-450x323.png\" alt=\"\" width=\"450\" height=\"323\" srcset=\"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112-450x323.png 450w, https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable112.png 889w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/a><\/p>\n<p>A vertical line is drawn at the point in time where spending any more each month will result in the savings running out: 11 months from now, if the monthly shortfall is \u00a3590.<\/p>\n<h3>Feedback please!<\/h3>\n<p>There are lots of ways of combining different account models, and lots of different types of questions that can be answered by using this modelling program.\u00a0 If you have a problem getting it to behave the way you want it to, or have an idea for making it better, please let me know by adding a comment below.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This is a quick guide to using Expendable for modelling home finances.\u00a0 If you want to be able to predict how much time or interest can be saved on a mortgage by using an offset facility, or want to see the effects of using a cash ISA or regular saver account, or any other type [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2}},"categories":[3],"tags":[17,15,96],"class_list":["post-292","post","type-post","status-publish","format-standard","hentry","category-software","tag-expendable","tag-money","tag-software"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Expendable tutorial (offset mortgage calculator) - PRINT HEAD<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/\" \/>\n<meta property=\"og:locale\" content=\"en_GB\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Expendable tutorial (offset mortgage calculator) - PRINT HEAD\" \/>\n<meta property=\"og:description\" content=\"This is a quick guide to using Expendable for modelling home finances.\u00a0 If you want to be able to predict how much time or interest can be saved on a mortgage by using an offset facility, or want to see the effects of using a cash ISA or regular saver account, or any other type [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/\" \/>\n<meta property=\"og:site_name\" content=\"PRINT HEAD\" \/>\n<meta property=\"article:published_time\" content=\"2008-10-07T19:17:17+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2014-05-20T08:09:12+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png\" \/>\n<meta name=\"author\" content=\"Tim Waugh\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Tim Waugh\" \/>\n\t<meta name=\"twitter:label2\" content=\"Estimated reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/\"},\"author\":{\"name\":\"Tim Waugh\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#\\\/schema\\\/person\\\/23b749f30a67f1b1c6af17024fc94bf6\"},\"headline\":\"Expendable tutorial (offset mortgage calculator)\",\"datePublished\":\"2008-10-07T19:17:17+00:00\",\"dateModified\":\"2014-05-20T08:09:12+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/\"},\"wordCount\":1379,\"publisher\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#\\\/schema\\\/person\\\/23b749f30a67f1b1c6af17024fc94bf6\"},\"image\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/expendable13-450x324.png\",\"keywords\":[\"expendable\",\"money\",\"Software\"],\"articleSection\":[\"Software\"],\"inLanguage\":\"en-GB\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/\",\"url\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/\",\"name\":\"Expendable tutorial (offset mortgage calculator) - PRINT HEAD\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#primaryimage\"},\"thumbnailUrl\":\"http:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/expendable13-450x324.png\",\"datePublished\":\"2008-10-07T19:17:17+00:00\",\"dateModified\":\"2014-05-20T08:09:12+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#breadcrumb\"},\"inLanguage\":\"en-GB\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#primaryimage\",\"url\":\"http:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/expendable13-450x324.png\",\"contentUrl\":\"http:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2008\\\/10\\\/expendable13-450x324.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/2008\\\/10\\\/07\\\/expendable-tutorial\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Expendable tutorial (offset mortgage calculator)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#website\",\"url\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/\",\"name\":\"PRINT HEAD\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#\\\/schema\\\/person\\\/23b749f30a67f1b1c6af17024fc94bf6\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-GB\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/#\\\/schema\\\/person\\\/23b749f30a67f1b1c6af17024fc94bf6\",\"name\":\"Tim Waugh\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-GB\",\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/printhead.png\",\"url\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/printhead.png\",\"contentUrl\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/printhead.png\",\"width\":731,\"height\":140,\"caption\":\"Tim Waugh\"},\"logo\":{\"@id\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/wp-content\\\/uploads\\\/2023\\\/01\\\/printhead.png\"},\"sameAs\":[\"http:\\\/\\\/cyberelk.net\\\/tim\"],\"url\":\"https:\\\/\\\/cyberelk.net\\\/tim\\\/author\\\/twaugh\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Expendable tutorial (offset mortgage calculator) - PRINT HEAD","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/","og_locale":"en_GB","og_type":"article","og_title":"Expendable tutorial (offset mortgage calculator) - PRINT HEAD","og_description":"This is a quick guide to using Expendable for modelling home finances.\u00a0 If you want to be able to predict how much time or interest can be saved on a mortgage by using an offset facility, or want to see the effects of using a cash ISA or regular saver account, or any other type [&hellip;]","og_url":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/","og_site_name":"PRINT HEAD","article_published_time":"2008-10-07T19:17:17+00:00","article_modified_time":"2014-05-20T08:09:12+00:00","og_image":[{"url":"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png","type":"","width":"","height":""}],"author":"Tim Waugh","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Tim Waugh","Estimated reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#article","isPartOf":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/"},"author":{"name":"Tim Waugh","@id":"https:\/\/cyberelk.net\/tim\/#\/schema\/person\/23b749f30a67f1b1c6af17024fc94bf6"},"headline":"Expendable tutorial (offset mortgage calculator)","datePublished":"2008-10-07T19:17:17+00:00","dateModified":"2014-05-20T08:09:12+00:00","mainEntityOfPage":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/"},"wordCount":1379,"publisher":{"@id":"https:\/\/cyberelk.net\/tim\/#\/schema\/person\/23b749f30a67f1b1c6af17024fc94bf6"},"image":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#primaryimage"},"thumbnailUrl":"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png","keywords":["expendable","money","Software"],"articleSection":["Software"],"inLanguage":"en-GB"},{"@type":"WebPage","@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/","url":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/","name":"Expendable tutorial (offset mortgage calculator) - PRINT HEAD","isPartOf":{"@id":"https:\/\/cyberelk.net\/tim\/#website"},"primaryImageOfPage":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#primaryimage"},"image":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#primaryimage"},"thumbnailUrl":"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png","datePublished":"2008-10-07T19:17:17+00:00","dateModified":"2014-05-20T08:09:12+00:00","breadcrumb":{"@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#breadcrumb"},"inLanguage":"en-GB","potentialAction":[{"@type":"ReadAction","target":["https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/"]}]},{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#primaryimage","url":"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png","contentUrl":"http:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2008\/10\/expendable13-450x324.png"},{"@type":"BreadcrumbList","@id":"https:\/\/cyberelk.net\/tim\/2008\/10\/07\/expendable-tutorial\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/cyberelk.net\/tim\/"},{"@type":"ListItem","position":2,"name":"Expendable tutorial (offset mortgage calculator)"}]},{"@type":"WebSite","@id":"https:\/\/cyberelk.net\/tim\/#website","url":"https:\/\/cyberelk.net\/tim\/","name":"PRINT HEAD","description":"","publisher":{"@id":"https:\/\/cyberelk.net\/tim\/#\/schema\/person\/23b749f30a67f1b1c6af17024fc94bf6"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/cyberelk.net\/tim\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-GB"},{"@type":["Person","Organization"],"@id":"https:\/\/cyberelk.net\/tim\/#\/schema\/person\/23b749f30a67f1b1c6af17024fc94bf6","name":"Tim Waugh","image":{"@type":"ImageObject","inLanguage":"en-GB","@id":"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2023\/01\/printhead.png","url":"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2023\/01\/printhead.png","contentUrl":"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2023\/01\/printhead.png","width":731,"height":140,"caption":"Tim Waugh"},"logo":{"@id":"https:\/\/cyberelk.net\/tim\/wp-content\/uploads\/2023\/01\/printhead.png"},"sameAs":["http:\/\/cyberelk.net\/tim"],"url":"https:\/\/cyberelk.net\/tim\/author\/twaugh\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/pnnS2-4I","_links":{"self":[{"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/posts\/292","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/comments?post=292"}],"version-history":[{"count":1,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/posts\/292\/revisions"}],"predecessor-version":[{"id":1069,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/posts\/292\/revisions\/1069"}],"wp:attachment":[{"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/media?parent=292"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/categories?post=292"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cyberelk.net\/tim\/wp-json\/wp\/v2\/tags?post=292"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}