Author Topic: Star Citizen Analytics Project  (Read 392917 times)

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #90 on: November 06, 2017, 02:11:20 PM »
See my original article, as well as PT 1, 2, 3 of this financial analysis by our UK accounting Goon.


Today's accounting error/mistake is the final one. It builds on the ones that were previously highlighted but this is actually more a series of deliberate decisions. I'm struggling to find a generously innocuous word that conveys making deliberate decisions that are possibly not correct.

4.) Prior year adjustments.

At some point a set of accounts will be filed that are incorrect. Humans can make mistakes. I'll give an example. Say in 2015 a client paid you in cash for £1000 and you accidentally lost the sales receipt and accidentally banked the money in your personal bank account instead of the company bank account. Later on in 2016, the client asks for a receipt and this helps you remember this event. You're now faced with three options.
(i) You could file an amended set of accounts for 2015 that makes corrections. This seems intuitive and I'm sure textbooks and "experts" online will tell you this is the right thing to do. No one ever files amended accounts. To be honest I'm not entirely sure why, but it doesn't happen.
(ii) You can "do nothing". This doesn't really mean you do nothing. It means when you file the 2016 accounts, you add on those £1000 sales that were really in 2015 and you pay the company back the cash from your personal account. So now the company is declaring that missing income, albeit in the wrong period.
(iii) You make a prior year adjustment to the 2015 figures in the comparative when you compile the 2016 accounts. You disclose all of these items and you can file an amended tax return, without adjusting the 2015 accounts themselves.

The UK CIG group were faced with such a situation. Here is the disclosure in the Foundry 42 Ltd accounts that explains the decision:



So the original turnover amount was £15,169,773 and it was adjusted to be £12,737,713. A reduction in turnover of £2,432,060. This means they also had to add £2,432,060 to the balance sheet, as a liability. Since they now owed Cloud Imperium Games UK Ltd that amount. You can see they did all this correct (since they were owed £83,979 separately, this is netted off against this amount due to CIG UK).




So far this is all correct from an accounting angle. However, the UK group of companies are all irrevocably linked. Because of the way the accounts were filed, we have access to the individual filings for 2015 but not the group accounts. In 2016 we have the accounts for Foundry 42, RSI and the group accounts (but not the individual accounts for the CIG company). We can pretty much recreate the missing sets of accounts.

Here is a summary of the 2015 accounts, as they were originally filed. It should be noted that the linked green items, do not appear in the group accounts. These inter-company transactions cancel each other.



Here is an extract from the 2016 consolidated group accounts. Note the profit for the year 2015 shown as £1,088,498.



So the group profit in my summary differs from the 2015 group profit that is disclosed in the 2016 accounts by £2,432,060. Now we know what that is, it's that prior year adjustment. But nowhere in the 2016 group accounts is any prior-year adjustment disclosed. What is disclosed is that the CIG company profit was the same as filed in 2015 at £265,299 profit.



So now we have a big problem. How can we adjust the summary of the 2015 accounts to correct for this prior-year adjustment. Remember all the linked boxes in my summary that can't be changed individually? If we are reducing Foundry 42s turnover figure by £2,432,060 we also have to reduce CIGs cost of sales by £2,432,060 since that is where the turnover came from. We know that CIG (the company) profit stayed the same though, so we know we have to reduce CIGs turnover, also by £2,432,060. So now we also need to reduce RSIs cost of sales by £2,432,060. All good so far. We know that that RSIs profit remains zero also, because we know the groups profit so we also have to reduce their turnover by £2,432,060 however this goes outside the UK group because this is a refund to Roberts Space Industries Corporation, in the USA. So this is going to be an amount in dollars, so it may not match exactly and we have to rely on the accountants to get this right.

We arrive at a new summary, something like this. Bolded numbers are the figures that have been adjusted:



