I can not figure out this spreadsheet without hardcoding the cells. No hardcoding is allowed. All if the information is in the excel file.

ES X V fx ??? B D E F G H Financial Statement Analysis FINANCIALS: ANDREWS BALDWIN CHESTER DIGBY Sales ??? ??? EBIT ??? ??? ??? Profits ??? ??? ??? SG&A % ??? ??? ??? Contribution Margins % ??? ??? 10 Emergency Loans ??? ??? ??? ??? 11 RATIOS: ANDREWS BALDWIN CHESTER DIGBY 12 Return on Assets ??? ??? 13 Return on Equity ??? ??? ??? Capsim Website 14 Return on Sales ??? ??? (Contains helpful 15 Asset Turnover ??? ??? ??? formulas) 16 Leverage ??? ??? ??? 17 Analysis Questions: (Briefly explain in 2-3 sentences) 18 1)Which Company is performing the best and 19 using the above key financials and ratios? -> 20 21 22 23 2)Which Company is performing the worst and 24 using the above key financials and ratios? -> 25 26 27 3)Explain the relationship between the Income 28 Statement, Balance Sheet, and Cash Flows-> 29 30 31 32 Cash Flow Summary: 34 Cash Flows from Operating Activities ANDREWS BALDWIN CHESTER DIGBY 35 Net Income (Loss) S 2,123 (2,356) $ (4,573) $ 5,109 CHECK FIGURES 36 Adjustment for Non Cash Items (Cells should be Green) 37 Depreciation 3,535 $ 2,704 $ 2,760 38 Extraordinary Gain/Losses/Writeoff (156) $