I was inspired to summarise.
For 9 months:
Total EDD revenue = $6.5bn
Total 360 and PC games revenue = $5bn (based on 1% is $51m)
This means nearly 77% of revenue is made by the 360 and PC.
Total EDD costs = $6.2bn (based on profit at $300m, 6.5 - 6.2 = 0.3)
Total EDD cost of revenue = $3bn (based on 2% is $60m)
Total R&D cost = $1.3bn (based on 30% is $317m)
The remaining $2bn in costs would be due to administrative, legal, sales & marketing, procurement/acquisition, employee severance.
For 3 months:
Total EDD revenue = $1.5bn
Total EDD costs = $1.53bn (based on loss of $31m, 1.5 - 1.53 = -0.3)
Total EDD cost of revenue = $0.9bn (based on 6% is $52m)
Total R&D cost = $0.4bn (based on 18% is $66m)
The remaining $0.2bn in costs would be due to administrative, legal, sales & marketing, procurement/acquisition, employee severance.
This means:
23% of the 9-month revenue was generated in Q1 09 (1.5/6.5 = 23%).
30% of the 9-month cost of revenues was incurred in Q1 09 (0.9/3 = 30%).
30% of the 9-month R&D costs was incurred in Q1 09 (0.4/1.3 = 30%).
10% of the 9-month other costs was incurred in Q1 09 (0.2/2 = 10%).
The revenue is seasonal, most are generated during Q4 holidays of each year.
