Anyone here good with numbers?
Jan. 22nd, 2012 05:06 pm![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png)
I'm currently looking at the difference in price between going to a Samsung Galaxy Nexus by getting a contract (£35-ish/month) or by buying up front (£480+10/month). This works out to about £120-£140 cheaper by buying the phone myself, depending on exactly how I do it.
My question, then, is about discounting future costs. If I spend £480 now rather than in chunks then I lose the utility of that money over the next two years. How does one account for that?
I assume there's a simple equation I could plug in that would tell me to stop being so stupid and just buy the fucking phone, but I'd like to be sure...
My question, then, is about discounting future costs. If I spend £480 now rather than in chunks then I lose the utility of that money over the next two years. How does one account for that?
I assume there's a simple equation I could plug in that would tell me to stop being so stupid and just buy the fucking phone, but I'd like to be sure...
no subject
Date: 2012-01-22 05:14 pm (UTC)I think there's another reason. I'm tied to both my phone and my existing contract for another 18 months. Now, I like my phone, and the contract is OK and suits my needs, but if circumstances change, or a new deal is available, I'm stuck with it, but if you buy the phoen outright you can switch deals to get the best data costs &c without any hassle.
Ultimately, money up front plus small monthly fee is probably better, especially given interest rates and similar are very low currently, but I can't do the maths on that.
no subject
Date: 2012-01-22 05:19 pm (UTC)no subject
Date: 2012-01-22 05:57 pm (UTC)no subject
Date: 2012-01-22 07:35 pm (UTC)no subject
Date: 2012-01-22 07:36 pm (UTC)no subject
Date: 2012-01-22 05:14 pm (UTC)The thing to decide is your discount rate - the value you put on having the cash (all known as the "time value" of cash or - surprise surprise - the interest rate): one would usually use 5% or 10% for simplicity, but when you can only get c 2% interest in the bank that might make more sense.
But it looks like you've already done more or less that calculation - £120-140, you say.
DCF makes more sense over several years - monthly payments complicate it a bit...
no subject
Date: 2012-01-22 05:19 pm (UTC)Not that I have £500 right now, but it sounds like any end-of-year-bonus I get ought to be spent buying the phone.
no subject
Date: 2012-01-22 05:49 pm (UTC)no subject
Date: 2012-01-22 05:50 pm (UTC)no subject
Date: 2012-01-22 06:03 pm (UTC)That £35 would buy you less of -other- things in eighteen months time compared to what it would buy now, but if you sign a contract for £35 then there will be zero inflation for that product (the product being your phone contract) over the following eighteen months. The contract on my phone costs me the same money each month, and I get the same thing every month, regardless of what inflation is running at in the UK.
I would also argue that if you are considering spending £480 on a phone, I would hope that the effect of inflation or indeed savings interest on £35 a month over eighteen months would not be material to you.
no subject
Date: 2012-01-22 06:05 pm (UTC)no subject
Date: 2012-01-22 06:08 pm (UTC)It's most definitely the phone I want (I did a post, and nobody could recommend an alternative that fulfilled all of my requirements).
Buying it outright does give more possibilities for selling it on and getting another one though in a year if I'm staggeringly rich at that point, which is even better.
no subject
Date: 2012-01-22 07:48 pm (UTC)That's why I am now buying unlocked iphones at full retail price direct from Apple. Combined with a SIM-only monthly contract it works out about the same price as a two year contract, but if my carrier goes pear-shaped I can walk at a month's notice. (Oh, and I'm choosing to buy alternate iPhones, i.e. I started on a 3G, skipped the 3GS, am now on a 4, am skipping the 4S, will probably upgrade to an iphone 5 a month or three after it comes out ... unless Apple piss me off in the mean time.)
no subject
Date: 2012-01-22 07:49 pm (UTC)no subject
Date: 2012-01-22 09:24 pm (UTC)The 4S is a fucking fantastic phone, but I don't love it in the same way as I did the 3G. This is entirely down to form factor: I did not and still don't like the 4 design, though it is growing on me daily. As a device to use, it is quite wonderful.
I will be sorely tempted by the 5, assuming I can afford it. The mock-ups posted based on 'insider info' were stunning
having now played with a Galaxy S II, I'm very happy to stick with iPhone. It just feels better to use - and saved my life countless times in Moscow.
no subject
Date: 2012-01-22 06:05 pm (UTC)It's 24 months, and over that time, 10% of £the 840 is 1/6 of the original cost of the phone. That's certainly big enough to be worth taking into consideration.
no subject
Date: 2012-01-22 05:20 pm (UTC)no subject
Date: 2012-01-22 07:13 pm (UTC)no subject
Date: 2012-01-23 10:50 am (UTC)no subject
Date: 2012-01-23 10:53 am (UTC)If I have £100, and there's 5% inflation and 4% interest, then one year from now I'll have £104 and that will be worth £99.04 in today's money.
no subject
Date: 2012-01-22 05:21 pm (UTC)no subject
Date: 2012-01-22 05:24 pm (UTC)no subject
Date: 2012-01-22 05:26 pm (UTC)no subject
Date: 2012-01-22 05:27 pm (UTC)no subject
Date: 2012-01-22 05:39 pm (UTC)no subject
Date: 2012-01-22 06:31 pm (UTC)Your looking for the present value of future cash flows. In your case, with monthly payments, take your interest rate and divide by 12, and do it for 24 periods.
In excel or something similar, copy "25" in a row 24 times (the difference in monthly payments), then somewhere over on the left type "=NPV((5%/12), A1:X1)" and see if that's more or less than the difference in price.
(obviously, "A1:X1" should be replaced by wherever your string of 25s is)
no subject
Date: 2012-01-22 06:32 pm (UTC)no subject
Date: 2012-01-22 07:52 pm (UTC)no subject
Date: 2012-01-22 08:11 pm (UTC)no subject
Date: 2012-01-22 08:15 pm (UTC)no subject
Date: 2012-01-22 08:16 pm (UTC)The key question is what to use as the discount rate. This question is at the heart of the current financial crisis!
I reckon it's defensible to use 0% - to say £1 today is worth £1 tomorrow. The big benefit of this is (a) sums are trivially easier, and (b) it's a nice counterbalance to the human tendency to hyperbolic discounting.
Another quick answer is to use 3% because that's what everybody does.
Or you can try to work it out.
You need to job in a guess for inflation (CPI? RPI? whose forecast)?
Then you need your personal risk-free return rate. This is very apropos at the moment, since if you were doing this for finance purposes you'd use the rate on Government debt ... but the consensus that this is a risk-free return rate is dissolving, to say the least.
I'd say the more important factor is what you'd do with the money otherwise - the opportunity cost. If it'd just be in your current account earning 0.1% minus your top marginal rate of tax, that's negligible, but if on the other hand it would save you from taking out payday loans every month, that's well worth taking in to account.
... out of time, sorry, but you get the idea. Every time I do these sums, buying outright wins by such a spectacular margin I think I must have made some mistake, and I can't really understand why so many people buy on a contract. I mean, even credit card debt works out cheaper.
no subject
Date: 2012-01-22 08:17 pm (UTC)no subject
Date: 2012-01-22 10:23 pm (UTC)no subject
Date: 2012-01-22 11:00 pm (UTC)no subject
Date: 2012-01-22 11:20 pm (UTC)I'd look at "Can I afford to pay up front?" and if yes on that, then "What else could I do with that cash sum?" less in terms of interest, more in terms of buying other things you might want or need.
Another question is the difference between the £10/month contract and the £35/month contract in terms of what they give you, free minutes, texts and internet-wise.
I bought my iPhone 3GS on pay as you go, used it on such for a year (spending about £10 every 2-3 months for more credit), when the free internet that came with the phone ran out, I switched to a £10 for 100 texts, 100 minutes, and Unlimited/2GB internet usage. Whilst I went over it a few times during the Yes campaign, outside of that I rarely use up all of my allowance, but I don't think there's any cheaper option that gets me some level of phoning plus what I really want — the internet.
If your usage is similar to mine, then the buy it and pay £10 a month thing is probably a good solution if the cash is viable — I looked at mine and was saving somewhere between £130-200 depending which contract I'd bought it on, I did have the money to buy it outright with, and I had no other things I desperately needed to buy with that cash.
And for £10/month I can get 300 minutes, 3000 texts and a GB of data from 3. Which looks better than what I have at the moment.
no subject
Date: 2012-01-25 10:24 am (UTC)Never take the contract they advertise. Phone them, and say "I want [shorter contract/ more data allowance/ freebies] for [amount of money]. Or I will go and talk to [other provider] and give them all my money instead. Get back to me if you can't agree that now. You can call me at [convenient time]."
It works most of the time. Unless the phone itself is only available on one network, of course...
no subject
Date: 2012-01-25 10:43 am (UTC)