Thursday, June 10, 2010

Getting the Asus T91MT up to scratch

Here's what I've done:
  1. Had a look at the (pre-installed) Windows 7 OS, and used the Magical Jelly Bean Keyfinder to find out what the registration keys for Windows and for Microsoft Office were. Wrote these down in case they differed from the ones written down on my recovery disk.
  2. Updated the BIOS using the installed "ASUS Update" program.
    Did a clean install of Windows 7. Not having an external DVD drive, I had to fiddle around with transferring the recovery disk to a USB drive: it's darn near impossible to get the recovery disk to boot from a USB drive as is, so I used UltraISO to create a bootable version of Window 7 Home Premium from another copy I have, and the followed this technique to turn it into the Asus recovery disk. This step took a while (both to create the USB boot disk and to install). I set the Asus to boot from the USB as the primary HDD via BIOS (press F2 during the boot sequence to enter the BIOS), but for some reason the install process installed Windows twice before fully setting up.
    (A network install was the other alternative. See here and here for details should you go down that path.)
  3. Manually re-installed the Asus software and services not automatically installed in the previous step (those that I wanted, anyway), and disabled those services/uninstalled the software I didn't want. This was based broadly on these recommendations.What I installed from either the restore disk or the Asus Support Website was:

    • ASUSUpdate
    • AsCalibration
    • Chipset Driver
    • HotKeys
    • IntelliWriting
    • Super Hybrid Engine
    • TouchPad Driver
    • TouchSuite
    • VGA Graphics Driver
     
  4. Turned off or down the graphics effects to improve performance.Other possible performance enhancements include upgrading the RAM to 2GB (you'll need 2GB DDR2 800MhzPC2-6400 RAM for laptops), installing a faster SSD, and overclocking the processor to 1.6Ghz/1.8Ghz. Upgrading RAM is cheap and simple (mine's on the way), but I'll wait until I've done that before messing around with anything else.
  5. Downloaded the "Touch Series Application" pack from the Asus Support Website to get the included "PenWrite" program, which activates global palm rejection (indispensable if you plan on writing on the screen). N.B. This package is available from the T101MT's page (not the T91MT's), under "Utilities".
  6. Installed Microsoft Security Essentials for the AntiVirus, Foxit for the PDF reader, and Firefox as the browser (with AdBlock Plus, Xmarks, and Speed Dial as extensions). Also Digsby for chat, Twitter, and checking emails.
  7. Installed the most recent set of Windows Updates, it being just past Patch Tuesday.
  8. Pulled off all the existing stickers and put my own, bigger sticker on the case :-)
Further updates as they happen...

[Update 1]
I installed and ran CrystalDiskMark to test my hard drive's read/write speed (see below), which compared favourably to those measured by JKK during his SSD upgrade.
Then, since everything looked to be in order, I backed up an image of my system to an external hard drive using the Windows 7 backup utility.

Also bookmarking this post on overclocking for later (includes links to BIOS and drivers).

Wednesday, June 09, 2010

A bit of all right

A hot topic of discussion in the Jones household these past few weeks – we're craaazily exciting, remember – has been the subtle slide of (young) English speakers to using nouns as adjectives. 

I had said something was "a bit crap", and my dad retorted that, if at all, it was "a bit crappy". I try and be correct in my language usage – or, at to be more precise, to only break the rules deliberately – so this misstep made ponder about where this had come from. We couldn't think of too many examples: I've heard people refer to things as "pretty shit", or "kind of poo", and, notably, the ABC's The Hungry Beast has a segment highlighting things they think are "a little bit bullshit."

So, when did we start corrupting "crappy" and "shitty" to just "crap" and "shit"? And is it something confined to defecations-related words? 
The latter hypothesis I rejected when I caught myself saying something could be "pretty fun", which also gave me an insight into how this usage developed. You see, no-one's ever said, "that was a bit funny" and meant it was enjoyable, so there's no way saying "that was a bit fun" came from there – this reasoning is even stronger for "it's kind of poo" or "that's a little bit bullshit", for which adjective variants (it's kind of pooey / that's a little bit bullshitty) are highly unusual to non-existent.