For some reason, they changed the cost of sales in RSI by adding £239,986 to the costs. I've noted it down as a suspense amount because we have no idea why they did this. So to maintain a zero profit, we need to counter this by adding £239,986 to their revenue. This seems like a leap of faith but our summary now matches the group accounts exactly.

So now the group accounts match our summary there are some implications to this. The UK group derives all its income from RSI International Ltd, which derives all its income from the USA company RSI Corporation. Now we can solve why the 2015 turnover figures don't match and the 2016 ones do match. Note the figure does match our summary for RSI, that we have recreated with our own turnover figure by deduction from the group accounts.



We sort of have to now conclude that there must be two different sets of RSI accounts for them to get this "correct" in the group accounts. The RSI accounts that were filed were never corrected for any prior-year adjustment and yet, there must exist a set of RSI accounts that have been corrected in order to get a set of group accounts that is accurate.

The implications here are decidedly tricky. Back in 2015 the US companies would have presumably filed accounts and tax returns to US authories that claimed a dollar amount of expenses equal to £15.3m. Any audits done at this time, would have confirmation letters and invoices for these amounts. As far as audit trails for this £2.4m refund that would have gone back to the United States, well I hope I have demonstrated that this trail is really unclear for anyone that might investigate it. If it were accidentally paid to the wrong entity and then never declared, there would not be any trail.

So the corrections were handled appropriately in the Foundry 42 Ltd accounts. Adjustments were made and disclosures for those adjustments. They used option (iii) from my opening statement. The CIG accounts are slightly trickier, since we have the company accounts for 2015 and the group accounts for 2016 but we can safely say that some adjustments were made but absolutely no disclosures at all. That is sort of an incorrectly implented option (iii) from my opening statement. The RSI accounts have not had any adjustments made and therefore no disclosures and we have some pretty firm suspicions that there may in fact be two different sets of RSI accounts and they are certainly aware that the filed RSI accounts do not match the RSI accounts used for the consolidation of the group accounts that were filed. So it turns out that there was a hidden fourth option that you will not find in any text books and Chris Roberts has developed new solutions to problems and a way to make money apparently disappear.

I can only imagine the state of the dozen or so American companies that are open to zero public scrutiny.

Unrelated hypothetical paragraph
Imagine your company is sitting on £2.4m in the bank that it should not have, that should be refunded to another company in another country. However, in that country, that company does not know it's due any money from years ago. It was all audited and balances confirmed at that time and it's not asking or expecting any money. However, this company with the money in the bank has to get rid of it to make its books balance, it sure should go to the right place and I'm sure anyone would make certain that the right people get this £2.4m.

So as a disclaimer I should stress that I am in no way suggesting that anything unlawful was actually done here. I guess this highlights the "perils" of having multiple shell companies with regard to nice clean audit trails.
« Last Edit: November 06, 2017, 02:54:58 PM by dsmart »
Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

David-2

  • Full Member
  • ***
  • Posts: 152
Re: Star Citizen Analytics Project
« Reply #91 on: November 06, 2017, 05:16:43 PM »
This series of 4 posts is actually making accounting sound like fun!  Like solving a mystery story (or creating one)!

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #92 on: November 06, 2017, 07:16:53 PM »
This series of 4 posts is actually making accounting sound like fun!  Like solving a mystery story (or creating one)!

Yeah. But being a numbers guy myself, I'm biased to the beauty of numerical data.  :smuggo:
« Last Edit: November 07, 2017, 12:34:24 PM by dsmart »
Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

RaTTuS

  • Newbie
  • *
  • Posts: 1
Re: Star Citizen Analytics Project
« Reply #93 on: November 07, 2017, 11:05:21 AM »
Spreadsheets FTW :D

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #94 on: November 08, 2017, 11:24:14 AM »
More confirmation that there are really only a few whales still propping up this train wreck.


So it seems these are the numbers of pioneers sold in the end

Quote
around 4000-4500 out of 5000 made available.
Concierge warbonds: 2000 of 2000 sold.
Normal warbonds: ~800 of 1000 sold.
Normal credit: 1000 of 1000 sold.
GamesCom CitizenCon reserved: 200-700 of 1000 sold.

