Monday, December 3, 2007

Trends in the Second Life Economy

Awhile ago, Intlibber Brautigan brought up to me the idea of the SL economy having a cycle based on the college year, with recessions in the summer and more economic activity during other parts of the year. While data certainly supports that this year, there may also be some confounding with the gambling ban.

I meant to do a statistical test on this awhile back, but forgot. Sad, but true. Anyway, I remembered the idea, and thought I'd give it a shot. Unfortunately, I promptly ran into the limits of Excel before recalling that my Regression and Time Series class used specialty software to do its magic. Does anyone out there know of a good, free, and somewhat easy-to-use statistical analysis package?

In consolation to my lack of findings with the seasonal analysis, I did at least find that the Total Hours data fits very well to an exponential curve. However, it doesn't take a statistical analysis to see that - just to quantify it. For those interested, the formula turned out to be

62293.35 + e^(.124155t), where t is months since August 2003

and the significance values were all under 10-40. The saving grace for Intlibber's proposition, however, is the residual plot which seems to demonstrate some autocorrelation that could mean seasonality.

You can find the Google Spreadsheet here. (Scroll down a little to see the graph of the residuals. I'd like to make it prettier, but I'm still learning Google Spreadsheets for now.) Again, anyone who knows of nice, free software for statistical analysis, please comment.

Let me introduce myself

This night I happened to meet Guardian Market over at the AVC Finance Center, where I do have an office.

We chatted a bit and he asked me if I would have liked to write here. After some thinking, I said yes.

You may not know me (most likely); I am the Communication and Public Relations Director for the VSTEX, a community based virtual stock exchange in Second Life.

I do have a blog of mine but it's more a personal diary (sort of) and it's hardly updated (spare time is such a rare commodity!).

Here I'll talk about the SL financial world and maybe something else related to the metaverse we love so much.

I won't use this blog as free advertising for the VSTEX and I'll try to be neutral, anyway remember who I am when you'll read my posts.

Hope the relationship between me as a writer and you as a reader will work.

Happy trading!

Samantha Goldflake

Saturday, December 1, 2007

Lessons in FM: Part II - Annuities

Note: This is a continuation of the series Lessons in Financial Mathematics. Please read Part I - Present Value if you have not already done so. It will aid greatly in your understanding of subsequent parts of the series.

Now that you understand the basics of present value, you might see how this could possible get a little cumbersome. For example, if you had monthly payments due for 30 years on a mortgage, you could do the sum of all the present values...all 30*12=360 of them...but it would take awhile. Fortunately, there is a better way: geometric series to the rescue!

From your early algebra classes (and I know all of you treasured those greatly), you might recall that if you have a sum where the terms increase or decrease by a common ratio (r) then you can easily condense the sum into a compact formula. The proof is very compact, but I will summarize the findings here:

a + a*r + a*r2 + a*r3 + ... + a*rn = a*(1-rn+1)/(1-r)

There's also a version for an infinite sum, provided that |r|<1:>2 + a*r3 + ... = a* (1/(1-r))

If we had a series of payments occurring at regular intervals, they would likely look something like this, where P is the payment, PV is present value, v is (as defined in Part I) 1/(1+i), i is the interest rate, and there are n payments:

P + P*v + P*v2 + P*v3 + ... + P*vn-1 = PV

(we use n-1 because we started at time t=0, so going from that to n-1 gives n payments) using the geometric series above, this simplifies to:

PV = P*(1-vn)/(1-v)

and 1-v can be simplified to i/(1+i) (I leave that proof to the reader). In FM, we define the discount rate d = i/(1+i). Therefore, the entire formula reduces to:

PV = P*(1-vn)/d