No, the progression comes from the straight comparative construction: "that is crap", "it was fun", etc.; we're saying that one thing is equivalent to another thing, in it's entirety. However, though these words are originally nouns, in this usage – and possibly in others ‐ they are used in the same way as adjectives. And once we start using them as adjectives here, we've obviously started using them as adjectives in other cases; modifying and qualifying them. Thus, things become "a bit crap", rather than "a bit crappy", or even "a bit of crap". (We still use that last one, but in the original comparative sense as a noun.)

Now that I'm aware of the "mistake", I wonder how often I'll notice myself doing it...

Friday, June 04, 2010

It's here!


No prizes for guessing what I'll be doing the rest of the day.

Tuesday, June 01, 2010

Netbook re-shined!

First I wanted it, then I changed my mind, now I'm back on the Asus Eee PC T91 bandwagon – except now it's the T91MT, where the "MT" stands for "multi-touch". Mmmmmmtouchy!

It turns out the T91MT does support handwriting recognition and, with a software upgrade, global palm recognition. It's still underpowered, but apparently that's not so much of a problem as the sometimes slow solid state hard drive. Luckily, the latter can be replaced with a faster SSD.

I've been a bit torn about whether to buy the T91MT or its bigger brother, the T101MT, but I'm leaning towards the former: if I want to get a different product from my Travelmate, it makes no sense to differentiate by degrees – I'd just be trying to decide which to use for the same tasks, when I want to be using them for different tasks.

My inner sense of caution means I probably won't buy it RIGHT NOW (though I have the purchase page open), but soon... perhaps before the day is out.

Mmmmmmm, shiny shiny shiny shiny!

(P.S. Stuff iPads, seriously.)

Friday, May 28, 2010

A man of letters

I sent a letter to The Age yesterday about the Resource Super Profit Tax (RSPT), which was published today with minor alterations. Here is my original text:

RSPT was always going to kick in above 6%
Sir,

Lest the Government's negotiations to raise the rate at which the RSPT takes effect be seen as weakness on their part: the original "Australia's Future Tax System" report clearly stated that the industry needs to be compensated for "the time value of money (the risk-free return) and a premium for the risk associated with investment (the risk premium return for systematic risk)."

Dr. Henry confirmed as much in his post-budget address to the ABE, stating in an example, "The appropriate rate of return for a resource project will include an appropriate risk premium, say 9 per cent. With a risk free rate of 6 per cent, the required rate of return is 15 per cent."

The Government and the miners will now argue about how high the level of systematic risk is, and rightly so. But it seems clear from the report and Dr. Henry's remarks that the RSPT was always going to kick in at 6% + X.

I hold little hope that my letter will be read (or understood) by many, but I do hope I'm taken more seriously than the drongo whose letter followed mine.

N.B. The quotes were taken from the Australia's Future Tax System report and Dr. Henry's address.

Further reading:
Though I don't wish to turn this blog into merely an outlet for my economic and political views, I do find this topic particularly interesting because it's a) a rare public discussion of fairly "pure" economics and b) an issue of political importance, not simply because of the possible tax income but because it's an issue the Rudd Government needs to "perform" on and can't put on the backburner like the Carbon Pollution Reduction Scheme. Success here could – this is my hope – give Labor the guts to engage on climate change again and submit something better than the crap that was their Emissions Trading Scheme.
In any case, I would like to recommend the following three articles by three well-respected economists:
None of them provide all the answers, and you can argue about whether they even ask the right questions. (For the most part, I'd say they do.) But wouldn't it be boring if they did?

Friday, May 21, 2010

Resource Super Profit Tax (RSPT) for Dummies

Since the Australian Government announced its Resource Super Profit Tax (RSPT) recently, based on one of the recommendations of the "Australia's Future Tax System" review (colloquially known as the "Henry review", after the head of Treasury, Dr. Ken Henry), it's become a big topic of discussion. Having had a chance to look at the actual proposal, I feel that much of the mainstream media coverage (including the Government's attempts to "sell" the tax) has been pretty poor, and am going to have a crack at explaining it:

