Servervault Case Study Solution Format

ServerVaultStatement of Cash Flows(Direct Method)New Facility$5-$6 millionServer Cost$3,000 Growth Rate50% <-- decrease to 10% by the third-year periodOne Time Set-Up Fee$500 Monthly Hosting Fees$750 Services$50 Operating Expenses$7,000 <--worker, per month, per person$25,000 <--Facility Saleries per Facility$175,000 Cost of Servers3000New Facility$5,500,000 Exhibit 4 Statement of Cash FlowsJan-00Feb-00Mar-00Apr-00May-00Jun-00Jul-00Aug-00Sep-00Cash Flows from Operating ActivitiesOperating RevenuesSetup1,000 2,500 3,000 5,000 6,000 7,500 12,500 17,500 32,500 Hosting2,420 6,440 10,480 18,540 26,200 35,480 57,000 83,250 132,000 Assume $50 services per serverServices445 350 600 1,150 1,900 2,325 3,800 5,550 8,800 Total Sources3,865 9,290 14,080 24,690 34,100 45,305 73,300 106,300 173,300 Operating ExpensesBandwidth(3,790)### (6,115) (5,591) (11,678) (25,000) (50,000)Marketing(3,500) (22,250) (51,750) (57,250) (79,800) (100,000) (100,000)Assume 8 people hired each monthSalaries(28,250) (45,100) (54,570) (56,600) (61,520) (62,200) (118,200) (174,200) (230,200)G&A (including corp.)(9,584) (15,484) (16,884) (22,530) (30,160) (39,910) (50,000) (50,000)Total Uses(45,124) (86,624) (129,319) (141,971) (149,021) (193,588) (293,200) (349,200) (430,200)Net Cash Produced (Used) by Operating Activities(41,259) (77,334) (115,239) (117,281) (114,921) (148,283) (219,900) (242,900) (256,900)Cash Flows from Investing Activities:Capital ExpendituresComputer Hardware(9,800) (14,265) (17,770) (31,220) (36,150) (44,890) (75,000) (105,000) (195,000)Facilities(10,180) (81,100) (29,540) (27,590) (5,550,000)Net Cash Produced (Used) by Investing Activities(19,980) (95,365) (47,310) (58,810) (61,150) (69,890) (130,000) (5,745,000)Cash Flows from Financing Activities:External funding47,500 50,000 10,000 2,000,000 Net Cash Produced (Used) by Financing Activities47,500 50,000 10,000 - 2,000,000 - - - - NET MONTHLY CASH INFLOW (OUTFLOW)(13,739) (122,699) (152,549) (176,091) 1,823,929 (218,173) (319,900) (372,900) (6,001,900)CASH POSITIONBeginning balance575,000 561,261 438,562 286,013 109,922 1,933,851 1,715,678 1,395,778 1,022,878 Ending Cash Balance561,261 438,562 286,013 109,922 1,933,851 1,715,678 1,395,778 1,022,878 (4,979,022)

От волнений и переживаний он совсем забыл, где находится. Он же в аэропорту. Где-то там, на летном поле, в одном из трех частных ангаров севильского аэропорта стоит Лирджет-60, готовый доставить его домой.

Пилот сказал вполне определенно: У меня приказ оставаться здесь до вашего возвращения.

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *