60.1K

Verified Solution

Link Copied!

To calculate the company's ROS, how can I get these two numbers I have circled in red?

(pls give formula and numbers in details)

thanks

(CNY million) 2007 2008 2009 2010e 2011e 2012e 2013e 2014e 2015e Sales revenue 1,290.4 1,394.6 1,602.7 1,923.2 2,307.9 2,769.5 3.323.4 3,988.0 4,785.6 Cost of goods sold (849.4) (943.4) (1.110.0) (1.294.0) (1,610.3) (2,000.7) (2.491.1) (3,096.8) (3,848.2) Gross profit 441.0 451.2 492.7 629.3 697.6 768.8 832.2 891.2 937.4 Gross margin 34.2% 32.4% 30.7% 32.7% 30.2% 27.8% 25.0% 22.3% 19.6% Selling expense (216.0) (208.0) (201.8) (242.3) (290.8) (349.0) (418.7) (502.5) (603.0) G&A expense (19.6) (20.0) (20.1) (24.1) (28.9) (34.7) (41.7) (50.0) (60.0) EBITDA 205.7 223.6 271.1 362.8 377.9 385.1 371.8 338.7 274.4 EBITDA margin 15.9% 16.0% 16.9% 18.9% 16.4% 13.9% 11.2% 8.5% 5.7% Depreciation (40.3) (45.3) (49.4) (57.5) (60.8) (64.0) (67.3) (70.5) (73.7) EBIT 165.6 178.4 221.9 305.3 317.1 321.1 304.5 268.2 200.7 EBIT margin 12.8% 12.8% 13.8% 15.9% 13.7% 11.6% 9.2% 6.7% 4.2% Interest expense (7.1) (12.0) (15.1) (15.9) (13.9) (11.2) (7.7) (4.4) (2.2) EBT 158.5 166.4 206.8 289.4 303.2 309.9 296.8 263.8 198.5 Income tax (8.4) (18.0) (20.0) (28.9) (30.3) (31.0) (29.7) (26.4) (19.9) Net income 150.1 148.4 186.8 260.5 272.9 278.9 267.1 237.5 178.7 Return on sales 11.6% 10.8% 11.7% 13.5% 11.8% 10.1% 8.0% 6.0% 3.7% Assumes sales growth of 20% per year. Estimated costs assume INR 1344 1.00 RMB. Projected selling expenses assumed 12.6% of sales, G&A expenses at 1.3% of sales, and income tax expenses at 10% of EBT. Cost of goods sold assumptions for 20102-2015e are based on Exhibit C, which follows. Indonesian rupiah = 1 Chinese yuan 2,200 2,050 2,000 1,915 Forward Rat Quotations 1,784 1,800 1,652 1,600 1,431 1,450 1,470 1,400 1,352 1.357 1,397 1,410 1,405 1,343 1,373 1,338 Spot Rate Forecasts 1,299 1.200 1.260 1,000 Spot 20 2010 30 2010 40 2010 2011 2012 2013 2014 2015 rates, (b) forward rate quotes, or (c) fixed rate baseline assumption? When China Noah replaces the Chinese wood supplier with Indonesian supplier, the prices of CNY 62.6/m2 came with the rough estimation of 8% cheaper than the current Chinese prices. China Noah started traded with Indonesian company in 2010 with the evaluation of 30% Indonesian sourcing of the total 17.2 million square meters of flooring. The price which was quoted for wood per square meter is IDR 84,090 i.e. 62.6 in Chinese yuan per square meter. Return on sales for 2010 a) If the exchange rate is to be change as per the forecast i.e. 1 CNY = IDR, the return on sales is figured at 14.9% b) If China Noah were to use the currency forward, the 2010 forward rate is IDR 1450 = 1 CNY, where return on sales is 14.6%. c) If the change in exchange rate remains constant, IDR 1344 = 1 CNY, the forecast return on sales to be figured at 13.5% These return on sales forecast with the change in the exchange rate of IDR and CNY helps the company to secure the normal profit within the time frame mentioned. (CNY million) 2007 2008 2009 2010e 2011e 2012e 2013e 2014e 2015e Sales revenue 1,290.4 1,394.6 1,602.7 1,923.2 2,307.9 2,769.5 3.323.4 3,988.0 4,785.6 Cost of goods sold (849.4) (943.4) (1.110.0) (1.294.0) (1,610.3) (2,000.7) (2.491.1) (3,096.8) (3,848.2) Gross profit 441.0 451.2 492.7 629.3 697.6 768.8 832.2 891.2 937.4 Gross margin 34.2% 32.4% 30.7% 32.7% 30.2% 27.8% 25.0% 22.3% 19.6% Selling expense (216.0) (208.0) (201.8) (242.3) (290.8) (349.0) (418.7) (502.5) (603.0) G&A expense (19.6) (20.0) (20.1) (24.1) (28.9) (34.7) (41.7) (50.0) (60.0) EBITDA 205.7 223.6 271.1 362.8 377.9 385.1 371.8 338.7 274.4 EBITDA margin 15.9% 16.0% 16.9% 18.9% 16.4% 13.9% 11.2% 8.5% 5.7% Depreciation (40.3) (45.3) (49.4) (57.5) (60.8) (64.0) (67.3) (70.5) (73.7) EBIT 165.6 178.4 221.9 305.3 317.1 321.1 304.5 268.2 200.7 EBIT margin 12.8% 12.8% 13.8% 15.9% 13.7% 11.6% 9.2% 6.7% 4.2% Interest expense (7.1) (12.0) (15.1) (15.9) (13.9) (11.2) (7.7) (4.4) (2.2) EBT 158.5 166.4 206.8 289.4 303.2 309.9 296.8 263.8 198.5 Income tax (8.4) (18.0) (20.0) (28.9) (30.3) (31.0) (29.7) (26.4) (19.9) Net income 150.1 148.4 186.8 260.5 272.9 278.9 267.1 237.5 178.7 Return on sales 11.6% 10.8% 11.7% 13.5% 11.8% 10.1% 8.0% 6.0% 3.7% Assumes sales growth of 20% per year. Estimated costs assume INR 1344 1.00 RMB. Projected selling expenses assumed 12.6% of sales, G&A expenses at 1.3% of sales, and income tax expenses at 10% of EBT. Cost of goods sold assumptions for 20102-2015e are based on Exhibit C, which follows. Indonesian rupiah = 1 Chinese yuan 2,200 2,050 2,000 1,915 Forward Rat Quotations 1,784 1,800 1,652 1,600 1,431 1,450 1,470 1,400 1,352 1.357 1,397 1,410 1,405 1,343 1,373 1,338 Spot Rate Forecasts 1,299 1.200 1.260 1,000 Spot 20 2010 30 2010 40 2010 2011 2012 2013 2014 2015 rates, (b) forward rate quotes, or (c) fixed rate baseline assumption? When China Noah replaces the Chinese wood supplier with Indonesian supplier, the prices of CNY 62.6/m2 came with the rough estimation of 8% cheaper than the current Chinese prices. China Noah started traded with Indonesian company in 2010 with the evaluation of 30% Indonesian sourcing of the total 17.2 million square meters of flooring. The price which was quoted for wood per square meter is IDR 84,090 i.e. 62.6 in Chinese yuan per square meter. Return on sales for 2010 a) If the exchange rate is to be change as per the forecast i.e. 1 CNY = IDR, the return on sales is figured at 14.9% b) If China Noah were to use the currency forward, the 2010 forward rate is IDR 1450 = 1 CNY, where return on sales is 14.6%. c) If the change in exchange rate remains constant, IDR 1344 = 1 CNY, the forecast return on sales to be figured at 13.5% These return on sales forecast with the change in the exchange rate of IDR and CNY helps the company to secure the normal profit within the time frame mentioned

Answer & Explanation Solved by verified expert

See Answer