Underpinning the tax is idea of what we're taxing: natural resources (i.e. minerals). These natural resources have the characteristic that they are non-renewable – once they've been dug up and sold, they're gone for good. This is quite different to most things produced in Australia, which are goods or services that to a greater (services) or lesser (some goods) extent can be produced again, and again, and again. You can milk a cow today, and milk it again tomorrow; milking it today does "rob" future generations. However, if we mine something today, we can't mine it again tomorrow: the resource is gone.
Further, natural resources aren't private. They aren't skills someone has learnt; they aren't objects someone has bought or created. They are parts of our country, and as such belong to all Australian citizens. As the Government says (PDF, 372 KB), "If the community undercharges for the use of their non‐renewable resources, it is akin to under‐pricing the sale of a public asset."
These two arguments – and there are others, which I won't go into because I consider this point to be the least debatable in the discussion – provide a strong case for "getting more" out of our natural resources when they are sold, i.e. taxing them more highly.

The question, then, is how to do it. At the moment the states have resource royalties, which are based on the quantity of resources extracted. This is silly, since if two people sell the same quantity of different things, but one makes more profit than the other, taxing them the same amount is clearly unfair. More importantly for our example, a "flat" royalty fee doesn't account for changes in value, so that we – the owners of the resources – aren't getting all we could should be.

What the RSPT does is the following: the Government pays 40% of whatever investments the mining companies make (e.g. on equipment & machinery), in the form of a tax credit. In return, the Government gets a 40% share of the profits.

BUT, the Government doesn't take 40% of all profits. Instead, the mining companies get to make a "normal" profit, to compensate them for the fact that they are running the thing, and taking account for the fact that they could be investing their money somewhere else. A "normal" profit is usually seen as the risk-free return(1) plus the level of systematic risk: in the case of the RSPT, I've heard the figure "6%" used a lot, but I suspect that's just the "risk-free" rate. Based on an example in Dr. Henry's post-budget address to the Australian Business Economists, I suspect the systemic risk is about 9%, which would imply a "normal" profit of about 15%. So it's only once the profits start going ABOVE 15% that the Government steps in and asks for their 40% share (of the excess).  
[EDIT] Based on comments made by Labor pollie Simon Crean today, it looks like the Government actually does intend for the RSPT tax to kick in at 6%. Given that's barely above the risk-free rate, it seems a little low... hmmm.[/EDIT]

Now, the miners still have to pay company tax - on everything: the normal and the super profits. Taxing the normal profits at the normal rate is hard to argue with (everyone else pays it!), and adding the company rate to the RSPT just gives you a higher marginal rate on the super profits. Again, you can argue about the level, but it's not really that high IMO.

The wonderful thing about a tax like the RSPT is that is has very little distortion (if any). That's pretty much the holy grail of public finance/tax policy, because it doesn't change the decisions the market would have made in absence of the tax: profitable mines are still profitable, unprofitable mines don't suddenly become profitable, and – because it only taxes "super" profits – prices shouldn't increase either... theoretically.

What's good for the mining sector is that the old royalty system didn't use to tax profits, but turnover, so even unprofitable mines were being taxed. The RSPT doesn't do that, so "marginal" mines – those on the cusp of making a profit – are benefited. Also, it's part of the proposal that the Government uses a portion of the RSPT to subsidise exploration, which is also good for the miners (and for us).

In short: the owners of the resources (us) get a more equitable return for selling them, resource companies get to make a fair profit before we start sticking out our hand, struggling resource companies aren't unfairly disadvantaged, and some of the proceeds are reinvested to benefit the whole sector.

Post-Script: The argument that implementing the RSPT damages Australia's reputation as a stable regulatory environment has some weight, though not nearly as much as the mining companies would have you believe. However, this is primarily a problem of how the Government has gone about announcing the RSPT (true to form), rather than with the tax itself.

Post- Post-Script: The comparison between the RSPT and the petroleum resource rent tax (PRRT) is a furphy. The RPST gives the miners 40% of their investments back, regardless of whether the project makes a profit or not. The PRRT, on the other hand, only lets the industry use their tax deductions if they make a profit. As the RSPT credits are obviously worth more, the PRRT compensates by using a higher rate – Government bond rate + 5%, I think – than the RSPT to "uplift" the credits (when carrying them forward in time). If you don't understand this, it's okay: we're a little beyond the "for dummies" level here.