Cute, huh? Note that this formula is applicable if payments are made at the beginning of the period. If they are made at the end of the period, then you replace the d with an i (for the interest rate) and the formula still works (I'll leave the proof of that to the reader). Actuaries have a special symbol for that, which will be rather difficult to put in Blogger. It's named "a-double-dot angle n", and is a lowercase "a" with two dots over it. I can find an image of it from the Wikipedia article on actuarial notation:




The lowercase a represents the fact that it's an annuity (as opposed to being a capital A, which would represent an insurance). The angle-n represents that the payment is guaranteed for n periods. The double-dot represents that the payment occurs at the beginning of the period (if it is missing, then it occurs at the end of the period). The i after the angle is often omitted, but is simply a reminder of what interest rate is being used.

For the remainder of this post, I will assume end of period payments (thus eliminating the need for double dots), and spell out "a-angle-n" whenever I need to use it.

Let's do an example. Suppose you want to take out a loan for L$10,000 and the banker wants to charge you 7% interest. You agree to pay the loan back over 30 periods. The question then becomes, how much is the payment.

To solve this, you use the formula above. You know the present value (10,000), the interest rate (0.07), and the number of periods (n), so you just solve for the payment.

PV = P * "a-angle-30"
10,000 = P * (1 + (1/1.07)^30)/(0.07)
10,000 = P * (12.40904)
P = 805.86

Your payment would be L$805.86 at the end of each period.

You might be saying "there has to be an easier way" at this point. Fortunately, there is. I give you, the financial calculator! To show you how to use this, we'll go over the previous example again with the calculator.

To start, note that the general way of inputting numbers to the right-hand side of that calculator is to enter the number first, and then press the value that you want it to go to. Also note that we enter percentages, so 7% is entered at 7, not 0.07. To do the previous example, follow these steps:

  1. Enter 10000
  2. Press PV
  3. Enter 7
  4. Press i%
  5. Enter 0
  6. Press FV (the loan is worth zero at the end)
  7. Enter 30
  8. Press N
  9. Press Calculate
  10. Press PMT
Now, observe that the number it spit out was the same as I calculated above (rounded): 805.86. Funny how that works.

I haven't actually defined that funny word in the title of the article yet: annuities. An annuity is a set of payments, guaranteed or conditional, that occur at regular intervals. There is a lot more detail that can be set up with annuities, such as varying the frequency of payment (say, to quarterly), the amount of payment (increasing/decreasing), the time frame (infinite annuity = perpetuity, by the way), etc. These are annuities, and they are the basis of loans, dividends, millions of people's retirements, insurance, etc. Annuities are quite flexible and applicable in a variety of financial settings.

I'll leave you to play with that calculator. Note that it only appears to do end-of-period calculations. You can enter any four of the five variables, and it'll compute the last one (provided it is solvable). The next segment will have less math (I think...) and deal with a more economic topic: Risk.

Friday, November 30, 2007

One Year - An Observation

I recently passed my first birthday in Second Life, having entered into The Grid on November 20, 2006. Shortly after entering and figuring out the basics of getting around, I noted an interesting phenomenon for a world so creative: There were no capital markets. There were some banks, and some places that would lend you funds if you had land as collateral, but nowhere (that I could find) could you find a stock or a bond.

One year later, there are six stock exchanges, a myriad of banks, insurance companies, hedge funds, and a whole realm of new devices to support them. What a difference a year makes.

Goodbye to a SL media figurehead

As I mentioned at SLReports.net, I found out late last night that SLNN.com's Marvel Ousley had resigned from her position as Editorial Director of the Second Life News Network (SLNN).

I first met Marvel in February or March (not sure which) when she visited a sculpture-building competition which I had sponsored.

We struck a friendship that has lasted through my IPO at AVIX, through the original Sal Ackland accusations, through all the summer's financial drama, JTF's buyout of AVIX, Investor Allen's admissions and subsequent exit from SL, and beyond to this day.

What I can say about Marvel is she committed herself to something that so many SL news professionals (including me) and bloggers don't bother to worry about - AP Style journalism.

Through Marvel's tenure, SLNN prided itself in bringing Second Life something it had not seen before... real-world quality news coverage.

Second Life is like any online community. Bloggers devote time to talking about the platform but we rarely see any true journalists here. Marvel was the exception. I won't get into my opinionated view of Second Life journalism, but I will say that Marvel will be missed here in our community.

Marvel Ousley has been a friend to SL Reports and JT Financial for quite some time, and on behalf of both organizations I wish her well in all her future endeavors... RL and SL, both.

Xavier Mohr

Wednesday, November 28, 2007

New Blogger

Today I was invited by Guardian Market to this blog. I hope to bring a different and interesting perspective to the SL financial community. Glad to be here.

Tuesday, November 27, 2007

Why bank in SL?

As often happens to me when I'm poking along on the SLCapEx forums, I came across a thread with a good question. The question is simple enough, and is the title of the thread: "Why should I put my money in an SL bank?"

At first brush, this may seem to be a simple and scared n00b asking a question because they're scared. However, ultimately this is a question that every investor has to answer: Why trust your Lindens anywhere outside your avatar?

When you put your money outside of your own control, you're exposing yourself to the risk of loss for a variety of reasons. There are the multitude of frauds that can and have occurred in Second Life, but also there's the genuine chance that the security you've chosen will simply fail to be successful. For this risk, you demand payment, which usually comes in the form of interest, dividends, or capital growth, depending on your preferences. How much growth is enough to make your Linden dollars stray from your pocket is up to you and your own private discussion with utility curves.

I'd like to bring something completely from left field into this discussion however: game theory. I've just recently gotten into the most basic concepts of game theory, and I'm loving every minute of it. Specifically, I'd like to call to mind a simple game called a "trust game."

Here's the gist of how a trust game works: You are given an initial allocation of $X. (Almost always, this is real money - if you ever have a chance to volunteer for a game theory experiment, do it! You'll probably get lunch money out of it.) You are then given a choice to pass an amount T to another player, T>=0. This amount T, once under control of the other player, earns a rate of return r, r>1 (usually r is 1 or 2, in the games I've read about). Then, the other person gets to divide the amount they now control, which is T * (1 + r), between you and themselves however they choose. There are no restrictions on how that money they now control is to be divided. That's why it's called a trust game. (If any of you are really interested, you can find an instructor's script for a trust game here.)