Which means that, as this thread has often guessed, the number of whales is around 2000-3000.   



Even at $500 dollars a month per whale they're going to need a quite a bit more to make ends meet.  I wonder if they'll dip into the Javelin piggy bank this month.
Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

Spunky Munkee

  • Sr. Member
  • ****
  • Posts: 253
Re: Star Citizen Analytics Project
« Reply #95 on: November 08, 2017, 06:43:36 PM »
No it will be the ultimate lazy jpeg. The double super Hornet. THey will attach two Hornets together wingtip to wingtip with only a gain in speed and firepower to show for it. It will be like the F82 Mustang. http://militaryhistorynow.com/2015/08/04/double-trouble-the-strange-history-of-the-p-82-twin-mustang/

Oh, wait... That would require Robbers to have some knowledge about actual military aviation development and since he lives in fantasy land it could only happen if jammed under his nose as something he could sell this weekend with a little photoshop editing.

Silly as this may sound it is something that I could easily see him doing for a quick million in "limited LTI War bond"  sales.
Extended range more than double the missiles.

The Pay to kill ship.

Motto

  • Hero Member
  • *****
  • Posts: 1023
Re: Star Citizen Analytics Project
« Reply #96 on: November 10, 2017, 04:10:58 PM »
The agent posted some numbers:

well October ended at almost 40% below last years funding

October 2017 funding: $3,251,843 (actual - estimated at $3,275,000 on October 30th)
October 2016 funding: $5,215,403
Difference: -$1,963,560
Percentage: -37.7%

Novembers estimate puts them even below that

November 2017 funding: $3,750,000 (estimated)
November 2016 funding: $7,776,767
Difference: -$4,026,767
Percentage: -51.8%

that would be a huge fucking difference and will make everyone shit their pants

as I've said before, the only thing I could see saving them is a bug free, stable and content rich 3.0 out the door like right motherfuckin now

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #97 on: November 10, 2017, 04:25:13 PM »
Yeah, you can map the actual amounts from the spreadsheet.

Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #98 on: November 18, 2017, 10:10:24 AM »
Completionist pack #12 for the year showed up yesterday, with the usual Javelin followup.



Totally not dodgy. At all.

Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

Motto

  • Hero Member
  • *****
  • Posts: 1023
Re: Star Citizen Analytics Project
« Reply #99 on: November 18, 2017, 01:14:21 PM »
Well, keep crunching those numbers away, 'cause the next Sale is coming up. With supposedly 2 new ships (probably just variations on a theme)

This years anniversary sale will begin on the 24th of November and run for till the 4th of December. Like last year, it's planned to be a daily event kicked off by an intro video, and then a themed sale for 24h. Unlike 3 or 6 month insurance, an “Anniversary Standalone ship or “anniversary game package, come with a longer period of insurance. This year, being the fifth year, we should expect 60 Month insurance.

Last chance to give them your money before they go bust! Save CIG, buy something that does not exist yet for a game that never will see the light of day!

Greggy_D

  • Full Member
  • ***
  • Posts: 120
Re: Star Citizen Analytics Project
« Reply #100 on: November 18, 2017, 08:21:05 PM »
They're absolutely despicable.  The gall of them to full court press the ship sales at this point.

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #101 on: November 22, 2017, 09:47:03 AM »
Code: [Select]
October 2017: $3,251,843 (estimated at $3,275,000 - actual funding was below estimated target)
October 2016: $5,215,403 (-$1,940,403 vs 2017 estimate / -37.3% difference)
October 2015: $4,248,793 (-$973,793 vs 2017 estimate / -23.3% difference)
October 2014: $3,903,722 (-$628.722 vs 2017 estimate / -16.2% difference)
October 2013: $5,132,756 (-$1,857,756 vs 2017 estimate / -36.2% difference)
October 2012: $2,543,656 (+731,344 vs 2017 estimate / +32.4% difference)