(1) The risk-free return is defined as the return on 10-year Government bonds, as you can't get much less risky than that. Currently that's a headline (coupon) rate of 4.5%, but the real return is closer to 5.3% given the coupon price. I don't know which is used, exactly – 5.36% seems the more sensible – but what's bandied about in the media is ~6%

Further Reading:
Post-Budget Address to the Australian Business Economists: http://www.treasury.gov.au/documents/1813/HTML/docshell.asp?URL=Secretary_address_ABE.htm

Douglas Adams: How to Stop Worrying and Learn to Love the Internet

I've just stumbled across a fantastic article by Douglas Adams on the internet, made all the more excellent by the fact he wrote it over a decade ago. You really must read it.
I suppose earlier generations had to sit through all this huffing and puffing with the invention of television, the phone, cinema, radio, the car, the bicycle, printing, the wheel and so on, but you would think we would learn the way these things work, which is this:

1) everything that’s already in the world when you’re born is just normal;

2) anything that gets invented between then and before you turn thirty is incredibly exciting and creative and with any luck you can make a career out of it;

3) anything that gets invented after you’re thirty is against the natural order of things and the beginning of the end of civilisation as we know it until it’s been around for about ten years when it gradually turns out to be alright really.

Apply this list to movies, rock music, word processors and mobile phones to work out how old you are.

Bless him.

Vorne hui, hinten...

One of the first things I did when I got back to Australia was rejoin my old football team, the Eltham Eagles. I think less than a week after being back I was at my first training session, and registered soon after, just before the season began.

The club has changed a bit since last I played for it, and not much for the better. Our home ground is no longer the pitch at Eltham College – my old high school – which was one of the best grounds I've ever played on thanks to access to dam water and comparatively light usage; instead we play on a very new synthetic pitch – also good! However, for various reasons, we don't train on it, instead trekking over to what is basically a paddock in Ivanhoe with two wan floodlights.

More distressing – for me, at least – is the drop in the quality of the team since 2006. Before I went to Germany, we were a solid contender in the top half of the Victorian Churches Soccer Association (VCSA) Division 2, with occasional forays into Division 1. Almost everyone I used to play with has left the club, though, and we now play two divisions lower. Meanwhile, I have gotten much better during my time in Germany. In fact, had I had any concrete idea of where I would be in 6 months time, I would never have joined the club again. But I didn't, so I figured I might as well kick around with these guys until I know what my future holds.

Its depressing, though. Depressing, and frustrating. Our squad is full of young blokes, between the ages of 18 and 24. There's one or two around my age, and two in the their late thirties or early forties, but you can count the number of blokes with real football experience on one hand. Many of the young blokes have some decent skills (or at least show some promise), but the tactical understanding and mental attitude leave worlds to be desired. Know, dear reader, that my baseline of comparison is the lowest German division, and know also that the VCSA goes all the way down to Division 6. So these are by no means the worst of the bunch.

Having spent years as a bit player in Heidelberg, I am now (literally) in the centre of the team; the axis in midfield. I still don't have the best technical skills – that honour goes to our two young forwards, who really are quite good and whom I am incredibly glad to have – but I have "the run", as they say, a bit of tactical nous, and knowledge of how to use my body (all 60kg of it). Though I once aspired to playing in central midfield, in the holding or attacking midfield roles (auf der 6 bzw. 10, für die Deutschen), I've discovered I'm uncomfortable trying to carry a team. Not when I actually want to win things.

In Germany, I was a clown; a guy with a constant smile on his face. I joked around, making fun of everything and everyone: my teammates, the coaches, the club president Here, I yell at people. I yell at the wingers to run, I yell at defenders to push up, I yell at my midfielders to stay closer to their opposition.
In Germany, I didn't yell. In Germany, we'd do a parcour with a wooden bench to spring over; I'd do anything but. I'd do a dive roll, or a cartwheel, click my heels as I went over, or crawl underneath. We ran laps of 400m track to see how many we could do within, I dunno, 4-5 minutes, and every time we passed the 1sts, who were doing exercises near the last corner of the track, I'd send a few jocular insults over at their captain. After four laps one of my teammates yelled at me to shut up, and asked if there was some way of turning me off. Here, my midfielders tell me to shut up because I yell at the defence.

