Hello, I need help with my assignment. I have totally three questions to answer. The first question seems to be answered already in "item.docx". I really need help with Q2 and Q3, which are shown in "casestudy 2.pdf". Please have a close look at the notes below the questions in this file. They are very important. In addition, some other files are also uploaded. Please help me and put all the questions in a word document as is mentioned in the notes in the file. Thanks a lot.

ROE Decomposition Inditex S.A. is the Spain-based parent company of a large number of clothing design, manufacturing and retail subsidiaries. The company's brands include Zara, Pull & Bear, and Massimo Dutti. At the end of the fiscal year ending on January 31, 2009 (fiscal year 2008), the subsidiaries of Inditex operated 4,359 stores across 73 countries, making Inditex one of the three largest clothing retailers in the world. The tables in Case Study 2 worksheet show the standardized and adjusted income statements and balance sheets for Inditex, for the years ended January 31, 2006, 2007 and 2008. Operating lease obligations have been capitalized and the operating lease expense has been replaced with depreciation and interest expense, following the procedure described in Chapter 4: 1. Calculate Inditex's net operating profit after taxes, operating working capital, net noncurrent assets, net debt, and net assets in 2007 and 2008. (Use the effective tax rate [tax expense/profit before taxes] to calculate NOPAT; Suppose excess cash and marketable securities at 8% of sales.) 2. Decompose Inditex's return on equity in 2007 and 2008 using the traditional approach (using net operating assets to calculate asset turnover). 3. Decompose Inditex's return on equity in 2007 and 2008 using the alternative approach. What explains the difference between Inditex's return on assets and its operating return on assets? Notes: 1. An Excel worksheet called 'Case Study 2.xlsx' is attached for solving this case. Please answer each question in a word document. Please do not just submit the workouts in Excel sheets. 2. You do not need to answer the questions for the year 2006. 3. In your report submitted, it is recommended that the Excel results are copied and pasted in your word document in \"Picture\" format. 4. Investment income: Income coming from interest payments, dividends, capital gains collected upon the sale of a security or other assets, and any other profit that is made through an investment vehicle of any kind. In income statements of Inditex's, you will commonly see an item called investment income; this is where the company reports the portion of the net income that was obtained through investments made with surplus cash as opposed to being earned with the company's usual line of business. It is subtracted from operating profit before net profit is obtained. Inditex Inditex (EURm) 2008 Sales Cost of materials (nature) Personnel expense (nature) Inditex (EURm) 2007 (EURm) 2006 10,407 (4,493) (1,703) 9,435 (4,086) (1,473) 8,196 (3,589) (1,251) (910) (803) (674) (1,168) 2,133 0 (84) 2,050 (455) 1,595 (8) 1,587 (1,039) 2,033 (9) (72) 1,953 (474) 1,479 (7) 1,471 (997) 1,685 (5) (74) 1,607 (404) 1,202 (8) 1,194 6,325 148 203 188 6,863 6,000 139 133 165 6,437 5,262 114 89 148 5,613 585 1,055 158 1,466 3,264 464 1,007 45 1,466 2,982 364 824 55 906 2,148 10,127 9,418 7,761 5,055 27 4,414 24 3,641 22 Non-Current Debt Deferred Tax Liability 2,003 343 2,095 197 1,844 179 Other Non-Current Liabilities (non interest bearing) Total non-current liabilities 308 2,655 229 2,522 190 2,214 Current Debt Trade Payables Other Current Liabilities Total current liabilities 234 2,073 84 2,391 371 1,975 112 2,458 145 1,619 121 1,885 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 10,127 9,418 7,761 Depreciation and amortization (nature) Other operating income, net of other operating expense (nature) Operating profit Investment income Net interest expense (income) Profit before taxes Tax expense Profit after taxes Minority interest Net profit ASSETS Non-Current Tangible Assets Non-Current Intangible Assets Deferred Tax Asset Other Non-Current Assets Total non-current assets Trade Receivables Inventories Other Current Assets Cash and Marketable Securities Total current assets TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY Shareholders' equity Minority Interest Inditex Inditex (EURm) 2008 Sales Cost of materials (nature) Personnel expense (nature) Inditex (EURm) 2007 (EURm) 2006 10,407 (4,493) (1,703) 9,435 (4,086) (1,473) 8,196 (3,589) (1,251) (910) (803) (674) (1,168) 2,133 0 (84) 2,050 (455) 1,595 (8) 1,587 (1,039) 2,033 (9) (72) 1,953 (474) 1,479 (7) 1,471 (997) 1,685 (5) (74) 1,607 (404) 1,202 (8) 1,194 6,325 148 203 188 6,863 6,000 139 133 165 6,437 5,262 114 89 148 5,613 585 1,055 158 1,466 3,264 464 1,007 45 1,466 2,982 364 824 55 906 2,148 10,127 9,418 7,761 5,055 27 4,414 24 3,641 22 Non-Current Debt Deferred Tax Liability 2,003 343 2,095 197 1,844 179 Other Non-Current Liabilities (non interest bearing) Total non-current liabilities 308 2,655 229 2,522 190 2,214 Current Debt Trade Payables Other Current Liabilities Total current liabilities 234 2,073 84 2,391 371 1,975 112 2,458 145 1,619 121 1,885 TOTAL LIABILITIES AND SHAREHOLDERS' EQUITY 10,127 9,418 7,761 Depreciation and amortization (nature) Other operating income, net of other operating expense (nature) Operating profit Investment income Net interest expense (income) Profit before taxes Tax expense Profit after taxes Minority interest Net profit ASSETS Non-Current Tangible Assets Non-Current Intangible Assets Deferred Tax Asset Other Non-Current Assets Total non-current assets Trade Receivables Inventories Other Current Assets Cash and Marketable Securities Total current assets TOTAL ASSETS LIABILITIES AND SHAREHOLDERS' EQUITY Shareholders' equity Minority Interest Q1 Item Net profit Effective tax rate Net interest expense and investment income after tax Net interest expense after tax Net operating profit after tax (NOPAT) Net investment profit after tax Sales Excess cash and marketable securities @ 8 percent of sales Working capital Non-current operating assets Investment assets Business assets Debt Group equity Capital The items can also be reported on a "net" basis. We use these "net" items below: Working capital Non-current operating assets Net operating assets Net debt Group equity Net capital Q2 Ratio Return on equity Traditional decomposition of ROE Net profit margin (ROS) Asset turnover = Return on assets (ROA) Financial leverage = Return on equity (ROE) Distinguishing operating and financing components in ROE Q3 decomposition Net operating profit margin Operating asset turnover = Return on Operating Assets Return on Operating Assets x (Operating Assets/Business Assets) + Return on Investment Assets x (Investment Assets/Business Assets) = Return on Business Assets Spread Financial leverage = Financial leverage gain ROE = Return on Business Assets + Financial leverage gain Distinguishing operating and financing components in ROE decomposition (using "net" items) Net operating profit margin Net operating asset turnover = Return on Operating Assets Spread Net financial leverage = Financial leverage gain ROE = Return on Business Assets + Financial leverage gain Item Net profit Effective tax rate Net interest expense and investment income after tax Net interest expense after tax Net operating profit after tax (NOPAT) Net investment profit after tax Sales Excess cash and marketable securities @ 8 percent of sales Working capital Non-current operating assets Investment assets Business assets Debt Group equity Capital 2008 1,587 22.19% 65 909 2,561 84 10,407 833 873 6,473 2007 1,471 24.27% 61 787 2,319 81 9,435 755 524 6,138 2,003 5,082 7,085 2,095 4,438 6,534