Code: [Select]
November 2017 Current to 11/22/2016: $1,135,753
November 2016 Total to 11/22/2016: $3,656,780 (sale started on the 19th of 2016)
November 2016 Total pre-sale value: $851,407

Code: [Select]
November 2017: $5,100,000 (high estimate -- funding estimation by Nehkara puts it around $3,950,000 total for November)
November 2016: $7,776,767 (-$2,676,767 vs 2017 estimate / -34.4% difference)
November 2015: $5,358,817 (-$258,817 vs 2017 estimate / -5.1% difference)
November 2014: $6,101,678 (-$1,001,678.00 vs 2017 estimate / -16.4% difference)
November 2013: $7,871,634 (-$2,771,643 vs 2017 estimate / -35.2% difference)
November 2012: $4,367,877 (+$732,123 vs 2017 estimate / +16.8% difference)
Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

dsmart

  • Supreme Cmdr
  • Administrator
  • Hero Member
  • *****
  • Posts: 4915
    • Smart Speak Blog
Re: Star Citizen Analytics Project
« Reply #102 on: November 24, 2017, 09:24:50 PM »
Code: [Select]
First Day Star Citizen Anniversary Sale Funding 2017: $434,735
First Day Star Citizen Anniversary Sale Funding 2016: $1,302,326
First Day Star Citizen Anniversary Sale Funding 2015: $633,883
First Day Star Citizen Anniversary Sale Funding 2014: $665,676
First Day Star Citizen Anniversary Sale Funding 2013: $242,069

For all you playing at home, the funding tracker for the 24th is complete at $434,735. That's an $867,591 decrease from last year or a 66.6% decline in first day sales, making it the worst opening anniversary sale day since 2013
Star Citizen isn't a game. It's a TV show about a bunch of characters making a game. It's basically "This is Spinal Tap" - except people think the band is real.

xtrouble

  • Newbie
  • *
  • Posts: 1
Re: Star Citizen Analytics Project
« Reply #103 on: November 25, 2017, 03:15:53 AM »
Code: [Select]
First Day Star Citizen Anniversary Sale Funding 2017: $434,735
First Day Star Citizen Anniversary Sale Funding 2016: $1,302,326
First Day Star Citizen Anniversary Sale Funding 2015: $633,883
First Day Star Citizen Anniversary Sale Funding 2014: $665,676
First Day Star Citizen Anniversary Sale Funding 2013: $242,069

For all you playing at home, the funding tracker for the 24th is complete at $434,735. That's an $867,591 decrease from last year or a 66.6% decline in first day sales, making it the worst opening anniversary sale day since 2013

It's still unbelievable that there are enough fools to give them this much money. Bonkers !!

Meowz

  • Jr. Member
  • **
  • Posts: 75
Re: Star Citizen Analytics Project
« Reply #104 on: November 25, 2017, 10:02:09 AM »
Code: [Select]
First Day Star Citizen Anniversary Sale Funding 2017: $434,735
First Day Star Citizen Anniversary Sale Funding 2016: $1,302,326
First Day Star Citizen Anniversary Sale Funding 2015: $633,883
First Day Star Citizen Anniversary Sale Funding 2014: $665,676
First Day Star Citizen Anniversary Sale Funding 2013: $242,069

For all you playing at home, the funding tracker for the 24th is complete at $434,735. That's an $867,591 decrease from last year or a 66.6% decline in first day sales, making it the worst opening anniversary sale day since 2013

It's still unbelievable that there are enough fools to give them this much money. Bonkers !!

That's what I was thinking. I think the delusional backers at this point have taken to an all out fake information campaign about SC to get their friends and others to back, showing only the best game play clips, cinematics, and likely just blatantly lying about the state of the game. No one would honest back SC as a newcomer if they had done any research into the current state of affairs.

 

SMF spam blocked by CleanTalk