I don't like this role, but as long as the defence isn't doing what they're supposed to, I don't think I can stop yelling. I want to play well, and I want to play in a team that plays well, and if they're just dicking around I either have to change clubs, lower my expectations, or tell them what they're doing wrong. It's really frustrating when players with talent waste in by playing like nongs. Players with good ball skills, athletic builds, and good feel for the game, who just play shit because they're a metre or two too far way from their players and don't put in the effort to get there.
As a result, we lose games we should have drawn, or draw games we should have won. We score the most goals in the division – we really do have a good forward line, even if they are a little profligate now and again – but we also concede the most. That's where the title of this post comes from, actually: at the front "hui", and at the back "pfui" – that should be acoustically close enough for even English-speakers to figure out.

A few weeks ago I was looking through the player passports, and chuckled over mine: the 4:3 photo had somehow been stretched into 4:4, so that my face was both shortened and fattened. "Look at that!", I said to a teammate, "Looks a bit odd, doesn't it?".
"Yeah," he replied, "doesn't look like you all. You're never that happy."

This is my footballing life here, ladies and gentlemen: the ill-tempered German.
*sigh*

Thursday, May 13, 2010

Jedi Jack & Jill – blindfolded swing dancing

The swing dancing scene in Melbourne is awesome. Sometimes I forget that, and then we have a night like Wednesday. Wednesday was Melbourne's (and possibly the world's) first "Jedi Jack & Jill" – blindfolded swing dancing. The term "Jack and Jill" refers to the format of the event, in which lead and follows dancers – traditionally male and female, respectively; hence "Jack" and "Jill" – enter separately and are randomly assigned to one another. The idea is to test pure dancing talent rather than prearranged choreography.

Anyway, this J&J competition upped the stakes by blinding each couple before they danced – and they didn't dance by themselves, oh no! We had four couples on the floor at a time, meaning that the crowd offered significant aural support to help them navigate.

Dancing without visual cues is really difficult, especially in an "open" dance like Lindy Hop(1) (the dancers are connected only by one hand), and extra points were awarded for risky moves i.e. stuff you really shouldn't do blindfolded! I snapped what is probably my favourite, and possibly the best Lindy Hop photo of all time, which demonstrates one such move beautifully:

She's blindfolded, people!

Video of the finalists' dances and some more photos below:





That last song is fast, by the way. Just try counting along and think about taking a step on each beat (sometimes more).



Interested in swing dancing? Swing Patrol have you covered; Melbourne, Sydney, Geelong, Launceston, and even London. Blindfolds are free, but strictly optional. (And for the record: there were no injuries.)

(1) Technically Lindy Hop is both closed and open, because, in the basic step, the partners move together (into "closed" position ) and away (into "open" position) from each other.

Tuesday, May 11, 2010

Annuities, Superannuation, and Geometric Progressions

After a dinner-table discussion about superannuation – I know: the Jones family is craaazily exciting – I came away with two problems I wanted to solve:
  1. If, after I retire, I would like to be able to spend X dollars/euro/whatever every year for N years, what lump sum do I need at retirement to achieve that?
  2. If I start saving now, how much do I need to put aside each year to reach that lump sum?
The first step is to ask yourself what level of income you'd like to have when you retire. My Dad suggested somewhere between 60-80% of your last income before retirement, which seems reasonable: it's not what you really need, but you're probably used to that level of income, and it's what you'd get on a generous pension (see, for example, Greece).
Alternatively, we can just name a figure – I'm calculating in current dollars here, so that should be fairly easy. Let's, an an example, set a goal of AU$60,000 per year for 30 years. (Call me aspirational. *grins*)

