Projections : Using what you know about the company's financial health and performance, forecast its future performance. In particular, you should:

A. Project the company's likely consolidated financial performance for each of the next three years. Support your analysis with an appendix spreadsheet showing actual results for the mos t recent year, along with your projec tions and assumptions. Remember that your supervisor is interested in fresh perspectives, so you should not just replicat e existing financial statements: You should add other relevant calculations or disaggregations to help inform decisions.

B. Modify your projections for the coming year to show a best - and worst - case scenario based on the potential success factors and risks you identified. As with your initial projections, support your analysis with an appendix spreadsheet , specifying your assumptions and including relevant calculations and disaggregations beyond those inthe existing financial reports.

Annual Income Statement (values in 999's} Get Quarterly Date Period Ending: Trend 1115552515 12I'31IED16 13269191 5 1212?.F2l114 Tetal Revenue |||| 5552,555 5555,445 5555,5114 5555,555 Cost of Revenue llll $413,991 $445,??5 $453,317" $431995 Gross Prot |||| $445,551 $455,555 $551,515 $455,511 Research and Development 59 $9 $9 59 Sales, General and Admin. llll $331,??5 $322,245 $345,185 $316,135? Non-Reouning Items '_ I 52,451 {5235] 5253 51,??? Diner Dperatjng Items $9 $9 $9 $9 peraijnu Ineeme |||| $115,555 $155,555 $155,154 $145,555 .5551 ineernetespense itelns -.'. $46? {5533] [$1,164] {$9?3] EaminusEeforelnterestand Ta): I'll $116,142 $135,121 $155,915 $145,594 Interest Expense $9 $9 $9 $9 Earnings BeforeTax IIII 5115,145 5135,121 5155,515 5145,554 lnoome Tex _||| 515,555 545,552 555,555 554,551 Minority Interest $9 $9 $9 $9 Equity EaminusJLoss Uneonsolidated 5D 59 59 59 Sultlsitiiarllr Net Income-Cent. perations llll 599,549 55?,349 593,414 599,543 Net Income |||| $55,545 $55,545 $55,414 $55,545 Net Income Applicable to Eemmon llll $99,049 $3?,349 $93,414 $911,?43 Shanen elders Quarterly lneeme Statement [values in EIEIEI'e) Get Annual Date Quarter: Trend 2nd 1st 4th erd ISmarter Ending: BIS-DIEME SEE-112013 1330:2017 QBDIEM? Total Revenue |"| 533,100 memes? 315,320 $241114? Cost of REFEII ue I". $131,130 $94,350 $93,233 $115,54 Gross Prot |"| $141,911] $96.09? $10333? $131,501 Research and Development ED 0 0 ED Sales, General and Admin. |||| $110,339 $86,359 $92,223 HonReclining Items I I 551? $0 $945 50 Other Doeratjng Items SD $0 $0 $0 deeming Ineeme .__| $31,054 $9.233 $14,353 $51.49!: Add'l inedlnefexpense items _.I em {$343) ($115?) $40? Earnings Before Interest and Tea: .__| 53.11134 $9,153 $14,13EIE $511903 Interest Expense $0 $0 $0 5|] Eaminus Before Tax .__I $311134 $9,153 $14,695 5511903 In some Ta: - II 53599 {5152; {$15,334} $131220 Minority Interest SD $0 $0 $0 Equity EaminusiLoss Unconsolidated Subsidiary so HI $0 $0 Net Income-Cent. perations LII $231535 $9,310 $341530 $331533 Net Income ._|| $23,535 $9.310 $30,530 $33,633 Net Income Applieahleto Common Shareholst I-II $23,535 $9,310 $30.53D $33,633