For the less math-oriented, let's do a quick numerical example. You sit down and someone hands you $10. You can then choose to give any part of that to me that you wish, with the understanding that it will triple as soon as you hand it to me and then I can divide it between us however I choose. You choose (as an example) to give me $5, which then becomes $15, and I, being grateful, choose to return $7 to you. You get $12 and I walk away with $8.

Here's the interesting thing, though: there has been at least one study done which links trust (as a culture) to wealth. (Apologies for the link not going directly to the paper - the paper costs money to get to, as near as I can tell.) The concept is simple enough: the more risk you take, the more return you get, and therefore the richer you become. I'm not well enough versed in the topic to attempt to argue it as this paper has done, but you get the idea: risk begets reward.

So, does this work in Second Life? Time will tell. Certainly blind trust will just get your Lindens stolen, as many lemmings have proven. However, well-placed trust could be the secret of success behind some of Second Life's most well-known names. That is a bit of mind candy I leave for you to chew on.

Still Looking

I'm still looking for additional authors for Second Chaos, by the way. If interested, send me a coherent message in English, and you'll likely get an invite. You can write about whatever you like, but I think that by banding together with several different authors, we'll have more readership than individual blogs. Come on, it'll be fun!

Still Around

Quick note... I'm still around. Fell behind on some RL and SLR stuff and haven't had much time period. Hopefully I will be able to blog some more tonight or tomorrow.

Take Care,

Xav

Sunday, November 25, 2007

Windlight

There isn't much in Second Life that just leaves me with my jaw hanging open. Windlight did it. Go download the first look viewer and give it a try - you won't be disappointed.

If you doubt my words, check out some of the other reactions to Windlight:

Chino Ray
Maple.nu
Vint Falken
Google