A stream of income like this is called an annuity, and calculating their value is reasonably easy; every Commerce student should have covered it introductory Finance. Pretend, for a moment, that you needed to pay someone else $60k, today – how much money would you need? Well, $60k, obviously. Now pretend you only had to pay this amount in one year, and could invest the money until then. How much money would you need today? Only enough so that what you currently have plus the interest you earn equals $60k. If you invest one (1) dollar today, in a year you will have (1+i) dollars, where i is the (nominal) interest rate, e.g. 0.06 or 6%. Working backwards, we can divide our debt from next year by (1+i) and find out how much we need right now; this is called the present value (PV) of the debt.
In algebraic notation, it looks like this:


If we had two years to invest before paying the $60k, we could take advantage of compound interest: the $1 we invest today would be worth (1+i) in one year, and that would be worth that much again the year after – (1+i)x(1+i), or (1+i)2. Algebraically:


By extension, a debt paid three years from now is worth (1+i)3th of its future value, and a debt paid n years from now can be discounted (the technical term for what we're doing) by (1+i)n.

It should hopefully only be a short leap to realising that, from our retirement savings, we will be paying off a debt each year – to ourselves. So the question becomes: if I want to pay myself $60k now, and $60k next year, and $60k the year after that, and so on for n years, how much do I need today? Easy: just take the amounts we calculated above in (1) and (2) and add them together: $60k for today, plus $60k divided by (1+i) for next year, plus ...


The payments quite clearly change from one year to the next at the same rate: to get from one year's payment to the one after it, you divide the first year's payment by a further (1+i), and that's it! That makes these payments a geometric progression, and the rate each one changes by – (1+i) – is the common ratio. So we can also express the amount we need to save as:

Now we get to be clever, and reduce the number of terms. For the sake of abstraction I'm just going to replace "$60,000" with "x", but we'll put it back in at the end:
Before you get too settled with equation (6), we should account for inflation: after all, we don't just want $60,000 every year, we want that amount of purchasing power every year; if the price of everything we buy goes up by 10%, we'd need $60,000 x (1+10%) = $66,000 to buy it all. Sparing you the messy details, (6) becomes (7):
Engineers, physicists and the like will despair at my use of π as a variable, but I am an economist and do not care: here and now, π represents the rate of inflation.

Let's bring this back into a format that you, gentle reader, can more easily utilise. Below you'll find a table containing four variables for you to enter, with the fifth row (in bold) containing equation 7 adapted to use cell references. Simple paste the table into the indicated cells and you should be good to go:

Row/ColumnAB
1Desired annuity60000
2Number of years30
3Expected inflation0.025
4Expected interest rate0.05
5Lump sum needed=B1*(1-(1+B3)^(B2+1)/(1+B4)^(B2+1))/(1-(1+B3)/(1+B4))

I've chosen what I called an "aspirational" target of $60k per year for 30 years – aspiration both because of the level (the average Australian salary is currently around $50,000) and the length (assume a retirement of around 65-70: 30 years beyond that would be a fair effort!). The Reserve Bank of Australia (RBA) has an inflation target of 2-3% over the medium term, so in this example I've pitched the expected inflation into the middle of that range, assuming the RBA will succeed. The expected interest rate is relatively conservative: I get more than that on my bank account. However, it's probably better to err on the side of caution when choosing these variables!

If you've copied the table into your spreadsheet and everything's worked, you should get a lump sum needed of $1,326,088 and change. This is the answer to Question 1, and will be the target of our next set of equations as we seek to answer Question 2.

This time, we're saving an amount every year of our working life – say, 40 years – so that, at the end, we've saved up $1.3 million (in current dollars). The money we invest at the start of of this period gathers more (compound) interest than the money we invest later on, so instead of discounting (dividing) our money figure x by the interest rate we'll multiply it. Conversely, inflation decreases the value of our savings, so that'll come into the equation as a divisor; essentially, the two terms (inflation and interest) have just changed places.

Equation 8 is basically Equation 5 with inflation added and the terms reversed because we're saving to achieve a future value (FV) rather than paying out from a present value.

Now the tricky part to this equation – and the reason I didn't posted this on, say, last Thursday – is accounting for wage increases. Why does that matter? Well, we've started off assuming that we're contributing a fixed amount x each year – but the reality is that, during our working lives, we can expect to earn less at the start and more at the end: it's going to be much easier to save money towards the end of our career than at the start.
The difficulty with accounting for wage increases is that their effect goes the other way to the inflation and the interest rate effects: your first salary will not have increased at all, but anything you save will be subject to a lot of inflation and interest; your last salary will (hopefully) have seen many wage increases, but the money you save from it won't earn any interest or be devalued by inflation. Observe:
The first term x · (1+w)n-1 is the amount (a percentage, perhaps) you're saving from the wage you've earned after 39 wage increases (n = 40 years). The second term is that same amount/percentage two years before retirement: only n-2=38 wage increases, but with one period of interest and one period of inflation effects. What took me a bit of time was converting that series into a neat expression


and figuring out the common ratio

Once you have it, it's not that difficult: (1+w) decreases in k (because we're counting last period to first period), so each progression needs to reduce that (1+w) term by one factor, but after working exclusively with terms that increased in k it took me a little while to figure out. On the plus side, I was proud when I did get there :-)

