• Please, compleetee TABLE 4 THRU TABLE 7, the SealTek Fittings Worksheets A, the Excel spreadsheet attached down below.

Appendix 1. SealTek Fittings, Statement of Income (millions of INR, year ending December 31) Income Item 2008 2009 2010 Sales 1,861.68 1,560.30 1,940.30 Cost ofgoods sold 1,255.12 1,160.10 1,456.70 Gross prot margin 606.56 400.20 483.60 Marketing & selling expenses 125.42 128.20 116.84 General and administrative expenses 162.66 158.29 160.82 Earnings before interest, taxes, depreciation 318.48 113.71 205.94 and amortization Depreciation expenses 50.54 58.17 62.00 Earnings before interest and taxes 267.94 55.54 143.94 Interest expenses 26.10 34.60 47.70 Earnings before taxes 241.84 20.94 96.24 Taxation expenses @ 25% 60.46 5.24 24.06 Net income 181.38 15.71 72.18 Dividends paid 60.00 60.00 60.00 Appendix 2. SealTek Fittings, Balance Sheets (millions of INR, year ending December 31) Assets 2008 2009 2010 Cash 61.20 26.40 17.40 Accounts receivable 201.21 198.78 292.91 Inventory 192.29 183.49 247.84 Prepaid expenses 34.17 38.73 32.59 Current assets 488.88 447.39 590.73 Gross fixed assets 437.24 493.44 565.94 Accumulated depreciation 98.64 156.81 218.81 Net fixed assets 338.60 336.63 347.13 Total Assets 827.48 784.02 937.86 Liabilities & Net Worth 2008 2009 2010 Accounts payable 107.05 105.27 140.48 Accrued expenses 43.71 35.78 44.18 Short-term debt 119.54 137.29 242.74 Current Liabilities 270.30 278.34 427.40 Long-term debt 127.80 120.60 113.20 Equity 429.38 385.09 397.27 Liabilities & Net Worth 827.48 784.02 937.86Appendix 3. Sales Decomposition by Region Sales by Region (millions of Rmb) 2008 2009 2010 India 484.0 530.5 776.1 Europe 279.3 187.2 194.0 Americas 446.8 312.1 310.4 Singapore/Indonesia/Korea 502.7 405.7 523.9 China 148.9 124.8 135.8 Global sales, net 1,861.7 1,560.3 1,940.3 Supplementary Data: Sales by Region (percent) 2008 2009 2010 India 26% 34% 40% Europe 15% 12% 10% Americas 24% 20% 16% Singapore/Indonesia/Korea 27% 26% 27% China 8% 8% 7% Global sales, net 100% 100% 100% Average Exchange Rate for the Period 2008 2009 2010 INR / EUR (rupees per euro) 63.54 67.27 60.59 INR / USD (rupees per US dollar) 43.43 48.34 45.67 INR / SGD (rupees per Singapore dollar) 30.65 33.24 33.53 INR/ CNY (rupees per Chinese yuan) 6.2587 7.0762 6.7470Appendix 4. Sales and Costs by Product Line (millions of Rmb, year ending December 31) Product Line Pneumatic Systems Hydraulic Systems Components Instrumentation Total Product Line Pneumatic Systems Hydraulic Systems Components Instrumentation Total Product Line Pneumatic Systems Hydraulic Systems Components Instrumentation Total Sales 707.4 844.7 223.4 86.2 1,861.7 Sales 570.3 725.9 183.6 80.5 1,560.3 Sales 670.8 950.1 219.2 100.2 1,940.3 2008 Cost of Sales 4702 542.2 179.8 62.9 1,255.1 2009 Cost of Sales 450.2 498.1 149.5 62.3 1,160.1 2010 Cost of Sales 540.6 657.3 179.5 79.3 1,456.7 Inventory 76.3 85.2 21.6 9.2 192.3 Inventory 74.3 81.9 17.9 9.4 183.5 Inventory 96.3 114.2 24.2 13.1 247.8 TABLE 4 SealTek Fittings (India) ( millions of Indain rupee, INR) Net Working Capital (NWC) Management 2008 2009 2010 Sales (INR) 1,861.7 1,560.3 Sales growth (%) -16.2% Net Working Capital (NWC in INR) 276.9 279.9 NWC/Sales (percent) 14.9% 17.9% Net Working Capital Components Days sales outstanding 39.4 46.5 (A/R/ (Sales/365) ) Days of inventory 55.9 57.7 (Inventory / (Cost of sales/365) ) Days of prepaid expenses 6.7 9.1 (Prepaid / (Sales/365) ) Days to pay (31.1) (33.1) ( - A/P / (Cost of Sales/365) ) Days accrued expenses (8.6) (8.4)! ( - Accrued / (Sales/365) ) Days of NWC 62.3 71.8 (A/R + Inv + Prepaid - A/P - Accrued) Financing of Net Working Capital % of NWC Financed by Long-Term Debt 79% 60% (LT Debt + Equity - Net Fixed Assets) / NWC % of NWC Financed by Short-Term Debt 21% 40% (ST Debt - Cash) / NWC The management of net working capital (NWC) is based on days of sales (or days of payables). The management objective is to minimize NWC while maintaining adequate levels for the maintenance and growth of the business. The financing of NWC is a separate critical management challenge, with more conservative management financing NWC with a greater proportion of long-term debt.TABLE 5 SealTek Fittings (India) (millions of Indian rupee, INR) Constructed Statement of Cash Flows 2009 2010 Opening Cash Balance 61.2 Cash Flow from Operations EBIT 55.5 Less interest expense (34.6) Less taxes (5.2) Plus depreciation 58.2 Change in net working capital (NWC) (3.0) Cash flow from operating activities (OCF) 70.9 Cash Flow from Investing Capital expenditure (56.2) Net acquisitions of assets Cash flow from investing activities (ICF) 56.2) Cash Flow from Financing Dividend payments (60.0) Change in Long Term Debt (7.2) Change in Short Term Debt 17.8 New Issues (Repurchases) of Equity Cash flow from financing activities (FCF) (49.4) Closing Cash Balance 26.5 Value is created through cash flow, not accounting. The cash flow statement organizes corporate cash flows into three basic categories which reflect the firm's execution of its business -- operating , investing , and financing . A profitable firm will generate a positive OCF. That same firm should always be re-investing in itself and its business, experiencing a negative ICF. If the firm is in a rapid growth stage of its business life cycle, FCF will be positive (the firm is raising capital from outside the firm). If the firm is in a mature or even declining stage of its business life cycle, FCF will be negative.TABLE 6 SealTek Fittings (India) (Indian rupee, IINR) Return on Invested Capital 2008 2009 2010 Margin = EBIT / Sales 14.4% 3.6% X Y Capital Turnover = Sales / Invested Capital 2.75 2.43 Pre-tax ROIC = EBIT / Invested Capital 39.6% 8.7% Tax Effect = (1 - Tax Rate) 75.0% 75.0% After-tax ROIC 29.7% 6.5% Return on Assets After-tax Return on Assets 21.9% 2.0% "EAT/Total Assets) Return on Equity After-tax Return on Equity 42.2% 4.1% X X Retention Rate (Note 2) 66.9% -282.0% Sustainable Growth Rate 28.2% -11.6% (Retained Earnings/Equity) ROE = Return on Equity; ROIC = Return on Invested Capital; EAT = Earnings After Tax Note 1: Financial leverage multiplier = Pretax ROE / Pretax ROIC Note 2: Retention rate (b) = Retained earnings / Earnings after tax Return on invested capital is a key metric of business performance used by many companies because it combines operating and financial information derived from two different financial statements -- the income statement and the balance sheet. An ROIC greater than the firm's cost of raising capital -- the company's weighted average cost of capital or WACC -- is key to the creation of value. The sustainable growth rate is that rate of sales growth the company could support financially using internal financing at the current rate of profitability. For example, a 3.1% sustainable growth rate means that if the company's sales grow faster than 3.1%, at current operating parameters, external financing will be needed (new debt or new equity or both).TABLE 7 SealTek Fittings (India) Benchmarking 2010 Performance Company Company Company SealTek A C Working Capital Management Days Sales Outstanding 38 41 Days of Inventory 44 39 38 Days Payables 36 34 35 Use of Debt Financing Debt / Total Assets 0.26 0.21 ).25 Debt / Invested Capital 0.31 0.35 0.29 Debt / Equity 0.65 0.59 0.52 Returns on Sales and Capital Gross Profit Margin 28.0% 24.6% 25.3% Return on Sales 14.2% 7.7% 12.1% Return on Invested Capital (ROIC) 23.2% 17.3% 21.9% Return on Assets (ROA) 14.3% 10.1% 15.9% Return on Equity (ROE) 29.5% 22.5% 27.4% Benchmarking provides a different perspective on the performance of the firm. Whereas all the previous worksheets and statements analyzed the company from its own results over time, benchmarking compares selective measures and metrics against comparable firms in the marketplace. Publicly traded firms are constantly benchmarked by the firms, analysts, and all participants in the public equity markets. Privately held firms, however, due to their lack of reporting and transparency, are often fail to utilize benchmarking sufficiently to assess their own performance on an on-going basi