need to develop pro forma statment for (3 coming years) based on assumptions developd from I/S and B/S/.

an examaple is as attached on the appindix 1&2.. please i need it ASAB

Appendix 2: Historical & Pro-Forma Balance Sheet USD in Millions Assets Current Assets Dec. 31, 2012 2013E 2014F 2015F 2016F 2017F 2018F Cash & Equivalents Accounts Receivable, net Prepaid Expenses Other Current Assets Income Taxes Receivable Defrred Tax Asset Total Current Assets $108.34 S9.73 $7.23 $5.92 S93.43$103.38S104.89$105.72$107.65 $108.94 $9.78 $7.27 $9.28 $6.90 $5.65 $9.42 S7.00 S5.73 $9.67 $7.18 $7.05 S5.78 S6.23 $7.62 $8.78 $141.81$122.30 $135.32 $137.29$138.38$140.91$142.59 Property and Equipment $40.68 $40.68 $40.68 $40.68 Leasehold Improvements Computer Equipment & Software Furniture & Office Equip Capital Projects in Process Total PPE Less Accumulated Depreciation Net PPE $40.68 $40.68 $40.68 $267.90 $283.71$317.10 $354.04$391.52$429.30$467.77 $26.33 $17.18 S343.93S365.44 $400.40 $437.58$475.19 $513.28$551.95 S(187.44) S(188.16) S(195.93) $(201.52) $(207.18) $(212.91) $(218.73) $156.49$177.29$204.47$236.06$268.01$300.37$333.22 $26.33 $14.73 $26.33 $26.33 $16.67 $26.33 $16.97 $23.55 $26.33 $16.54 $21.04 $90.23 $21.04 $90.23 $21.04 $90.23 Other Assets Net Intangibles Long Term Deferred Tax Asset Net Goodwill Net Customer Contracts $21.04 $90.23 $90.23 $90.23 $90.23 S338.70S338.70$338.70 $338.70$338.70 $338.70$338.70 S- S- S- S- S- S- S- Total Assets $748.27$749.55$789.75$823.32$856.36$891.24$925.78 Source: Company Financials & Team Estimates Assumptions: Current Assets: Expected to remain at a constant percentage of sales Leasehold Improvements:Held constant over the forecast period omputer Equipment: Furniture & Office Equip Capital Projects in Progress: Expected to increase by 5% of sales from year to year Held constant over the forecast period Expected to remain at a constant percentage of sales ice Equip. Held cons