Anyway, multiplying both sides of (10) by [1-(11)], cancelling out, and then dividing again by [1-(11)] – analogue to what we did in Equation (5) to get to (6) – brings us to the final equation:

Bam. Isn't it pretty? A form only a parent could love, perhaps; be that as it may, it's still very useful! Technically, we can't actually answer Question 2 with the equation in its current form (it would need to be solved for x), but I promised you no more equations; instead I'll give you table with which to play around. You can figure out how much you'll save for various rates of contribution; once you've chosen values for inflation, interest, salary increase, and years worked, you can adjust the savings rate until you reach the lump sum calculated in Question 1:

Row/ColumnAB
11Starting annual salary50000
12Expected yearly salary increase0.025
13Years worked40
14Savings rate0.12
15Expected inflation0.025
16Expected interest rate0.07
17Lump sum at end=((B11*B14)*((1+B12)^(B13-1)))*(1-(((1+B16)^B13)/(((1+B15)^B13)*((1+B12)^B13))))/(1-(1+B16)/((1+B15)*(1+B12)))

I consider the starting values here to be reasonably realistic: the average current annual salary is $50,000; 40 years is a reasonable working life; the current superannuation contribution rate is 12% (in Australia); inflation is in the middle of the RBA's 2-3% band; a 7% interest rate is, I feel, conservative, taking the 10-year Government bond rate of ~5.5% as a baseline and looking to a "normal" long-term market investment return in the low double-digits. Yearly salary increases is not something I have a whole of knowledge about, but I've acted upon the assumption that we work in industries whose (relative) productive value does not decrease over time; that implies that our salaries would increase at least as much as the price level (i.e. by the rate of inflation).

This table is good for just plugging figures and seeing how big a difference various changes in the variables have – a change in the interest rate of 1-percentage point, for example, has almost as much effect as a 3-percentage point change in your savings rate. Lesson: choosing good investments is more important than just savings lots.

With the starting values, the expected savings lump sum is $918k-odd. That's obviously less than the $1.326m we're aiming for, but ratcheting up our savings rate to ~17.5% gets us there. If you think that's high, Germany has a compulsory superannuation contributions rate of roughly 20%; with the current Australian compulsory rate of 12%, another 6% of your post-tax income should do the trick.

Two final points:
  1. Yes, I have used "wage" and "salary" interchangeably here – it's bad, I'm sorry.
  2. I've not accounted for tax in my equations. This is an important omission. I'm not up to date on what the current tax scheme is for superannuation versus other forms on investment. The contributions (savings) themselves are tax free, as far as I know, as is the money you "pay" yourself once in retirement, but I don't know whether the interest you earn in the meantime is taxed, or at what rate. I have the vague recollection that there's a 15% tax in Australia when you withdraw your superannuation, but I'll have to look into that. If anyone knows the specifics, or can point me in the right direction, I'd welcome the assistance!
    Depending on where the tax falls it'll be more or less easy to integrate into the equation: a 15% tax on superannuation returns would simply involve replacing the term (1+i) with (1+i)·(1-t), which isn't too complex.